Dark Energy Survey Logo

DES Document 1320-v3

DECam SISPI Database Schema Description

Document #:
Document type:
Technical Note
Submitted by:
Elizabeth J Buckley-Geer
Updated by:
Elizabeth J Buckley-Geer
Document Created:
04 Jan 2008, 15:14
Contents Revised:
07 Apr 2008, 17:16
Metadata Revised:
17 Sep 2008, 13:52
Viewable by:
  • Public document
Modifiable by:

Quick Links:
Latest Version

Other Versions:
Document describing the proposed schema for the DECam SISPI mountain top database
Files in Document:
Notes and Changes:
1. Added table_modify_time to all tables. Updated the data volumes to reflect this.
2. Shortened the names of some tables to keep within the Oracle limit of 30 characters for a table names.
3. Make all time_stamp columns be TIMESTAMP WITHOUT TIME ZONE. This allows us to enter UTC times. Make sure all tables have a primary key in the form of a column of type SERIAL.
4. Make modifications in the ICS section based on conversations with Steve Kuhlmann
DocDB Home ]  [ Search ] [ Last 20 Days ] [ List Authors ] [ List Events ] [ List Topics ]

Security, Privacy, Legal
Fermilab Policy on Computing

For assistance contact HelpDesk

DocDB Version 8.8.9, contact Document Database Administrators