여기어때

테이블 (14)

Authentic (Untitled11)

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

Book (Untitled5)

  • Id (BookId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Id (FacilityId) — BIGINT — 외래 키 → Facility.Id — NOT NULL
  • bookName (bookUseName) — VARCHAR(255)
  • bookcall (bookUseCall) — VARCHAR(100)
  • people (howManyPeople) — INT
  • startDate (bookstartDate) — DATETIME
  • endDate (bookendDate) — DATETIME
  • cancel (bookCancelY/N) — BOOLEAN

Comment (Untitled12)

  • Id (CommentId) — BIGINT — 기본 키 — NOT NULL
  • Field

ConvenienceService (Untitled9)

  • Id (CSId) — BIGINT — 기본 키 — NOT NULL
  • wifi (wifiY/N) — BOOLEAN
  • park (parkY/N) — BOOLEAN
  • landry (landryY/N) — BOOLEAN
  • Field

Coupon (Untitled2)

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

Event (Untitled8)

  • Id (EventId) — BIGINT — 기본 키 — NOT NULL
  • event1 (Field) — BOOLEAN
  • event2 (Field2) — BOOLEAN
  • event3 (Field3) — BOOLEAN
  • Field4 — BOOLEAN

Facility (Untitled4)

  • Id (FacilityId) — BIGINT — 기본 키 — NOT NULL
  • Id (ImageId) — BIGINT — 외래 키 → Image.Id — NOT NULL
  • Id (ReviewId) — BIGINT — 외래 키 → Review.Id — NOT NULL
  • Id (LikesId) — BIGINT — 외래 키 → Likes.Id — NOT NULL
  • Id (RoomPriceId) — BIGINT — 외래 키 → Room.Id — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • category (typeOfFacility) — VARCHAR(20)
  • name (facilityName) — VARCHAR(255)
  • address (facilityAddress) — VARCHAR(4000)
  • businessnumber (facilityBusinessNumber) — VARCHARR(200)
  • refundPolicy (Field)

Image (Untitled3)

  • Id (ImageId) — 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)

Likes (Untitled7)

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

Owner (CopyOfUntitled)

  • Id (UserId) — BIGINT — 기본 키 — 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

Price (Untitled10)

  • Id (PriceId) — BIGINT — 기본 키 — NOT NULL
  • price (stayUse)
  • discount (Field2)
  • Field

Review (Untitled6)

  • Id (ReviewId) — BIGINT — 기본 키 — NOT NULL
  • Id (UserId) — BIGINT — 외래 키 → User.Id — NOT NULL
  • Id (BookId) — BIGINT — 외래 키 → Book.Id — NOT NULL
  • Id (AuthenticId) — BIGINT — 외래 키 → Authentic.Id — NOT NULL
  • rate (ReviewRate) — INT
  • content — VARCHAR(1000)

Room (CopyOfUntitled3)

  • Id (RoomPriceId) — BIGINT — 기본 키 — NOT NULL
  • Id (CSId) — BIGINT — 외래 키 → ConvenienceService.Id — NOT NULL
  • Id (EventId) — BIGINT — 외래 키 → Event.Id — NOT NULL
  • people (roomAcceptablePeople) — INT
  • name (roomName) — VARCHAR(1000)
  • content (roomContent) — VARCHAR(4000)
  • price1 (timeUse(대실)) — VARCHAR(100)
  • price2 (stayUse(숙박)) — VARCHAR(100)

User (Untitled)

  • Id (UserId) — BIGINT — 기본 키 — NOT NULL
  • Id (couponId) — BIGINT — 외래 키 → Coupon.Id — NOT NULL
  • Id (LikesId) — BIGINT — 외래 키 → Likes.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