KB_miniPtj

Tables (5)

Ingredient (CopyOfUntitled2)

  • ingredientId (Key2) — Primary key — NOT NULL
  • ingredientName (Field)
  • stock (Field2)
  • ingredientPrice (Field3)
  • ingredientKcal (Field4)
  • ingerdientCategory (Field5)

Membership (Untitled)

  • memberID (Key) — Primary key — NOT NULL
  • memberName (Field)
  • phoneNumber (Field2)
  • point (Field3)

Menu (Untitled3)

  • menuId (Key) — Primary key — NOT NULL
  • menuName (Field)
  • menuPrice (Field2)

Order (Untitled4)

    UserHistory (Untitled2)

    • userHistoryId (PK) — Primary key — NOT NULL
    • menuId (FK1) — Foreign key → Menu.menuId — NOT NULL
    • memberID (FK2) — Foreign key → Membership.memberID — NOT NULL
    • regdate (Field)
    • breadId (Field2)
    • cheeseId (Field3)