DAS Assignment
Tables (10)
Customer (customer)
- booking_number — int(10) — Foreign key → Reservation.booking_number — NOT NULL
- first_name — varchar(50) — NOT NULL
- last_name — varchar(50) — NOT NULL
- mailing_address — varchar(20) — NOT NULL
- house_contact — number — NOT NULL
- email — varchar(20) — NOT NULL
Each Flight Members (each_flight_members)
- staff_number — INT(10) — Foreign key → Pilot.staff_number — NOT NULL
- unique_id — int(10) — Foreign key → Flight Attendant.unique_id — NOT NULL
- flight_id — int(11) — Foreign key → Flight.flight_id — NOT NULL
Flight (flight)
- flight_id — int(11) — Primary key — NOT NULL
- totalseats_business — numeric — NOT NULL
- Total Seats Economy (totalseats_economy) — numeric — NOT NULL
Flight Attendant (flight_attendant)
- unique_id — int(10) — Primary key — NOT NULL
- fullname — varchar(50) — NOT NULL
- position — varchar(20) — NOT NULL
- phone_number — varchar(20) — NOT NULL
- address — varchar(255) — NOT NULL
- city — varchar(20) — NOT NULL
- postal_code — number — NOT NULL
- country — varchar(10) — NOT NULL
Mailing Address (mailing_address)
- booking_number — int(10) — Foreign key → Customer.booking_number — NOT NULL
- street — varchar(50) — NOT NULL
- city — varchar(50) — NOT NULL
- state (statev) — varchar(20) — NOT NULL
- postal_code — number — NOT NULL
- country — varchar(20) — NOT NULL
- Field
One or more flight (one_or_more_flight)
- staff_number — INT(10) — Foreign key → Pilot.staff_number — NOT NULL
Pilot (pilot)
- staff_number — INT(10) — Primary key — NOT NULL
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- age — VARCHAR(20) — NOT NULL
- year_of_experience — numeric — NOT NULL
- flying_hours — numeric — NOT NULL
- position — varchar(20) — NOT NULL
- salary — money — NOT NULL
Reservation (reservation)
- booking_number — int(10) — Primary key — NOT NULL
- booking_state — varchar(50) — NOT NULL
- booking_date — date — NOT NULL
- date_of_depature — datetime — NOT NULL
- time_of_depature — time — NOT NULL
- date_of_arrival — datetime — NOT NULL
- time_of_arrival — time — NOT NULL
- class_indicator — varchar(20) — NOT NULL
- price — money — NOT NULL
- status_indicator — varchar(20) — NOT NULL
- flight_id — int(11) — Foreign key → Flight.flight_id — NOT NULL
- paid_by — varchar(50) — NOT NULL
- amount_paid — decimal (5, 2) — NOT NULL
- outstanding_balance — decimal(5, 2) — NOT NULL
- first_name — varchar(50) — NOT NULL
- last_name — varchar(50) — NOT NULL
Senior Pilot (senior_pilot)
- staff_number — INT(10) — Foreign key → Pilot.staff_number — NOT NULL
- flying_hpurs (flying_hours) — numeric — NOT NULL
- first_name — varchar(50) — NOT NULL
- last_name — varchar(50) — NOT NULL
Zero Or More House Number (zero_or_more_house_number)
- booking_number — int(10) — Foreign key → Customer.booking_number — NOT NULL
- house_contact — number — NOT NULL