ss

Tables (13)

bed_type

  • bedType_id — TINYINT — Primary key — NOT NULL
  • bed_type_name — VARCHAR(20) — NOT NULL

file

  • file_id — BIGINT — Primary key — NOT NULL
  • file_name — VARCHAR(100) — NOT NULL

hotel

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

member

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(20) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • points — INT — NOT NULL

reservation

  • reservation_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • reservation_code — VARCHAR(30)
  • user_number — INT
  • reservation_date — DATETIME — NOT NULL
  • user_name — VARCHAR(50)
  • user_phone — VARCHAR(20)

reservation_status

  • reservation_status_id — TINYINT — Primary key — NOT NULL
  • reservation_status_name — VARCHAR(20) — NOT NULL

review

  • review_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — NOT NULL
  • review_content — VARCHAR(200)

review_file

  • file_id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — NOT NULL

room

  • room_id — BIGINT — Primary key — NOT NULL
  • room_name — VARCHAR(20) — NOT NULL
  • floor — TINYINT — NOT NULL
  • capacity — TINYINT — NOT NULL
  • smoking_room — BOOLEAN — NOT NULL
  • has_bathtub — BOOLEAN — NOT NULL
  • room_status_id — TINYINT — NOT NULL
  • hotel_id — BIGINT — NOT NULL
  • price — BIGINT — NOT NULL
  • premium_price — BIGINT — NOT NULL
  • view_id — TINYINT — NOT NULL
  • bedType_id — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

room_file

  • file_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — NOT NULL

room_status

  • room_status_id — TINYINT — Primary key — NOT NULL
  • room_status_name — VARCHAR(20) — NOT NULL

user_point

  • user_point_id — BIGINT — Primary key — NOT NULL
  • point_balance — INT — NOT NULL
  • point_detail — VARCHAR(150) — NOT NULL
  • point_date — DATE — NOT NULL
  • user_id — BIGINT — NOT NULL

view_type

  • view_id — TINYINT — Primary key — NOT NULL
  • view_name — VARCHAR(20) — NOT NULL