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