Template

Table __

DDL

create sequence seq__ as bigint start with 1;

create table __ (
   ID bigint not null default next value for seq__,
   CreatedOn datetime not null default sysdatetime(),
   CreatedByFK pointer not null,
   ChangedOn datetime not null default sysdatetime(),
   ChangedByFK pointer not null,

   ___remember to use nvarchar for string fields___

   CONSTRAINT pk__ PRIMARY key (ID)
 );
 create unique index udx

Default Data

insert into __ (_ID, _CreatedByFK, _ChangedByFK, ) values

Mapping

___

Conversion ID: .cnv ID

New	Old
ID
CreatedOn
CreatedByFK
ChangedOn
ChangedByFK