= Database Creation

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

[attachment: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