Terminal
id | name | total_area | num_gates | commercial_spaces |
1 | Terminal A | 20000.0 | 30 | Offices |
2 | Terminal B | 25000.0 | 28 | Shops |
3 | Terminal C | 30000.0 | 36 | Restaurants |
4 | Terminal D | 27000.0 | 32 | Bars |
5 | Terminal E | 29000.0 | 34 | Cafes |
CommercialSpaceType
id | type |
1 | Food Court |
2 | Retail Shop |
Revenue
id | revenue |
1 | $1 Million |
2 | $500K |
SpaceInTerminal
terminal_id | space_type_id | area |
(→ Terminal.id) | (→ CommercialSpaceType.id) | |
1 | 1 | 5000.0 |
1 | 2 | 3000.0 |
2 | 1 | 6000.0 |
2 | 2 | 2000.0 |
3 | 1 | 7000.0 |
3 | 2 | 2000.0 |
4 | 1 | 5500.0 |
4 | 2 | 2500.0 |
5 | 1 | 6500.0 |
5 | 2 | 2500.0 |
FinancialReport
date | terminal_id | revenue_id |
| (→ Terminal.id) | (→ Revenue.id) |
2022-01-01 | 1 | 1 |
2022-01-01 | 2 | 2 |
2022-02-01 | 1 | 1 |
2022-02-01 | 2 | 2 |
2022-03-01 | 1 | 1 |
2022-03-01 | 2 | 2 |
2022-04-01 | 1 | 1 |
2022-04-01 | 2 | 2 |
2022-05-01 | 1 | 1 |
2022-05-01 | 2 | 2 |