teamproject

Tables (8)

attraction

  • attractionID — int(11) — Primary key
  • attractionScore — float
  • title (Field) — varchar(100)
  • addr (Field2) — varchar(100)
  • mapX — float
  • mapY — float
  • firstimage (Field11) — varchar(100)
  • firstimage2 (Field12) — varchar(100)
  • overview (Field3) — varchar(2000)
  • thema1 (Field4) — float
  • thema2 (Field5) — float
  • thema3 (Field6) — float
  • thema4 (Field7) — float
  • thema5 (Field8) — float
  • thema6 (Field9) — float
  • thema7 (Field10) — float

board

  • boardID — int(11) — Primary key
  • routeID (routeID2) — int — Foreign key → route.routeID
  • userID (userID2) — varchar(50) — Foreign key → user.userID
  • 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)
  • takeuserID — varchar(50) — Foreign key → user.userID
  • giveuserID — varchar(50) — Foreign key → user.userID
  • evaluationDate — DATE
  • evaluationScore — int

permission

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

review

  • reviewID — int(11)
  • boardID (boardID2) — int(11) — Foreign key → board.boardID
  • userID (userID2) — varchar(50) — Foreign key → user.userID
  • reviewDate — DATE
  • reviewScore — int
  • reviewTitle — varchar(100)
  • reviewContent — varchar(1000)

review attraction (CopyOfreview)

  • attractionID — int(11) — Foreign key → attraction.attractionID
  • userID — varchar(50) — Foreign key → user.userID
  • reviewDate — DATE
  • Score (reviewScore) — float
  • reviewTitle — varchar(100)
  • reviewContent — varchar(1000)

route

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

user

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