외주 ERD

테이블 (6)

alerts

  • id — SERIAL — 기본 키 — NOT NULL
  • variant_id — SERIAL — 외래 키 → product_variants.product_id — NOT NULL
  • threshold — INT — NOT NULL
  • alert_date — TIMESTAMP
  • resolved — BOOLEAN

orders

  • id — SERIAL — 기본 키 — NOT NULL
  • variant_id — SERIAL — 외래 키 → product_variants.product_id — NOT NULL
  • supplier_id — SERIAL — 외래 키 → suppliers.id — NOT NULL
  • quantity — INT — NOT NULL
  • status — VARCHAR(10)
  • order_date — TIMESTAMP

product_variants

  • id — SERIAL — 기본 키 — NOT NULL
  • product_id — SERIAL — 외래 키 → products.id — NOT NULL
  • variant_code — VARCHAR(50) — NOT NULL
  • option — VARCHAR(255) — NOT NULL
  • stock — INT — NOT NULL
  • price — INT — NOT NULL
  • created_at — TIMESTAMP

products

  • id — SERIAL — 기본 키 — NOT NULL
  • product_id — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

sales

  • id — SERIAL — 기본 키 — NOT NULL
  • variant_id — SERIAL — 외래 키 → product_variants.product_id — NOT NULL
  • quantity — INT — NOT NULL
  • total_price — INT — NOT NULL
  • sale_date — TIMESTAMP

suppliers

  • id — SERIAL — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • contact — VARCHAR(20)
  • address — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL