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