scenarios
scenarios
| Variable | Type | NOT NULL | Constraint |
|---|---|---|---|
| id | TEXT | ✓ |
| Table Constraint | Details |
|---|---|
| PRIMARY KEY | id |
scenarios_flights
| Variable | Type | NOT NULL | Constraint |
|---|---|---|---|
| scenario_id | TEXT | ✓ | |
| operation_id | TEXT | ✓ | |
| operation | TEXT | ✓ |
| Table Constraint | Details |
|---|---|
| PRIMARY KEY | scenario_id, operation_id, operation |
| FOREIGN KEY | scenario_id from scenarios |
| FOREIGN KEY | operation_id, operation from operations_flights |
scenarios_tracks_4d
| Variable | Type | NOT NULL | Constraint |
|---|---|---|---|
| scenario_id | TEXT | ✓ | |
| operation_id | TEXT | ✓ | |
| operation | TEXT | ✓ |
| Table Constraint | Details |
|---|---|
| PRIMARY KEY | scenario_id, operation_id, operation |
| FOREIGN KEY | scenario_id from scenarios |
| FOREIGN KEY | operation_id, operation from operations_tracks_4d |