exam-hotel

Tables (9)

hotels (호텔)

  • 호텔아이디 (id) — BIGINT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(100) — NOT NULL

member (멤버)

  • 멤버아이디 (id) — BIGINT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(45) — NOT NULL
  • 비밀번호 (password) — VARCHAR(255) — NOT NULL
  • 이메일 (email) — VARCHAR(255) — NOT NULL
  • 전화번호 (phone_number) — VARCHAR(20) — NOT NULL
  • 생일 (birth) — DATE — NOT NULL
  • (created_at) — DATETIME(6) — NOT NULL
  • Field (updated_at) — DATETIME(6)
  • Field (deleted_at) — DATETIME(6)

point (포인트)

  • 포인트아이디 (id) — BIGINT — Primary key — NOT NULL
  • 포인트정책아이디 (id2) — BIGINT — Foreign key → point_policy.포인트정책아이디 — NOT NULL
  • 멤버아이디 (id3) — BIGINT — Foreign key → member.멤버아이디 — NOT NULL
  • (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME
  • Field (deleted_at) — DATETIME

point_policy (포인트정책)

  • 포인트정책아이디 (id) — BIGINT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(255) — NOT NULL
  • 타입 (type) — VARCHAR(45) — NOT NULL
  • 적립량 (amount) — INT — NOT NULL
  • 만료일 (expired_at) — VARCHAR(255) — NOT NULL

reservation (예약)

  • 예약아이디 (id) — BIGINT — Primary key — NOT NULL
  • 방아이디 (id2) — BIGINT — Foreign key → rooms.방아이디 — NOT NULL
  • 멤버아이디 (id3) — BIGINT — Foreign key → member.멤버아이디 — NOT NULL
  • 호텔아이디 (id22) — BIGINT — Foreign key → rooms.호텔아이디 — NOT NULL
  • 체크인 (check_in) — DATE — NOT NULL
  • 체크아웃 (check_out) — DATE — NOT NULL
  • 인원수 (personnel) — INT — NOT NULL
  • 예약번호 (number) — INT — NOT NULL
  • 예약상태 (status) — VARCHAR(45) — NOT NULL
  • Field (created_at) — DATETIME(6) — NOT NULL
  • Field (updated_at) — DATETIME(6)
  • Field (deleted_at) — DAATETIME(6)

review (리뷰)

  • 리뷰아이디 (id) — BIGINT — Primary key — NOT NULL
  • 방아이디 (id2) — BIGINT — Foreign key → rooms.방아이디 — NOT NULL
  • 호텔아이디 (id22) — BIGINT — Foreign key → rooms.호텔아이디 — NOT NULL
  • 이름 (name) — VARCHAR(255) — NOT NULL
  • 내용 (text) — TEXT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at)

review_image (리뷰이미지)

  • 리뷰이미지아이디 (id) — BIGINT — Primary key — NOT NULL
  • 리뷰아이디 (id2) — BIGINT — Foreign key → review.리뷰아이디 — NOT NULL
  • 방아이디 (id22) — BIGINT — Foreign key → review.방아이디 — NOT NULL
  • 호텔아이디 (id222) — BIGINT — Foreign key → review.호텔아이디 — NOT NULL
  • 이미지주소 (url) — VARCHAR(400) — NOT NULL

room_image (방이미지)

  • 방사진아이디 (id) — BIGINT — Primary key — NOT NULL
  • 방아이디 (id2) — BIGINT — Foreign key → rooms.방아이디 — NOT NULL
  • 호텔아이디 (id22) — BIGINT — Foreign key → rooms.호텔아이디 — NOT NULL
  • 이미지주소 (url) — VARCHAR(255) — NOT NULL

rooms (방)

  • 방아이디 (id) — BIGINT — Primary key — NOT NULL
  • 호텔아이디 (id2) — BIGINT — Foreign key → hotels.호텔아이디 — NOT NULL
  • 이름 (name) — VARCHAR(100) — NOT NULL
  • 수용인원 (capacity) — TINYINT — NOT NULL
  • 층 (floor) — TINYINT — NOT NULL
  • 욕조여부 (bathtub_flag) — TINYINT(1) — NOT NULL
  • 뷰타입 (view_type) — TINYINT
  • Field (created_at) — DATETIME — NOT NULL
  • 상태 (status) — TINYINT(1) — NOT NULL