jeju

Tables (6)

Community (community)

  • C_id (c_id) — int(10) — Primary key — NOT NULL
  • Content (content) — varchar(255)
  • Photo (photo) — varhcar(255)
  • Like (like) — int
  • Writeday (writeday) — date
  • Id (id2) — int(10) — Foreign key → Member.Id — NOT NULL

LocationCourse (locationcourse)

  • LC_id (lc_id) — int(10) — Primary key — NOT NULL
  • Name (name) — varchar(255)
  • Content (content) — varchar(255)
  • Photo (photo) — varchar(255)

Member (member)

  • Id (id) — int(10) — Primary key — NOT NULL
  • Member_Id (member_id) — varchar(255)
  • Member_Pass (member_pass) — varchar(255)
  • Name (name) — varchar(255)
  • Age (age) — int(10)
  • Gender (gender) — varchar(1)
  • Phone (phone) — varhcar(255)
  • Email (email) — varchar(255)
  • Photo (photo) — varchar(255)
  • Gaipday (gaipday) — date

MyPage (mypage)

  • MP_id (mp_id) — int(10) — Primary key — NOT NULL
  • Id (id) — int(10) — Foreign key → Member.Id — NOT NULL
  • TS_Id (ts_id) — int(10) — Foreign key → TouristSpot.TS_id — NOT NULL

ThemeCourse (themecourse)

  • TC_id (tc_id) — int(10) — Primary key — NOT NULL
  • Name (name) — varchar(255)
  • Content (content) — varchar(255)
  • Photo (photo) — varhcar(255)

TouristSpot (touristspot)

  • TS_id (ts_id) — int(10) — Primary key — NOT NULL
  • Name (name) — varchar(255)
  • Photo (photo) — varchar(255)
  • Phone (phone) — varhcar(255)
  • Content (content) — varchar(2000)
  • View (view) — int(10)
  • Location (location) — varchar(255)
  • TC_id (tc_id) — int(10) — Foreign key → ThemeCourse.TC_id — NOT NULL
  • LC_id (lc_id) — int(10) — Foreign key → LocationCourse.LC_id — NOT NULL