BackGarden ERD
Tables (5)
Ingredients
- ingreNum — Primary key — NOT NULL
- ingreName — NOT NULL
- ingrePrice
- ingreCount
- ingreClient
- ingreCategory
dish
- dish_num — Primary key — NOT NULL
- disn_name (dish_name) — NOT NULL
- dish_price — NOT NULL
sales
- sales_num — Primary key — NOT NULL
- dish_num — Foreign key → dish.dish_num — NOT NULL
- how_many — NOT NULL
- amount — NOT NULL
- sales_date — NOT NULL
suppliers
- supplier_id — Primary key — NOT NULL
- supplier_name — NOT NULL
- category
- contact_name
- phone
- address
users
- id — Primary key — NOT NULL
- password — NOT NULL
- name — NOT NULL
- tel