영화 앱
테이블 (7)
food_expense_items
- id — VARCHAR(255)
- user_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- quantity — INT — NOT NULL
- price — INT — NOT NULL
- purchased_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
fridge_ingredients
- id — VARCHAR(255)
- user_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- quantity — INT — NOT NULL
- food_expense_item_id — VARCHAR(255) — 외래 키 → food_expense_items.id
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
movie
- id — uuid — 기본 키 — NOT NULL
- email — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- password — varchar(255) — NOT NULL
- created_at — timestamp — NOT NULL
recipe_scraps
- user_id — VARCHAR(255) — 외래 키 → users.id — NOT NULL
- recipe_id — VARCHAR(255) — 외래 키 → recipes.id — NOT NULL
- created_at — TIMESTAMP
recipe_steps
- id — VARCHAR(255)
- recipe_id — VARCHAR(255) — 외래 키 → recipes.id — NOT NULL
- step_number — INT — NOT NULL
- content — TEXT — NOT NULL
- image_url — VARCHAR(255)
recipes
- id — VARCHAR(255)
- source — VARCHAR(50) — NOT NULL
- public_recipe_id — VARCHAR(255)
- user_id — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(255)
- cooking_method — VARCHAR(255)
- ingredients — TEXT
- hash_tag — VARCHAR(255)
- main_image_url — VARCHAR(255)
- thumbnail_url — VARCHAR(255)
- calories — FLOAT
- carbohydrate — FLOAT
- protein — FLOAT
- fat — FLOAT
- sodium — FLOAT
- sodium_tip — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP