travelssafy

Tables (11)

attraction_description

  • content_id — int — Foreign key → attraction_info.content_id — NOT NULL
  • homepage — varchar(100)
  • overview — varchar(10000)
  • telname — varchar(45)

attraction_detail

  • content_id — int — Foreign key → attraction_info.content_id — NOT NULL
  • cat1 — varchar(3)
  • cat2 — varchar(5)
  • cat3 — varchar(9)
  • created_time — varchar(14)
  • modified_time — varchar(14)
  • booktour — varchar(5)

attraction_info

  • content_id — int — Primary key — NOT NULL
  • content_type_id — int
  • 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
  • sido_code — int — Foreign key → sido.sido_code
  • gugun_code — int — Foreign key → gugun.gugun_code
  • latitude — decimal(20,17)
  • longitude — decimal(20,17)
  • mlevel — varchar(2)

board

  • article_no — INT — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → member.user_id
  • subject — VARCHAR(100)
  • content — VARCHAR(2000)
  • hit — INT
  • register_time — TIMESTAMP — NOT NULL
  • INDEX — `board_to_member_user_id_fk`

favorite

  • favorite_id — int — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → member.user_id — NOT NULL
  • content_id — int — Foreign key → attraction_info.content_id — NOT NULL

gugun

  • gugun_code — int — Primary key — NOT NULL
  • sido_code — int — Foreign key → sido.sido_code — NOT NULL
  • gugun_name — varchar(30)

member

  • user_id — varchar(50) — Primary key — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(255)
  • sido_code — int — Foreign key → sido.sido_code — NOT NULL
  • gugun_code — int — Foreign key → gugun.gugun_code — NOT NULL
  • is_active — int

memo

  • memo_no — INT — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → member.user_id
  • comment — VARCHAR(500)
  • memo_time — TIMESTAMP — NOT NULL
  • article_no — INT — Foreign key → board.article_no
  • parent_memo_no — INT — Foreign key → memo.memo_no
  • INDEX — `memo_to_board_article_no_fk`
  • INDEX — `memo_to_member_fk_idx`

plan

  • plan_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → member.user_id — NOT NULL
  • title — VARCHAR(255)
  • memo — VARCHAR(1000)

plan_detail

  • planDetail_id — INT — Primary key — NOT NULL
  • plan_id — INT — Foreign key → plan.plan_id — NOT NULL
  • content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
  • sequence — INT — NOT NULL

sido

  • sido_code — int — Primary key — NOT NULL
  • sido_name — varchar(30)