|  | 
| const auto | TABLE_FLIGHTS = QStringLiteral("flights") | 
|  | 
| const auto | TABLE_PILOTS = QStringLiteral("pilots") | 
|  | 
| const auto | TABLE_TAILS = QStringLiteral("tails") | 
|  | 
| const auto | TABLE_AIRCRAFT = QStringLiteral("aircraft") | 
|  | 
| const auto | TABLE_AIRPORTS = QStringLiteral("airports") | 
|  | 
| const auto | TABLE_CURRENCIES = QStringLiteral("currencies") | 
|  | 
| const auto | TABLE_SIMULATORS = QStringLiteral("simulators") | 
|  | 
| const auto | FLIGHTS_ROWID = QStringLiteral("flight_id") | 
|  | 
| const auto | FLIGHTS_DOFT = QStringLiteral("doft") | 
|  | 
| const auto | FLIGHTS_DEPT = QStringLiteral("dept") | 
|  | 
| const auto | FLIGHTS_DEST = QStringLiteral("dest") | 
|  | 
| const auto | FLIGHTS_TOFB = QStringLiteral("tofb") | 
|  | 
| const auto | FLIGHTS_TONB = QStringLiteral("tonb") | 
|  | 
| const auto | FLIGHTS_PIC = QStringLiteral("pic") | 
|  | 
| const auto | FLIGHTS_ACFT = QStringLiteral("acft") | 
|  | 
| const auto | FLIGHTS_TBLK = QStringLiteral("tblk") | 
|  | 
| const auto | FLIGHTS_TSPSE = QStringLiteral("tSPSE") | 
|  | 
| const auto | FLIGHTS_TSPME = QStringLiteral("tSPME") | 
|  | 
| const auto | FLIGHTS_TMP = QStringLiteral("tMP") | 
|  | 
| const auto | FLIGHTS_TNIGHT = QStringLiteral("tNIGHT") | 
|  | 
| const auto | FLIGHTS_TIFR = QStringLiteral("tIFR") | 
|  | 
| const auto | FLIGHTS_TPIC = QStringLiteral("tPIC") | 
|  | 
| const auto | FLIGHTS_TPICUS = QStringLiteral("tPICUS") | 
|  | 
| const auto | FLIGHTS_TSIC = QStringLiteral("tSIC") | 
|  | 
| const auto | FLIGHTS_TDUAL = QStringLiteral("tDUAL") | 
|  | 
| const auto | FLIGHTS_TFI = QStringLiteral("tFI") | 
|  | 
| const auto | FLIGHTS_TSIM = QStringLiteral("tSIM") | 
|  | 
| const auto | FLIGHTS_PILOTFLYING = QStringLiteral("pilotFlying") | 
|  | 
| const auto | FLIGHTS_TODAY = QStringLiteral("toDay") | 
|  | 
| const auto | FLIGHTS_TONIGHT = QStringLiteral("toNight") | 
|  | 
| const auto | FLIGHTS_LDGDAY = QStringLiteral("ldgDay") | 
|  | 
| const auto | FLIGHTS_LDGNIGHT = QStringLiteral("ldgNight") | 
|  | 
| const auto | FLIGHTS_AUTOLAND = QStringLiteral("autoland") | 
|  | 
| const auto | FLIGHTS_SECONDPILOT = QStringLiteral("secondPilot") | 
|  | 
| const auto | FLIGHTS_THIRDPILOT = QStringLiteral("thirdPilot") | 
|  | 
| const auto | FLIGHTS_APPROACHTYPE = QStringLiteral("approachType") | 
|  | 
| const auto | FLIGHTS_FLIGHTNUMBER = QStringLiteral("flightNumber") | 
|  | 
| const auto | FLIGHTS_REMARKS = QStringLiteral("remarks") | 
|  | 
| const auto | TAILS_ROWID = QStringLiteral("tail_id") | 
|  | 
| const auto | TAILS_REGISTRATION = QStringLiteral("registration") | 
|  | 
| const auto | TAILS_COMPANY = QStringLiteral("company") | 
|  | 
| const auto | TAILS_MAKE = QStringLiteral("make") | 
|  | 
| const auto | TAILS_MODEL = QStringLiteral("model") | 
|  | 
| const auto | TAILS_VARIANT = QStringLiteral("variant") | 
|  | 
| const auto | TAILS_MULTIPILOT = QStringLiteral("multipilot") | 
|  | 
| const auto | TAILS_MULTIENGINE = QStringLiteral("multiengine") | 
|  | 
| const auto | TAILS_ENGINETYPE = QStringLiteral("engineType") | 
|  | 
| const auto | TAILS_WEIGHTCLASS = QStringLiteral("weightClass") | 
|  | 
| const auto | PILOTS_ROWID = QStringLiteral("pilot_id") | 
|  | 
| const auto | PILOTS_LASTNAME = QStringLiteral("lastname") | 
|  | 
| const auto | PILOTS_FIRSTNAME = QStringLiteral("firstname") | 
|  | 
| const auto | PILOTS_ALIAS = QStringLiteral("alias") | 
|  | 
| const auto | PILOTS_COMPANY = QStringLiteral("company") | 
|  | 
| const auto | PILOTS_EMPLOYEEID = QStringLiteral("employeeid") | 
|  | 
| const auto | PILOTS_PHONE = QStringLiteral("phone") | 
|  | 
| const auto | PILOTS_EMAIL = QStringLiteral("email") | 
|  | 
| const auto | CURRENCIES_EXPIRYDATE = QStringLiteral("expiryDate") | 
|  | 
| const auto | CURRENCIES_CURRENCYNAME = QStringLiteral("currencyName") | 
|  | 
| const auto | SIMULATORS_ROWID = QStringLiteral("session_id") | 
|  | 
| const auto | SIMULATORS_DATE = QStringLiteral("date") | 
|  | 
| const auto | SIMULATORS_TIME = QStringLiteral("totalTime") | 
|  | 
| const auto | SIMULATORS_TYPE = QStringLiteral("deviceType") | 
|  | 
| const auto | SIMULATORS_ACFT = QStringLiteral("aircraftType") | 
|  | 
| const auto | SIMULATORS_REG = QStringLiteral("registration") | 
|  | 
| const auto | SIMULATORS_REMARKS = QStringLiteral("remarks") | 
|  | 
| const auto | ROWID = QStringLiteral("rowid") | 
|  | 
| const auto | NULL_TIME_hhmm = QStringLiteral("00:00") | 
|  | 
The OPL::Db namespace provides string literals to programatically access the database
Example usage, do: newData.insert(OPL::Db::FLIGHTS_DEP, ui->deptLocLineEdit->text()); newData.value(OPL::Db::AIRCRAFT_MULTIPILOT);
instead of: newData.insert("dept", ui->deptLocLineEdit->text()); newData.value("multipilot");
Declaring these literals here avoids memory allocation at runtime for construction of temporary qstrings like ("dept").