---
# System prepended metadata

title: Untitled

---

## Aircraft Entity

### Properties
- An `Aircraft` has a property `aircraftReg` (`string`) (`pk`)
- An `Aircraft` has a property `name` (`string`)
- An `Aircraft` has a property `model` (`string`)
- An `Aircraft` has a property `economicClassCapacity` (`int`)
- An `Aircraft` has a property `executiveClassCapacity` (`int`) 
- An `Aircraft` has a property `firstClassCapacity` (`int`)
- An `Aircraft` has a property `fuelCapacity` (`int`) (`optional`)

### Relations
- An `Aircraft` has a relation `flies` (`Flight`)



## Ticket Entity

### Properties
- A `Ticket` has a property `ticketNumber` (`string`) (`pk`)
- A `Ticket` has a property `customerID` (`string`) (`fk`)
- A `Ticket` has a property `classCode` (`string`)
- A `Ticket` has a property `flightID` (`string`) (`fk`)
- A `Ticket` has a property `status` (`boolean`)

### Relations
- A `Ticket` has a relation `validate` (`Flight`)



## Customer Entity

### Properties
- A `Customer` has a property `customerID` (`string`) (`pk`)
- A `Customer` has a property `customerName` (`string`)
- A `Customer` has a property `customerPhone` (`string`)
- A `Customer` has a property `email` (`string`)
- A `Customer` has a property `age` (`int`) (`optional`)

### Relations
- A `Customer` has a relation `buys` (`Ticket`)
- A `Customer` has a relation `makes booking` (`Booking`)



## Flight Entity

### Properties
- A `Flight` has a property `flightID` (`string`) (`pk`)
- A `Flight` has a property `depLocation` (`string`)
- A `Flight` has a property `arrLocation` (`string`)
- A `Flight` has a property `flightDate` (`string`)
- A `Flight` has a property `depTime` (`string`) 
- A `Flight` has a property `arrTime` (`string`) 
- A `Flight` has a property `routeID` (`string`) (`optional`)

### Relations
- A `Flight` has a relation `has booking` (`Booking`)



## Booking

### Properties
- A `Booking` has a property `BookingID` (`string`) (`pk`)
- A `Booking` has a property `customerID` (`string`) (`fk`)
- A `Booking` has a property `bookingDate` (`string`)
- A `Booking` has a property `flightID` (`string`) (`fk`)
- A `Booking` has a property `seatNumber` (`string`) 
- A `Booking` has a property `classCode` (`int`)
- A `Booking` has a property `status` (`boolean`)

### Relations
- A `Booking` has a relation `generates flight` (`Flight`)
