ppdb

Version: 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.

Tables

name	description	columns
DiaObject	Astronomical objects detected on one or more difference images, containing only the latest version of each record (i.e., with an open validity interval)	82
DiaSource	Difference image sources detected on difference images	103
DiaForcedSource	Forced-photometry source measurement on an individual difference Exposure for all objects in the DiaObject table	14
SSSource	LSST-computed per-source quantities. 1::1 relationship with DiaSource.	39
SSObject	LSST-computed per-object quantities.	80
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.	10
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.	9