test

Tables (6)

Hotel

  • hotel_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)

Member

  • member_id — VARCHAR(100) — Primary key — NOT NULL
  • username — VARCHAR(100)
  • password — VARCHAR(100)

PointHistory

  • Key — BIGINT — Primary key — NOT NULL
  • member_id — VARCHAR(100) — Foreign key → Member.member_id — NOT NULL
  • created_at — DATETIME
  • is_use (use_status) — TINYINT(1)

Reservation

  • reservation_no — VARCHAR(100) — Primary key — NOT NULL
  • member_id — VARCHAR(100) — Foreign key → Member.member_id — NOT NULL
  • room_id — BIGINT — Foreign key → Room.room_id — NOT NULL
  • hotel_id — BIGINT — Foreign key → Hotel.hotel_id — NOT NULL
  • check_in_at — DATETIME
  • check_out_at — DATETIME
  • people_count — INT

Review

  • review_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → Room.room_id — NOT NULL
  • image_url — VARCHAR(100)
  • is_public — TINYINT(1)
  • title — VARCHAR(100)
  • context — VARCHAR(1000)

Room

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → Hotel.hotel_id — NOT NULL
  • name — VARCHAR(100)
  • capacity — TINYINT
  • floor — TINYINT
  • bathtub_flag — TINYINT(1)
  • view_type — TINYINT
  • created_at — DATETIME
  • price — INT
  • image_url — VARCHAR(100)