오늘냉장고
테이블 (18)
bookmark
- bookmark_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- recipe_id — BIGINT — 외래 키 → recipes.recipe_id — NOT NULL
- created_at — DATETIME — NOT NULL
condition_code
- condition_id — BIGINT — 기본 키 — NOT NULL
- condition_code — VARCHAR(30) — NOT NULL
- condition_name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
file_asset
- file_id — BIGINT — 기본 키 — NOT NULL
- uploader_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- storage_type — VARCHAR(20) — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- mime_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- storage_path — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
ingredient_category
- category_id — BIGINT — 기본 키 — NOT NULL
- category_code — VARCHAR(30) — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
ingredient_master
- ingredient_master_id — BIGINT — 기본 키 — NOT NULL
- normalized_name — VARCHAR(100) — NOT NULL
- category_id — BIGINT — 외래 키 → ingredient_category.category_id — NOT NULL
- alias_text — TEXT
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
notification
- notification_id — BIGINT — 기본 키 — NOT NULL
- target_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- actor_user_id — BIGINT — 외래 키 → users.user_id
- related_post_id — BIGINT — 외래 키 → post.post_id
- notification_type — VARCHAR(30) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- read_at — DATETIME
post
- post_id — BIGINT — 기본 키 — NOT NULL
- author_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- like_count — INT — NOT NULL
- report_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
post_image
- post_image_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.post_id — NOT NULL
- file_id — BIGINT — 외래 키 → file_asset.file_id — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
post_like
- post_like_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.post_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
post_report
- post_report_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.post_id — NOT NULL
- reporter_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- reason_code — VARCHAR(30) — NOT NULL
- detail_text — VARCHAR(500)
- created_at — DATETIME — NOT NULL
recipe_condition_map
- recipe_condition_map_id — BIGINT — 기본 키 — NOT NULL
- recipe_id — BIGINT — 외래 키 → recipes.recipe_id — NOT NULL
- condition_id — BIGINT — 외래 키 → condition_code.condition_id — NOT NULL
- fit_type — VARCHAR(20) — NOT NULL
- source_type — VARCHAR(20) — NOT NULL
- confidence_score — DECIMAL(5,2)
recipe_ingredient
- recipe_ingredient_id — BIGINT — 기본 키 — NOT NULL
- recipe_id — BIGINT — 외래 키 → recipes.recipe_id — NOT NULL
- ingredient_master_id — BIGINT — 외래 키 → ingredient_master.ingredient_master_id
- raw_text — VARCHAR(200) — NOT NULL
- normalized_name_snapshot — VARCHAR(100) — NOT NULL
- amount_text — VARCHAR(50)
- unit — VARCHAR(20)
- is_optional — BOOLEAN — NOT NULL
- sort_order — INT — NOT NULL
recipe_step
- recipe_step_id — BIGINT — 기본 키 — NOT NULL
- recipe_id — BIGINT — 외래 키 → recipes.recipe_id — NOT NULL
- step_no — INT — NOT NULL
- instruction_text — TEXT — NOT NULL
- step_image_url — VARCHAR(500)
recipes
- recipe_id — BIGINT — 기본 키 — NOT NULL
- source_site — VARCHAR(50) — NOT NULL
- source_recipe_key — VARCHAR(100) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- thumbnail_url — VARCHAR(500)
- summary — TEXT
- servings_text — VARCHAR(50)
- cook_time_text — VARCHAR(50)
- source_url — VARCHAR(500)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_follow
- follow_id — BIGINT — 기본 키 — NOT NULL
- follower_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- followee_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
user_ingredient
- user_ingredient_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- ingredient_master_id — BIGINT — 외래 키 → ingredient_master.ingredient_master_id
- raw_name — VARCHAR(100) — NOT NULL
- normalized_name_snapshot — VARCHAR(100) — NOT NULL
- quantity — DECIMAL(10,2)
- unit — VARCHAR(20)
- storage_type — VARCHAR(30)
- expires_at — DATE
- freshness_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_session
- session_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- refresh_token_hash — VARCHAR(255) — NOT NULL
- user_agent — VARCHAR(255)
- last_ip — VARCHAR(64)
- expires_at — DATETIME — NOT NULL
- revoked_at — DATETIME
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL