Database Model

The Startkladde MySQL database consists of several tables, which store information about flights, people and airplanes. The package pysk.db.model implements the database model in python. The package features one class per table in the database.

Tables

Each table in the database is implemented in terms of a single class in pysk.db.model. These table classes are intenden to store data of a single record, i.e. of one row in the respective table. The associated members have the same names as the respective columns in the represented table. Additionally each table class contains a static method tableName which returns the name of the modeled table. The following tables are supported:

• Airplane Record
• Flight Record
• Launch Method Record
• Pilot Record
• User Record