Table PickJob

Synopsis

Table to hold current pick jobs.

DDL

create sequence seqPickJob as bigint start with 1;

create table PickJob (
   pjID bigint not null default next value for seqPickJob,
   pjCreatedOn datetime not null default sysdatetime(),
   pjCreatedByFK pointer not null,
   pjChangedOn datetime not null default sysdatetime(),
   pjChangedByFK pointer not NULL,
   pjJobID bigint not NULL,
   pjInvoiceFK pointer not null,
   pjTrolleyLocationFK int not null,
   CONSTRAINT pkPickJob PRIMARY key (pjID)
);
create index idxPickJobJob on PickJob(pjJobid);

create sequence seqPickJobID as bigint start with 1;

Default Data

None.

Mapping

None, new table.