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.

Columns

name	datatype	description	nullable	ivoa:ucd	votable:arraysize	votable:xtype	length	precision
created_at	timestamp	When this row was created	true	time.creation;meta.dataset	*	timestamp		6
id	int	Internal ID (generally not seen/used by the user)	false	meta.id;src
identifier_ids	text	This is a set of unique identifier_ids in an array that points to the identification_metadata table.	false	meta.id;src	*
numbered	boolean	Has the object been numbered and hence does it appear in the numbered_objects table?	true
object_type	int	Integer to indicate the object type. To be linked (foreign key) to object_type lookup table	true
packed_primary_provisional_designation	char	The primary provisional designation in packed form (e.g. K08A00B)	false	meta.id;src	16		16
packed_secondary_provisional_designation	char	The secondary provisional designation in packed form (e.g. K08A00B). May be the same-as (A=A) or different-to (A=B) the primary provisional designation	false	meta.id;src	16		16
published	boolean	Has this been published yet? i.e. has it been released to the public?	true	meta.code.status;meta.dataset
unpacked_primary_provisional_designation	char	The primary provisional designation in unpacked form (e.g. 2008 AB)	false	meta.id;src	16		16
unpacked_secondary_provisional_designation	char	The secondary provisional designation in unpacked form (e.g. 2008 AB). May be the same-as (A=A) or different-to (A=B) the primary provisional designation	false	meta.id;src	16		16
updated_at	timestamp	When this row was updated	true	time.processing;meta.dataset	*	timestamp		6