TTbando
Tables (13)
Comment
- commentIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- textIdx — int — Foreign key → Text.textIdx — NOT NULL
- content — varchar(1000)
- class — int
- order — int
- groupNum — int
Coupon
- couponIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- hotelIdx — int — Foreign key → Hotel.hotelIdx — NOT NULL
- couponName — varchar(50) — NOT NULL
- couponReg — varchar(50) — NOT NULL
- couponDue — varchar(50) — NOT NULL
- couponUse — varchar(50) — NOT NULL
- couponCheck — varchar(50) — NOT NULL
Hotel
- hotelIdx — int — Primary key — NOT NULL
- hotelName — varchar(100) — NOT NULL
- regionIdx — int — Foreign key → Region.regionIdx — NOT NULL
- hotelType — varchar(500) — NOT NULL
- hotelInfo — varchar(500) — NOT NULL
- status — varchar(10) — NOT NULL
- createAt — timestamp — NOT NULL
- updateAt — timestamp — NOT NULL
Keyword
- keywordIdx — int — Primary key — NOT NULL
- keywordName — varchar(100) — NOT NULL
- keywordCnt — int — NOT NULL
Like
- likeIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- textIdx — int — Foreign key → Text.textIdx — NOT NULL
Region
- regionIdx — int — Primary key — NOT NULL
- regionName — varchar(100) — NOT NULL
- searchCnt — int — NOT NULL
Reservation
- reservationIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- hotelIdx — int — Foreign key → Hotel.hotelIdx — NOT NULL
- people — int — NOT NULL
- reservationStart — date — NOT NULL
- reservationEnd — date — NOT NULL
- status — varchar(10) — NOT NULL
- createAt — timestamp — NOT NULL
- updateAt — timestamp — NOT NULL
Review
- reviewIdx — int — Primary key — NOT NULL
- reservationIdx — int — Foreign key → Reservation.reservationIdx — NOT NULL
- star — int — NOT NULL
- comment — varchar(1000) — NOT NULL
- status — varchar(10) — NOT NULL
- createAt — timestamp — NOT NULL
- updateAt — timestamp — NOT NULL
Room
- roomIdx — int — Primary key — NOT NULL
- hotelIdx — int — Foreign key → Hotel.hotelIdx — NOT NULL
- roomType — varchar(100) — NOT NULL
- checkOut — varchar(100) — NOT NULL
- checkIn — varchar(100) — NOT NULL
- status — varchar(10) — NOT NULL
- createAt — timestamp — NOT NULL
- updateAt — timestamp — NOT NULL
Search
- searchIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- keywordIdx — int — Foreign key → Keyword.keywordIdx — NOT NULL
Text
- textIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- category — varchar(10)
- content — varchar(1000)
User
- userIdx — int — Primary key — NOT NULL
- userName — varchar(50) — NOT NULL
- nickname — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
- profileImgUrl — text — NOT NULL
- university — varchar(15) — NOT NULL
- email — varchar(100) — NOT NULL
- phone — varchar(12) — NOT NULL
- refreshToken — varchar(100) — NOT NULL
- status — varchar(10) — NOT NULL
- createAt — timestamp — NOT NULL
- updateAt — timestamp — NOT NULL
Wish
- wishIdx — int — Primary key — NOT NULL
- userIdx — int — Foreign key → User.userIdx — NOT NULL
- hotelIdx — int — Foreign key → Hotel.hotelIdx — NOT NULL
- status — varchar(10) — NOT NULL
- createAt — timestamp — NOT NULL
- updateAt — timestamp — NOT NULL