cdb_lsstcomcam

Version: 3.8.1

The Consolidated Database for LSSTComCam schema contains information for each exposure and visit (and each detector within those) taken by the instrument, a 9-detector camera for commissioning the Vera C. Rubin Observatory. 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	50
exposure_flexdata	Flexible key/value metadata about each raw image taken; used for development and engineering purposes	5
exposure_flexdata_schema	Key names and value types used in the exposure_flexdata table	5
ccdexposure	Information from observatory systems about each detector (CCD) within each raw image taken	6
ccdexposure_camera	Information from the Camera Control System about each detector (CCD) within each raw image taken	6
ccdexposure_flexdata	Flexible key/value metadata about each detector (CCD) within each raw image taken; used for development and engineering purposes	6
ccdexposure_flexdata_schema	Key names and value types used in the ccdexposure_flexdata table	5
visit1	Information from observatory systems about each visit in visit system 1 (visit per exposure); describes processed visit images (or calibrated exposures)	50
visit1_quicklook	Information from Summit Rapid Analysis about each visit in visit system 1 (visit per exposure); describes processed visit images (or calibrated exposures)	103
exposure_quicklook	Information from Summit Rapid Analysis about each raw image taken	13
ccdvisit1	Information from observatory systems about each detector (CCD) within each visit in visit system 1 (visit per exposure); describes detectors in processed visit images (or calibrated exposures)	6
ccdvisit1_quicklook	Information from Summit Rapid Analysis about each detector (CCD) within each visit in visit system 1 (visit per exposure); describes detectors in processed visit images (or calibrated exposures)	38
ccdexposure_quicklook	Information from Summit Rapid Analysis about each detector (CCD) within each raw image taken	5

Relationships

erDiagram
  t0["exposure"] {
    day_obs int PK
    seq_num int PK
  }
  t1["exposure_flexdata"] {
    obs_id long FK
    day_obs int PK, FK
    seq_num int PK, FK
    key string PK, FK
  }
  t2["exposure_flexdata_schema"] {
    key string PK
  }
  t3["ccdexposure"] {
    exposure_id long FK
    day_obs int PK, FK
    seq_num int PK, FK
    detector int PK
  }
  t4["ccdexposure_camera"] {
    day_obs int PK, FK
    seq_num int PK, FK
    detector int PK, FK
    ccdexposure_id long FK
  }
  t5["ccdexposure_flexdata"] {
    day_obs int PK, FK
    seq_num int PK, FK
    detector int PK, FK
    obs_id long FK
    key string PK, FK
  }
  t6["ccdexposure_flexdata_schema"] {
    key string PK
  }
  t7["visit1"] {
    day_obs int PK
    seq_num int PK
  }
  t8["visit1_quicklook"] {
    visit_id long FK
    day_obs int PK, FK
    seq_num int PK, FK
  }
  t9["exposure_quicklook"] {
    exposure_id long FK
    day_obs int PK, FK
    seq_num int PK, FK
  }
  t10["ccdvisit1"] {
    day_obs int PK, FK
    seq_num int PK, FK
    visit_id long FK
    detector int PK
  }
  t11["ccdvisit1_quicklook"] {
    day_obs int PK, FK
    seq_num int PK, FK
    detector int PK, FK
    ccdvisit_id long FK
  }
  t12["ccdexposure_quicklook"] {
    day_obs int PK, FK
    seq_num int PK, FK
    detector int PK, FK
    ccdexposure_id long FK
  }
  t1 }o--|| t0 : "fk_exposure_flexdata_ds"
  t1 }o--|| t0 : "fk_exposure_flexdata_obs_id"
  t1 }o--|| t0 : "fk_exposure_flexdata_obs_id_ds"
  t1 }o--|| t2 : "fk_exposure_flexdata_key"
  t3 }o--|| t0 : "fk_ccdexposure_ds"
  t3 }o--|| t0 : "fk_ccdexposure_exposure_id"
  t3 }o--|| t0 : "fk_ccdexposure_exposure_id_ds"
  t4 }o--|| t3 : "fk_ccdexposure_camera_ccdexposure_id"
  t4 }o--|| t3 : "fk_ccdexposure_camera_dsd"
  t4 }o--|| t3 : "fk_ccdexposure_camera_ccdexposure_id_dsd"
  t5 }o--|| t3 : "fk_ccdexposure_flexdata_obs_id"
  t5 }o--|| t3 : "fk_ccdexposure_flexdata_dsd"
  t5 }o--|| t3 : "fk_ccdexposure_flexdata_obs_id_dsd"
  t5 }o--|| t6 : "fk_ccdexposure_flexdata_key"
  t8 }o--|| t0 : "fk_visit1_quicklook_obs_id"
  t8 }o--|| t0 : "fk_visit1_quicklook_ds"
  t8 }o--|| t0 : "fk_visit1_quicklook_visit_id_ds"
  t9 }o--|| t0 : "fk_exposure_quicklook_ds"
  t9 }o--|| t0 : "fk_exposure_quicklook_obs_id"
  t9 }o--|| t0 : "fk_exposure_quicklook_exposure_id_ds"
  t10 }o--|| t7 : "fk_ccdvisit1_visit_id"
  t10 }o--|| t7 : "fk_ccdvisit1_ds"
  t11 }o--|| t3 : "fk_ccdvisit1_quicklook_obs_id"
  t11 }o--|| t3 : "fk_ccdvisit1_quicklook_dsd"
  t11 }o--|| t3 : "fk_ccdvisit1_quicklook_ccdvisit_id_dsd"
  t12 }o--|| t3 : "fk_ccdexposure_quicklook_obs_id"
  t12 }o--|| t3 : "fk_ccdexposure_quicklook_dsd"
  t12 }o--|| t3 : "fk_ccdexposure_qk_id_day_seq_det"