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