ㄴㅇㄹ

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