sfdsf
Tables (20)
T_ACCOMMODATION
- accommodationNum — int
- accommodationName — varchar(50) — NOT NULL
- tel — varchar(50) — NOT NULL
- categoryNum — int — Foreign key → T_ACCO_CATEGORY.categoryNum — NOT NULL
- regionNum — int — NOT NULL
- accommodationAddress — varchar(200) — NOT NULL
- rating — DECIMAL(2,1) — NOT NULL
- ratingCount — int — NOT NULL
- latitude — decimal(16,14) — NOT NULL
- longitude — decimal(17,14) — NOT NULL
- lowPrice — int — NOT NULL
- reservationRange — int — NOT NULL
T_ACCO_CATEGORY
- categoryNum — int
- categoryName — varchar(50) — NOT NULL
T_ACCO_IMAGE
- accommodationNum — int
- originFileName — varchar(100) — NOT NULL
- saveFileName — varchar(100) — NOT NULL
T_ACCO_VIEW_FACILITIES
- accommodationNum — int
- facilities — int
T_BOARD
- boardNum — int
- categoryNum — int — NOT NULL
- boardTitle — varchar(200) — NOT NULL
- boardContent — varchar(3096) — NOT NULL
- boardCreate — datetime — NOT NULL
- boardModify — datetime — NOT NULL
- boardHits — int — NOT NULL
T_BOARD_CATEGORY
- categoryNum — int
- categoryName — varchar(20) — NOT NULL
- parentNum — int — NOT NULL
T_CART
- memberNum — int
- accommodationNum — int
- roomNum — int
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- price — int — NOT NULL
T_COUPON
- couponNum — int
- couponName — varchar(50) — NOT NULL
- discountPrice — int — NOT NULL
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- useRules — int — NOT NULL
T_FACILITIES
- facilityNum — int
- facilityName — varchar(50) — NOT NULL
T_MEMBER
- memberNum — int
- email — varchar(40) — NOT NULL
- pw — varchar(20) — NOT NULL
- nickName — varchar(50) — NOT NULL
- tel — varchar(20) — NOT NULL
- memberPoint — int — NOT NULL
- grade — int — NOT NULL
T_MEMBER_VIEW_COUPON
- memberNum — int
- couponNum — int
T_REGION
- regionNum — int
- regionName — varchar(20) — NOT NULL
- parentNum — int — NOT NULL
T_RESERVATION
- memberNum — int
- accommodationNum — int
- reservationStatus — int
- orderNum — int — NOT NULL
- orderDate — datetime — NOT NULL
- reservationNum — int
- roomName — varchar(50) — NOT NULL
- useStartDate — datetime — NOT NULL
- useEndDate — datetime — NOT NULL
- vehicle — varchar(10) — NOT NULL
- price — int — NOT NULL
T_RESERVATION_STATE
- reservationStatus — int
- statusName — varchar(20)
T_REVIEW
- memberNum — int
- accommodationNum — int
- roomNum — int
- reservationNum — int
- reviewNum — int
- rating — DECIMAL(2,1) — NOT NULL
- reviewContent — varchar(1000) — NOT NULL
T_REVIEW_IMAGE
- reviewNum — int
- originFileName — varchar(100) — NOT NULL
- saveFileName — varchar(100) — NOT NULL
T_ROOM
- accommodationNum — int
- roomNum — int
- roomName — varchar(50) — NOT NULL
- defaultGuest — int — NOT NULL
- maxGuest — int — NOT NULL
- stayStartDate — datetime — NOT NULL
- stayEndDate — datetime — NOT NULL
- weekdayPrice — int — NOT NULL
- weekdayDiscount — int — NOT NULL
- weekendPrice — int — NOT NULL
- weekendDiscount — int — NOT NULL
- restStartTime — datetime — NOT NULL
- restEndTime — datetime — NOT NULL
- info — varchar(1000) — NOT NULL
T_ROOM_IMAGE
- accommodationNum — int
- roomNum — int
- originFileName — varchar(100) — NOT NULL
- saveFileName — varchar(100) — NOT NULL
T_ROOM_RESERVATION_INFO
- accommodationNum — int — Foreign key → T_ACCOMMODATION.accommodationNum
- roomNum — int — Foreign key → T_ROOM.roomNum
- reservationDate — datetime — NOT NULL
T_WISHLIST
- memberNum — int
- accommodationNum — int