Table Form

Table to store form definitions (as in program)

DDL

create sequence seqForm as bigint start with 1;

create table Form (
   fID bigint not null default next value for seqForm,
   fCreatedOn datetime not null default sysdatetime(),
   fCreatedByFK bigint not null,
   fChangedOn datetime not null default sysdatetime(),
   fChangedByFK bigint not NULL,
   fName NVARCHAR(128)
   CONSTRAINT pkForm PRIMARY key (fID)
 );
 create unique index udxFormName on Form(name);

Default Data

Mapping

none, new table