enjoytrip
Tables (8)
Article
- articleIdx — int — Primary key — NOT NULL
- hit — int
- likeCount — int
- content — varchar(500)
- placeIdx — int
- createAt — timestamp
- updateAt — timestamp
- deleteAt — timestamp
- userIdx — int — Foreign key → User.userIdx — NOT NULL
Comment
- commentIdx — int — Primary key — NOT NULL
- content — varchar(200)
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- articleIdx — int — Foreign key → Article.articleIdx — NOT NULL
Img
- imgIdx — int — Primary key — NOT NULL
- imgUrl — varchar(200)
- articleIdx — int — Foreign key → Article.articleIdx — NOT NULL
Like
- likeIdx — int — Primary key — NOT NULL
- planIdx — int — Foreign key → Plan.planIdx — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
Place
- placeIdx — int — Primary key — NOT NULL
- lat — double
- lon — double
- createAt (creatAt) — timestamp
- updateAt — timesatmp
- deleteAt — timestamp
Plan
- planIdx — int — Primary key — NOT NULL
- region (regjon) — varchar(30)
- startDate — timestamp
- period — int
- isOpened — boolean
- createAt — timestamp
- updateAt — timestamp
- deleteAt — timestamp
- userIdx — int — Foreign key → User.userIdx — NOT NULL
User
- userIdx — int — Primary key — NOT NULL
- userId — varchar(12)
- userPwd — varchar(500)
- userEmail — varchar(30)
- userName — varchar(10)
- createAt — timestamp
- updateAt — timestamp
- deleteAt — timestamp
planOrder (PlanOrder)
- planOrderIdx — int — Primary key — NOT NULL
- planDate — timestamp
- placeOrder — int
- planIdx — int — Foreign key → Plan.planIdx — NOT NULL
- placeIdx (placeIdx2) — int — Foreign key → Place.placeIdx — NOT NULL