triviesion

Tables (7)

attraction

  • attractionID — int — Primary key
  • attractionScore — float
  • title — varchar(100)
  • addr — varchar(100)
  • mapX — decimal(13,10)
  • mapY — decimal(13,10)
  • firstimage — varchar(100)
  • firstimage2 — varchar(100)
  • overview — varchar(2000)
  • Thema1 — int
  • Thema2 — int
  • Thema3 — int
  • Thema4 — int
  • Thema5 — int
  • Thema6 — int
  • Thema7 — int

attractionreview

  • reviewID — int(11) — Primary key
  • Key (userID) — varchar(50) — Foreign key → user.Key — NOT NULL
  • attractionID — int — Foreign key → attraction.attractionID
  • score — int
  • reviewDate — DATE

board

  • boardID — int(11) — Primary key
  • routeID — int(11) — Foreign key → route.routeID
  • Key (userID) — varchar(50) — Foreign key → user.Key — NOT NULL
  • boardDate — DATE
  • maxP — int(11)
  • currentP — int(11)
  • appliT — DATE
  • boardTitle — varchar(100) — NOT NULL
  • boardContent — varchar(2000)
  • stateInt — int
  • kakaoLink — varchar(300)

evaluation

  • evaluationID — int(11) — Primary key
  • Key (takeuserID) — varchar(50) — Foreign key → user.Key — NOT NULL
  • Key (giveuserID) — varchar(50) — Foreign key → user.Key — NOT NULL
  • evaluationScore — int
  • evaluationDate — DATE

permission

  • Key (userID) — varchar(50) — Foreign key → user.Key — NOT NULL
  • boardID — int(11) — Foreign key → board.boardID
  • stateInt — int(11)

route

  • routeID — int — Primary key
  • Key (userID) — varchar(50) — Foreign key → user.Key — NOT NULL
  • routeDate — DATE
  • routeTitle — varchar(300)
  • routeList — varchar(400)
  • stateInt — int
  • Thema — varchar(20)
  • arriveTime — varchar(400)

user

  • Key (userID) — varchar(50) — Primary key — NOT NULL
  • nickName — varchar(50)
  • gender — int
  • pwd — varchar(100)
  • UserScore — float
  • age — int