Public LEOrbiters ERD

Tables (5)

Alerts

  • alert_id — BIGINT
  • conjunction_id — BIGINT — Foreign key → Conjunctions.conjunction_id — NOT NULL
  • user_id — INT — Foreign key → Users.user_id
  • alert_timestamp — TIMESTAMP — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL

Conjunctions

  • conjunction_id — BIGINT
  • satellite1_id — INT — Foreign key → Satellites.satellite_id — NOT NULL
  • satellite2_id — INT — Foreign key → Satellites.satellite_id — NOT NULL
  • closest_approach_time — TIMESTAMP — NOT NULL
  • closest_approach_distance_km — DECIMAL(10, 3) — NOT NULL
  • collision_probability — DECIMAL(5, 4) — NOT NULL
  • risk_level — VARCHAR(10) — NOT NULL

Satellites

  • satellite_id — INT
  • name — VARCHAR(100) — NOT NULL
  • norad_id — VARCHAR(20) — NOT NULL
  • owner_country — VARCHAR(50)
  • launch_date — DATE
  • status — VARCHAR(10) — NOT NULL
  • description — TEXT

Trajectories

  • trajectory_id — BIGINT
  • satellite_id — INT — Foreign key → Satellites.satellite_id — NOT NULL
  • timestamp — TIMESTAMP — NOT NULL
  • latitude — DECIMAL(9, 6) — NOT NULL
  • longitude — DECIMAL(9, 6) — NOT NULL
  • altitude — DECIMAL(10, 3) — NOT NULL
  • fir — VARCHAR(50)
  • is_predicted — BOOLEAN — NOT NULL

Users

  • user_id — INT
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_type — VARCHAR(20) — NOT NULL
  • registration_date — TIMESTAMP