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