Field | Type | Null | Key | Default | Extra |
CCSDS_OMM_VERS | varchar(3) | NO | | | |
COMMENT | varchar(33) | NO | | | |
CREATION_DATE | datetime | YES | | | |
ORIGINATOR | varchar(7) | NO | | | |
OBJECT_NAME | varchar(25) | YES | | | |
OBJECT_ID | varchar(12) | YES | | | |
CENTER_NAME | varchar(5) | NO | | | |
REF_FRAME | varchar(4) | NO | | | |
TIME_SYSTEM | varchar(3) | NO | | | |
MEAN_ELEMENT_THEORY | varchar(4) | NO | | | |
EPOCH | datetime(6) | YES | | | |
MEAN_MOTION | decimal(13,8) | YES | | | |
ECCENTRICITY | decimal(13,8) | YES | | | |
INCLINATION | decimal(7,4) | YES | | | |
RA_OF_ASC_NODE | decimal(7,4) | YES | | | |
ARG_OF_PERICENTER | decimal(7,4) | YES | | | |
MEAN_ANOMALY | decimal(7,4) | YES | | | |
EPHEMERIS_TYPE | tinyint(3) unsigned | YES | | 0 | |
CLASSIFICATION_TYPE | char(1) | YES | | | |
NORAD_CAT_ID | int(10) unsigned | NO | | | |
ELEMENT_SET_NO | smallint(5) unsigned | YES | | | |
REV_AT_EPOCH | mediumint(8) unsigned | YES | | | |
BSTAR | decimal(19,14) | YES | | | |
MEAN_MOTION_DOT | decimal(9,8) | YES | | | |
MEAN_MOTION_DDOT | decimal(22,13) | YES | | | |
SEMIMAJOR_AXIS | double(12,3) | YES | | | |
PERIOD | double(12,3) | YES | | | |
APOAPSIS | double(12,3) | YES | | | |
PERIAPSIS | double(12,3) | YES | | | |
OBJECT_TYPE | varchar(12) | YES | | | |
RCS_SIZE | varchar(6) | YES | | | |
COUNTRY_CODE | char(6) | YES | | | |
LAUNCH_DATE | varchar(10) | YES | | | |
SITE | char(5) | YES | | | |
DECAY_DATE | varchar(10) | YES | | | |
FILE | bigint(20) unsigned | YES | | | |
GP_ID | int(10) unsigned | NO | | | |
TLE_LINE0 | varchar(27) | YES | | | |
TLE_LINE1 | varchar(71) | YES | | | |
TLE_LINE2 | varchar(71) | YES | | | |