The Science Data Model (SDM) schemas are a curated subset of the Rubin Observatory's database schemas, for its user-facing data products. They cover the data releases and previews, Data Release Processing, the Alert Production and Prompt Products databases, the Consolidated Database of Image Metadata, and other observatory metadata. Each schema is made up of tables, which contain columns along with keys, indexes and other database objects.
Schemas
| name | version | description | tables |
|---|---|---|---|
| ap_extra | Additional tables that are produced daily but are not in the Prompt Products Database. | 1 | |
| ApdbSchema | 10.0.0 | The Alert Production Database (APDB) contains the catalogs resulting from image differencing during nightly Prompt Processing as well as the results of daily Solar System Processing. | 12 |
| cdb_latiss | 3.7.1 | The Consolidated Database for LATISS schema contains information for each exposure and visit taken by the instrument, an imaging slitless spectrometer mounted on the Rubin Observatory Auxiliary Telescope. This includes observatory data from the FITS image header metadata and measurements and metrics from Rapid Analysis and other data processing. | 13 |
| cdb_lsstcam | 1.9.1 | The Consolidated Database for LSSTCam schema contains information for each exposure and visit (and each detector within those) taken by the instrument, the primary instrument for the Legacy Survey of Space and Time. This includes observatory data from the FITS image header metadata and measurements and metrics from Rapid Analysis and other data processing. | 13 |
| cdb_lsstcomcam | 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. | 13 |
| cdb_lsstcomcamsim | 3.5.1 | The Consolidated Database for LSSTComCamSim schema contains information for each exposure and visit (and each detector within those) taken by the simulated instrument. This information was recorded during an Operations Rehearsal. This includes simulated observatory data from the FITS image header metadata and measurements and metrics from Rapid Analysis and other data processing. | 13 |
| cdb_startrackerfast | 1.0.2 | The Consolidated Database for StarTrackerFast schema contains information for each exposure taken by the instrument, a fast 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. | 4 |
| cdb_startrackernarrow | 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. | 4 |
| cdb_startrackerwide | 1.0.2 | The Consolidated Database for StarTrackerWide schema contains information for each exposure taken by the instrument, a wide-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. | 4 |
| dp02_dc2_catalogs | Data Preview 0.2 contains the image and catalog products of the Rubin Science Pipelines v23 processing of the DESC Data Challenge 2 simulation, which covered 300 square degrees of the wide-fast-deep LSST survey region over 5 years. | 12 | |
| dp03_catalogs_10yr | Data Preview 0.3 (ten-year version) contains the catalog products of a Solar System Science Collaboration simulation of the results of SSO analysis of the wide-fast-deep data from the full LSST ten-year dataset. | 4 | |
| dp03_catalogs_1yr | Data Preview 0.3 (one-year version) contains the catalog products of a Solar System Science Collaboration simulation of the results of SSO analysis of the wide-fast-deep data, based on analyzing only the first year of LSST observations. | 4 | |
| dp1 | 1.3.1 | Data Preview 1 contains image and catalog products from the Rubin Science Pipelines v29 processing of observations obtained with the LSST Commissioning Camera of seven ~1 square degree fields, over seven weeks in late 2024. | 12 |
| dp2 | 1.1.1 | Data Preview 2 (Early) contains catalog products and coadded images from the Rubin Science Pipelines v30 processing of early observations obtained with LSSTCam from April 2025 to January 2026. Coadded images and catalogs cover ~3000 square degrees; single-epoch catalogs cover ~15,000 square degrees. | 16 |
| dp2_prompt | 1.1.1 | Prompt products tables from Data Preview 2 for testing in the PPDB BigQuery database. | 8 |
| drp_base | 1.1.0 | Base schema for defining Data Release Processing column definitions. | 17 |
| efd_latiss | 1.0.0 | Transformed EFD Consolidated Database for latiss. | 4 |
| efd_lsstcam | 1.2.0 | Transformed EFD Consolidated Database for lsstcam. | 4 |
| efd_lsstcomcam | 1.0.0 | Transformed EFD Consolidated Database for lsstcomcam. | 4 |
| HscSchema | The HyperSuprimeCam (HSC) Schema describes the outputs of the latest data release production pipelines for HyperSuprimeCam. It is used in the CI testing of the pipelines. | 5 | |
| ImsimSchema | The ImSim Schema describes the Science Pipelines outputs for on Imsim simulated full-focal-plane LSSTCam data. It is used in the CI testing of the pipelines. | 11 | |
| ivoa | ObsCore v1.1 attributes in ObsTAP realization | 1 | |
| ivoa | ObsCore v1.1 attributes in ObsTAP realization | 1 | |
| ivoa | Observation Locator Table Access Protocol Version 1.0 | 1 | |
| lsstcam | Default schema for outputs of the LSSTCam Data Release Production Pipeline. It is used in the CI testing of the pipelines, and as basis for specific data release schemas. | 17 | |
| oga | OGA-specific metadata tables | 1 | |
| ppdb | 10.0.0 | The Prompt Products Database stores results from nightly and daily processing that detects time-variable astrophysical phenomena, including difference-image detections, associated objects, and Solar System objects. | 8 |
| sso_base | 10.0.0 | Column-definition dictionary for the common Solar System tables. | 5 |