3

Tables (3)

format

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

offer

  • product_id — SERIAL — Foreign key → product.product_id
  • format_id — SERIAL — Foreign key → format.format_id
  • price — NUMERIC(12,2) — NOT NULL
  • additional_info — TEXT

product

  • product_id — SERIAL — Primary key
  • title — VARCHAR(512) — NOT NULL
  • year — INT
  • description — TEXT