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

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery/branches/ingestAutomation-upgrade/database/spatial_temporal_data.sql@3831
Revision 3831, 387 bytes checked in by cbyrom, 12 years ago (diff)

Extend the new data model to include spatio-temporal tables - including using
postGIS geom column for the spatial data.

Line 
1DROP TABLE spatial_temporal_data;
2CREATE TABLE spatial_temporal_data
3(
4        spatial_temporal_data_id SERIAL PRIMARY KEY,
5        original_record_id      int references original_document(original_document_id),
6        spatial_data_id         int references spatial_data(spatial_data_id),
7        temporal_data_id        int references temporal_data(temporal_data_id)
8);
9ALTER TABLE spatial_temporal_data OWNER TO postgres;
Note: See TracBrowser for help on using the repository browser.