x

Tables (7)

files

  • file_id (Key3) — varchar(255) — Primary key — NOT NULL
  • file_extension — varchar(255)
  • file_origin_name — varchar(255)
  • file_url — varchar(255)
  • room_id — bigint — Foreign key

hotels

  • hotel_id — bigint — Primary key — NOT NULL
  • name — varchar(255)

point_histories

  • point_history_id — bigint — Primary key — NOT NULL
  • date_time — datetime(6)
  • description — varchar(255)
  • points — int
  • transaction_type — varchar(255)
  • user_id — bigint — Foreign key
  • Key — Foreign key → users.user_id — NOT NULL

reservations

  • reservation_id — bigint — Primary key — NOT NULL
  • check_in_date — date
  • check_out_date — date
  • contact_number — varchar(255)
  • number_of_people — int — NOT NULL
  • reserver_name — varchar(255)
  • room_id — bigint — Foreign key
  • user_id — bigint — Foreign key

reviews

  • review_id — bigint — Primary key — NOT NULL
  • review_comment — varchar(255)
  • review_rate — int
  • displayed — boolean
  • user_id — bigint — Foreign key
  • Key — Foreign key → users.user_id — NOT NULL

rooms

  • room_id — bigint — Primary key — NOT NULL
  • bathtub_flag — bit
  • bed_type — int
  • capacity — int
  • created_at — datetime(6)
  • floor — int
  • name — varchar(255)
  • view_type — int
  • hotel_id — bigint — Foreign key

users

  • user_id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • password — varchar(255)
  • user_auth — int