stellaERD
Tables (3)
3LE_DATA (Untitled)
- NORAD_ID (Key) — Foreign key → META_DATA.NORAD_ID — NOT NULL — 북미항공사령부 카탈로그 번호
- BATCH_ID (Key2) — Foreign key → META_DATA.BATCH_ID — NOT NULL
- SATELLITE_NAME (Field) — STRING — 위성이름
- LINE1 (Field2) — STRING — TLE 첫째줄
- LINE2 (Field3) — STRING — TLE 둘째줄
GP_DATA (Untitled4)
- NORAD_ID (Key) — Foreign key → META_DATA.NORAD_ID — NOT NULL
- BATCH_ID (Key2) — Foreign key → META_DATA.BATCH_ID — NOT NULL
- MEAN_MOTION (Field)
- ECCENTRICITY (Field2)
- INCLINATION (Field3)
- RA_OF_ASC_NODE (Field4)
- ARG_OF_PERICENTER (Field5)
- MEAN_ANOMALY (Field6)
- EPHEMERIS_TYPE (Field7)
- REV_AT_EPOCH (Field9)
- CLASSIFICATION_TYPE (Field10)
- BSTAR (Field11)
- MEAN_MOTION_DOT (Field12)
- MEAN_MOTION_DDOT (Field13)
- SEMIMAJOR_AXIS (Field8)
- PERIOD (Field14)
- APOAPSIS (Field15)
- PERIAPSIS (Field16)
META_DATA (Untitled2)
- NORAD_ID (Key) — Primary key — NOT NULL
- BATCH_ID (Key2) — Primary key — NOT NULL
- COUNTRY (Field)
- LAUNCH (Field2)
- SITE (Field3)
- RCS_SIZE (Field4)
- RCS_VALUE (Field5)
- OBJECT_NAME (Field6)
- OBJECT_TYPE (Field7) — NOT NULL
- OBJECT_ID (Field8)
- OBJECT_NUMBER (Field9)
- SAT_NAME (Field11)
- DECAY (Field12)
- COMMENT (Field13)
- TIME_SYSTEM (Field14)
- CREATION_DATE (Field10)
- ORIGINATOR (Field15)
- FILE (Field16)
- GP_ID (Field17)
- TIME_SYSTEM (Field18)
- ELEMENT_SET_NO (Field19)