석현 수정 작업 중인 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)