Table Inventory

A conversion from the old INVENTORY table.

DDL

create sequence seqInventory as bigint start with 1;

create table Inventory (
   ivID pointer not null default next value for seqInventory,
   ivCreatedOn datetime not null default sysdatetime(),
   ivCreatedByFK bigint not null,
   ivChangedOn datetime not null default sysdatetime(),
   ivChangedByFK bigint not NULL,
   ivInventoryType nchar(1) not null default 'N',
   ivRow1 Name not null default '',
   ivRow2 Name not null default '',
   ivPlace1 Name not null default '',
   ivPlace2 Name not null default '',
   ivLevel1 Name not null default '',
   ivLevel2 Name not null default '',
   ivOperatorFK bigint not null default 0,
   CONSTRAINT pkInventory PRIMARY KEY (ivID)
);

Default Data

none

Mapping

INVENTORY

Conversion ID: ivID is newly generated

New	Old
ivID	ID (now newly generated)
ivCreatedOn
ivCreatedByFK
ivChangedOn
ivChangedByFK
ivInventoryType
ivRow1	lRow1
ivRow2	lRow2
ivPlace1	lPlace1
ivPlace2	lPlace2
ivLevel1	lLevel1
ivLevel2	lLevel2
ivOperatorFK	MyOperator

CreationDate was replaced with ivCreatedOn and ivCreatedByFK.