Universe Datenbank Schema

celestial_objects

CREATE TABLE celestial_objects (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  type TEXT NOT NULL,
  parent_id TEXT,
  system_id TEXT,
  galaxy_id TEXT,
  mass_kg REAL,
  radius_km REAL,
  distance_au REAL,
  orbital_period_days REAL,
  rotation_period_hours REAL,
  axial_tilt_deg REAL,
  surface_temp_k REAL,
  surface_gravity REAL,
  composition TEXT,
  atmosphere TEXT,
  magnetic_field BOOLEAN,
  rings BOOLEAN,
  moons_count INTEGER,
  texture_url TEXT,
  color_hex TEXT,
  shader_type TEXT,
  magnitude REAL,
  discovered_by TEXT,
  discovery_date TEXT,
  constellation TEXT,
  ra_deg REAL,
  dec_deg REAL,
  description TEXT,
  fun_facts TEXT,
  nft_token_id TEXT,
  owner_address TEXT,
  created_at TEXT DEFAULT (datetime('now'))
);

moons

CREATE TABLE moons (
  id TEXT PRIMARY KEY,
  planet_id TEXT REFERENCES celestial_objects(id),
  name TEXT,
  radius_km REAL,
  distance_km REAL,
  orbital_period_days REAL,
  discovered_by TEXT,
  discovery_year INTEGER
);

constellation_cultures

CREATE TABLE constellation_cultures (
  constellation_id TEXT,
  culture TEXT,
  name TEXT,
  story TEXT,
  lines TEXT
);