YANOLJA DB
Tables (7)
Like (Untitled7)
- likeIdx — INT UNSIGNED — Primary key — NOT NULL
- 회원 id (userIdx) — INT UNSIGNED — Foreign key → User.회원 id
- 숙소 (lodgingIdx) — INT UNSIGNED — Foreign key → Lodging.숙소 — NOT NULL
List (Untitled3)
- 리스트 (listIdx) — INT UNSIGNED — Primary key — NOT NULL
- 숙소 (lodgingIdx2) — INT UNSIGNED — Foreign key → Lodging.숙소 — NOT NULL
- 이름 (name) — VARCHAR(20)
- 가격 (price) — INT UNSIGNED
- 이미지1 (image1) — TEXT
- 이미지2 (image2) — TEXT
- 이미지3 (image3) — TEXT
- 입실시간 (checkIn) — TIMESTAMP
- 퇴실시간 (checkOut) — TIMESTAMP
- createAt — TIMESTAMP
- updatedAt — TIMESTAMP
- status — VARCHAR(1)
Lodging (Untitled2)
- 숙소 (lodgingIdx) — INT UNSIGNED — Primary key — NOT NULL
- 숙소 이름 (name) — VARCHAR(40)
- 카테고리 (category) — VARCHAR(40)
- 이미지1 (image1) — TEXT
- 이미지2 (image2) — TEXT
- 이미지3 (image3) — TEXT
- 숙소 위치 (location) — VARCHAR(20)
- 숙소 주소 (address) — VARCHAR(20)
- 인기시설 및 서비스 (service) — VARCHAR(10)
- 날짜 선택 (date) — TIMESTAMP
- 인원 선택 (persons) — INT UNSIGNED
- createAt — TIMESTAMP
- updatedAt — TIMESTAMP
- status — VARCHAR(1)
Order (Untitled6)
- orderIdx — INT UNSIGNED — Primary key — NOT NULL
- 회원 id (userIdx) — INT UNSIGNED — Foreign key → User.회원 id
- 숙소 (lodgingIdx) — INT UNSIGNED — Foreign key → Lodging.숙소 — NOT NULL
- 최종 금액 (totalPrice) — INT UNSIGNED
- 할인1 (discount1) — INT UNSIGNED
- 할인2 (discount2) — INT UNSIGNED
- 포인트 (point) — INT UNSIGNED
User (Untitled)
- 회원 id (userIdx) — INT UNSIGNED — Primary key
- 이메일 (email) — VARCHAR(20)
- 비밀번호 (password) — VARCHAR(20)
- 닉네임 (nickname) — VARCHAR(10)
- 핸드폰번호 (phoneNumber) — INT UNSIGNED
- createAt — TIMESTAMP
- updatedAt — TIMESTAMP
- status — VARCHAR(1)
listReview (Untitled5)
- listReviewIdx — INT UNSIGNED — Primary key — NOT NULL
- 리스트 (listIdx) — INT UNSIGNED — Foreign key → List.리스트 — NOT NULL
- 숙소 (lodgingIdx2) — INT UNSIGNED — Foreign key → List.숙소 — NOT NULL
- 점수 (score) — INT UNSIGNED
- 코멘트 (omment) — VARCHAR(200)
lodgingReview (Untitled4)
- lodgingReviewIdx — INT UNSIGNED — Primary key — NOT NULL
- 숙소 (lodgingIdx) — INT UNSIGNED — Foreign key → Lodging.숙소 — NOT NULL
- 점수 (score) — INT UNSIGNED
- 이미지1 (image1) — TEXT
- 이미지2 (image2) — TEXT
- 이미지3 (image3) — TEXT
- 코멘트 (comment) — VARCHAR(200)