Field | Type | Null | Key | Default | Extra |
INTLDES | char(12) | NO | | | |
NORAD_CAT_ID | int(10) unsigned | YES | | | |
OBJECT_TYPE | varchar(12) | YES | | | |
SATNAME | char(25) | NO | | | |
COUNTRY | char(6) | NO | | | |
LAUNCH | date | YES | | | |
SITE | char(5) | YES | | | |
DECAY | date | YES | | | |
PERIOD | decimal(12,2) | YES | | | |
INCLINATION | decimal(12,2) | YES | | | |
APOGEE | bigint(10) unsigned | YES | | | |
PERIGEE | bigint(10) unsigned | YES | | | |
COMMENT | char(32) | YES | | | |
COMMENTCODE | tinyint(3) unsigned | YES | | | |
RCSVALUE | int(1) | NO | | 0 | |
RCS_SIZE | varchar(6) | YES | | | |
FILE | smallint(5) unsigned | NO | | 0 | |
LAUNCH_YEAR | smallint(5) unsigned | NO | | 0 | |
LAUNCH_NUM | smallint(5) unsigned | NO | | 0 | |
LAUNCH_PIECE | varchar(3) | NO | | | |
CURRENT | enum('Y','N') | NO | | N | |
OBJECT_NAME | char(25) | NO | | | |
OBJECT_ID | char(12) | NO | | | |
OBJECT_NUMBER | int(10) unsigned | YES | | | |