init_table.sql

CREATE TABLE IF NOT EXISTS products (
  id SERIAL PRIMARY KEY,
  description TEXT,
  buyer_id INTEGER,
  weld_counter DECIMAL,
  polish_counter DECIMAL,
  weave_counter DECIMAL,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS orders (
  id SERIAL PRIMARY KEY,
  client_po_no TEXT,
  shipment_date DATE, 
  product_id INTEGER,
  quantity INTEGER,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS orders_overview (
  id SERIAL PRIMARY KEY,
  client_po_no TEXT,
  shipment_date DATE, 
  production_start DATE, 
  production_end DATE);

CREATE TABLE IF NOT EXISTS schedule (
  id SERIAL PRIMARY KEY,
  order_id INTEGER,
  product_id INTEGER,
  weld_start DATE,
  weld_period_days DECIMAL,
  polish_start DATE,
  polish_period_days DECIMAL,
  weave_start DATE,
  weave_period_days DECIMAL,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS buyers (
  id SERIAL PRIMARY KEY,
  buyer_name TEXT,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS users (
  id SERIAL PRIMARY KEY,
  email TEXT,
  password TEXT,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);