Erd_POS
Tables (3)
Ingredient (재료)
- Email (Key) — VARCHAR(100) — Foreign key → User.Email — NOT NULL
- Ingredient (Field2) — VARCHAR(10) — NOT NULL
- Category (Field3) — VARCHAR(10)
- Storage (Field4) — VARCHAR(10)
- Image (Field5) — Image
- ExpirationDate (Field6) — DateTime
- Count (Field7) — Int
Recipes (레시피)
- FoodIngredient (Field) — VARCHAR(10)
- Recipe (Key) — VARCHAR(10) — NOT NULL
User (유저)
- Email (Key) — VARCHAR(100) — Primary key — NOT NULL
- Field — VARCHAR(10)