source: TI01-discovery/branches/ingestAutomation-upgrade/database/transformed_document.sql @ 3863

/* 
 * Basic DB structure to use in test of NERC Discovery upgrad
 * 
 * C Byrom Apr 08
 * 
 */
--CREATE SCHEMA badc;
--CREATE TABLE badc.records (
DROP TABLE transformed_document;
CREATE TABLE transformed_document (
        transformed_document_id SERIAL primary key,
                original_document_id    int references original_document(original_document_id),
                transformed_format      text,
                transformed_document    text,
                create_date     timestamp,
                update_date timestamp,
                scn                     int
);