erp_product
Tables (4)
Untitled
material
- ma_code — CHAR(5) — Primary key — NOT NULL
- ma_name — VARCHAR(20)
- ma_cost — int
product
- pr_code — CHAR(8) — Primary key — NOT NULL
- pr_name — VARCHAR(50) — NOT NULL
- pr_price — INT — NOT NULL
- pr_ctgry — VARCHAR(20)
recipe
- pr_code — CHAR(8) — Foreign key → product.pr_code — NOT NULL
- ma001 — double — NOT NULL
- ma002 — double — NOT NULL
- ma003 — double — NOT NULL