호텔

테이블 (7)

hotels

  • hotel_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL

members

  • member_id — BIGINT — 기본 키 — NOT NULL
  • id — varchar(50) — NOT NULL
  • pwd — varchar(50) — NOT NULL
  • grade — varchar(10) — NOT NULL
  • point — BIGINT — NOT NULL

points

  • point_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.member_id — NOT NULL
  • point_value — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • point_content — VARCHAR(50) — NOT NULL

reservations

  • reservation_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.member_id — NOT NULL
  • check_in — DATETIME — NOT NULL
  • check_out — DATETIME — NOT NULL
  • reservation_code — VARCHAR(255) — NOT NULL
  • reservation_at — DATETIME — NOT NULL
  • reservation_status — VARCHAR(10) — NOT NULL

reviews

  • review_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.member_id — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • review_title — VARCHAR(50) — NOT NULL
  • review_content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

room_status

  • room_status_id — INT — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
  • status_name — VARCHAR(20) — NOT NULL
  • Field

rooms

  • room_id — BIGINT — 기본 키 — NOT NULL
  • hotel_id — BIGINT — 외래 키 → hotels.hotel_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • capacity — TINYINT — NOT NULL
  • floor — TINYINT — NOT NULL
  • bathtub_flag — TINYINT(1) — NOT NULL
  • view_type — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL