여행 추천 서비스 ERD
테이블 (16)
Alarm
- alarm_id — BIGINT — 기본 키 — NOT NULL
- comment_id — BIGINT — 외래 키 → Comment.comment_id — NOT NULL
- target_member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
- is_read — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
Comment
- comment_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(500) — NOT NULL
- like_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
- post_id — BIGINT — 외래 키 → Post.post_id — NOT NULL
- parent_id — BIGINT — 외래 키 → Comment.comment_id
- status — TINYINT — NOT NULL
Destination
- destination_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- country — VARCHAR(100) — NOT NULL
- city — VARCHAR(100)
- average_cost — INT — NOT NULL
- feature — VARCHAR(50) — NOT NULL
- is_domestic — TINYINT — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
Like_Post
- like_post_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → Post.post_id — NOT NULL
- member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
MBTI_Preference
- mbti_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
- mbti_type — CHAR(4) — NOT NULL
- lodging_weight — TINYINT — NOT NULL
- flight_weight — TINYINT — NOT NULL
- shopping_weight — TINYINT — NOT NULL
- activity_weight — TINYINT — NOT NULL
- sightseeing_weight — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Member
- member_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- mbti_type — CHAR(4)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Post
- post_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
- status — TINYINT — NOT NULL
Travel_Place
- place_id — BIGINT — 기본 키 — NOT NULL
- destination_id — BIGINT — 외래 키 → Destination.destination_id — NOT NULL
- category — VARCHAR(30) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- estimated_cost — INT — NOT NULL
- rating — DECIMAL(2,1)
- created_at — DATETIME — NOT NULL
alarm
- alarm_id — BIGINT — 기본 키 — NOT NULL
- comment_id — BIGINT — 외래 키 → comment.comment_id — NOT NULL
- target_member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- is_read — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
comment
- comment_id — BIGINT — 기본 키 — NOT NULL
- content — VARCHAR(500) — NOT NULL
- like_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- post_id — BIGINT — 외래 키 → post.post_id — NOT NULL
- parent_id — BIGINT — 외래 키 → comment.comment_id
- status — TINYINT — NOT NULL
destination
- destination_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- country — VARCHAR(100) — NOT NULL
- city — VARCHAR(100)
- average_cost — INT — NOT NULL
- feature — VARCHAR(50) — NOT NULL
- is_domestic — TINYINT — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
like_post
- like_post_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → post.post_id — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
mbti_preference
- mbti_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- mbti_type — CHAR(4) — NOT NULL
- lodging_weight — TINYINT — NOT NULL
- flight_weight — TINYINT — NOT NULL
- shopping_weight — TINYINT — NOT NULL
- activity_weight — TINYINT — NOT NULL
- sightseeing_weight — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member
- member_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- mbti_type — CHAR(4)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
post
- post_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- status — TINYINT — NOT NULL
travel_place
- place_id — BIGINT — 기본 키 — NOT NULL
- destination_id — BIGINT — 외래 키 → destination.destination_id — NOT NULL
- category — VARCHAR(30) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- estimated_cost — INT — NOT NULL
- rating — DECIMAL(2,1)
- created_at — DATETIME — NOT NULL