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

/* 
 * Table to relate spatial and temporal data to each other and to a particular ingested document
 * 
 * C Byrom Apr 08
 * 
 */
DROP TABLE spatial_temporal_data CASCADE;
CREATE TABLE spatial_temporal_data
(
        spatial_temporal_data_id SERIAL PRIMARY KEY,
        original_document_id    int references original_document(original_document_id),
        spatial_data_id         int references spatial_data(spatial_data_id) ON DELETE CASCADE,
        temporal_data_id        int references temporal_data(temporal_data_id) ON DELETE CASCADE,
        create_date     timestamp
);
--ALTER TABLE spatial_temporal_data OWNER TO postgres;