Soviax sql structure

soviax_init.sql

CREATE SCHEMA soviax_site;

CREATE TABLE soviax_site.packages (
  id serial PRIMARY KEY, -- Es lo mismo que el autoincrement
  name text NOT NULL UNIQUE,
  title text NOT NULL,
  departure_dates text NOT NULL,
  price_desc text NOT NULL,
  start_date date NOT NULL,
  end_date date NOT NULL,
  date_created timestamp NOT NULL,
  location varchar(200) NOT NULL
);

CREATE TABLE soviax_site.package_images (
  id serial PRIMARY KEY, -- Es lo mismo que el autoincrement
  package_id int NOT NULL,
  image_path varchar(1000) NOT NULL UNIQUE,
  image_type varchar(20) -- Puede ser 'main' (es la que se muestra en la home page), 'mini', 'other'
);

CREATE TABLE soviax_site.package_details (
  id serial PRIMARY KEY, -- Es lo mismo que el autoincrement
  package_id int NOT NULL,
  description text NOT NULL,
  included bool NOT NULL
);

CREATE TABLE soviax_site.logs (
  message text NOT NULL,
  date timestamp NOT NULL
);