Show dbModel.txt syntax highlighted
Passenger
{
PassengerNr int(9) unique autoincrement not null,
PassengerName varchar(100) not null,
PassengerVorname varchar(100) not null
}
Booking
{
BookingNr int(9) unique autoincrement not null,
BookingDate timestamp not null,
BookerNr int(9) not null
}
BookingItem
{
ItemNr int(9) unique autoincrement not null,
PassengerNr int(9) not null,
BookingNr int(9) not null
}
Booker
{
BookerNr int(9) uniquq autoincrement not null,
BookerName varchar(100) not null,
BookerVorname varchar(100) not null
}
Flight
{
FlightNr int(9) unique autoincrement not null,
FlightStartTime datetime not null,
FLightStopTime datetime not null
}
FlightDescription
{
FlightDescriptionNr int(9) unique autoincrement not null,
FlightDescriptionDateFrom date not null,
FlightDescriptionDateTo date not null,
FlightDescriptionFlightDay int(3) not null
FlightDescriptionStartAirportNr int(9) not null,
FlightDescriptionEndAirportNr int(9) not null
}
FlightCategory
{
FlightDescriptionNr int(9) not null,
CategoryNr int(9) not null,
PriceCategoryNr int(9) not null,
Prize flaoat(9,2) not null,
Key(FlightDescriptionNr, CategoryNr, PriceCategoryNr) unique
}
PriceCategory
{
PriceCategoryNr int(9) unique autoincrement not null,
PriceCategoryName varchar(20) not null
}
Category
{
CategoryNr int(9) unique autoincrement not null,
CategoryName varchar(100) not null
}
Aircraft
{
AircraftNr int(9) unique autoincrement not null,
AircraftName varchar(100) not null,
CarrierNr int(9) not null
}
Carrier
{
CarrierNr int(9) unique autoincrement not null,
CarrierName varchar(100) not null
}
Seat
{
SeatNr int(9) unique autoincrement not null,
CategoryNr int(9) not null
}
Airport
{
AirportNr int(9) unique autoincrement not null,
AirportName varchar(100) not null,
AirportTimezone int(2) not null,
AirportTax float(9,2) not null
}
BoardingPass
{
BoardingPassNr int(9) unique autoincrement not null,
Timestamp timestamp(14) not null,
}
See more files for this project here