First Time in Korea?
Tables (20)
article (여행지 후기)
- id — INT — Primary key — NOT NULL — AUTO_INCREMENT
- member_id — VARCHAR(50) — Foreign key → member.id — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- hit — INT
- created_time — TIMESTAMP — NOT NULL
- modified_time — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP
article_and_article_tag (여행지 후기 태그&여행지 후기)
- id — INT — Primary key — NOT NULL — AUTO_INCREMENT
- article_id — INT — Foreign key → article.id — NOT NULL — AUTO_INCREMENT
- article_tag_id — INT — Foreign key → article_tag.id — NOT NULL — AUTO_INCREMENT
article_comment (여행지 후기 댓글)
- id — INT — Primary key — NOT NULL — auto_increment
- article_id — INT — Foreign key → article.id — NOT NULL — auto_increment
- member_id — VARCHAR(50) — Foreign key → member.id — NOT NULL
- parent_article_comment_id — INT — Foreign key → article_comment.id
- content — VARCHAR(2000) — NOT NULL
- depth — INT — NOT NULL
- created_time — TIMESTAMP — NOT NULL
- is_deleted — TNYINT(1) — NOT NULL
article_file (여행지 후기 사진)
- id — INT — Primary key — NOT NULL — AUTO_INCREMENT
- article_id — INT — Foreign key → article.id — NOT NULL — AUTO_INCREMENT
- save_folder — VARCHAR(45) — NOT NULL
- origin_file — VARCHAR(50) — NOT NULL
- save_file — VARCHAR(50) — NOT NULL
article_like (여행지 후기 좋아요)
- id — INT — Primary key — NOT NULL — AUTO_INCREMENT
- article_id — INT — Foreign key → article.id — NOT NULL
- member_id — VARCHAR(50) — Foreign key → member.id — NOT NULL
article_tag (여행지 후기 태그)
- id — INT — Primary key — NOT NULL — AUTO_INCREMENT
- name — VARCHAR(50) — NOT NULL
attraction_description
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL — PK
- overview — VARCHAR(10000)
attraction_detail
- content_id — INT — Foreign key → attraction_description.content_id — NOT NULL — PK
- thema_code — VARCHAR(3) — Foreign key → thema.thema_code — NOT NULL — A, B, C, ...
- category_code — VARCHAR(5) — Foreign key → category.category_code — NOT NULL — A01, A02, A03, ...
- created_time — VARCHAR(14)
- modified_time — VARCHAR(14)
- booktour — VARCHAR(5) — 예약 필요 여부
attraction_info
- content_id — INT — Primary key — NOT NULL
- sido_code — INT — Foreign key → sido.sido_code — NOT NULL
- gugun_code — INT — Foreign key → gugun.gugun_code — NOT NULL
- title — VARCHAR(100)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(50)
- zipcode — VARCHAR(50)
- tel — VARCHAR(50)
- first_image — VARCHAR(200)
- first_image2 — VARCHAR(200)
- readcount — INT
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
bookmark (여행지 북마크)
- id — INT — Primary key — NOT NULL — AUTO_INCREMENT
- member_id — VARCHAR(50) — Foreign key → member.id — NOT NULL
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
category (여행지 카테고리 코드)
- category_code — VARCHAR(5) — Primary key — NOT NULL — A01, A02, A03, ...
- thema_code — VARCHAR(3) — Foreign key → thema.thema_code — NOT NULL — A, B, C, ...
- category_name — VARCHAR(50)
gugun (구군)
- gugun_code — INT — Primary key — NOT NULL
- sido_code — INT — Foreign key → sido.sido_code — NOT NULL
- gugun_name — VARCHAR(30)
member (회원)
- id — VARCHAR(50) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email_id — VARCHAR(50) — NOT NULL
- email_domain — VARCHAR(100) — NOT NULL
- status — TINYINT(1) — NOT NULL — 0:비활성화, 1:활성화
- token — VARCHAR(255)
member_file (회원 프로필 이미지)
- id — INT — Primary key — NOT NULL
- member_id — VARCHAR(50) — Foreign key → member.id — NOT NULL
- save_folder — VARCHAR(45) — NOT NULL
- origin_file — VARCHAR(50) — NOT NULL
- save_file — VARCHAR(50) — NOT NULL
plan (여행 계획)
- id — INT — Primary key — NOT NULL — auto_increment
- member_id — VARCHAR(50) — Foreign key → member.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- created_time — TIMESTAMP — NOT NULL
- modified_time — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP
plan_and_attraction (관계 테이블)
- id — INT — Primary key — NOT NULL — auto_increment
- plan_id — INT — Foreign key → plan.id — NOT NULL
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- date — TIMESTAMP — NOT NULL
plan_file (여행 계획 썸네일)
- id — INT — Primary key — NOT NULL — auto_increment
- plan_id — INT — Foreign key → plan.id — NOT NULL
- save_folder — VARCHAR(45) — NOT NULL
- origin_file — VARCHAR(50) — NOT NULL
- save_file — VARCHAR(50) — NOT NULL
plan_memo (Untitled)
- id — Primary key — NOT NULL — auto increment
- plan_and_attraction_id — INT — Foreign key → plan_and_attraction.id — NOT NULL — 여행계획-장소 쌍에 대한 메모
- text — 기본은 NULL, 상세 페이지에서 수정 시 글 들어옴
- modified_time — NOT NULL — ON UPDATE CURRENT_TIMESTAMP
sido (시도)
- sido_code — INT — Primary key — NOT NULL
- sido_name — VARCHAR(30)
thema (여행지 테마 코드)
- thema_code — VARCHAR(3) — Primary key — NOT NULL — A, B, C, ...
- thema_name — VARCHAR(50)