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.
Columns
| name | datatype | description | unit | nullable | ivoa:ucd | votable:arraysize | votable:xtype | length | precision |
|---|---|---|---|---|---|---|---|---|---|
| id primary key | int | Internal ID (generally not seen/used by the user) | false | meta.id;src | |||||
| packed_primary_provisional_designation | char | The primary provisional designation in packed form (e.g. K08A00B) | false | meta.id;src | 16 | 16 | |||
| unpacked_primary_provisional_designation | char | The primary provisional designation in unpacked form (e.g. 2008 AB) | false | meta.id;src | 16 | 16 | |||
| permid | char | Permanent designation (number) | false | meta.id;src | 16 | 16 | |||
| iau_designation | text | IAU-approved designation (not filled at the moment) | true | meta.id;src | * | ||||
| iau_name | char | IAU-approved name (not filled at the moment) | true | meta.id;src | 32 | 32 | |||
| naming_credit | text | Credit for suggesting the name | true | * | |||||
| created_at | timestamp | When this row was created | true | time.creation;meta.dataset | * | timestamp | 6 | ||
| updated_at | timestamp | When this row was updated | true | time.processing;meta.dataset | * | timestamp | 6 |