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)