source: TI01-discovery/branches/ingestAutomation-upgrade/database/temporal_data.sql @ 3849

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

Adjust tables to use timestamps instead of dates - and add create dates to
the spatiotemporal tables + add delete cascade to the spatial_temporal_data
to allow easy removal of spatial and temporal records.

Line 
1/*
2 * Table storing temporal information
3 *
4 * C Byrom Apr 08
5 *
6 */
7DROP TABLE temporal_data CASCADE;
8CREATE TABLE temporal_data
9(
10        temporal_data_id SERIAL primary key,
11        start_time timestamp without time zone,
12        end_time timestamp without time zone,
13        create_date     timestamp
14);
15--ALTER TABLE temporal_data OWNER TO postgres;
Note: See TracBrowser for help on using the repository browser.