Table CustomerGroup

DDL

create sequence seqCustomerGroup as bigint start with 1;

create table CustomerGroup (
   cgID bigint not null default next value for seqCustomerGroup,
   cgCreatedOn datetime not null default sysdatetime(),
   cgCreatedByFK bigint not null,
   cgChangedOn datetime not null default sysdatetime(),
   cgChangedByFK bigint not NULL,
   cgName LongName not null
   CONSTRAINT pkCustomerGroup PRIMARY key (cgID)
 );
 create unique index udxCustomerGroup on CustomerGroup(cgName);

Mapping

Geen, nieuw gegeven.