외주 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