ㄴㅇㄹ
Tables (18)
T_ACCOMMODATION
- accommodationNum — bigint
- accommodationName — VARCHAR(50) — NOT NULL
- tel — VARCHAR(50) — NOT NULL
- categoryNum — bigint — NOT NULL
- region — BIGINT — NOT NULL
- accommodationAddress — VARCHAR(200) — NOT NULL
- rating — DECIMAL(2,1) — NOT NULL
- ratingCount — BIGINT — NOT NULL
- lowPrice — bigint — NOT NULL
- reservationRange — bigint — NOT NULL
T_ACCO_IMAGE
- accommodationNum — bigint
- originFileName — VARCHAR(100) — NOT NULL
- saveFileName — VARCHAR(100) — NOT NULL
T_ACCO_VIEW_FACILITIES
- accommodationNum — bigint
- facilities — bigint
T_CART
- memberNum — bigint
- accommodationNum — bigint
- roomNum — bigint
- startDate — DATETIME — NOT NULL
- endDate — DATETIME — NOT NULL
- price — bigint — NOT NULL
T_CATEGORY
- categoryNum — bigint
- categoryName — VARCHAR(50) — NOT NULL
T_COUPON
- couponNum — BIGINT
- couponName — VARCHAR(50) — NOT NULL
- discountPrice — BIGINT — NOT NULL
- startDate — DATETIME — NOT NULL
- endDate — DATETIME — NOT NULL
- useRules — BIGINT — NOT NULL
T_FACILITIES
- facilityNum — bigint
- facilityName — VARCHAR(50) — NOT NULL
T_MEMBER
- memberNum — bigint
- email — VARCHAR(40) — NOT NULL
- pw — VARCHAR(20) — NOT NULL
- nickName — VARCHAR(50) — NOT NULL
- tel — VARCHAR(20) — NOT NULL
- memberPoint — BIGINT — NOT NULL
- grade — BIGINT — NOT NULL
T_MEMBER_VIEW_COUPON
- memberNum — bigint
- couponNum — bigint
- CONSTRAINTS — FK_23
- CONSTRAINTS — FK_24
T_REGION
- regionNum — bigint
- major — bigint — NOT NULL
- minor — VARCHAR(50) — NOT NULL
T_RESERVATION
- memberNum — bigint
- accommodationNum — bigint
- reservationStatus — bigint
- orderNum — bigint — NOT NULL
- orderDate — DATETIME — NOT NULL
- reservationNum — bigint
- roomName — VARCHAR(50) — NOT NULL
- useStartDate — DATETIME — NOT NULL
- useEndDate — DATETIME — NOT NULL
- vehicle — VARCHAR(10) — NOT NULL
- price — bigint — NOT NULL
T_RESERVATION_STATE
- reservationStatus — bigint
- statusName — VARCHAR(20)
T_REVIEW
- memberNum — bigint
- accommodationNum — bigint
- roomNum — bigint
- reservationNum — bigint
- reviewNum — bigint
- rating — DECIMAL(2,1) — NOT NULL
- content — VARCHAR(1000) — NOT NULL
T_REVIEW_IMAGE
- reviewNum — bigint
- originFileName — VARCHAR(100) — NOT NULL
- saveFileName — VARCHAR(100) — NOT NULL
T_ROOM
- accommodationNum — bigint
- roomNum — bigint
- roomName — VARCHAR(50) — NOT NULL
- defaultGuest — bigint — NOT NULL
- maxGuest — bigint — NOT NULL
- weekdayPrice — bigint — NOT NULL
- weekdayDiscount — bigint — NOT NULL
- weekendPrice — bigint — NOT NULL
- weekendDiscount — bigint — NOT NULL
- restStartTime — DATETIME — NOT NULL
- restEndTime — DATETIME — NOT NULL
- info — VARCHAR(1000) — NOT NULL
T_ROOM_IMAGE
- accommodationNum — bigint
- roomNum — bigint
- originFileName — VARCHAR(100) — NOT NULL
- saveFileName — VARCHAR(100) — NOT NULL
T_ROOM_RESERVATION_INFO
- accommodationNum — bigint — Foreign key → T_ACCOMMODATION.accommodationNum
- roomNum — bigint — Foreign key → T_ROOM.roomNum
- reservationDate — DATETIME — NOT NULL
T_WISHLIST
- memberNum — bigint
- accommodationNum — bigint