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.

Tables

name	description	columns
Object	Descriptions of static astronomical objects (or the static aspects of variable and slowly-moving objects) detected and measured on coadds.	1248
Source	Properties of detections on the single-epoch visit images, performed independently of the Object detections on coadded images.	156
ForcedSource	Forced-photometry measurements on individual single-epoch visit images and difference images, based on and linked to the entries in the Object table. Point-source PSF photometry is performed, based on coordinates from a reference band chosen for each Object and reported in the Object.refBand column.	28
DiaSource	Properties of transient-object detections on the single-epoch difference images.	94
DiaObject	Properties of time-varying astronomical objects based on association of data from one or more spatially-related DiaSource detections on individual single-epoch difference images.	67
ForcedSourceOnDiaObject	Point-source forced-photometry measurements on individual single-epoch visit images and difference images, based on and linked to the entries in the DiaObject table.	28
CoaddPatches	Static information about the subset of tracts and patches from the standard LSST skymap that apply to coadds in these catalogs	5
Visit	Metadata about the pointings of the telescope, largely associated with the boresight of the LSSTCam focal plane as a whole.	15
VisitDetector	Per-detector metadata and metrics associated with each visit	78
SSObject	LSST-computed per-object quantities.	80
SSSource	LSST-computed per-source quantities. 1::1 relationship with DiaSource.	39
mpc_orbits	Table of orbital elements and related information of known (sun-orbiting and unbound) Solar System objects. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.	53
current_identifications	All single-designations, and all identifications between designations. Always uses primary provisional designation (even for numbered objects). Includes all comets and satellites. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.	11
numbered_identifications	The numbered identification table contains all the numbered objects (minor planets, comets and natural satellites) with their primary provisional designations. The table is continously updated everytime a new object is numbered. Replicated from the Minor Planet Center (Postgres) database. This schema will generally closely follow the schema of the upstream table, to allow end-users to rerun queries developed elsewhere on the RSP.	11
Parent	Descriptions of the parent objects in the deblending hierarchy.	15
ShearObject	Descriptions of shear objects detected and measured on coadds with metadetection.	67
IsolatedStarStellarMotions	Position, proper motion, and parallax for isolated stars, fit using associated source measurements, with positions for associated reference objects if available.	28

Relationships

erDiagram
  t0["Object"] {
    objectId long PK
  }
  t1["Source"] {
    visit long FK
    sourceId long PK
  }
  t2["ForcedSource"] {
    objectId long FK
    visit long FK
  }
  t3["DiaSource"] {
    visit long FK
    diaObjectId long FK
    ssObjectId long FK
  }
  t4["DiaObject"] {
    diaObjectId long PK
  }
  t5["ForcedSourceOnDiaObject"] {
    diaObjectId long FK
    visit long FK
  }
  t6["Visit"] {
    visit long PK
  }
  t7["VisitDetector"] {
    visitId long PK, FK
    detector long PK
  }
  t8["SSObject"] {
    ssObjectId long PK
    designation char FK
  }
  t9["SSSource"] {
    diaSourceId long PK, FK
    ssObjectId long FK
    designation char FK
  }
  t10["mpc_orbits"] {
    id int PK
  }
  t1 }o--|| t6 : "fk_Source_Visit"
  t2 }o--|| t0 : "fk_ForcedSource_Object"
  t2 }o--|| t6 : "fk_ForcedSource_Visit"
  t3 }o--|| t6 : "fk_DiaSource_Visit"
  t3 }o--|| t4 : "fk_DiaSource_DiaObject"
  t3 }o--|| t8 : "fk_DiaSource_SSObject"
  t5 }o--|| t4 : "fk_ForcedSourceOnDiaobject_DiaObject"
  t5 }o--|| t6 : "fk_ForcedSourceOnDiaObject_Visit"
  t7 }o--|| t6 : "fk_VisitDetector_Visit"
  t8 }o--|| t10 : "fk_SSObject_mpc_orbits"
  t9 }o--|| t3 : "fk_SSSource_DiaSource"
  t9 }o--|| t8 : "fk_SSSource_SSObject"
  t9 }o--|| t10 : "fk_SSSource_mpc_orbits"