Field | Type | Null | Key | Default | Extra |
CCSDS_OMM_VERS | varchar(3) | NO | | | |
COMMENT | varchar(33) | NO | | | |
CREATION_DATE | varchar(19) | NO | | | |
ORIGINATOR | varchar(7) | NO | | | |
OBJECT_NAME | varchar(25) | NO | | | |
OBJECT_ID | char(12) | YES | | | |
CENTER_NAME | varchar(5) | NO | | | |
REF_FRAME | varchar(4) | NO | | | |
TIME_SYSTEM | varchar(3) | NO | | | |
MEAN_ELEMENT_THEORY | varchar(4) | NO | | | |
EPOCH | varchar(26) | YES | | | |
MEAN_MOTION | double | NO | | 0 | |
ECCENTRICITY | double | NO | | 0 | |
INCLINATION | double | NO | | 0 | |
RA_OF_ASC_NODE | double | NO | | 0 | |
ARG_OF_PERICENTER | double | NO | | 0 | |
MEAN_ANOMALY | double | NO | | 0 | |
EPHEMERIS_TYPE | tinyint(3) unsigned | NO | | 0 | |
CLASSIFICATION_TYPE | char(1) | NO | | | |
NORAD_CAT_ID | int(10) unsigned | YES | | | |
ELEMENT_SET_NO | smallint(5) unsigned | NO | | 0 | |
REV_AT_EPOCH | float | NO | | 0 | |
BSTAR | double | NO | | 0 | |
MEAN_MOTION_DOT | double | NO | | 0 | |
MEAN_MOTION_DDOT | double | NO | | 0 | |
TLE_LINE0 | varchar(27) | NO | | | |
TLE_LINE1 | char(71) | NO | | | |
TLE_LINE2 | char(71) | NO | | | |
SEMIMAJOR_AXIS | double(20,3) | NO | | 0.000 | |
PERIOD | double(20,3) | YES | | | |
APOAPSIS | double(20,3) | NO | | 0.000 | |
PERIAPSIS | double(20,3) | NO | | 0.000 | |
OBJECT_TYPE | varchar(12) | YES | | | |
DECAYED | decimal(3,0) | NO | | 0 | |