오늘 할 일 내일로

테이블 (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))