The most important
tables of the flight model are:
•
T000: Client table
•
SCURX: Currencies (key: currency key)
•
SBUSPART: Business partner (key: client, partner
number)
•
STRAVELAG: Travel agencies (key: client, travel
agency number)
•
SCUSTOM: Customers (key: client, customer
number)
•
SCARR: Carriers (key: client, carrier ID)
•
SCOUNTER: Sales counters (key: client, carrier
ID, sales counter number)
•
SPFLI: Flight schedule (key: client, carrier ID,
connection number)
•
SFLIGHT: Flights (key: client, carrier ID,
connection number, date of flight)
•
SBOOK: Flight bookings (key: client, carrier ID,
connection number, date of flight, booking number, customer number)
Relationships between
the Tables
Table SBUSPART contains all the business partners of a
carrier. A business partner is identified by his number in this table. The data
of the contact person for the business partner is also stored. A business
partner can be a travel agency or a customer (e.g. company that frequently
books flights directly with the carrier). Different data is required for these
two types of business partner. The data for a travel agency is stored in table
STRAVELAG and the data for a customer in table SCUSTOM. There is therefore an
entry with the same key in either table STRAVELAG or table SCUSTOM for each
entry in table SBUSPART.
