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