universe.sql

DROP TABLE moon;

DROP TABLE planet;

DROP TABLE STAR;

DROP TABLE galaxy;

DROP TABLE administrative;

CREATE TABLE
  administrative (
    administrative_id SERIAL PRIMARY KEY,
    name VARCHAR(30) NOT NULL UNIQUE,
    department TEXT,
    cost INT
  );

INSERT INTO
  administrative (name, department, cost)
VALUES
  ('sales', 'sales', 123),
  ('hr', 'hr', 1233),
  ('management', 'management', 1232);

CREATE TABLE
  galaxy (
    galaxy_id SERIAL PRIMARY KEY,
    name VARCHAR(30) UNIQUE,
    density INT,
    age INT,
    lightness NUMERIC(6, 2) UNIQUE,
    finder TEXT NOT NULL,
    habitable BOOLEAN NOT NULL,
    explorable BOOLEAN
  );

CREATE TABLE
  star (
    star_id serial primary key,
    name varchar(30) UNIQUE,
    atoms int not null,
    protons int not null,
    darkness NUMERIC(6, 2),
    disocoverer TEXT,
    probed BOOLEAN,
    harnessed BOOLEAN,
    galaxy_id int,
    Constraint galaxy_id Foreign key (galaxy_id) References galaxy (galaxy_id)
  );

INSERT INTO
  galaxy (
    name,
    density,
    age,
    lightness,
    finder,
    habitable,
    explorable
  )
VALUES
  (
    'gringo paradise',
    2,
    324,
    '4.52',
    'jacob',
    TRUE,
    TRUE
  ),
  ('green zone', 4, 546, '3.4', 'glenn', TRUE, TRUE),
  ('macau', 4, 3, '6.7', 'bobb', TRUE, FALSE),
  ('galgor', 2, 34, '5.6', 'me', TRUE, FALSE),
  (
    'sloop john b',
    123,
    93409,
    '234.33',
    'dave',
    FALSE,
    TRUE
  ),
  (
    'hong kong',
    12,
    23423,
    '32.56',
    'eduard',
    TRUE,
    FALSE
  );

InSERT INTO
  star (
    name,
    atoms,
    protons,
    darkness,
    disocoverer,
    probed,
    harnessed,
    galaxy_id
  )
VALUES
  ('melba', 12, 23, '5.6', 'melba', FALSE, FALSE, 1),
  (
    'jimmy',
    1234,
    34235,
    '85.04',
    'jimmy',
    TRUE,
    FALSE,
    3
  ),
  ('paul', 563, 234, '0.23', 'paul', TRUE, FALSE, 1),
  (
    'micah',
    435,
    8934,
    '0.45',
    'vikander',
    TRue,
    False,
    2
  ),
  ('aurora', 6, 154, '9.23', 'lyra', TRUE, TRUE, 1),
  (
    'nebula prime',
    10,
    764,
    '4.12',
    'orion',
    TRUE,
    FALSE,
    2
  ),
  (
    'cosmo delta',
    3,
    67,
    '1.34',
    'altair',
    FALSE,
    TRUE,
    3
  ),
  (
    'eclipse zone',
    8,
    902,
    '12.78',
    'vega',
    TRUE,
    TRUE,
    2
  ),
  (
    'andromeda',
    14,
    4500,
    '7.55',
    'cassiopeia',
    TRUE,
    FALSE,
    1
  );

CREATE TABLE
  planet (
    planet_id SERIAL PRIMARY KEY,
    name varchar(30) NOT NULL UNIQUE,
    inhabited BOOLEAN NOT NULL,
    star_id INT,
    is_green BOOLEAN,
    has_ocean BOOLEAN,
    constraint star_id foreign key (star_id) references star (star_id)
  );

INSERT INTO
  planet (name, inhabited, star_id, is_green, has_ocean)
VALUES
  ('gronk', TRUE, 1, TRUE, TRUE),
  ('melbor', FALSE, 2, FALSE, TRUE),
  ('xanthea', TRUE, 1, TRUE, FALSE),
  ('luridia', FALSE, 3, FALSE, FALSE),
  ('zephyra', TRUE, 2, TRUE, TRUE),
  ('ignis', FALSE, 4, FALSE, FALSE),
  ('aqualis', TRUE, 3, FALSE, TRUE),
  ('corthos', FALSE, 4, FALSE, TRUE),
  ('balthea', TRUE, 1, TRUE, FALSE),
  ('kyron', FALSE, 2, FALSE, FALSE),
  ('ventara', TRUE, 3, TRUE, TRUE),
  ('solaria', FALSE, 4, FALSE, TRUE);

CREATE TABLE
  moon (
    moon_id SERIAL PRIMARY KEY,
    name varchar(30) NOT NULL UNIQUE,
    inhabited BOOLEAN NOT NULL,
    planet_id INT,
    is_explorable BOOLEAN,
    is_minable BOOLEAN,
    constraint planet_id foreign key (planet_id) references planet (planet_id)
  );

INSERT INTO
  moon (
    name,
    inhabited,
    planet_id,
    is_explorable,
    is_minable
  )
VALUES
  ('tom brady', TRUE, 1, TRUE, TRUE),
  ('lunarix', FALSE, 2, TRUE, TRUE),
  ('selenor', TRUE, 3, TRUE, FALSE),
  ('crimora', FALSE, 4, FALSE, TRUE),
  ('caldera', TRUE, 5, TRUE, TRUE),
  ('emberlyn', FALSE, 6, FALSE, FALSE),
  ('glintara', TRUE, 7, TRUE, TRUE),
  ('morrida', FALSE, 8, TRUE, FALSE),
  ('tyralis', TRUE, 9, FALSE, TRUE),
  ('phoenara', FALSE, 10, TRUE, TRUE),
  ('galidora', TRUE, 11, TRUE, FALSE),
  ('zenlith', FALSE, 12, FALSE, TRUE),
  ('quintara', TRUE, 1, TRUE, TRUE),
  ('shadowmere', FALSE, 2, TRUE, FALSE),
  ('eclipso', TRUE, 3, FALSE, TRUE),
  ('astrellis', FALSE, 4, TRUE, TRUE),
  ('nythera', TRUE, 5, TRUE, FALSE),
  ('volcora', FALSE, 6, FALSE, TRUE),
  ('aurialis', TRUE, 7, TRUE, TRUE),
  ('noctis', FALSE, 8, FALSE, TRUE);