| 1 | create view RepairDetails (AirplaneId, RegistrationNumber,AirplaneModelId, AirplaneModel, Manufacturer, MaintenanceId, MaintenanceDate,
|
|---|
| 2 | RepairId, Description, RepairPrice, PartOnAirplaneId, PartType,PartPrice, InUse) as
|
|---|
| 3 | select airplane.id, airplane.registrationnumber, airplanemodel.id,
|
|---|
| 4 | airplanemodel.model,
|
|---|
| 5 | airplanemodel.manufacturer, maintenance.id, maintenance.date,
|
|---|
| 6 | repair.id,repair.description,
|
|---|
| 7 | repair.price, partonairplane.id, parttype.name,
|
|---|
| 8 | parttype.price,partonairplane.inuse
|
|---|
| 9 | from maintenance
|
|---|
| 10 | join repair on repair.maintenanceid = maintenance.id
|
|---|
| 11 | join airplane on maintenance.airplaneid = airplane.id
|
|---|
| 12 | join airplanemodel on airplane.modelid = airplanemodel.id
|
|---|
| 13 | join partonairplane on repair.partonairplaneid = partonairplane.id
|
|---|
| 14 | join parttype on partonairplane.parttypeid = parttype.id;
|
|---|
| 15 |
|
|---|
| 16 |
|
|---|
