enjoytrip

Tables (14)

attraction_description

  • content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
  • homepage (hompage) — VARCHAR(200)
  • overview — VARCHAR(10000)
  • telname — VARCHAR(45)

attraction_info

  • content_id — INT — Primary key — NOT NULL
  • sido_code (sido_code2) — INT — Foreign key → sido.sido_code — NOT NULL
  • gugun_code (gugun_code2) — INT — Foreign key → gugun.gugun_code — NOT NULL
  • content_type_id — INT
  • title — VARCHAR(100)
  • addr1 — VARCHAR(100)
  • addr2 — VARCHAR(100)
  • zipcode — VARCHAR(10)
  • tel — VARCHAR(20)
  • first_image — VARCHAR(200)
  • latitude — DECIMAL(20, 17)
  • longitude — DECIMAL(20, 17)

gugun

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

hotplace

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
  • hotplace_name — VARCHAR(20)
  • visit_date — VARCHAR(50)
  • ctype — INT
  • place_desc — VARCHAR(200)

hotplace_img

  • id — INT — Primary key — NOT NULL
  • hid — INT — Foreign key → hotplace.id — NOT NULL
  • img_path — VARCHAR(200)

hotplace_recommend

  • id — INT — Primary key — NOT NULL
  • hotplace_id (hotplcae_id) — INT — Foreign key → hotplace.id — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • recommend_time — VARCHAR(20)
  • valid — TINYINT(1)

notice

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • title — VARCHAR(30)
  • content — VARCHAR(500)
  • view_count — INT
  • write_date — VARCHAR(20)

participate

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • plan_id — INT — Foreign key → trip_plan.id — NOT NULL

selected_trip_plan

  • id — INT — Primary key — NOT NULL
  • plan_id — INT — Foreign key → trip_plan.id — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL

sido

  • sido_code — INT — Primary key — NOT NULL
  • sido_name — VARCHAR(30)

trip_plan

  • id — INT — Primary key — NOT NULL
  • plan_name — VARCHAR(50)
  • start_date — DATETIME
  • end_date — DATETIME
  • plan_detail — VARCHAR(200)

trip_plan_places

  • id — INT — Primary key — NOT NULL
  • plan_id — INT — Foreign key → trip_plan.id — NOT NULL
  • content_id — INT — Foreign key → attraction_info.content_id — NOT NULL

trip_plan_reply

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • plan_id — INT — Foreign key → trip_plan.id — NOT NULL
  • write_date — DATETIME
  • content — VARCHAR(255)
  • user_name — VARCHAR(20)

user

  • 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
  • name — VARCHAR(20)
  • email — VARCHAR(50)
  • password — VARCHAR(200)
  • legion_name — VARCHAR(10)
  • city_name — VARCHAR(10)
  • comment — VARCHAR(200)
  • user_code — VARCHAR(10)
  • profile_image — VARCHAR(10)
  • role — VARCHAR(20)