patry_manager

Tables (9)

Ingredient

  • Key (ingredient_id) — int — Primary key — NOT NULL
  • Key (pantry_id) — int — Foreign key → Pantry.Key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field2 (quantity) — int — NOT NULL
  • Field4 (expiration) — date
  • Field5 (created) — timestamp — NOT NULL
  • Field3 (barcode) — varchar(50)

Pantry

  • Key (pantry_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (created) — timestamp — NOT NULL

Recipe

  • Key (recipe_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (title) — varchar(50) — NOT NULL
  • Field (content) — varchar(50) — NOT NULL
  • Field (created) — timesramp — NOT NULL

Recipe_Ingredient (Recipe_ingredient)

  • Key (recipe_ingredient_id) — int — Primary key — NOT NULL
  • Key (ingredient_id2) — int — Foreign key → Ingredient.Key — NOT NULL
  • Key (recipe_id) — int — Foreign key → Recipe.Key — NOT NULL
  • Field (quantity) — int

Untitled2 (ShoppingList)

  • Key (shoppinglist_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (item) — varchar(50) — NOT NULL
  • Field (created) — timestamp — NOT NULL

Untitled2 (Notification)

  • Key — notification_id — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Key (ingredient_id) — int — Foreign key → Ingredient.Key — NOT NULL
  • Field (message) — text — NOT NULL
  • Field2 (sent_at) — timestamp — NOT NULL
  • Field (is_read) — boolean — NOT NULL

Untitled2 (Budget)

  • Key (budget_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (start) — date — NOT NULL
  • Field (end) — date — NOT NULL
  • Field (total) — decimal(10,2) — NOT NULL
  • Field (remaining) — decimal(10,2) — NOT NULL
  • Field (created) — timestamp — NOT NULL

Untitled2 (Expense)

  • Key — Primary key — NOT NULL
  • Key (budget_id) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (date) — date — NOT NULL
  • Field (amount) — decimal(10,2) — NOT NULL
  • Field (description) — text
  • Field (created) — timestamp — NOT NULL

User

  • Key (user_id) — int — Primary key — NOT NULL
  • 이메일 (email) — varchar(50)
  • Field2 (pssword) — varchar(50)
  • Field3 (name) — varchar(50)
  • Field (created) — timestamp
  • Field2 (updated) — timestamp