DATABASE

Tables (9)

attraction_description

  • attraction_id — int — Foreign key → attraction_info.attraction_id — NOT NULL
  • description — varchar(10000)

attraction_info

  • attraction_id — int — Primary key — NOT NULL
  • type_id — int
  • title — varchar(100)
  • addr — varchar(100)
  • zipcode — varchar(50)
  • tel — varchar(50)
  • img_small — varchar(200)
  • img_big — varchar(200)
  • latitude — decimal(20,17)
  • longitude — decimal(20,17)
  • gugun_code — int — Foreign key → gugun.gugun_code — NOT NULL
  • sido_code — int — Foreign key → sido.sido_code — NOT NULL

gugun

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

member

  • user_id — varchar(16) — Primary key — NOT NULL
  • password — varchar(60)
  • name — varchar(20)
  • tel — varchar(20)
  • location — varchar(20)
  • join_date — timestamp

place

  • plan_id — int — Foreign key → plan.plan_id — NOT NULL
  • attraction_id — int — Foreign key → attraction_info.attraction_id — NOT NULL
  • order — int
  • start_time — datetime
  • end_time — datetime
  • comment — varchar(100)

plan

  • plan_id — int — Primary key — NOT NULL
  • regist_date — timestamp
  • visibility — boolean
  • comment — text
  • maker_id — varchar(16) — Foreign key → member.user_id — NOT NULL

realation

  • user_id — varchar(16) — Foreign key → member.user_id — NOT NULL
  • user_id2 — varchar(16) — Foreign key → member.user_id — NOT NULL
  • type — tinyint

sido

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

tripwith

  • plan_id — int — Foreign key → plan.plan_id — NOT NULL
  • user_id — varchar(16) — Foreign key → member.user_id — NOT NULL