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