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