오늘냉장고

테이블 (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