HonCook

Tables (5)

menu (메뉴)

  • menu_id (menuId) — bigint — Primary key — NOT NULL
  • user_id (userId) — bigint — Foreign key → user.user_id — NOT NULL

menu_comment (메뉴에 대한 댓글)

  • menu_comment_id (menuCommentId) — bigint — Primary key — NOT NULL
  • menu_id (menuId) — bigint — Foreign key → menu.menu_id — NOT NULL
  • user_id (userId) — bigint — Foreign key → user.user_id — NOT NULL

step (단계)

  • step_id (stepId) — bigint — Primary key — NOT NULL
  • menu_id (menuId) — bigint — Foreign key → menu.menu_id — NOT NULL
  • user_id (userId) — bigint — Foreign key → user.user_id — NOT NULL

step_comment (단계에 대한 댓글)

  • step_comment_id (stepCommentId) — bigint — Primary key — NOT NULL
  • step_id (stepId) — bigint — Foreign key → step.step_id — NOT NULL
  • user_id (userId) — bigint — Foreign key → user.user_id — NOT NULL

user (사용자)

  • user_id (userId) — bigint — Primary key — NOT NULL
  • tier (role) — varchar