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)