Table TransitLocation

DDL

create sequence seqTransitLocation as bigint start with 1;

create table TransitLocation (
   tlID bigint not null default next value for seqTransitLocation,
   tlCreatedOn datetime not null default sysdatetime(),
   tlCreatedByFK bigint not null,
   tlChangedOn datetime not null default sysdatetime(),
   tlChangedByFK bigint not NULL,
   tlCode ShortName NOT NULL,
   tlType SMALLINT not null default 0,
   CONSTRAINT pxTransitLocation PRIMARY key (ID)
 );
 create unique index udxTransitLocation on TransitLocation(tlCode,tlType);

Default Data

insert into TransitLocation (tlID,tlCreatedByFK,tlChangedByFK, tlCode,tlType)
  values (0,0,0,'?',0);
insert into TransitLocation (tlID,tlCreatedByFK,tlChangedByFK, tlCode,tlType)
    values (1,0,0,'?',1);

tlType$ : * 0 trolley * 1* temp location in warehouse

Mapping

None.