Untitled

public text v1 · immutable

#676714

·published 2007-08-31 10:34 UTC

CREATE TABLE DOCUMENTS
(
DOCUMENTS_ID SERIAL NOT NULL CONSTRAINT DOCUMENTS_ID PRIMARY KEY,
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
);