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)