Untitled

CREATE TABLE DOCUMENTS
(
DOCUMENTS_ID integer NOT NULL,
AD_CLIENT_ID integer NOT NULL,
AD_ORG_ID integer NOT NULL,
ISACTIVE CHAR(1) DEFAULT 'Y' NOT NULL,
CREATED DATE NOT NULL,
CREATEDBY integer NOT NULL,
UPDATED DATE NOT NULL,
UPDATEDBY integer NOT NULL,
NAME VARCHAR(60) NOT NULL,
LASTEDITED DATE NOT NULL,
DOCSIZE integer NOT NULL
);