enjoyTrip

Tables (9)

attraction_category

  • category_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50)

attraction_info

  • attraction_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
  • category_id — INT — Foreign key → attraction_category.category_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • addr — VARCHAR(100) — NOT NULL
  • image — VARCHAR(200) — NOT NULL
  • latitude — DECIMAL(20,17) — NOT NULL
  • longtitude — DECIMAL(20,17) — NOT NULL
  • INDEX — `sido_code`
  • INDEX — `gugun_code`
  • INDEX — `category_id`

gugun

  • gugun_code — INT — Primary key — NOT NULL
  • sido_code — INT — NOT NULL

likes

  • member_id — INT — Foreign key → member.member_id — NOT NULL
  • post_id — INT — Foreign key → post.post_id — NOT NULL
  • INDEX — `post_id`

member

  • member_id — INT — Primary key — NOT NULL
  • id — VARCHAR(20) — NOT NULL
  • password — VARCHAR(20) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(10) — NOT NULL
  • authority_type — INT — NOT NULL

post

  • post_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • hit — INT — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • is_notion — TINYINT(1) — NOT NULL
  • INDEX — `member_id`

sido

  • sido_code — INT — Foreign key → gugun.sido_code — NOT NULL
  • sido_name — VARCHAR(30)

trip_plan

  • trip_plan_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • INDEX — `member_id`

tripdetail

  • trip_plan_id — INT — Foreign key → trip_plan.trip_plan_id — NOT NULL
  • attraction_id — INT — Foreign key → attraction_info.attraction_id — NOT NULL
  • seq — INT — NOT NULL
  • INDEX — `trip_plan_id`
  • INDEX — `attraction_id`