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)