도리

테이블 (9)

attraction_info

  • content_id — integer — 외래 키 → post.attraction_id

comment

  • id — integer
  • content — varchar(255)
  • user_id — integer — 외래 키 → user.id
  • post_id — integer — 외래 키 → post.id
  • created_at — timestamp
  • changed_at — timestamp

favorite

  • id — integer
  • user_id — integer — 외래 키 → user.id
  • attraction_id — integer — 외래 키 → attraction_info.content_id
  • plan_id — integer — 외래 키 → plan.id

plan

  • id — integer
  • user_id — integer — 외래 키 → user.id
  • title — varchar(255) — NOT NULL
  • content — varchar(255) — NOT NULL
  • open — integer
  • created_at — timestamp
  • changed_at — timestamp
  • hit — integer

plan_list

  • id — integer
  • plan_id — integer — 외래 키 → plan.id
  • attraction_id — integer — 외래 키 → attraction_info.content_id
  • comment — varchar(255)

post

  • id — integer
  • title — varchar(255)
  • content — text — Content of the post
  • user_id — integer — 외래 키 → user.id
  • attraction_id — integer — 상위 게시판 번호
  • created_at — timestamp
  • changed_at — timestamp
  • hit — integer

thumb

  • id — integer
  • plan_id — integer — 외래 키 → plan.id
  • post_id — integer — 외래 키 → post.id
  • comment_id — integer — 외래 키 → comment.id
  • like — integer
  • dislike — integer
  • user_id — integer — 외래 키 → user.id

user

  • id — integer — 외래 키 → verified.user_id
  • nickname — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • username — varchar(255)
  • verified — bool — NOT NULL
  • role — varchar(255)
  • created_at — timestamp
  • changed_at — timestamp

verified

  • id — integer
  • code — varchar(255) — NOT NULL — UUID 사용
  • user_id — integer — NOT NULL
  • created_at — timestamp
  • changed_at — timestamp