| id | name | address |
|---|---|---|
| 1 | Hostel A | 123 Main St |
| 2 | Hostel B | 456 Elm St |
| 3 | Hostel C | 789 Oak St |
| 4 | Hostel D | 012 Pine St |
| 5 | Hostel E | 345 Maple Ave |
| dormitory_id | type | capacity |
|---|---|---|
| 1 | Mixed_Dormitory | 20 |
| 2 | Female Only | 15 |
| 3 | Mixed_Dormitory | 30 |
| 4 | Male Only | 25 |
| 5 | Mixed_Dormitory | 20 |
| 6 | Female Only | 10 |
| 7 | Mixed_Dormitory | 35 |
| 8 | Male Only | 30 |
| 9 | Mixed_Dormitory | 20 |
| 10 | Female Only | 15 |
| hostel_dormitory_id | hostel_id | dormitory_id |
|---|---|---|
| (→ Hostels.id) | (→ Dormitories.dormitory_id) | |
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 4 | 2 | 4 |
| 5 | 3 | 5 |
| 6 | 3 | 6 |
| 7 | 4 | 7 |
| 8 | 4 | 8 |
| 9 | 5 | 9 |
| 10 | 5 | 10 |
| 11 | 2 | 1 |
| 12 | 3 | 1 |
| 13 | 4 | 1 |
| 14 | 5 | 1 |