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