Table Report

DDL

create sequence seqReport as bigint start with 1;

create table Report (
   rpID bigint not null default next value for seqReport,
   rpCreatedOn datetime not null default sysdatetime(),
   rpCreatedByFK bigint not null,
   rpChangedOn datetime not null default sysdatetime(),
   rpChangedByFK bigint not NULL,
   rpName LongName NOT NULL,
   rpDesign binary(max) NOT NULL,
   rpData nvarchar(max) NOT NULL,
   rpFormFK Pointer NOT NULL,
   CONSTRAINT pkReport PRIMARY key (rpID)
);
create unique index udxReport on Report (rpName);
alter table Report add constraint fkReportForm foreign key (rpFormFK) references Form(fID);  

Default Data

None.

Mapping

None.