석현 수정 작업 중인 ERD

테이블 (35)

Admin (CopyOfCopyOfUntitled)

  • Id (OwnerId) — BIGINT — 기본 키 — NOT NULL
  • email (nosnsUserId) — VARCHAR(255)
  • password (nosnsUserPassword) — VARCHAR(255)

Authentic (Untitled11)

  • Id (AuthenticId) — BIGINT — 기본 키 — NOT NULL
  • private (private/public) — BOOLEAN
  • commentFree (commentAccept_Deny) — BOOLEAN

Book(예약=결제) (-)

  • Id (BookId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Id (RoomId) — BIGINT — 외래 키 → Room.Id — NOT NULL
  • Id (PriceId) — BIGINT — 외래 키 → Room.Id — NOT NULL
  • Id (PaymentId) — BIGINT — 외래 키 → Payment.Id — NOT NULL
  • bookName (bookUseName) — VARCHAR(255)
  • bookcall (bookUseCall) — VARCHAR(100)
  • startDate (Field) — DATETIME
  • endDate (Field2) — DATETIME
  • visitWay (Field3) — VARCHAR(100) — Enum
  • accept (bookAcceptY/N) — BOOLEAN — 예약확정(락)
  • cancel (bookCancelY/N) — BOOLEAN — 예약취소
  • Id (cartId) — BIGINT — 외래 키 → Cart.Id — NOT NULL
  • Id (PaymentCancelId) — BIGINT — 외래 키 → PayMentCancel.Id — NOT NULL

CancelReason (Untitled17)

  • Id (CancelReasonId) — BIGINT — 기본 키 — NOT NULL
  • cancelReason (Field) — Enum
  • Id (etcId) — BIGINT — 외래 키 → CancelReasonetc.Id — NOT NULL

CancelReasonetc (Untitled20)

  • Id (etcId) — BIGINT — 기본 키 — NOT NULL
  • etcDetail (detailReason) — VARCHAR(1000)

Cart (장바구니)

  • Id (cartId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Id (RoomId) — BIGINT — 외래 키 → Room.Id — NOT NULL
  • Id (PriceId) — BIGINT — 외래 키 → Room.Id — NOT NULL
  • startDate (Field) — DATETIME
  • endDate (Field2) — DATETIME
  • CartOut (Field3) — BOOLEAN — Default false

Category (Untitled14)

  • Id (CategoryId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → Scrap.Id — NOT NULL
  • Id (ScrapId) — BIGINT — 외래 키 → Scrap.Id — NOT NULL
  • title — VARCHAR(100) — NOT NULL

ChangePriceDate (CopyOfUntitled17)

  • Id (changePriceDateId) — BIGINT — 기본 키 — NOT NULL
  • date (날짜) — DATETIME — 2023-06-31
  • change_price (바꿀 가격) — BIGINT — 1000000

ChangePricePeriod (Untitled18)

  • id (ChangePricePeriodId) — BIGINT — 기본 키 — NOT NULL — 가격 아아디
  • Id (changePriceDateId) — BIGINT — 외래 키 → ChangePriceDate.Id — NOT NULL
  • id (DiscountId) — BIGINT — 외래 키 → Discount.id — NOT NULL
  • start_date (시작 날짜) — DATETIME — 2023-06-28
  • end_date (끝 날짜) — DATETIME — 2023-08-15
  • change_price (바꿀 가격) — INT — 100000

Comment (Untitled12)

  • Id (CommentId) — BIGINT — 기본 키 — NOT NULL
  • Id (ReviewId) — BIGINT — 외래 키 → Review.Id — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • comment — VARCHAR(4000)
  • class (댓글계층) — BIGINT
  • order (댓글대댓글순서) — BIGINT
  • groupNum (댓글 그룹) — BIGINT

Coupon (Untitled2)

  • Id (CouponId) — BIGINT — 기본 키 — NOT NULL
  • name (couponName) — VARCHAR(255)
  • startDate (couponStartDate) — DATETIME
  • endDate (couponEndDate) — DATETIME
  • DisCountInfo (discountInfo) — VARCHAR(255)

Discount (discount)

  • id (DiscountId) — BIGINT — 기본 키 — NOT NULL
  • discount (변동율) — VARCHAR(4) — 10%
  • change_price (변동가격) — INT — 무조건 빠지는 금액

Facility (Untitled4)

  • Id (FacilityId) — BIGINT — 기본 키 — NOT NULL
  • Id (HostId) — BIGINT — 외래 키 → host.Id — NOT NULL
  • Id (RoomId) — BIGINT — 외래 키 → Room.Id — NOT NULL
  • Id (FacilityConvenienceServiceIde) — BIGINT — 외래 키 → FacilityConvenienceService.Id — NOT NULL
  • Id (FacilityImageId) — BIGINT — 외래 키 → FacilityImage.Id — NOT NULL
  • Id (FacilityPromotionId) — BIGINT — 외래 키 → FacilityMainPromotion.Id — NOT NULL
  • category (typeOfFacility) — VARCHAR(20) — 호텔, 모텔
  • name (facilityName) — VARCHAR(255)
  • address (facilityAddress) — VARCHAR(4000) — required
  • businessnumber (facilityBusinessNumber) — VARCHARR(200)
  • LAT — DOUBLE — NOT NULL
  • LNT — DOUBLE — NOT NULL
  • inTimeDate (입실시간) — DATETIME
  • outTimeDate (퇴실시간) — DATETIME
  • Id (PriceId) — BIGINT — 외래 키 → Room.Id — NOT NULL

FacilityConvenienceService (CopyOfUntitled9)

  • Id (FacilityConvenienceServiceIde) — BIGINT — 기본 키 — NOT NULL
  • wifi (wifiY/N) — BOOLEAN
  • park (parkY/N) — BOOLEAN
  • tennis (tennisY/N) — BOOLEAN
  • health (healthY/N) — BOOLEAN
  • golf (golfY/N) — BOOLEAN
  • swingPool (swingPoolY/N) — BOOLEAN
  • pet (petY/N) — BOOLEAN
  • spa (spaY/N) — BOOLEAN

FacilityImage (Untitled3)

  • Id (FacilityImageId) — BIGINT — 기본 키 — NOT NULL
  • image1 (Field) — VARCHAR(4000)
  • image2 (Field2) — VARCHAR(4000)
  • image3 (Field3) — VARCHAR(4000)
  • image4 (Field4) — VARCHAR(4000)
  • image5 (Field5) — VARCHAR(4000)
  • image6 (Field6) — VARCHAR(4000)
  • image7 (Field7) — VARCHAR(4000)
  • image8 (Field8) — VARCHAR(4000)
  • image9 (Field9) — VARCHAR(4000)
  • image10 (Field10) — VARCHAR(4000)
  • image11 (Field11) — VARCHAR(4000)
  • image12 (Field12) — VARCHAR(4000)
  • image13 (Field13) — VARCHAR(4000)
  • image14 (Field14) — VARCHAR(4000)
  • image15 (Field15) — VARCHAR(4000)
  • image16 (Field16) — VARCHAR(4000)
  • image17 (Field17) — VARCHAR(4000)
  • image18 (Field18) — VARCHAR(4000)
  • image19 (Field19) — VARCHAR(4000)
  • image20 (Field20) — VARCHAR(4000)

FacilityMainPromotion (CopyOfUntitled8)

  • Id (FacilityPromotionId) — BIGINT — 기본 키 — NOT NULL
  • Id (FacilitySubPromotionId) — BIGINT — 외래 키 → FacilitySubPromotion.Id — NOT NULL
  • StartTime (promotionStartDate) — DATETIME — NotNull
  • EndTime (promotionEndDate) — DATETIME — Null

FacilitySubPromotion (sub)

  • Id (FacilitySubPromotionId) — BIGINT — 기본 키 — NOT NULL
  • event (상세페이지 확인 가능한 이벤트) — VARCHAR(50)
  • StartTime (promotionStartDate) — DATETIME — NotNull
  • EndTime (promotionEndDate) — DATETIME — Null

LikesFacilityOrRoom (Untitled7)

  • Id (LikesId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Id (FacilityId) — BIGINT — 외래 키 → Facility.Id — NOT NULL
  • Id (RoomId) — BIGINT — 외래 키 → Room.Id — NOT NULL
  • Interesting (LikesY/N) — BOOLEAN

PayMentCancel (Untitled16)

  • Id (PaymentCancelId) — BIGINT — 기본 키 — NOT NULL
  • Id (CancelReasonId) — BIGINT — 외래 키 → CancelReason.Id — NOT NULL
  • cancelAccept (cancelY/N) — BOOLEAN
  • cancelFee (cancelFeePercent) — INT
  • refundAmount — INT
  • refundAccept (refundY/N) — BOOLEAN

PayMentMethod (Untitled5)

  • Id (PaymetnMethodId) — BIGINT — 기본 키 — NOT NULL
  • method (결제수단) — VARCHAR(255) — Enum

Payment (CopyOfpayment)

  • Id (PaymentId) — BIGINT — 기본 키 — NOT NULL
  • Id (PaymetnMethodId) — BIGINT — 외래 키 → PayMentMethod.Id — NOT NULL
  • paymentAmount (payment_amount) — INT

Price (Untitled10)

  • Id (PriceId) — BIGINT — 기본 키 — NOT NULL
  • id (ChangePricePeriodId) — BIGINT — 외래 키 → ChangePricePeriod.id — NOT NULL — 가격 아아디
  • id (DiscountId) — BIGINT — 외래 키 → Discount.id — NOT NULL
  • 주말가격 — INT — 50000
  • 평일가격 — INT — 40000

Review (Untitled6)

  • Id (ReviewId) — BIGINT — 기본 키 — NOT NULL
  • Id (AuthenticId) — BIGINT — 외래 키 → Authentic.Id — NOT NULL
  • Id (BookId) — BIGINT — 외래 키 → Book(예약=결제).Id — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → Book(예약=결제).Id — NOT NULL
  • Id (ReviewImageId) — BIGINT — 외래 키 → ReviewImage.Id — NOT NULL
  • rate (ReviewRate) — INT
  • content — VARCHAR(1000)

ReviewImage (CopyOfUntitled32)

  • Id (ReviewImageId) — BIGINT — 기본 키 — NOT NULL
  • image1 (Field) — VARCHAR(4000)
  • image2 (Field2) — VARCHAR(4000)
  • image3 (Field3) — VARCHAR(4000)
  • image4 (Field4) — VARCHAR(4000)
  • image5 (Field5) — VARCHAR(4000)
  • image6 (Field6) — VARCHAR(4000)
  • image7 (Field7) — VARCHAR(4000)
  • image8 (Field8) — VARCHAR(4000)
  • image9 (Field9) — VARCHAR(4000)
  • image10 (Field10) — VARCHAR(4000)

ReviewLikes (CopyOfUntitled7)

  • Id (LikesId) — BIGINT — 기본 키 — NOT NULL
  • Id (ReviewId) — BIGINT — 외래 키 → Review.Id — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Id (UserTypeId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Id (UserId2) — BIGINT — 외래 키 — NOT NULL
  • Id (RoomId) — BIGINT — 외래 키 — NOT NULL
  • Id (PriceId) — BIGINT — 외래 키 — NOT NULL
  • PaymentId (pay_success_code_id) — BIGINT — 외래 키 — NOT NULL
  • Id (BookId) — BIGINT — 외래 키 → Review.Id — NOT NULL
  • Id (UserId3) — BIGINT — 외래 키 → Review.Id — NOT NULL
  • Interesting (LikesY/N) — BOOLEAN

Room (CopyOfUntitled3)

  • Id (RoomId) — BIGINT — 기본 키 — NOT NULL
  • Id (PriceId) — BIGINT — 외래 키 → Price.Id — NOT NULL
  • Id (RoomConvenienceService) — BIGINT — 외래 키 → RoomConvenienceService.Id — NOT NULL
  • Id (RoomPromotionId) — BIGINT — 외래 키 → RoomPromotion.Id — NOT NULL
  • Id (RoomImageId) — BIGINT — 외래 키 → RoomImage.Id — NOT NULL
  • Id (InfoId) — BIGINT — 외래 키 → bed.Id — NOT NULL
  • people (roomDefaultPeople) — INT — 2
  • name (roomName) — VARCHAR(1000) — 럭셔리룸
  • content (roomDetailContent) — VARCHAR(4000) — 럭셔리해요
  • maxPeople (maximunPeopleIn) — INT — 4
  • roomNum — INT — 10
  • peopleFee (Field) — INT — 10,000

RoomConvenienceService (Untitled9)

  • Id (RoomConvenienceService) — BIGINT — 기본 키 — NOT NULL
  • wifi (wifiY/N) — BOOLEAN
  • bath (bathY/N) — BOOLEAN
  • breakfast (golfY/N) — BOOLEAN
  • earlyCheckIn (earlyCheckInY/N) — BOOLEAN
  • lateCheckIn (lateCheckInY/N) — BOOLEAN
  • lateCheckOut (lateCheckOutY/N) — BOOLEAN
  • freeMiniBar (freeMiniBarY/N) — BOOLEAN
  • kitchen (Field) — BOOLEAN

RoomImage (CopyOfUntitled33)

  • Id (RoomImageId) — BIGINT — 기본 키 — NOT NULL
  • image1 (Field) — VARCHAR(4000)
  • image2 (Field2) — VARCHAR(4000)
  • image3 (Field3) — VARCHAR(4000)
  • image4 (Field4) — VARCHAR(4000)
  • image5 (Field5) — VARCHAR(4000)
  • image6 (Field6) — VARCHAR(4000)
  • image7 (Field7) — VARCHAR(4000)
  • image8 (Field8) — VARCHAR(4000)
  • image9 (Field9) — VARCHAR(4000)
  • image10 (Field10) — VARCHAR(4000)

RoomPromotion (Untitled8)

  • Id (RoomPromotionId) — BIGINT — 기본 키 — NOT NULL
  • Id (RoomSubPromotionId) — BIGINT — 외래 키 → RoomSubPromotion.Id — NOT NULL
  • Promotion1 (노출되는 메인이벤트) — VARCHAR(50) — 방홍보
  • StartTime (promotionStartDate) — DATETIME — NOTNull
  • EndTime (promotionEndDate) — DATETIME — Null

RoomSubPromotion (Roomsub)

  • Id (RoomSubPromotionId) — BIGINT — 기본 키 — NOT NULL
  • event (상세페이지 확인 가능한 이벤트) — VARCHAR(50)
  • StartTime (promotionStartDate) — DATETIME — NOTNull
  • EndTime (promotionEndDate) — DATETIME — Null

Scrap (Untitled13)

  • Id (ScrapId) — BIGINT — 기본 키 — NOT NULL
  • Id (ReviewId) — BIGINT — 외래 키 → Review.Id — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Interesting (ScarpDelete) — BOOLEAN

User (Untitled)

  • Id (UserId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserTypeId) — BIGINT — 외래 키 → UserType.Id — NOT NULL
  • Id (couponId) — BIGINT — 외래 키 → Coupon.Id — NOT NULL
  • sns (snsUserY/N) — BOOLEAN
  • email (nosnsUserId) — VARCHAR(255)
  • password (nosnsUserPassword) — VARCHAR(255)
  • nickName (Field) — VARCHAR(4000)
  • bookName (bookUseName) — VARCHAR(255)
  • positionY/N (consentPositionInfo) — BOOLEAN
  • LAT (LAT_postion) — DOUBLE
  • LNT (LNT_postion) — DOUBLE

UserType (Untitled19)

  • Id (UserTypeId) — BIGINT — 기본 키 — NOT NULL
  • userType (Field) — VARCHAR(255) — 사용자, 호스트, 관리자

bed (Untitled15)

  • Id (InfoId) — BIGINT — 기본 키 — NOT NULL
  • bed1 (싱글침대) — INT
  • bed2 (트윈침대) — INT
  • roomNum (Field) — INT

host (CopyOfUntitled)

  • Id (HostId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserTypeId) — BIGINT — 외래 키 → UserType.Id — NOT NULL
  • email (nosnsUserId) — VARCHAR(255)
  • password (nosnsUserPassword) — VARCHAR(255)