오늘 할 일 내일로
테이블 (10)
area (Untitled5)
- area_no (int) — 기본 키 — NOT NULL
- areaname (varchar(10))
- attribute1 (INT)
- attribute2 (Int)
- attribute3 (INt)
attribute (Untitled6)
- attribute_no (int) — 기본 키
- attributename (varchar(10))
member
- member_no (int) — 기본 키 — NOT NULL
- email (varchar(30)) — "*@*.*
- phone (varchar(15)) — "000-0009-0000"
- pw (Field) — hash
- signup_date (date) — "0000-00-00"
- profile_no (Field2)
mypath (Untitled4)
- mypath_no (int) — 기본 키 — NOT NULL
- pathbytext (varchar(100))
- pathname (varchar(20))
- startdate (date)
- enddate (Date)
- member_no (INT)
path (Untitled3)
- path_no (int)
- station (varchar(10))
- area_no (INT)
path_review (Untitled2)
- bbs_no (int) — 기본 키 — NOT NULL
- date
- title (varchar(50))
- dec (text)
- member_no (INT)
- mypath_no (INt)
place (Untitled7)
- place_no — int — 기본 키 — NOT NULL
- type_no — int
- location — varchar(100)
- placename — varchar(20)
- img — varchar(30)
place_review (Untitled9)
- pr_review_no — int — 기본 키 — NOT NULL
- place_no — int
- member_no — int
- date — date
- title — varchar(100)
- dec — text
- score — int
place_type (Untitled8)
- type_no — int — 기본 키 — NOT NULL
- typename — varchar(10)
profile (Untitled)
- profile_no (int) — 기본 키 — NOT NULL
- intro_self (varchar(100))
- img (varchar(30))