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