Field | Type | Null | Key | Default | Extra |
COMMENT | varchar(32) | NO | | | |
ORIGINATOR | varchar(7) | NO | | | |
NORAD_CAT_ID | int(10) unsigned | YES | | | |
OBJECT_NAME | varchar(25) | NO | | | |
OBJECT_TYPE | varchar(12) | YES | | | |
CLASSIFICATION_TYPE | char(1) | NO | | | |
INTLDES | varchar(8) | YES | | | |
EPOCH | datetime | NO | | 1000-01-01 00:00:00 | |
EPOCH_MICROSECONDS | mediumint(8) unsigned | NO | | 0 | |
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 | |
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 | |
FILE | int(10) unsigned | NO | | 0 | |
TLE_LINE0 | varchar(27) | NO | | | |
TLE_LINE1 | char(71) | NO | | | |
TLE_LINE2 | char(71) | NO | | | |
OBJECT_ID | varchar(11) | YES | | | |
OBJECT_NUMBER | int(10) unsigned | YES | | | |
SEMIMAJOR_AXIS | double(20,3) | NO | | 0.000 | |
PERIOD | double(20,3) | YES | | | |
APOGEE | double(20,3) | NO | | 0.000 | |
PERIGEE | double(20,3) | NO | | 0.000 | |
DECAYED | tinyint(1) unsigned | YES | | 0 | |