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)
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)