Changes between Version 7 and Version 8 of DatabaseCreation


Ignore:
Timestamp:
05/19/26 12:13:08 (7 days ago)
Author:
231044
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseCreation

    v7 v8  
    44
    55[attachment:SBAirlines.ddl]
     6
     7|| Таблеа || Број на редици ||
     8|| ticket || 25817181 ||
     9|| reservation || 19826517 ||
     10|| baggage || 19826356 ||
     11|| seat || 19826101 ||
     12|| additionalcargo || 15600187 ||
     13|| baggagestatus || 13335983 ||
     14|| repair || 12993390 ||
     15|| itemssold || 6184941 ||
     16|| cabincrew || 3377868 ||
     17|| servedmeals || 2340235 ||
     18|| flight || 1560002 ||
     19|| flightcargostatistics || 1560001 ||
     20|| ticketrevenuedetails || 1560000 ||
     21|| passport || 1200000 ||
     22|| mealrequest || 1049710 ||
     23|| flightcertification || 1000002 ||
     24|| passengerloyaltyprogram || 1000000 ||
     25|| medicalcheckup || 1000000 ||
     26|| passenger || 1000000 ||
     27|| slot || 887964 ||
     28|| partonairplane || 600000 ||
     29|| repaircertification || 499980 ||
     30|| recommendedairplanemodel || 100000 ||
     31|| employee || 100000 ||
     32|| worksonmaintenance || 99997 ||
     33|| gate || 74363 ||
     34|| seatconfiguration || 56258 ||
     35|| maintenance || 52500 ||
     36|| airportemployee || 50000 ||
     37|| airlineemployee || 50000 ||
     38|| flightattendant || 37500 ||
     39|| canceledflight || 21023 ||
     40|| ticketingagent || 16667 ||
     41|| baggagehandler || 16667 ||
     42|| mechanic || 16666 ||
     43|| pilot || 12500 ||
     44|| scheduledflight || 10000 ||
     45|| runway || 9921 ||
     46|| terminal || 9903 ||
     47|| spatial_ref_sys || 8500 ||
     48|| city || 5515 ||
     49|| airport || 5515 ||
     50|| temp_airports || 5515 ||
     51|| parttype || 5000 ||
     52|| airplane || 1500 ||
     53|| airplanemodel || 368 ||
     54|| timezone || 308 ||
     55|| country || 237 ||
     56|| language || 184 ||
     57|| item || 100 ||
     58|| meal || 100 ||
     59|| flightstatus || 11 ||
     60|| baggagetype || 10 ||
     61|| pilotrank || 10 ||
     62|| mealtype || 9 ||
     63|| baggagestatustype || 8 ||
     64|| ticketstatus || 5 ||
     65|| shifttype || 4 ||
     66|| seatclass || 4 ||
     67|| terminaltype || 2 ||