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