OAT » TS Admin

-- ancillaryDocuments definition
-- Drop table
-- DROP TABLE ancillaryDocuments;
CREATE TABLE ancillaryDocuments
(
    ancillaryDocumentId int IDENTITY(1, 1) NOT NULL,
    recourseId int NOT NULL,
    recourseFilingId int NULL,
    dateCreated datetime DEFAULT getdate() NOT NULL,
    creatorId int NOT NULL,
    isDeleted bit DEFAULT 0 NOT NULL,
    deleterId int NULL,
    dateDeleted datetime NULL,
    CONSTRAINT PK_ancillary_d__6EC89661FC159B09 PRIMARY KEY (ancillaryDocumentId),
    CONSTRAINT FK_ancillary_documents_creator FOREIGN KEY (creatorId) REFERENCES persons(personId),
    CONSTRAINT FK_ancillary_documents_deleter FOREIGN KEY (deleterId) REFERENCES persons(personId),
    CONSTRAINT FK_ancillary_documents_recourses FOREIGN KEY (recourseId) REFERENCES recourses(recourseId),
    CONSTRAINT FK_ancillary_documents_recourseFilings FOREIGN KEY (recourseFilingId) REFERENCES recourseFilings(recourseFilingId)
);

-- ancillaryDocumentDetails definition
-- Drop table
-- DROP TABLE ancillaryDocumentDetails;
CREATE TABLE ancillaryDocumentDetails
(
    ancillaryDocumentDetailId int IDENTITY(1, 1) NOT NULL,
    ancillaryDocumentId int NOT NULL,
    documentTypeCode int NOT NULL,
    documentTypeDescription varchar(250) NOT NULL,
    description varchar(250) NOT NULL,
    url varchar(250) NULL,
    fileExtension varchar(5) NULL,
    fileName varchar(250) NULL,
    hash varchar(250) NULL,
    fileSize int NULL,
    filePageCount int NULL,
    dateCreated datetime DEFAULT getdate() NOT NULL,
    creatorId int NOT NULL,
    isDeleted bit DEFAULT 0 NOT NULL,
    deleterId int NULL,
    dateDeleted datetime NULL,
    CONSTRAINT PK__ancillaryDo__755D5FA72E19B83F PRIMARY KEY (ancillaryDocumentDetailId),
    CONSTRAINT FK_ancillary_document_details_creator FOREIGN KEY (creatorId) REFERENCES persons(personId),
    CONSTRAINT FK_ancillary_document_details_deleter FOREIGN KEY (deleterId) REFERENCES persons(personId),
    CONSTRAINT FK_ancillary_document_details_ancillary_document FOREIGN KEY (ancillaryDocumentId) REFERENCES ancillaryDocuments(ancillaryDocumentId),
    CONSTRAINT FK_ancillary_document_details_type FOREIGN KEY (documentTypeCode) REFERENCES catalogValues(catalogValueCode)
);

INSERT INTO catalogTypes (catalogTypeCode, catalogTypeDescription) VALUES (73, 'ancillaryDocumentType');

INSERT INTO catalogValues (catalogValueCode, catalogValueDescription, catalogTypeCode, catalogTypeDescription, isLocked, comment) VALUES (866, 'Minuta', 73, 'ancillaryDocumentType', 1, NULL);