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 |