room_types
Room categories at each hotel. One row is one room type at one hotel.
- One row is
- one room type at one hotel
- Columns
- 4
- Rows in Sample
- 12
- Rows in Standard
- 12
- Rows in Full
- 12
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| room_type_idkey | integer | Unique id for the row. | |
| hotel_id | integer | Links to hotels. | |
| room_type_name | text | Name of the category. | Courtyard King; Family Bunk Room; Family Suite; Garden Two Queen; Grand King; Gulf View Suite; Harbor King; Keeper's Suite; Lighthouse View Two Queen; Poolside King; Standard Two Queen; Velaluz Residence |
| sleeps | integer | Most guests the room holds. | 2 to 6 |
How it connects
This table points to
- hotel_id matches hotels.hotel_id
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| room_type_id | hotel_id | room_type_name | sleeps |
|---|---|---|---|
| 11 | 1 | Standard Two Queen | 4 |
| 12 | 1 | Courtyard King | 2 |
| 13 | 1 | Family Bunk Room | 6 |
| 21 | 2 | Garden Two Queen | 4 |
| 22 | 2 | Family Suite | 6 |