Current Identifications (mpc_sbn.current_identifications)
Description
Table of current identifications: which designations refer to the same object. Used for cross-identification and joining observations to canonical designations.
Schema and field descriptions follow the MPC current_identifications documentation.
Attribution
This research has made use of data and/or services provided by the International Astronomical Union's Minor Planet Center.
Columns
| Name | Type | UCD | Unit | Description |
|---|---|---|---|---|
| id | int |
meta.id meta.main |
PostgreSQL automatically generated identifier. |
|
| packed_primary_provisional_designation | char | meta.id |
Packed primary provisional designation. |
|
| packed_secondary_provisional_designation | char | meta.id |
Packed secondary provisional designation. |
|
| unpacked_primary_provisional_designation | char | meta.id |
Unpacked primary provisional designation. |
|
| unpacked_secondary_provisional_designation | char | meta.id |
Unpacked secondary provisional designation. |
|
| published | int | meta.code |
Publication status code. |
|
| identifier_ids | char | meta.id |
Array of identifier UUIDs. |
|
| object_type | int | meta.code |
Object type code. |
|
| numbered | boolean | meta.code |
Whether the object has been numbered. |
|
| created_at | timestamp | time.creation |
Date and time of initial row insert. |
|
| updated_at | timestamp | time.modification |
Date and time of latest row update. |