4

Tables (13)

author

  • author_id — SERIAL — Primary key
  • name — VARCHAR(255) — NOT NULL

basket_item

  • basket_item_id — SERIAL
  • basket_id — INT
  • product_id — INT
  • format_id — INT
  • offer_price — NUMERIC(12,2) — NOT NULL
  • quantity — INT — NOT NULL
  • added_at — TIMESTAMP

customer

  • customer_id — SERIAL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)
  • address — TEXT
  • phone — VARCHAR(50)

format

  • format_id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

offer

  • product_id — INT
  • format_id — INT
  • price — NUMERIC(12,2) — NOT NULL
  • stock — INT
  • additional_info — JSONB

order

  • order_id — SERIAL
  • customer_id — INT
  • order_date — TIMESTAMP
  • total_amount — NUMERIC(14,2)
  • status — VARCHAR(50)

order_item

  • order_item_id — SERIAL
  • order_id — INT
  • product_id — INT
  • format_id — INT
  • unit_price — NUMERIC(12,2) — NOT NULL
  • quantity — INT — NOT NULL

product

  • product_id — SERIAL — Primary key
  • title — VARCHAR(512) — NOT NULL
  • isbn — VARCHAR(50)
  • year — INT
  • description — TEXT
  • publisher_id (publisher_id2) — SERIAL — Foreign key → publisher.publisher_id

publisher

  • publisher_id — SERIAL — Primary key
  • name — VARCHAR(255) — NOT NULL

shopping_basket

  • basket_id — SERIAL
  • customer_id — INT
  • created_at — TIMESTAMP
  • status — VARCHAR(50)

stock

  • stock_id — SERIAL
  • warehouse_id — INT
  • product_id — INT
  • format_id — INT
  • quantity — INT — NOT NULL

warehouse

  • warehouse_id — SERIAL
  • code — VARCHAR(50)
  • address — TEXT
  • phone — VARCHAR(50)

written_by

  • product_id — INT
  • author_id — INT