ㅁㅁㅁ
Tables (10)
dong
- id — INT — Primary key — NOT NULL
- sigungu_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
food_expense_items
- id — VARCHAR(255)
- user_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
- quantity — INT — NOT NULL
- price — INT — NOT NULL
- purchased_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
fridge_ingredients
- id — VARCHAR(255)
- user_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
- quantity — INT — NOT NULL
- food_expense_item_id — VARCHAR(255) — Foreign key → food_expense_items.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
policy_scraps
- id — ObjectId — Primary key — NOT NULL
- user_id — ObjectId — NOT NULL
- policy_id — String — NOT NULL
- policy_name — String — NOT NULL
- support_type — String
- apply_start_date — LocalDate
- apply_end_date — LocalDate
- notification_sent — Boolean — NOT NULL
- created_at — LocalDateTime
recipe_scraps
- user_id — UUID — Foreign key → users.id — NOT NULL
- recipe_id — VARCHAR(255) — Foreign key → recipes.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
recipe_steps
- id — VARCHAR(255) — Primary key — NOT NULL
- recipe_id — VARCHAR(255) — Foreign key → recipes.id — NOT NULL
- step_number — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- image_url — TEXT
recipes
- id — VARCHAR(255) — Primary key — NOT NULL
- source — recipe_source — NOT NULL
- public_recipe_id — VARCHAR(255)
- user_id — UUID — Foreign key → users.id
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(255)
- cooking_method — VARCHAR(255)
- ingredients — TEXT
- hash_tag — VARCHAR(255)
- main_image_url — TEXT
- thumbnail_url — TEXT
- calories — DOUBLE
- carbohydrate — DOUBLE
- protein — DOUBLE
- fat — DOUBLE
- sodium — DOUBLE
- sodium_tip — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
sido
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
sigungu
- id — INT — Primary key — NOT NULL
- sido_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
users
- id — UUID — Primary key — NOT NULL
- kakao_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(100)
- birthday — DATE
- dong_id — INT
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP