여기어때
테이블 (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