cdb_startrackernarrow

Version: 1.0.2

The Consolidated Database for StarTrackerNarrow schema contains information for each exposure taken by the instrument, a narrow-field star tracker mounted on the Simonyi Survey Telescope. This includes observatory data from the FITS image header metadata and measurements and metrics from Rapid Analysis and other data processing.

Tables

name description columns
exposure Information from observatory systems about each raw image taken 34
exposure_flexdata Flexible key/value metadata about each raw image taken; used for development and engineering purposes 3
exposure_flexdata_schema Key names and value types used in the exposure_flexdata table 5
exposure_quicklook Information from Summit Rapid Analysis about each raw image taken 23

Relationships

erDiagram
  t0["exposure"] {
    exposure_id long PK
  }
  t1["exposure_flexdata"] {
    obs_id long PK, FK
    key string PK, FK
  }
  t2["exposure_flexdata_schema"] {
    key string PK
  }
  t3["exposure_quicklook"] {
    exposure_id long PK, FK
  }
  t1 }o--|| t0 : "fk_exposure_flexdata_obs_id"
  t1 }o--|| t2 : "fk_exposure_flexdata_key"
  t3 }o--|| t0 : "fk_exposure_quicklook_obs_id"