Table ClientOrderFile

Table to store imported file. Store outside ClientOrderJob to save space in that table.

DDL

create sequence seqClientOrderFile as bigint start with 1;

create table ClientOrderFile (
   cofID bigint not null default next value for seqClientOrderFile,
   cofCreatedOn datetime not null default sysdatetime(),
   cofCreatedByFK bigint not null,
   cofChangedOn datetime not null default sysdatetime(),
   cofChangedByFK bigint not NULL,
   cofClientOrderJobFk pointer not NULL,
   cofData Memo not null,
   CONSTRAINT pkClientOrderFile PRIMARY key (cofID)
 );
 create unique index udxClientOrderFile on ClientOrderFile(cofClientOrderJobFk);