Database Creation

DDL скрипта за креирање на табелите

SBAirlines.ddl​

Таблеа	Број на редици
ticket	25817181
reservation	19826517
baggage	19826356
seat	19826101
additionalcargo	15600187
baggagestatus	13335983
repair	12993390
itemssold	6184941
cabincrew	3377868
servedmeals	2340235
flight	1560002
passport	1200000
mealrequest	1049710
flightcertification	1000002
medicalcheckup	1000000
passenger	1000000
slot	887964
partonairplane	600000
repaircertification	499980
recommendedairplanemodel	100000
employee	100000
worksonmaintenance	99997
gate	74363
seatconfiguration	56258
maintenance	52500
airportemployee	50000
airlineemployee	50000
flightattendant	37500
canceledflight	21023
ticketingagent	16667
baggagehandler	16667
mechanic	16666
pilot	12500
scheduledflight	10000
runway	9921
terminal	9903
city	5515
airport	5515
parttype	5000
airplane	1500
airplanemodel	368
timezone	308
country	237
language	184
item	100
meal	100
flightstatus	11
baggagetype	10
pilotrank	10
mealtype	9
baggagestatustype	8
ticketstatus	5
shifttype	4
seatclass	4
terminaltype	2

Погледи

Airplane Availability