Ignore:
Timestamp:
07/05/08 10:13:17 (12 years ago)
Author:
cbyrom
Message:

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.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • TI01-discovery/branches/ingestAutomation-upgrade/database/spatial_temporal_data.sql

    r3834 r3849  
    1010        spatial_temporal_data_id SERIAL PRIMARY KEY, 
    1111        original_record_id      int references original_document(original_document_id), 
    12         spatial_data_id         int references spatial_data(spatial_data_id), 
    13         temporal_data_id        int references temporal_data(temporal_data_id) 
     12        spatial_data_id         int references spatial_data(spatial_data_id) ON DELETE CASCADE, 
     13        temporal_data_id        int references temporal_data(temporal_data_id) ON DELETE CASCADE, 
     14        create_date     timestamp 
    1415); 
    15 ALTER TABLE spatial_temporal_data OWNER TO postgres; 
     16--ALTER TABLE spatial_temporal_data OWNER TO postgres; 
Note: See TracChangeset for help on using the changeset viewer.