{
  "formatVersion": 1,
  "database": {
    "version": 57,
    "identityHash": "b3134b3203de2a0433a17d6ffc4f5aee",
    "entities": [
      {
        "tableName": "NetworkNode",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`nodeId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `bluetoothMacAddress` TEXT, `ipAddress` TEXT, `wifiDirectMacAddress` TEXT, `deviceWifiDirectName` TEXT, `endpointUrl` TEXT, `lastUpdateTimeStamp` INTEGER NOT NULL, `networkServiceLastUpdated` INTEGER NOT NULL, `nsdServiceName` TEXT, `port` INTEGER NOT NULL, `numFailureCount` INTEGER NOT NULL, `wifiDirectDeviceStatus` INTEGER NOT NULL, `groupSsid` TEXT)",
        "fields": [
          {
            "fieldPath": "nodeId",
            "columnName": "nodeId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "bluetoothMacAddress",
            "columnName": "bluetoothMacAddress",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "ipAddress",
            "columnName": "ipAddress",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "wifiDirectMacAddress",
            "columnName": "wifiDirectMacAddress",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "deviceWifiDirectName",
            "columnName": "deviceWifiDirectName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "endpointUrl",
            "columnName": "endpointUrl",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "lastUpdateTimeStamp",
            "columnName": "lastUpdateTimeStamp",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "networkServiceLastUpdated",
            "columnName": "networkServiceLastUpdated",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "nsdServiceName",
            "columnName": "nsdServiceName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "port",
            "columnName": "port",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "numFailureCount",
            "columnName": "numFailureCount",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "wifiDirectDeviceStatus",
            "columnName": "wifiDirectDeviceStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupSsid",
            "columnName": "groupSsid",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "nodeId"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_NetworkNode_bluetoothMacAddress",
            "unique": false,
            "columnNames": [
              "bluetoothMacAddress"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_NetworkNode_bluetoothMacAddress` ON `${TABLE_NAME}` (`bluetoothMacAddress`)"
          },
          {
            "name": "index_NetworkNode_lastUpdateTimeStamp",
            "unique": false,
            "columnNames": [
              "lastUpdateTimeStamp"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_NetworkNode_lastUpdateTimeStamp` ON `${TABLE_NAME}` (`lastUpdateTimeStamp`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "DownloadJobItemHistory",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `url` TEXT, `networkNode` INTEGER NOT NULL, `downloadJobItemId` INTEGER NOT NULL, `mode` INTEGER NOT NULL, `numBytes` INTEGER NOT NULL, `successful` INTEGER NOT NULL, `startTime` INTEGER NOT NULL, `endTime` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "url",
            "columnName": "url",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "networkNode",
            "columnName": "networkNode",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "downloadJobItemId",
            "columnName": "downloadJobItemId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "mode",
            "columnName": "mode",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "numBytes",
            "columnName": "numBytes",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "successful",
            "columnName": "successful",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "startTime",
            "columnName": "startTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "endTime",
            "columnName": "endTime",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "id"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzLog",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzLogUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzLogClazzUid` INTEGER NOT NULL, `logDate` INTEGER NOT NULL, `timeRecorded` INTEGER NOT NULL, `clazzLogDone` INTEGER NOT NULL, `cancellationNote` TEXT, `clazzLogCancelled` INTEGER NOT NULL, `clazzLogNumPresent` INTEGER NOT NULL, `clazzLogNumAbsent` INTEGER NOT NULL, `clazzLogNumPartial` INTEGER NOT NULL, `clazzLogScheduleUid` INTEGER NOT NULL, `clazzLogStatusFlag` INTEGER NOT NULL, `clazzLogMSQN` INTEGER NOT NULL, `clazzLogLCSN` INTEGER NOT NULL, `clazzLogLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzLogUid",
            "columnName": "clazzLogUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogClazzUid",
            "columnName": "clazzLogClazzUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "logDate",
            "columnName": "logDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeRecorded",
            "columnName": "timeRecorded",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogDone",
            "columnName": "clazzLogDone",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cancellationNote",
            "columnName": "cancellationNote",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzLogCancelled",
            "columnName": "clazzLogCancelled",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogNumPresent",
            "columnName": "clazzLogNumPresent",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogNumAbsent",
            "columnName": "clazzLogNumAbsent",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogNumPartial",
            "columnName": "clazzLogNumPartial",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogScheduleUid",
            "columnName": "clazzLogScheduleUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogStatusFlag",
            "columnName": "clazzLogStatusFlag",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogMSQN",
            "columnName": "clazzLogMSQN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogLCSN",
            "columnName": "clazzLogLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogLCB",
            "columnName": "clazzLogLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzLogUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzLogAttendanceRecord",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzLogAttendanceRecordUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzLogAttendanceRecordClazzLogUid` INTEGER NOT NULL, `clazzLogAttendanceRecordClazzMemberUid` INTEGER NOT NULL, `attendanceStatus` INTEGER NOT NULL, `clazzLogAttendanceRecordMasterChangeSeqNum` INTEGER NOT NULL, `clazzLogAttendanceRecordLocalChangeSeqNum` INTEGER NOT NULL, `clazzLogAttendanceRecordLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzLogAttendanceRecordUid",
            "columnName": "clazzLogAttendanceRecordUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogAttendanceRecordClazzLogUid",
            "columnName": "clazzLogAttendanceRecordClazzLogUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogAttendanceRecordClazzMemberUid",
            "columnName": "clazzLogAttendanceRecordClazzMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "attendanceStatus",
            "columnName": "attendanceStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogAttendanceRecordMasterChangeSeqNum",
            "columnName": "clazzLogAttendanceRecordMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogAttendanceRecordLocalChangeSeqNum",
            "columnName": "clazzLogAttendanceRecordLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLogAttendanceRecordLastChangedBy",
            "columnName": "clazzLogAttendanceRecordLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzLogAttendanceRecordUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Schedule",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`scheduleUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `sceduleStartTime` INTEGER NOT NULL, `scheduleEndTime` INTEGER NOT NULL, `scheduleDay` INTEGER NOT NULL, `scheduleMonth` INTEGER NOT NULL, `scheduleFrequency` INTEGER NOT NULL, `umCalendarUid` INTEGER NOT NULL, `scheduleClazzUid` INTEGER NOT NULL, `scheduleMasterChangeSeqNum` INTEGER NOT NULL, `scheduleLocalChangeSeqNum` INTEGER NOT NULL, `scheduleLastChangedBy` INTEGER NOT NULL, `scheduleActive` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "scheduleUid",
            "columnName": "scheduleUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sceduleStartTime",
            "columnName": "sceduleStartTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleEndTime",
            "columnName": "scheduleEndTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleDay",
            "columnName": "scheduleDay",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleMonth",
            "columnName": "scheduleMonth",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleFrequency",
            "columnName": "scheduleFrequency",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "umCalendarUid",
            "columnName": "umCalendarUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleClazzUid",
            "columnName": "scheduleClazzUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleMasterChangeSeqNum",
            "columnName": "scheduleMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleLocalChangeSeqNum",
            "columnName": "scheduleLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleLastChangedBy",
            "columnName": "scheduleLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduleActive",
            "columnName": "scheduleActive",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "scheduleUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "DateRange",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`dateRangeUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `dateRangeLocalChangeSeqNum` INTEGER NOT NULL, `dateRangeMasterChangeSeqNum` INTEGER NOT NULL, `dateRangLastChangedBy` INTEGER NOT NULL, `dateRangeFromDate` INTEGER NOT NULL, `dateRangeToDate` INTEGER NOT NULL, `dateRangeUMCalendarUid` INTEGER NOT NULL, `dateRangeName` TEXT, `dateRangeDesc` TEXT, `dateRangeActive` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "dateRangeUid",
            "columnName": "dateRangeUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dateRangeLocalChangeSeqNum",
            "columnName": "dateRangeLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dateRangeMasterChangeSeqNum",
            "columnName": "dateRangeMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dateRangLastChangedBy",
            "columnName": "dateRangLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dateRangeFromDate",
            "columnName": "dateRangeFromDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dateRangeToDate",
            "columnName": "dateRangeToDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dateRangeUMCalendarUid",
            "columnName": "dateRangeUMCalendarUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dateRangeName",
            "columnName": "dateRangeName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dateRangeDesc",
            "columnName": "dateRangeDesc",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dateRangeActive",
            "columnName": "dateRangeActive",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "dateRangeUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "HolidayCalendar",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`umCalendarUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `umCalendarName` TEXT, `umCalendarCategory` INTEGER NOT NULL, `umCalendarActive` INTEGER NOT NULL, `umCalendarMasterChangeSeqNum` INTEGER NOT NULL, `umCalendarLocalChangeSeqNum` INTEGER NOT NULL, `umCalendarLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "umCalendarUid",
            "columnName": "umCalendarUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "umCalendarName",
            "columnName": "umCalendarName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "umCalendarCategory",
            "columnName": "umCalendarCategory",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "umCalendarActive",
            "columnName": "umCalendarActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "umCalendarMasterChangeSeqNum",
            "columnName": "umCalendarMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "umCalendarLocalChangeSeqNum",
            "columnName": "umCalendarLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "umCalendarLastChangedBy",
            "columnName": "umCalendarLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "umCalendarUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Holiday",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`holUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `holMasterCsn` INTEGER NOT NULL, `holLocalCsn` INTEGER NOT NULL, `holLastModBy` INTEGER NOT NULL, `holActive` INTEGER NOT NULL, `holHolidayCalendarUid` INTEGER NOT NULL, `holStartTime` INTEGER NOT NULL, `holEndTime` INTEGER NOT NULL, `holName` TEXT)",
        "fields": [
          {
            "fieldPath": "holUid",
            "columnName": "holUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holMasterCsn",
            "columnName": "holMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holLocalCsn",
            "columnName": "holLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holLastModBy",
            "columnName": "holLastModBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holActive",
            "columnName": "holActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holHolidayCalendarUid",
            "columnName": "holHolidayCalendarUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holStartTime",
            "columnName": "holStartTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holEndTime",
            "columnName": "holEndTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "holName",
            "columnName": "holName",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "holUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ScheduledCheck",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`scheduledCheckUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `checkTime` INTEGER NOT NULL, `checkType` INTEGER NOT NULL, `checkUuid` TEXT, `checkParameters` TEXT, `scClazzLogUid` INTEGER NOT NULL, `scheduledCheckMasterCsn` INTEGER NOT NULL, `scheduledCheckLocalCsn` INTEGER NOT NULL, `scheduledCheckLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "scheduledCheckUid",
            "columnName": "scheduledCheckUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "checkTime",
            "columnName": "checkTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "checkType",
            "columnName": "checkType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "checkUuid",
            "columnName": "checkUuid",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "checkParameters",
            "columnName": "checkParameters",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "scClazzLogUid",
            "columnName": "scClazzLogUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduledCheckMasterCsn",
            "columnName": "scheduledCheckMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduledCheckLocalCsn",
            "columnName": "scheduledCheckLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scheduledCheckLastChangedBy",
            "columnName": "scheduledCheckLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "scheduledCheckUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "AuditLog",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`auditLogUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `auditLogMasterChangeSeqNum` INTEGER NOT NULL, `auditLogLocalChangeSeqNum` INTEGER NOT NULL, `auditLogLastChangedBy` INTEGER NOT NULL, `auditLogActorPersonUid` INTEGER NOT NULL, `auditLogTableUid` INTEGER NOT NULL, `auditLogEntityUid` INTEGER NOT NULL, `auditLogDate` INTEGER NOT NULL, `notes` TEXT)",
        "fields": [
          {
            "fieldPath": "auditLogUid",
            "columnName": "auditLogUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "auditLogMasterChangeSeqNum",
            "columnName": "auditLogMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "auditLogLocalChangeSeqNum",
            "columnName": "auditLogLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "auditLogLastChangedBy",
            "columnName": "auditLogLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "auditLogActorPersonUid",
            "columnName": "auditLogActorPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "auditLogTableUid",
            "columnName": "auditLogTableUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "auditLogEntityUid",
            "columnName": "auditLogEntityUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "auditLogDate",
            "columnName": "auditLogDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "notes",
            "columnName": "notes",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "auditLogUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "CustomField",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`customFieldUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `customFieldName` TEXT, `customFieldNameAlt` TEXT, `customFieldLabelMessageID` INTEGER NOT NULL, `customFieldIcon` TEXT, `customFieldIconId` INTEGER NOT NULL, `actionOnClick` TEXT, `customFieldType` INTEGER NOT NULL, `customFieldEntityType` INTEGER NOT NULL, `customFieldActive` INTEGER NOT NULL, `customFieldDefaultValue` TEXT, `customFieldMCSN` INTEGER NOT NULL, `customFieldLCSN` INTEGER NOT NULL, `customFieldLCB` INTEGER NOT NULL, `customFieldInputType` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "customFieldUid",
            "columnName": "customFieldUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldName",
            "columnName": "customFieldName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldNameAlt",
            "columnName": "customFieldNameAlt",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldLabelMessageID",
            "columnName": "customFieldLabelMessageID",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldIcon",
            "columnName": "customFieldIcon",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldIconId",
            "columnName": "customFieldIconId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "actionOnClick",
            "columnName": "actionOnClick",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldType",
            "columnName": "customFieldType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldEntityType",
            "columnName": "customFieldEntityType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldActive",
            "columnName": "customFieldActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldDefaultValue",
            "columnName": "customFieldDefaultValue",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldMCSN",
            "columnName": "customFieldMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldLCSN",
            "columnName": "customFieldLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldLCB",
            "columnName": "customFieldLCB",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldInputType",
            "columnName": "customFieldInputType",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "customFieldUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "CustomFieldValue",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`customFieldValueUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `customFieldValueFieldUid` INTEGER NOT NULL, `customFieldValueEntityUid` INTEGER NOT NULL, `customFieldValueValue` TEXT, `customFieldValueCustomFieldValueOptionUid` INTEGER NOT NULL, `customFieldValueMCSN` INTEGER NOT NULL, `customFieldValueLCSN` INTEGER NOT NULL, `customFieldValueLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "customFieldValueUid",
            "columnName": "customFieldValueUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueFieldUid",
            "columnName": "customFieldValueFieldUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueEntityUid",
            "columnName": "customFieldValueEntityUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueValue",
            "columnName": "customFieldValueValue",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldValueCustomFieldValueOptionUid",
            "columnName": "customFieldValueCustomFieldValueOptionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueMCSN",
            "columnName": "customFieldValueMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueLCSN",
            "columnName": "customFieldValueLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueLCB",
            "columnName": "customFieldValueLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "customFieldValueUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "CustomFieldValueOption",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`customFieldValueOptionUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `customFieldValueOptionName` TEXT, `customFieldValueOptionFieldUid` INTEGER NOT NULL, `customFieldValueOptionIcon` TEXT, `customFieldValueOptionMessageId` INTEGER NOT NULL, `customFieldValueOptionActive` INTEGER NOT NULL, `customFieldValueOptionMCSN` INTEGER NOT NULL, `customFieldValueOptionLCSN` INTEGER NOT NULL, `customFieldValueOptionLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "customFieldValueOptionUid",
            "columnName": "customFieldValueOptionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueOptionName",
            "columnName": "customFieldValueOptionName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldValueOptionFieldUid",
            "columnName": "customFieldValueOptionFieldUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueOptionIcon",
            "columnName": "customFieldValueOptionIcon",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "customFieldValueOptionMessageId",
            "columnName": "customFieldValueOptionMessageId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueOptionActive",
            "columnName": "customFieldValueOptionActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueOptionMCSN",
            "columnName": "customFieldValueOptionMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueOptionLCSN",
            "columnName": "customFieldValueOptionLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "customFieldValueOptionLCB",
            "columnName": "customFieldValueOptionLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "customFieldValueOptionUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Person",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`personUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `username` TEXT, `firstNames` TEXT, `lastName` TEXT, `emailAddr` TEXT, `phoneNum` TEXT, `gender` INTEGER NOT NULL, `active` INTEGER NOT NULL, `admin` INTEGER NOT NULL, `personNotes` TEXT, `fatherName` TEXT, `fatherNumber` TEXT, `motherName` TEXT, `motherNum` TEXT, `dateOfBirth` INTEGER NOT NULL, `personAddress` TEXT, `personOrgId` TEXT, `personGroupUid` INTEGER NOT NULL, `personMasterChangeSeqNum` INTEGER NOT NULL, `personLocalChangeSeqNum` INTEGER NOT NULL, `personLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "personUid",
            "columnName": "personUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "username",
            "columnName": "username",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "firstNames",
            "columnName": "firstNames",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "lastName",
            "columnName": "lastName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "emailAddr",
            "columnName": "emailAddr",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "phoneNum",
            "columnName": "phoneNum",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "gender",
            "columnName": "gender",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "active",
            "columnName": "active",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "admin",
            "columnName": "admin",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personNotes",
            "columnName": "personNotes",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "fatherName",
            "columnName": "fatherName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "fatherNumber",
            "columnName": "fatherNumber",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "motherName",
            "columnName": "motherName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "motherNum",
            "columnName": "motherNum",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "dateOfBirth",
            "columnName": "dateOfBirth",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personAddress",
            "columnName": "personAddress",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "personOrgId",
            "columnName": "personOrgId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "personGroupUid",
            "columnName": "personGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personMasterChangeSeqNum",
            "columnName": "personMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personLocalChangeSeqNum",
            "columnName": "personLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personLastChangedBy",
            "columnName": "personLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "personUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "DownloadJob",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`djUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `djDsUid` INTEGER NOT NULL, `timeCreated` INTEGER NOT NULL, `timeRequested` INTEGER NOT NULL, `timeCompleted` INTEGER NOT NULL, `totalBytesToDownload` INTEGER NOT NULL, `bytesDownloadedSoFar` INTEGER NOT NULL, `djStatus` INTEGER NOT NULL, `meteredNetworkAllowed` INTEGER NOT NULL, `djRootContentEntryUid` INTEGER NOT NULL, `djDestinationDir` TEXT)",
        "fields": [
          {
            "fieldPath": "djUid",
            "columnName": "djUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djDsUid",
            "columnName": "djDsUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeCreated",
            "columnName": "timeCreated",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeRequested",
            "columnName": "timeRequested",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeCompleted",
            "columnName": "timeCompleted",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "totalBytesToDownload",
            "columnName": "totalBytesToDownload",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "bytesDownloadedSoFar",
            "columnName": "bytesDownloadedSoFar",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djStatus",
            "columnName": "djStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "meteredNetworkAllowed",
            "columnName": "meteredNetworkAllowed",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djRootContentEntryUid",
            "columnName": "djRootContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djDestinationDir",
            "columnName": "djDestinationDir",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "djUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "DownloadJobItem",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`djiUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `djiDsiUid` INTEGER NOT NULL, `djiDjUid` INTEGER NOT NULL, `djiContainerUid` INTEGER NOT NULL, `djiContentEntryUid` INTEGER NOT NULL, `downloadedSoFar` INTEGER NOT NULL, `downloadLength` INTEGER NOT NULL, `currentSpeed` INTEGER NOT NULL, `timeStarted` INTEGER NOT NULL, `timeFinished` INTEGER NOT NULL, `djiStatus` INTEGER NOT NULL, `destinationFile` TEXT, `numAttempts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "djiUid",
            "columnName": "djiUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiDsiUid",
            "columnName": "djiDsiUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiDjUid",
            "columnName": "djiDjUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiContainerUid",
            "columnName": "djiContainerUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiContentEntryUid",
            "columnName": "djiContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "downloadedSoFar",
            "columnName": "downloadedSoFar",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "downloadLength",
            "columnName": "downloadLength",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "currentSpeed",
            "columnName": "currentSpeed",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeStarted",
            "columnName": "timeStarted",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeFinished",
            "columnName": "timeFinished",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiStatus",
            "columnName": "djiStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "destinationFile",
            "columnName": "destinationFile",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "numAttempts",
            "columnName": "numAttempts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "djiUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_DownloadJobItem_timeStarted",
            "unique": false,
            "columnNames": [
              "timeStarted"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_DownloadJobItem_timeStarted` ON `${TABLE_NAME}` (`timeStarted`)"
          },
          {
            "name": "index_DownloadJobItem_djiStatus",
            "unique": false,
            "columnNames": [
              "djiStatus"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_DownloadJobItem_djiStatus` ON `${TABLE_NAME}` (`djiStatus`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "DownloadJobItemParentChildJoin",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`djiPcjUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `djiParentDjiUid` INTEGER NOT NULL, `djiChildDjiUid` INTEGER NOT NULL, `djiCepcjUid` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "djiPcjUid",
            "columnName": "djiPcjUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiParentDjiUid",
            "columnName": "djiParentDjiUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiChildDjiUid",
            "columnName": "djiChildDjiUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "djiCepcjUid",
            "columnName": "djiCepcjUid",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "djiPcjUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Clazz",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzName` TEXT, `clazzDesc` TEXT, `attendanceAverage` REAL NOT NULL, `clazzHolidayUMCalendarUid` INTEGER NOT NULL, `clazzScheuleUMCalendarUid` INTEGER NOT NULL, `isClazzActive` INTEGER NOT NULL, `clazzLocationUid` INTEGER NOT NULL, `clazzStartTime` INTEGER NOT NULL, `clazzEndTime` INTEGER NOT NULL, `clazzFeatures` INTEGER NOT NULL, `clazzSchoolUid` INTEGER NOT NULL, `clazzMasterChangeSeqNum` INTEGER NOT NULL, `clazzLocalChangeSeqNum` INTEGER NOT NULL, `clazzLastChangedBy` INTEGER NOT NULL, `clazzTimeZone` TEXT, `clazzStudentsPersonGroupUid` INTEGER NOT NULL, `clazzTeachersPersonGroupUid` INTEGER NOT NULL, `clazzPendingStudentsPersonGroupUid` INTEGER NOT NULL, `clazzCode` TEXT)",
        "fields": [
          {
            "fieldPath": "clazzUid",
            "columnName": "clazzUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzName",
            "columnName": "clazzName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzDesc",
            "columnName": "clazzDesc",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "attendanceAverage",
            "columnName": "attendanceAverage",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "clazzHolidayUMCalendarUid",
            "columnName": "clazzHolidayUMCalendarUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzScheuleUMCalendarUid",
            "columnName": "clazzScheuleUMCalendarUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "isClazzActive",
            "columnName": "isClazzActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLocationUid",
            "columnName": "clazzLocationUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzStartTime",
            "columnName": "clazzStartTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzEndTime",
            "columnName": "clazzEndTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzFeatures",
            "columnName": "clazzFeatures",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzSchoolUid",
            "columnName": "clazzSchoolUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMasterChangeSeqNum",
            "columnName": "clazzMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLocalChangeSeqNum",
            "columnName": "clazzLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzLastChangedBy",
            "columnName": "clazzLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzTimeZone",
            "columnName": "clazzTimeZone",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzStudentsPersonGroupUid",
            "columnName": "clazzStudentsPersonGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzTeachersPersonGroupUid",
            "columnName": "clazzTeachersPersonGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzPendingStudentsPersonGroupUid",
            "columnName": "clazzPendingStudentsPersonGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzCode",
            "columnName": "clazzCode",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzMember",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzMemberUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzMemberPersonUid` INTEGER NOT NULL, `clazzMemberClazzUid` INTEGER NOT NULL, `clazzMemberDateJoined` INTEGER NOT NULL, `clazzMemberDateLeft` INTEGER NOT NULL, `clazzMemberRole` INTEGER NOT NULL, `clazzMemberAttendancePercentage` REAL NOT NULL, `clazzMemberActive` INTEGER NOT NULL, `clazzMemberLocalChangeSeqNum` INTEGER NOT NULL, `clazzMemberMasterChangeSeqNum` INTEGER NOT NULL, `clazzMemberLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzMemberUid",
            "columnName": "clazzMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberPersonUid",
            "columnName": "clazzMemberPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberClazzUid",
            "columnName": "clazzMemberClazzUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberDateJoined",
            "columnName": "clazzMemberDateJoined",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberDateLeft",
            "columnName": "clazzMemberDateLeft",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberRole",
            "columnName": "clazzMemberRole",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberAttendancePercentage",
            "columnName": "clazzMemberAttendancePercentage",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberActive",
            "columnName": "clazzMemberActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberLocalChangeSeqNum",
            "columnName": "clazzMemberLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberMasterChangeSeqNum",
            "columnName": "clazzMemberMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzMemberLastChangedBy",
            "columnName": "clazzMemberLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzMemberUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzMember_clazzMemberPersonUid_clazzMemberClazzUid",
            "unique": false,
            "columnNames": [
              "clazzMemberPersonUid",
              "clazzMemberClazzUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzMember_clazzMemberPersonUid_clazzMemberClazzUid` ON `${TABLE_NAME}` (`clazzMemberPersonUid`, `clazzMemberClazzUid`)"
          },
          {
            "name": "index_ClazzMember_clazzMemberClazzUid_clazzMemberPersonUid",
            "unique": false,
            "columnNames": [
              "clazzMemberClazzUid",
              "clazzMemberPersonUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzMember_clazzMemberClazzUid_clazzMemberPersonUid` ON `${TABLE_NAME}` (`clazzMemberClazzUid`, `clazzMemberPersonUid`)"
          },
          {
            "name": "index_ClazzMember_clazzMemberClazzUid_clazzMemberRole",
            "unique": false,
            "columnNames": [
              "clazzMemberClazzUid",
              "clazzMemberRole"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzMember_clazzMemberClazzUid_clazzMemberRole` ON `${TABLE_NAME}` (`clazzMemberClazzUid`, `clazzMemberRole`)"
          },
          {
            "name": "index_ClazzMember_clazzMemberPersonUid",
            "unique": false,
            "columnNames": [
              "clazzMemberPersonUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzMember_clazzMemberPersonUid` ON `${TABLE_NAME}` (`clazzMemberPersonUid`)"
          },
          {
            "name": "index_ClazzMember_clazzMemberClazzUid",
            "unique": false,
            "columnNames": [
              "clazzMemberClazzUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzMember_clazzMemberClazzUid` ON `${TABLE_NAME}` (`clazzMemberClazzUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "PersonCustomFieldValue",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`personCustomFieldValueUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `personCustomFieldValuePersonCustomFieldUid` INTEGER NOT NULL, `personCustomFieldValuePersonUid` INTEGER NOT NULL, `fieldValue` TEXT, `personCustomFieldValueMasterChangeSeqNum` INTEGER NOT NULL, `personCustomFieldValueLocalChangeSeqNum` INTEGER NOT NULL, `personCustomFieldValueLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "personCustomFieldValueUid",
            "columnName": "personCustomFieldValueUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personCustomFieldValuePersonCustomFieldUid",
            "columnName": "personCustomFieldValuePersonCustomFieldUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personCustomFieldValuePersonUid",
            "columnName": "personCustomFieldValuePersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "fieldValue",
            "columnName": "fieldValue",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "personCustomFieldValueMasterChangeSeqNum",
            "columnName": "personCustomFieldValueMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personCustomFieldValueLocalChangeSeqNum",
            "columnName": "personCustomFieldValueLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personCustomFieldValueLastChangedBy",
            "columnName": "personCustomFieldValueLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "personCustomFieldValueUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntry",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`contentEntryUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `title` TEXT, `description` TEXT, `entryId` TEXT, `author` TEXT, `publisher` TEXT, `licenseType` INTEGER NOT NULL, `licenseName` TEXT, `licenseUrl` TEXT, `sourceUrl` TEXT, `thumbnailUrl` TEXT, `lastModified` INTEGER NOT NULL, `primaryLanguageUid` INTEGER NOT NULL, `languageVariantUid` INTEGER NOT NULL, `contentFlags` INTEGER NOT NULL, `leaf` INTEGER NOT NULL, `publik` INTEGER NOT NULL, `ceInactive` INTEGER NOT NULL, `contentTypeFlag` INTEGER NOT NULL, `contentEntryLocalChangeSeqNum` INTEGER NOT NULL, `contentEntryMasterChangeSeqNum` INTEGER NOT NULL, `contentEntryLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "contentEntryUid",
            "columnName": "contentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "title",
            "columnName": "title",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "description",
            "columnName": "description",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "entryId",
            "columnName": "entryId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "author",
            "columnName": "author",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "publisher",
            "columnName": "publisher",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "licenseType",
            "columnName": "licenseType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "licenseName",
            "columnName": "licenseName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "licenseUrl",
            "columnName": "licenseUrl",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "sourceUrl",
            "columnName": "sourceUrl",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "thumbnailUrl",
            "columnName": "thumbnailUrl",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "lastModified",
            "columnName": "lastModified",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "primaryLanguageUid",
            "columnName": "primaryLanguageUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "languageVariantUid",
            "columnName": "languageVariantUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentFlags",
            "columnName": "contentFlags",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "leaf",
            "columnName": "leaf",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "publik",
            "columnName": "publik",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceInactive",
            "columnName": "ceInactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentTypeFlag",
            "columnName": "contentTypeFlag",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryLocalChangeSeqNum",
            "columnName": "contentEntryLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryMasterChangeSeqNum",
            "columnName": "contentEntryMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryLastChangedBy",
            "columnName": "contentEntryLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "contentEntryUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentEntry_primaryLanguageUid",
            "unique": false,
            "columnNames": [
              "primaryLanguageUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntry_primaryLanguageUid` ON `${TABLE_NAME}` (`primaryLanguageUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryContentCategoryJoin",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`ceccjUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `ceccjContentEntryUid` INTEGER NOT NULL, `ceccjContentCategoryUid` INTEGER NOT NULL, `ceccjLocalChangeSeqNum` INTEGER NOT NULL, `ceccjMasterChangeSeqNum` INTEGER NOT NULL, `ceccjLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "ceccjUid",
            "columnName": "ceccjUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceccjContentEntryUid",
            "columnName": "ceccjContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceccjContentCategoryUid",
            "columnName": "ceccjContentCategoryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceccjLocalChangeSeqNum",
            "columnName": "ceccjLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceccjMasterChangeSeqNum",
            "columnName": "ceccjMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceccjLastChangedBy",
            "columnName": "ceccjLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "ceccjUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentEntryContentCategoryJoin_ceccjContentEntryUid",
            "unique": false,
            "columnNames": [
              "ceccjContentEntryUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryContentCategoryJoin_ceccjContentEntryUid` ON `${TABLE_NAME}` (`ceccjContentEntryUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryParentChildJoin",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cepcjUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cepcjLocalChangeSeqNum` INTEGER NOT NULL, `cepcjMasterChangeSeqNum` INTEGER NOT NULL, `cepcjLastChangedBy` INTEGER NOT NULL, `cepcjParentContentEntryUid` INTEGER NOT NULL, `cepcjChildContentEntryUid` INTEGER NOT NULL, `childIndex` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "cepcjUid",
            "columnName": "cepcjUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cepcjLocalChangeSeqNum",
            "columnName": "cepcjLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cepcjMasterChangeSeqNum",
            "columnName": "cepcjMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cepcjLastChangedBy",
            "columnName": "cepcjLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cepcjParentContentEntryUid",
            "columnName": "cepcjParentContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cepcjChildContentEntryUid",
            "columnName": "cepcjChildContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "childIndex",
            "columnName": "childIndex",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "cepcjUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "parent_child",
            "unique": false,
            "columnNames": [
              "cepcjChildContentEntryUid",
              "cepcjParentContentEntryUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `parent_child` ON `${TABLE_NAME}` (`cepcjChildContentEntryUid`, `cepcjParentContentEntryUid`)"
          },
          {
            "name": "index_ContentEntryParentChildJoin_cepcjParentContentEntryUid",
            "unique": false,
            "columnNames": [
              "cepcjParentContentEntryUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryParentChildJoin_cepcjParentContentEntryUid` ON `${TABLE_NAME}` (`cepcjParentContentEntryUid`)"
          },
          {
            "name": "index_ContentEntryParentChildJoin_cepcjChildContentEntryUid",
            "unique": false,
            "columnNames": [
              "cepcjChildContentEntryUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryParentChildJoin_cepcjChildContentEntryUid` ON `${TABLE_NAME}` (`cepcjChildContentEntryUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryRelatedEntryJoin",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cerejUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cerejContentEntryUid` INTEGER NOT NULL, `cerejRelatedEntryUid` INTEGER NOT NULL, `cerejLastChangedBy` INTEGER NOT NULL, `relType` INTEGER NOT NULL, `comment` TEXT, `cerejRelLanguageUid` INTEGER NOT NULL, `cerejLocalChangeSeqNum` INTEGER NOT NULL, `cerejMasterChangeSeqNum` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "cerejUid",
            "columnName": "cerejUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cerejContentEntryUid",
            "columnName": "cerejContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cerejRelatedEntryUid",
            "columnName": "cerejRelatedEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cerejLastChangedBy",
            "columnName": "cerejLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "relType",
            "columnName": "relType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "comment",
            "columnName": "comment",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "cerejRelLanguageUid",
            "columnName": "cerejRelLanguageUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cerejLocalChangeSeqNum",
            "columnName": "cerejLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cerejMasterChangeSeqNum",
            "columnName": "cerejMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "cerejUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContentCategorySchema",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`contentCategorySchemaUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `schemaName` TEXT, `schemaUrl` TEXT, `contentCategorySchemaLocalChangeSeqNum` INTEGER NOT NULL, `contentCategorySchemaMasterChangeSeqNum` INTEGER NOT NULL, `contentCategorySchemaLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "contentCategorySchemaUid",
            "columnName": "contentCategorySchemaUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schemaName",
            "columnName": "schemaName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "schemaUrl",
            "columnName": "schemaUrl",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "contentCategorySchemaLocalChangeSeqNum",
            "columnName": "contentCategorySchemaLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentCategorySchemaMasterChangeSeqNum",
            "columnName": "contentCategorySchemaMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentCategorySchemaLastChangedBy",
            "columnName": "contentCategorySchemaLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "contentCategorySchemaUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContentCategory",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`contentCategoryUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `ctnCatContentCategorySchemaUid` INTEGER NOT NULL, `name` TEXT, `contentCategoryLocalChangeSeqNum` INTEGER NOT NULL, `contentCategoryMasterChangeSeqNum` INTEGER NOT NULL, `contentCategoryLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "contentCategoryUid",
            "columnName": "contentCategoryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ctnCatContentCategorySchemaUid",
            "columnName": "ctnCatContentCategorySchemaUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "name",
            "columnName": "name",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "contentCategoryLocalChangeSeqNum",
            "columnName": "contentCategoryLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentCategoryMasterChangeSeqNum",
            "columnName": "contentCategoryMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentCategoryLastChangedBy",
            "columnName": "contentCategoryLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "contentCategoryUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Language",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`langUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `name` TEXT, `iso_639_1_standard` TEXT, `iso_639_2_standard` TEXT, `iso_639_3_standard` TEXT, `Language_Type` TEXT, `langLocalChangeSeqNum` INTEGER NOT NULL, `langMasterChangeSeqNum` INTEGER NOT NULL, `langLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "langUid",
            "columnName": "langUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "name",
            "columnName": "name",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "iso_639_1_standard",
            "columnName": "iso_639_1_standard",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "iso_639_2_standard",
            "columnName": "iso_639_2_standard",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "iso_639_3_standard",
            "columnName": "iso_639_3_standard",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "Language_Type",
            "columnName": "Language_Type",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "langLocalChangeSeqNum",
            "columnName": "langLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "langMasterChangeSeqNum",
            "columnName": "langMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "langLastChangedBy",
            "columnName": "langLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "langUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "LanguageVariant",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`langVariantUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `langUid` INTEGER NOT NULL, `countryCode` TEXT, `name` TEXT, `langVariantLocalChangeSeqNum` INTEGER NOT NULL, `langVariantMasterChangeSeqNum` INTEGER NOT NULL, `langVariantLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "langVariantUid",
            "columnName": "langVariantUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "langUid",
            "columnName": "langUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "countryCode",
            "columnName": "countryCode",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "name",
            "columnName": "name",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "langVariantLocalChangeSeqNum",
            "columnName": "langVariantLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "langVariantMasterChangeSeqNum",
            "columnName": "langVariantMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "langVariantLastChangedBy",
            "columnName": "langVariantLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "langVariantUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "AccessToken",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`token` TEXT NOT NULL, `accessTokenPersonUid` INTEGER NOT NULL, `expires` INTEGER NOT NULL, PRIMARY KEY(`token`))",
        "fields": [
          {
            "fieldPath": "token",
            "columnName": "token",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "accessTokenPersonUid",
            "columnName": "accessTokenPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "expires",
            "columnName": "expires",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "token"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "PersonAuth",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`personAuthUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `passwordHash` TEXT, `personAuthStatus` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "personAuthUid",
            "columnName": "personAuthUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "passwordHash",
            "columnName": "passwordHash",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "personAuthStatus",
            "columnName": "personAuthStatus",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "personAuthUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Role",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`roleUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `roleName` TEXT, `roleActive` INTEGER NOT NULL, `roleMasterCsn` INTEGER NOT NULL, `roleLocalCsn` INTEGER NOT NULL, `roleLastChangedBy` INTEGER NOT NULL, `rolePermissions` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "roleUid",
            "columnName": "roleUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "roleName",
            "columnName": "roleName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "roleActive",
            "columnName": "roleActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "roleMasterCsn",
            "columnName": "roleMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "roleLocalCsn",
            "columnName": "roleLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "roleLastChangedBy",
            "columnName": "roleLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rolePermissions",
            "columnName": "rolePermissions",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "roleUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Role_rolePermissions",
            "unique": false,
            "columnNames": [
              "rolePermissions"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Role_rolePermissions` ON `${TABLE_NAME}` (`rolePermissions`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "EntityRole",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`erUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `erMasterCsn` INTEGER NOT NULL, `erLocalCsn` INTEGER NOT NULL, `erLastChangedBy` INTEGER NOT NULL, `erTableId` INTEGER NOT NULL, `erEntityUid` INTEGER NOT NULL, `erGroupUid` INTEGER NOT NULL, `erRoleUid` INTEGER NOT NULL, `erActive` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "erUid",
            "columnName": "erUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erMasterCsn",
            "columnName": "erMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erLocalCsn",
            "columnName": "erLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erLastChangedBy",
            "columnName": "erLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erTableId",
            "columnName": "erTableId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erEntityUid",
            "columnName": "erEntityUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erGroupUid",
            "columnName": "erGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erRoleUid",
            "columnName": "erRoleUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "erActive",
            "columnName": "erActive",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "erUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_EntityRole_erGroupUid_erRoleUid_erTableId",
            "unique": false,
            "columnNames": [
              "erGroupUid",
              "erRoleUid",
              "erTableId"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_EntityRole_erGroupUid_erRoleUid_erTableId` ON `${TABLE_NAME}` (`erGroupUid`, `erRoleUid`, `erTableId`)"
          },
          {
            "name": "index_EntityRole_erTableId",
            "unique": false,
            "columnNames": [
              "erTableId"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_EntityRole_erTableId` ON `${TABLE_NAME}` (`erTableId`)"
          },
          {
            "name": "index_EntityRole_erEntityUid",
            "unique": false,
            "columnNames": [
              "erEntityUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_EntityRole_erEntityUid` ON `${TABLE_NAME}` (`erEntityUid`)"
          },
          {
            "name": "index_EntityRole_erGroupUid",
            "unique": false,
            "columnNames": [
              "erGroupUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_EntityRole_erGroupUid` ON `${TABLE_NAME}` (`erGroupUid`)"
          },
          {
            "name": "index_EntityRole_erRoleUid",
            "unique": false,
            "columnNames": [
              "erRoleUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_EntityRole_erRoleUid` ON `${TABLE_NAME}` (`erRoleUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "PersonGroup",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`groupUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `groupMasterCsn` INTEGER NOT NULL, `groupLocalCsn` INTEGER NOT NULL, `groupLastChangedBy` INTEGER NOT NULL, `groupName` TEXT, `groupActive` INTEGER NOT NULL, `personGroupFlag` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "groupUid",
            "columnName": "groupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupMasterCsn",
            "columnName": "groupMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLocalCsn",
            "columnName": "groupLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLastChangedBy",
            "columnName": "groupLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupName",
            "columnName": "groupName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "groupActive",
            "columnName": "groupActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personGroupFlag",
            "columnName": "personGroupFlag",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "groupUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "PersonGroupMember",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`groupMemberUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `groupMemberActive` INTEGER NOT NULL, `groupMemberPersonUid` INTEGER NOT NULL, `groupMemberGroupUid` INTEGER NOT NULL, `groupMemberMasterCsn` INTEGER NOT NULL, `groupMemberLocalCsn` INTEGER NOT NULL, `groupMemberLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "groupMemberUid",
            "columnName": "groupMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupMemberActive",
            "columnName": "groupMemberActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupMemberPersonUid",
            "columnName": "groupMemberPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupMemberGroupUid",
            "columnName": "groupMemberGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupMemberMasterCsn",
            "columnName": "groupMemberMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupMemberLocalCsn",
            "columnName": "groupMemberLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupMemberLastChangedBy",
            "columnName": "groupMemberLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "groupMemberUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_PersonGroupMember_groupMemberPersonUid",
            "unique": false,
            "columnNames": [
              "groupMemberPersonUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_PersonGroupMember_groupMemberPersonUid` ON `${TABLE_NAME}` (`groupMemberPersonUid`)"
          },
          {
            "name": "index_PersonGroupMember_groupMemberGroupUid",
            "unique": false,
            "columnNames": [
              "groupMemberGroupUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_PersonGroupMember_groupMemberGroupUid` ON `${TABLE_NAME}` (`groupMemberGroupUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "PersonPicture",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`personPictureUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `personPicturePersonUid` INTEGER NOT NULL, `personPictureMasterCsn` INTEGER NOT NULL, `personPictureLocalCsn` INTEGER NOT NULL, `personPictureLastChangedBy` INTEGER NOT NULL, `personPictureUri` TEXT, `personPictureMd5` TEXT, `fileSize` INTEGER NOT NULL, `picTimestamp` INTEGER NOT NULL, `mimeType` TEXT, `personPictureActive` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "personPictureUid",
            "columnName": "personPictureUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personPicturePersonUid",
            "columnName": "personPicturePersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personPictureMasterCsn",
            "columnName": "personPictureMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personPictureLocalCsn",
            "columnName": "personPictureLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personPictureLastChangedBy",
            "columnName": "personPictureLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "personPictureUri",
            "columnName": "personPictureUri",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "personPictureMd5",
            "columnName": "personPictureMd5",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "fileSize",
            "columnName": "fileSize",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "picTimestamp",
            "columnName": "picTimestamp",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "mimeType",
            "columnName": "mimeType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "personPictureActive",
            "columnName": "personPictureActive",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "personPictureUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ScrapeQueueItem",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`sqiUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `sqiContentEntryParentUid` INTEGER NOT NULL, `sqiContentEntryUid` INTEGER NOT NULL, `destDir` TEXT, `scrapeUrl` TEXT, `status` INTEGER NOT NULL, `runId` INTEGER NOT NULL, `itemType` INTEGER NOT NULL, `errorCode` INTEGER NOT NULL, `contentType` TEXT, `timeAdded` INTEGER NOT NULL, `timeStarted` INTEGER NOT NULL, `timeFinished` INTEGER NOT NULL, `priority` INTEGER NOT NULL, `overrideEntry` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "sqiUid",
            "columnName": "sqiUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sqiContentEntryParentUid",
            "columnName": "sqiContentEntryParentUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sqiContentEntryUid",
            "columnName": "sqiContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "destDir",
            "columnName": "destDir",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "scrapeUrl",
            "columnName": "scrapeUrl",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "status",
            "columnName": "status",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "runId",
            "columnName": "runId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "itemType",
            "columnName": "itemType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "errorCode",
            "columnName": "errorCode",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentType",
            "columnName": "contentType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "timeAdded",
            "columnName": "timeAdded",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeStarted",
            "columnName": "timeStarted",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timeFinished",
            "columnName": "timeFinished",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "priority",
            "columnName": "priority",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "overrideEntry",
            "columnName": "overrideEntry",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "sqiUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ScrapeQueueItem_status_itemType",
            "unique": false,
            "columnNames": [
              "status",
              "itemType"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ScrapeQueueItem_status_itemType` ON `${TABLE_NAME}` (`status`, `itemType`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ScrapeRun",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`scrapeRunUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `scrapeType` TEXT, `scrapeRunStatus` INTEGER NOT NULL, `conversionParams` TEXT)",
        "fields": [
          {
            "fieldPath": "scrapeRunUid",
            "columnName": "scrapeRunUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "scrapeType",
            "columnName": "scrapeType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "scrapeRunStatus",
            "columnName": "scrapeRunStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "conversionParams",
            "columnName": "conversionParams",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "scrapeRunUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryStatus",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cesUid` INTEGER NOT NULL, `totalSize` INTEGER NOT NULL, `bytesDownloadSoFar` INTEGER NOT NULL, `downloadStatus` INTEGER NOT NULL, `locallyAvailable` INTEGER NOT NULL, `downloadSpeed` INTEGER NOT NULL, `invalidated` INTEGER NOT NULL, `cesLeaf` INTEGER NOT NULL, PRIMARY KEY(`cesUid`))",
        "fields": [
          {
            "fieldPath": "cesUid",
            "columnName": "cesUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "totalSize",
            "columnName": "totalSize",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "bytesDownloadSoFar",
            "columnName": "bytesDownloadSoFar",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "downloadStatus",
            "columnName": "downloadStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "locallyAvailable",
            "columnName": "locallyAvailable",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "downloadSpeed",
            "columnName": "downloadSpeed",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "invalidated",
            "columnName": "invalidated",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cesLeaf",
            "columnName": "cesLeaf",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "cesUid"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ConnectivityStatus",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`csUid` INTEGER NOT NULL, `connectivityState` INTEGER NOT NULL, `wifiSsid` TEXT, `connectedOrConnecting` INTEGER NOT NULL, PRIMARY KEY(`csUid`))",
        "fields": [
          {
            "fieldPath": "csUid",
            "columnName": "csUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "connectivityState",
            "columnName": "connectivityState",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "wifiSsid",
            "columnName": "wifiSsid",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "connectedOrConnecting",
            "columnName": "connectedOrConnecting",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "csUid"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Container",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`containerUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cntLocalCsn` INTEGER NOT NULL, `cntMasterCsn` INTEGER NOT NULL, `cntLastModBy` INTEGER NOT NULL, `fileSize` INTEGER NOT NULL, `containerContentEntryUid` INTEGER NOT NULL, `cntLastModified` INTEGER NOT NULL, `mimeType` TEXT, `remarks` TEXT, `mobileOptimized` INTEGER NOT NULL, `cntNumEntries` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "containerUid",
            "columnName": "containerUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cntLocalCsn",
            "columnName": "cntLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cntMasterCsn",
            "columnName": "cntMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cntLastModBy",
            "columnName": "cntLastModBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "fileSize",
            "columnName": "fileSize",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "containerContentEntryUid",
            "columnName": "containerContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cntLastModified",
            "columnName": "cntLastModified",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "mimeType",
            "columnName": "mimeType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "remarks",
            "columnName": "remarks",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "mobileOptimized",
            "columnName": "mobileOptimized",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cntNumEntries",
            "columnName": "cntNumEntries",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "containerUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "cnt_uid_to_most_recent",
            "unique": false,
            "columnNames": [
              "containerContentEntryUid",
              "cntLastModified"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `cnt_uid_to_most_recent` ON `${TABLE_NAME}` (`containerContentEntryUid`, `cntLastModified`)"
          },
          {
            "name": "index_Container_cntLastModified",
            "unique": false,
            "columnNames": [
              "cntLastModified"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Container_cntLastModified` ON `${TABLE_NAME}` (`cntLastModified`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContainerEntry",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`ceUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `ceContainerUid` INTEGER NOT NULL, `cePath` TEXT, `ceCefUid` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "ceUid",
            "columnName": "ceUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceContainerUid",
            "columnName": "ceContainerUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cePath",
            "columnName": "cePath",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "ceCefUid",
            "columnName": "ceCefUid",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "ceUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContainerEntry_ceContainerUid",
            "unique": false,
            "columnNames": [
              "ceContainerUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContainerEntry_ceContainerUid` ON `${TABLE_NAME}` (`ceContainerUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContainerEntryFile",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cefUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cefMd5` TEXT, `cefPath` TEXT, `ceTotalSize` INTEGER NOT NULL, `ceCompressedSize` INTEGER NOT NULL, `compression` INTEGER NOT NULL, `lastModified` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "cefUid",
            "columnName": "cefUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cefMd5",
            "columnName": "cefMd5",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "cefPath",
            "columnName": "cefPath",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "ceTotalSize",
            "columnName": "ceTotalSize",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ceCompressedSize",
            "columnName": "ceCompressedSize",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "compression",
            "columnName": "compression",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "lastModified",
            "columnName": "lastModified",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "cefUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContainerEntryFile_cefMd5",
            "unique": false,
            "columnNames": [
              "cefMd5"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContainerEntryFile_cefMd5` ON `${TABLE_NAME}` (`cefMd5`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "VerbEntity",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`verbUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `urlId` TEXT, `verbMasterChangeSeqNum` INTEGER NOT NULL, `verbLocalChangeSeqNum` INTEGER NOT NULL, `verbLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "verbUid",
            "columnName": "verbUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "urlId",
            "columnName": "urlId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "verbMasterChangeSeqNum",
            "columnName": "verbMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "verbLocalChangeSeqNum",
            "columnName": "verbLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "verbLastChangedBy",
            "columnName": "verbLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "verbUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "XObjectEntity",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`xObjectUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `objectType` TEXT, `objectId` TEXT, `definitionType` TEXT, `interactionType` TEXT, `correctResponsePattern` TEXT, `objectContentEntryUid` INTEGER NOT NULL, `xObjectMasterChangeSeqNum` INTEGER NOT NULL, `xObjectocalChangeSeqNum` INTEGER NOT NULL, `xObjectLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "xObjectUid",
            "columnName": "xObjectUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "objectType",
            "columnName": "objectType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "objectId",
            "columnName": "objectId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "definitionType",
            "columnName": "definitionType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "interactionType",
            "columnName": "interactionType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "correctResponsePattern",
            "columnName": "correctResponsePattern",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "objectContentEntryUid",
            "columnName": "objectContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "xObjectMasterChangeSeqNum",
            "columnName": "xObjectMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "xObjectocalChangeSeqNum",
            "columnName": "xObjectocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "xObjectLastChangedBy",
            "columnName": "xObjectLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "xObjectUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "StatementEntity",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`statementUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `statementId` TEXT, `statementPersonUid` INTEGER NOT NULL, `statementVerbUid` INTEGER NOT NULL, `xObjectUid` INTEGER NOT NULL, `subStatementActorUid` INTEGER NOT NULL, `substatementVerbUid` INTEGER NOT NULL, `subStatementObjectUid` INTEGER NOT NULL, `agentUid` INTEGER NOT NULL, `instructorUid` INTEGER NOT NULL, `authorityUid` INTEGER NOT NULL, `teamUid` INTEGER NOT NULL, `resultCompletion` INTEGER NOT NULL, `resultSuccess` INTEGER NOT NULL, `resultScoreScaled` REAL NOT NULL, `resultScoreRaw` INTEGER NOT NULL, `resultScoreMin` INTEGER NOT NULL, `resultScoreMax` INTEGER NOT NULL, `resultDuration` INTEGER NOT NULL, `resultResponse` TEXT, `timestamp` INTEGER NOT NULL, `stored` INTEGER NOT NULL, `contextRegistration` TEXT, `contextPlatform` TEXT, `contextStatementId` TEXT, `fullStatement` TEXT, `statementMasterChangeSeqNum` INTEGER NOT NULL, `statementLocalChangeSeqNum` INTEGER NOT NULL, `statementLastChangedBy` INTEGER NOT NULL, `extensionProgress` INTEGER NOT NULL, `statementContentEntryUid` INTEGER NOT NULL, `statementLearnerGroupUid` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "statementUid",
            "columnName": "statementUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementId",
            "columnName": "statementId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "statementPersonUid",
            "columnName": "statementPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementVerbUid",
            "columnName": "statementVerbUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "xObjectUid",
            "columnName": "xObjectUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "subStatementActorUid",
            "columnName": "subStatementActorUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "substatementVerbUid",
            "columnName": "substatementVerbUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "subStatementObjectUid",
            "columnName": "subStatementObjectUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "agentUid",
            "columnName": "agentUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "instructorUid",
            "columnName": "instructorUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "authorityUid",
            "columnName": "authorityUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "teamUid",
            "columnName": "teamUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "resultCompletion",
            "columnName": "resultCompletion",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "resultSuccess",
            "columnName": "resultSuccess",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "resultScoreScaled",
            "columnName": "resultScoreScaled",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "resultScoreRaw",
            "columnName": "resultScoreRaw",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "resultScoreMin",
            "columnName": "resultScoreMin",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "resultScoreMax",
            "columnName": "resultScoreMax",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "resultDuration",
            "columnName": "resultDuration",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "resultResponse",
            "columnName": "resultResponse",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "timestamp",
            "columnName": "timestamp",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stored",
            "columnName": "stored",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contextRegistration",
            "columnName": "contextRegistration",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "contextPlatform",
            "columnName": "contextPlatform",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "contextStatementId",
            "columnName": "contextStatementId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "fullStatement",
            "columnName": "fullStatement",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "statementMasterChangeSeqNum",
            "columnName": "statementMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementLocalChangeSeqNum",
            "columnName": "statementLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementLastChangedBy",
            "columnName": "statementLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "extensionProgress",
            "columnName": "extensionProgress",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementContentEntryUid",
            "columnName": "statementContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementLearnerGroupUid",
            "columnName": "statementLearnerGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "statementUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContextXObjectStatementJoin",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`contextXObjectStatementJoinUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `contextActivityFlag` INTEGER NOT NULL, `contextStatementUid` INTEGER NOT NULL, `contextXObjectUid` INTEGER NOT NULL, `verbMasterChangeSeqNum` INTEGER NOT NULL, `verbLocalChangeSeqNum` INTEGER NOT NULL, `verbLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "contextXObjectStatementJoinUid",
            "columnName": "contextXObjectStatementJoinUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contextActivityFlag",
            "columnName": "contextActivityFlag",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contextStatementUid",
            "columnName": "contextStatementUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contextXObjectUid",
            "columnName": "contextXObjectUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "verbMasterChangeSeqNum",
            "columnName": "verbMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "verbLocalChangeSeqNum",
            "columnName": "verbLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "verbLastChangedBy",
            "columnName": "verbLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "contextXObjectStatementJoinUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "AgentEntity",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`agentUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `agentMbox` TEXT, `agentMbox_sha1sum` TEXT, `agentOpenid` TEXT, `agentAccountName` TEXT, `agentHomePage` TEXT, `agentPersonUid` INTEGER NOT NULL, `statementMasterChangeSeqNum` INTEGER NOT NULL, `statementLocalChangeSeqNum` INTEGER NOT NULL, `statementLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "agentUid",
            "columnName": "agentUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "agentMbox",
            "columnName": "agentMbox",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "agentMbox_sha1sum",
            "columnName": "agentMbox_sha1sum",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "agentOpenid",
            "columnName": "agentOpenid",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "agentAccountName",
            "columnName": "agentAccountName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "agentHomePage",
            "columnName": "agentHomePage",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "agentPersonUid",
            "columnName": "agentPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementMasterChangeSeqNum",
            "columnName": "statementMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementLocalChangeSeqNum",
            "columnName": "statementLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementLastChangedBy",
            "columnName": "statementLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "agentUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "StateEntity",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`stateUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `stateId` TEXT, `agentUid` INTEGER NOT NULL, `activityId` TEXT, `registration` TEXT, `isIsactive` INTEGER NOT NULL, `timestamp` INTEGER NOT NULL, `stateMasterChangeSeqNum` INTEGER NOT NULL, `stateLocalChangeSeqNum` INTEGER NOT NULL, `stateLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "stateUid",
            "columnName": "stateUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateId",
            "columnName": "stateId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "agentUid",
            "columnName": "agentUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "activityId",
            "columnName": "activityId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "registration",
            "columnName": "registration",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "isIsactive",
            "columnName": "isIsactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timestamp",
            "columnName": "timestamp",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateMasterChangeSeqNum",
            "columnName": "stateMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateLocalChangeSeqNum",
            "columnName": "stateLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateLastChangedBy",
            "columnName": "stateLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "stateUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "StateContentEntity",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`stateContentUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `stateContentStateUid` INTEGER NOT NULL, `stateContentKey` TEXT, `stateContentValue` TEXT, `isIsactive` INTEGER NOT NULL, `stateContentMasterChangeSeqNum` INTEGER NOT NULL, `stateContentLocalChangeSeqNum` INTEGER NOT NULL, `stateContentLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "stateContentUid",
            "columnName": "stateContentUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateContentStateUid",
            "columnName": "stateContentStateUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateContentKey",
            "columnName": "stateContentKey",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "stateContentValue",
            "columnName": "stateContentValue",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "isIsactive",
            "columnName": "isIsactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateContentMasterChangeSeqNum",
            "columnName": "stateContentMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateContentLocalChangeSeqNum",
            "columnName": "stateContentLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "stateContentLastChangedBy",
            "columnName": "stateContentLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "stateContentUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "XLangMapEntry",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`statementLangMapUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `verbLangMapUid` INTEGER NOT NULL, `objectLangMapUid` INTEGER NOT NULL, `languageLangMapUid` INTEGER NOT NULL, `languageVariantLangMapUid` INTEGER NOT NULL, `valueLangMap` TEXT NOT NULL, `statementLangMapMasterCsn` INTEGER NOT NULL, `statementLangMapLocalCsn` INTEGER NOT NULL, `statementLangMapLcb` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "statementLangMapUid",
            "columnName": "statementLangMapUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "verbLangMapUid",
            "columnName": "verbLangMapUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "objectLangMapUid",
            "columnName": "objectLangMapUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "languageLangMapUid",
            "columnName": "languageLangMapUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "languageVariantLangMapUid",
            "columnName": "languageVariantLangMapUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "valueLangMap",
            "columnName": "valueLangMap",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "statementLangMapMasterCsn",
            "columnName": "statementLangMapMasterCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementLangMapLocalCsn",
            "columnName": "statementLangMapLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "statementLangMapLcb",
            "columnName": "statementLangMapLcb",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "statementLangMapUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "SyncNode",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`nodeClientId` INTEGER NOT NULL, `master` INTEGER NOT NULL, PRIMARY KEY(`nodeClientId`))",
        "fields": [
          {
            "fieldPath": "nodeClientId",
            "columnName": "nodeClientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "master",
            "columnName": "master",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "nodeClientId"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "LocallyAvailableContainer",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`laContainerUid` INTEGER NOT NULL, PRIMARY KEY(`laContainerUid`))",
        "fields": [
          {
            "fieldPath": "laContainerUid",
            "columnName": "laContainerUid",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "laContainerUid"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContainerETag",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`ceContainerUid` INTEGER NOT NULL, `cetag` TEXT, PRIMARY KEY(`ceContainerUid`))",
        "fields": [
          {
            "fieldPath": "ceContainerUid",
            "columnName": "ceContainerUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cetag",
            "columnName": "cetag",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "ceContainerUid"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "SyncResult",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`srUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `tableId` INTEGER NOT NULL, `status` INTEGER NOT NULL, `localCsn` INTEGER NOT NULL, `remoteCsn` INTEGER NOT NULL, `syncType` INTEGER NOT NULL, `timestamp` INTEGER NOT NULL, `sent` INTEGER NOT NULL, `received` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "srUid",
            "columnName": "srUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "tableId",
            "columnName": "tableId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "status",
            "columnName": "status",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "localCsn",
            "columnName": "localCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "remoteCsn",
            "columnName": "remoteCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "syncType",
            "columnName": "syncType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "timestamp",
            "columnName": "timestamp",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sent",
            "columnName": "sent",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "received",
            "columnName": "received",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "srUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "School",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`schoolUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `schoolName` TEXT, `schoolDesc` TEXT, `schoolAddress` TEXT, `schoolActive` INTEGER NOT NULL, `schoolPhoneNumber` TEXT, `schoolGender` INTEGER NOT NULL, `schoolHolidayCalendarUid` INTEGER NOT NULL, `schoolFeatures` INTEGER NOT NULL, `schoolLocationLong` REAL NOT NULL, `schoolLocationLatt` REAL NOT NULL, `schoolEmailAddress` TEXT, `schoolTeachersPersonGroupUid` INTEGER NOT NULL, `schoolStudentsPersonGroupUid` INTEGER NOT NULL, `schoolPendingStudentsPersonGroupUid` INTEGER NOT NULL, `schoolCode` TEXT, `schoolMasterChangeSeqNum` INTEGER NOT NULL, `schoolLocalChangeSeqNum` INTEGER NOT NULL, `schoolLastChangedBy` INTEGER NOT NULL, `schoolTimeZone` TEXT)",
        "fields": [
          {
            "fieldPath": "schoolUid",
            "columnName": "schoolUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolName",
            "columnName": "schoolName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "schoolDesc",
            "columnName": "schoolDesc",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "schoolAddress",
            "columnName": "schoolAddress",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "schoolActive",
            "columnName": "schoolActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolPhoneNumber",
            "columnName": "schoolPhoneNumber",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "schoolGender",
            "columnName": "schoolGender",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolHolidayCalendarUid",
            "columnName": "schoolHolidayCalendarUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolFeatures",
            "columnName": "schoolFeatures",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolLocationLong",
            "columnName": "schoolLocationLong",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "schoolLocationLatt",
            "columnName": "schoolLocationLatt",
            "affinity": "REAL",
            "notNull": true
          },
          {
            "fieldPath": "schoolEmailAddress",
            "columnName": "schoolEmailAddress",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "schoolTeachersPersonGroupUid",
            "columnName": "schoolTeachersPersonGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolStudentsPersonGroupUid",
            "columnName": "schoolStudentsPersonGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolPendingStudentsPersonGroupUid",
            "columnName": "schoolPendingStudentsPersonGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolCode",
            "columnName": "schoolCode",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "schoolMasterChangeSeqNum",
            "columnName": "schoolMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolLocalChangeSeqNum",
            "columnName": "schoolLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolLastChangedBy",
            "columnName": "schoolLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolTimeZone",
            "columnName": "schoolTimeZone",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "schoolUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "SchoolMember",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`schoolMemberUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `schoolMemberPersonUid` INTEGER NOT NULL, `schoolMemberSchoolUid` INTEGER NOT NULL, `schoolMemberJoinDate` INTEGER NOT NULL, `schoolMemberLeftDate` INTEGER NOT NULL, `schoolMemberRole` INTEGER NOT NULL, `schoolMemberActive` INTEGER NOT NULL, `schoolMemberLocalChangeSeqNum` INTEGER NOT NULL, `schoolMemberMasterChangeSeqNum` INTEGER NOT NULL, `schoolMemberLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "schoolMemberUid",
            "columnName": "schoolMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberPersonUid",
            "columnName": "schoolMemberPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberSchoolUid",
            "columnName": "schoolMemberSchoolUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberJoinDate",
            "columnName": "schoolMemberJoinDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberLeftDate",
            "columnName": "schoolMemberLeftDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberRole",
            "columnName": "schoolMemberRole",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberActive",
            "columnName": "schoolMemberActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberLocalChangeSeqNum",
            "columnName": "schoolMemberLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberMasterChangeSeqNum",
            "columnName": "schoolMemberMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "schoolMemberLastChangedBy",
            "columnName": "schoolMemberLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "schoolMemberUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_SchoolMember_schoolMemberSchoolUid_schoolMemberActive_schoolMemberRole",
            "unique": false,
            "columnNames": [
              "schoolMemberSchoolUid",
              "schoolMemberActive",
              "schoolMemberRole"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_SchoolMember_schoolMemberSchoolUid_schoolMemberActive_schoolMemberRole` ON `${TABLE_NAME}` (`schoolMemberSchoolUid`, `schoolMemberActive`, `schoolMemberRole`)"
          },
          {
            "name": "index_SchoolMember_schoolMemberPersonUid",
            "unique": false,
            "columnNames": [
              "schoolMemberPersonUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_SchoolMember_schoolMemberPersonUid` ON `${TABLE_NAME}` (`schoolMemberPersonUid`)"
          },
          {
            "name": "index_SchoolMember_schoolMemberSchoolUid",
            "unique": false,
            "columnNames": [
              "schoolMemberSchoolUid"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_SchoolMember_schoolMemberSchoolUid` ON `${TABLE_NAME}` (`schoolMemberSchoolUid`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWork",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzWorkUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzWorkCreatorPersonUid` INTEGER NOT NULL, `clazzWorkClazzUid` INTEGER NOT NULL, `clazzWorkTitle` TEXT, `clazzWorkCreatedDate` INTEGER NOT NULL, `clazzWorkStartDateTime` INTEGER NOT NULL, `clazzWorkStartTime` INTEGER NOT NULL, `clazzWorkDueTime` INTEGER NOT NULL, `clazzWorkDueDateTime` INTEGER NOT NULL, `clazzWorkSubmissionType` INTEGER NOT NULL, `clazzWorkCommentsEnabled` INTEGER NOT NULL, `clazzWorkMaximumScore` INTEGER NOT NULL, `clazzWorkInstructions` TEXT, `clazzWorkActive` INTEGER NOT NULL, `clazzWorkLocalChangeSeqNum` INTEGER NOT NULL, `clazzWorkMasterChangeSeqNum` INTEGER NOT NULL, `clazzWorkLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzWorkUid",
            "columnName": "clazzWorkUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkCreatorPersonUid",
            "columnName": "clazzWorkCreatorPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkClazzUid",
            "columnName": "clazzWorkClazzUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkTitle",
            "columnName": "clazzWorkTitle",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzWorkCreatedDate",
            "columnName": "clazzWorkCreatedDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkStartDateTime",
            "columnName": "clazzWorkStartDateTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkStartTime",
            "columnName": "clazzWorkStartTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkDueTime",
            "columnName": "clazzWorkDueTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkDueDateTime",
            "columnName": "clazzWorkDueDateTime",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionType",
            "columnName": "clazzWorkSubmissionType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkCommentsEnabled",
            "columnName": "clazzWorkCommentsEnabled",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkMaximumScore",
            "columnName": "clazzWorkMaximumScore",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkInstructions",
            "columnName": "clazzWorkInstructions",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzWorkActive",
            "columnName": "clazzWorkActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkLocalChangeSeqNum",
            "columnName": "clazzWorkLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkMasterChangeSeqNum",
            "columnName": "clazzWorkMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkLastChangedBy",
            "columnName": "clazzWorkLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzWorkUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkContentJoin",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzWorkContentJoinUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzWorkContentJoinContentUid` INTEGER NOT NULL, `clazzWorkContentJoinClazzWorkUid` INTEGER NOT NULL, `clazzWorkContentJoinInactive` INTEGER NOT NULL, `clazzWorkContentJoinDateAdded` INTEGER NOT NULL, `clazzWorkContentJoinMCSN` INTEGER NOT NULL, `clazzWorkContentJoinLCSN` INTEGER NOT NULL, `clazzWorkContentJoinLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzWorkContentJoinUid",
            "columnName": "clazzWorkContentJoinUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkContentJoinContentUid",
            "columnName": "clazzWorkContentJoinContentUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkContentJoinClazzWorkUid",
            "columnName": "clazzWorkContentJoinClazzWorkUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkContentJoinInactive",
            "columnName": "clazzWorkContentJoinInactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkContentJoinDateAdded",
            "columnName": "clazzWorkContentJoinDateAdded",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkContentJoinMCSN",
            "columnName": "clazzWorkContentJoinMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkContentJoinLCSN",
            "columnName": "clazzWorkContentJoinLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkContentJoinLCB",
            "columnName": "clazzWorkContentJoinLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzWorkContentJoinUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Comments",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`commentsUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `commentsText` TEXT, `commentsEntityType` INTEGER NOT NULL, `commentsEntityUid` INTEGER NOT NULL, `commentsPublic` INTEGER NOT NULL, `commentsStatus` INTEGER NOT NULL, `commentsPersonUid` INTEGER NOT NULL, `commentsToPersonUid` INTEGER NOT NULL, `commentsFlagged` INTEGER NOT NULL, `commentsInActive` INTEGER NOT NULL, `commentsDateTimeAdded` INTEGER NOT NULL, `commentsDateTimeUpdated` INTEGER NOT NULL, `commentsMCSN` INTEGER NOT NULL, `commentsLCSN` INTEGER NOT NULL, `commentsLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "commentsUid",
            "columnName": "commentsUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsText",
            "columnName": "commentsText",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "commentsEntityType",
            "columnName": "commentsEntityType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsEntityUid",
            "columnName": "commentsEntityUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsPublic",
            "columnName": "commentsPublic",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsStatus",
            "columnName": "commentsStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsPersonUid",
            "columnName": "commentsPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsToPersonUid",
            "columnName": "commentsToPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsFlagged",
            "columnName": "commentsFlagged",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsInActive",
            "columnName": "commentsInActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsDateTimeAdded",
            "columnName": "commentsDateTimeAdded",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsDateTimeUpdated",
            "columnName": "commentsDateTimeUpdated",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsMCSN",
            "columnName": "commentsMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsLCSN",
            "columnName": "commentsLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "commentsLCB",
            "columnName": "commentsLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "commentsUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkQuestion",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzWorkQuestionUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzWorkQuestionText` TEXT, `clazzWorkQuestionClazzWorkUid` INTEGER NOT NULL, `clazzWorkQuestionIndex` INTEGER NOT NULL, `clazzWorkQuestionType` INTEGER NOT NULL, `clazzWorkQuestionActive` INTEGER NOT NULL, `clazzWorkQuestionMCSN` INTEGER NOT NULL, `clazzWorkQuestionLCSN` INTEGER NOT NULL, `clazzWorkQuestionLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzWorkQuestionUid",
            "columnName": "clazzWorkQuestionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionText",
            "columnName": "clazzWorkQuestionText",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzWorkQuestionClazzWorkUid",
            "columnName": "clazzWorkQuestionClazzWorkUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionIndex",
            "columnName": "clazzWorkQuestionIndex",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionType",
            "columnName": "clazzWorkQuestionType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionActive",
            "columnName": "clazzWorkQuestionActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionMCSN",
            "columnName": "clazzWorkQuestionMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionLCSN",
            "columnName": "clazzWorkQuestionLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionLCB",
            "columnName": "clazzWorkQuestionLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzWorkQuestionUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkQuestionOption",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzWorkQuestionOptionUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzWorkQuestionOptionText` TEXT, `clazzWorkQuestionOptionQuestionUid` INTEGER NOT NULL, `clazzWorkQuestionOptionMasterChangeSeqNum` INTEGER NOT NULL, `clazzWorkQuestionOptionLocalChangeSeqNum` INTEGER NOT NULL, `clazzWorkQuestionOptionLastChangedBy` INTEGER NOT NULL, `clazzWorkQuestionOptionActive` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzWorkQuestionOptionUid",
            "columnName": "clazzWorkQuestionOptionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionOptionText",
            "columnName": "clazzWorkQuestionOptionText",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzWorkQuestionOptionQuestionUid",
            "columnName": "clazzWorkQuestionOptionQuestionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionOptionMasterChangeSeqNum",
            "columnName": "clazzWorkQuestionOptionMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionOptionLocalChangeSeqNum",
            "columnName": "clazzWorkQuestionOptionLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionOptionLastChangedBy",
            "columnName": "clazzWorkQuestionOptionLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionOptionActive",
            "columnName": "clazzWorkQuestionOptionActive",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzWorkQuestionOptionUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkSubmission",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzWorkSubmissionUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzWorkSubmissionClazzWorkUid` INTEGER NOT NULL, `clazzWorkSubmissionClazzMemberUid` INTEGER NOT NULL, `clazzWorkSubmissionMarkerClazzMemberUid` INTEGER NOT NULL, `clazzWorkSubmissionMarkerPersonUid` INTEGER NOT NULL, `clazzWorkSubmissionPersonUid` INTEGER NOT NULL, `clazzWorkSubmissionInactive` INTEGER NOT NULL, `clazzWorkSubmissionDateTimeStarted` INTEGER NOT NULL, `clazzWorkSubmissionDateTimeUpdated` INTEGER NOT NULL, `clazzWorkSubmissionDateTimeFinished` INTEGER NOT NULL, `clazzWorkSubmissionDateTimeMarked` INTEGER NOT NULL, `clazzWorkSubmissionText` TEXT, `clazzWorkSubmissionScore` INTEGER NOT NULL, `clazzWorkSubmissionMCSN` INTEGER NOT NULL, `clazzWorkSubmissionLCSN` INTEGER NOT NULL, `clazzWorkSubmissionLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzWorkSubmissionUid",
            "columnName": "clazzWorkSubmissionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionClazzWorkUid",
            "columnName": "clazzWorkSubmissionClazzWorkUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionClazzMemberUid",
            "columnName": "clazzWorkSubmissionClazzMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionMarkerClazzMemberUid",
            "columnName": "clazzWorkSubmissionMarkerClazzMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionMarkerPersonUid",
            "columnName": "clazzWorkSubmissionMarkerPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionPersonUid",
            "columnName": "clazzWorkSubmissionPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionInactive",
            "columnName": "clazzWorkSubmissionInactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionDateTimeStarted",
            "columnName": "clazzWorkSubmissionDateTimeStarted",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionDateTimeUpdated",
            "columnName": "clazzWorkSubmissionDateTimeUpdated",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionDateTimeFinished",
            "columnName": "clazzWorkSubmissionDateTimeFinished",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionDateTimeMarked",
            "columnName": "clazzWorkSubmissionDateTimeMarked",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionText",
            "columnName": "clazzWorkSubmissionText",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzWorkSubmissionScore",
            "columnName": "clazzWorkSubmissionScore",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionMCSN",
            "columnName": "clazzWorkSubmissionMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionLCSN",
            "columnName": "clazzWorkSubmissionLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkSubmissionLCB",
            "columnName": "clazzWorkSubmissionLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzWorkSubmissionUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkQuestionResponse",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzWorkQuestionResponseUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzWorkQuestionResponseClazzWorkUid` INTEGER NOT NULL, `clazzWorkQuestionResponseQuestionUid` INTEGER NOT NULL, `clazzWorkQuestionResponseText` TEXT, `clazzWorkQuestionResponseOptionSelected` INTEGER NOT NULL, `clazzWorkQuestionResponsePersonUid` INTEGER NOT NULL, `clazzWorkQuestionResponseClazzMemberUid` INTEGER NOT NULL, `clazzWorkQuestionResponseInactive` INTEGER NOT NULL, `clazzWorkQuestionResponseDateResponded` INTEGER NOT NULL, `clazzWorkQuestionResponseMCSN` INTEGER NOT NULL, `clazzWorkQuestionResponseLCSN` INTEGER NOT NULL, `clazzWorkQuestionResponseLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "clazzWorkQuestionResponseUid",
            "columnName": "clazzWorkQuestionResponseUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseClazzWorkUid",
            "columnName": "clazzWorkQuestionResponseClazzWorkUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseQuestionUid",
            "columnName": "clazzWorkQuestionResponseQuestionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseText",
            "columnName": "clazzWorkQuestionResponseText",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "clazzWorkQuestionResponseOptionSelected",
            "columnName": "clazzWorkQuestionResponseOptionSelected",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponsePersonUid",
            "columnName": "clazzWorkQuestionResponsePersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseClazzMemberUid",
            "columnName": "clazzWorkQuestionResponseClazzMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseInactive",
            "columnName": "clazzWorkQuestionResponseInactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseDateResponded",
            "columnName": "clazzWorkQuestionResponseDateResponded",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseMCSN",
            "columnName": "clazzWorkQuestionResponseMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseLCSN",
            "columnName": "clazzWorkQuestionResponseLCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clazzWorkQuestionResponseLCB",
            "columnName": "clazzWorkQuestionResponseLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "clazzWorkQuestionResponseUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryProgress",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`contentEntryProgressUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `contentEntryProgressActive` INTEGER NOT NULL, `contentEntryProgressContentEntryUid` INTEGER NOT NULL, `contentEntryProgressPersonUid` INTEGER NOT NULL, `contentEntryProgressProgress` INTEGER NOT NULL, `contentEntryProgressStatusFlag` INTEGER NOT NULL, `contentEntryProgressLocalChangeSeqNum` INTEGER NOT NULL, `contentEntryProgressMasterChangeSeqNum` INTEGER NOT NULL, `contentEntryProgressLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "contentEntryProgressUid",
            "columnName": "contentEntryProgressUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressActive",
            "columnName": "contentEntryProgressActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressContentEntryUid",
            "columnName": "contentEntryProgressContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressPersonUid",
            "columnName": "contentEntryProgressPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressProgress",
            "columnName": "contentEntryProgressProgress",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressStatusFlag",
            "columnName": "contentEntryProgressStatusFlag",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressLocalChangeSeqNum",
            "columnName": "contentEntryProgressLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressMasterChangeSeqNum",
            "columnName": "contentEntryProgressMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "contentEntryProgressLastChangedBy",
            "columnName": "contentEntryProgressLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "contentEntryProgressUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Report",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`reportUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `reportOwnerUid` INTEGER NOT NULL, `chartType` INTEGER NOT NULL, `xAxis` INTEGER NOT NULL, `yAxis` INTEGER NOT NULL, `subGroup` INTEGER NOT NULL, `fromDate` INTEGER NOT NULL, `toDate` INTEGER NOT NULL, `reportTitle` TEXT, `reportInactive` INTEGER NOT NULL, `reportMasterChangeSeqNum` INTEGER NOT NULL, `reportLocalChangeSeqNum` INTEGER NOT NULL, `reportLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "reportUid",
            "columnName": "reportUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportOwnerUid",
            "columnName": "reportOwnerUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "chartType",
            "columnName": "chartType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "xAxis",
            "columnName": "xAxis",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "yAxis",
            "columnName": "yAxis",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "subGroup",
            "columnName": "subGroup",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "fromDate",
            "columnName": "fromDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "toDate",
            "columnName": "toDate",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportTitle",
            "columnName": "reportTitle",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "reportInactive",
            "columnName": "reportInactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportMasterChangeSeqNum",
            "columnName": "reportMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportLocalChangeSeqNum",
            "columnName": "reportLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportLastChangedBy",
            "columnName": "reportLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "reportUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ReportFilter",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`reportFilterUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `reportFilterReportUid` INTEGER NOT NULL, `entityUid` INTEGER NOT NULL, `entityType` INTEGER NOT NULL, `filterInactive` INTEGER NOT NULL, `reportFilterMasterChangeSeqNum` INTEGER NOT NULL, `reportFilterLocalChangeSeqNum` INTEGER NOT NULL, `reportFilterLastChangedBy` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "reportFilterUid",
            "columnName": "reportFilterUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportFilterReportUid",
            "columnName": "reportFilterReportUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "entityUid",
            "columnName": "entityUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "entityType",
            "columnName": "entityType",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "filterInactive",
            "columnName": "filterInactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportFilterMasterChangeSeqNum",
            "columnName": "reportFilterMasterChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportFilterLocalChangeSeqNum",
            "columnName": "reportFilterLocalChangeSeqNum",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reportFilterLastChangedBy",
            "columnName": "reportFilterLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "reportFilterUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "DeviceSession",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`deviceSessionUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `dsDeviceId` INTEGER NOT NULL, `dsPersonUid` INTEGER NOT NULL, `expires` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "deviceSessionUid",
            "columnName": "deviceSessionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dsDeviceId",
            "columnName": "dsDeviceId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dsPersonUid",
            "columnName": "dsPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "expires",
            "columnName": "expires",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "deviceSessionUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "Site",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`siteUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `sitePcsn` INTEGER NOT NULL, `siteLcsn` INTEGER NOT NULL, `siteLcb` INTEGER NOT NULL, `siteName` TEXT, `guestLogin` INTEGER NOT NULL, `registrationAllowed` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "siteUid",
            "columnName": "siteUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sitePcsn",
            "columnName": "sitePcsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "siteLcsn",
            "columnName": "siteLcsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "siteLcb",
            "columnName": "siteLcb",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "siteName",
            "columnName": "siteName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "guestLogin",
            "columnName": "guestLogin",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "registrationAllowed",
            "columnName": "registrationAllowed",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "siteUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ContainerImportJob",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cijUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cijContainerUid` INTEGER NOT NULL, `cijFilePath` TEXT, `cijContainerBaseDir` TEXT, `cijContentEntryUid` INTEGER NOT NULL, `cijMimeType` TEXT, `cijSessionId` TEXT, `cijJobStatus` INTEGER NOT NULL, `cijBytesSoFar` INTEGER NOT NULL, `cijImportCompleted` INTEGER NOT NULL, `cijContentLength` INTEGER NOT NULL, `cijContainerEntryFileUids` TEXT, `cijConversionParams` TEXT)",
        "fields": [
          {
            "fieldPath": "cijUid",
            "columnName": "cijUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cijContainerUid",
            "columnName": "cijContainerUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cijFilePath",
            "columnName": "cijFilePath",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "cijContainerBaseDir",
            "columnName": "cijContainerBaseDir",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "cijContentEntryUid",
            "columnName": "cijContentEntryUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cijMimeType",
            "columnName": "cijMimeType",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "cijSessionId",
            "columnName": "cijSessionId",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "cijJobStatus",
            "columnName": "cijJobStatus",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cijBytesSoFar",
            "columnName": "cijBytesSoFar",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cijImportCompleted",
            "columnName": "cijImportCompleted",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cijContentLength",
            "columnName": "cijContentLength",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "cijContainerEntryFileUids",
            "columnName": "cijContainerEntryFileUids",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "cijConversionParams",
            "columnName": "cijConversionParams",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "cijUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "LearnerGroup",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`learnerGroupUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `learnerGroupName` TEXT, `learnerGroupDescription` TEXT, `learnerGroupActive` INTEGER NOT NULL, `learnerGroupMCSN` INTEGER NOT NULL, `learnerGroupCSN` INTEGER NOT NULL, `learnerGroupLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "learnerGroupUid",
            "columnName": "learnerGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupName",
            "columnName": "learnerGroupName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "learnerGroupDescription",
            "columnName": "learnerGroupDescription",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "learnerGroupActive",
            "columnName": "learnerGroupActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMCSN",
            "columnName": "learnerGroupMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupCSN",
            "columnName": "learnerGroupCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupLCB",
            "columnName": "learnerGroupLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "learnerGroupUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "LearnerGroupMember",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`learnerGroupMemberUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `learnerGroupMemberPersonUid` INTEGER NOT NULL, `learnerGroupMemberLgUid` INTEGER NOT NULL, `learnerGroupMemberRole` INTEGER NOT NULL, `learnerGroupMemberActive` INTEGER NOT NULL, `learnerGroupMemberMCSN` INTEGER NOT NULL, `learnerGroupMemberCSN` INTEGER NOT NULL, `learnerGroupMemberLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "learnerGroupMemberUid",
            "columnName": "learnerGroupMemberUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMemberPersonUid",
            "columnName": "learnerGroupMemberPersonUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMemberLgUid",
            "columnName": "learnerGroupMemberLgUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMemberRole",
            "columnName": "learnerGroupMemberRole",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMemberActive",
            "columnName": "learnerGroupMemberActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMemberMCSN",
            "columnName": "learnerGroupMemberMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMemberCSN",
            "columnName": "learnerGroupMemberCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "learnerGroupMemberLCB",
            "columnName": "learnerGroupMemberLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "learnerGroupMemberUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "GroupLearningSession",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`groupLearningSessionUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `groupLearningSessionContentUid` INTEGER NOT NULL, `groupLearningSessionLearnerGroupUid` INTEGER NOT NULL, `groupLearningSessionInactive` INTEGER NOT NULL, `groupLearningSessionMCSN` INTEGER NOT NULL, `groupLearningSessionCSN` INTEGER NOT NULL, `groupLearningSessionLCB` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "groupLearningSessionUid",
            "columnName": "groupLearningSessionUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLearningSessionContentUid",
            "columnName": "groupLearningSessionContentUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLearningSessionLearnerGroupUid",
            "columnName": "groupLearningSessionLearnerGroupUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLearningSessionInactive",
            "columnName": "groupLearningSessionInactive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLearningSessionMCSN",
            "columnName": "groupLearningSessionMCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLearningSessionCSN",
            "columnName": "groupLearningSessionCSN",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "groupLearningSessionLCB",
            "columnName": "groupLearningSessionLCB",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "groupLearningSessionUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "SiteTerms",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`sTermsUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `termsHtml` TEXT, `sTermsLang` TEXT, `sTermsLangUid` INTEGER NOT NULL, `sTermsActive` INTEGER NOT NULL, `sTermsLastChangedBy` INTEGER NOT NULL, `sTermsPrimaryCsn` INTEGER NOT NULL, `sTermsLocalCsn` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "sTermsUid",
            "columnName": "sTermsUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "termsHtml",
            "columnName": "termsHtml",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "sTermsLang",
            "columnName": "sTermsLang",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "sTermsLangUid",
            "columnName": "sTermsLangUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sTermsActive",
            "columnName": "sTermsActive",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sTermsLastChangedBy",
            "columnName": "sTermsLastChangedBy",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sTermsPrimaryCsn",
            "columnName": "sTermsPrimaryCsn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sTermsLocalCsn",
            "columnName": "sTermsLocalCsn",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "sTermsUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "SqliteChangeSeqNums",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`sCsnTableId` INTEGER NOT NULL, `sCsnNextLocal` INTEGER NOT NULL, `sCsnNextPrimary` INTEGER NOT NULL, PRIMARY KEY(`sCsnTableId`))",
        "fields": [
          {
            "fieldPath": "sCsnTableId",
            "columnName": "sCsnTableId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sCsnNextLocal",
            "columnName": "sCsnNextLocal",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "sCsnNextPrimary",
            "columnName": "sCsnNextPrimary",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "sCsnTableId"
          ],
          "autoGenerate": false
        },
        "indices": [
          {
            "name": "index_SqliteChangeSeqNums_sCsnNextLocal",
            "unique": false,
            "columnNames": [
              "sCsnNextLocal"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_SqliteChangeSeqNums_sCsnNextLocal` ON `${TABLE_NAME}` (`sCsnNextLocal`)"
          },
          {
            "name": "index_SqliteChangeSeqNums_sCsnNextPrimary",
            "unique": false,
            "columnNames": [
              "sCsnNextPrimary"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_SqliteChangeSeqNums_sCsnNextPrimary` ON `${TABLE_NAME}` (`sCsnNextPrimary`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "UpdateNotification",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pnUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `pnDeviceId` INTEGER NOT NULL, `pnTableId` INTEGER NOT NULL, `pnTimestamp` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pnUid",
            "columnName": "pnUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "pnDeviceId",
            "columnName": "pnDeviceId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "pnTableId",
            "columnName": "pnTableId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "pnTimestamp",
            "columnName": "pnTimestamp",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pnUid"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_UpdateNotification_pnDeviceId_pnTableId",
            "unique": true,
            "columnNames": [
              "pnDeviceId",
              "pnTableId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_UpdateNotification_pnDeviceId_pnTableId` ON `${TABLE_NAME}` (`pnDeviceId`, `pnTableId`)"
          },
          {
            "name": "index_UpdateNotification_pnDeviceId_pnTimestamp",
            "unique": false,
            "columnNames": [
              "pnDeviceId",
              "pnTimestamp"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_UpdateNotification_pnDeviceId_pnTimestamp` ON `${TABLE_NAME}` (`pnDeviceId`, `pnTimestamp`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "TableSyncStatus",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`tsTableId` INTEGER NOT NULL, `tsLastChanged` INTEGER NOT NULL, `tsLastSynced` INTEGER NOT NULL, PRIMARY KEY(`tsTableId`))",
        "fields": [
          {
            "fieldPath": "tsTableId",
            "columnName": "tsTableId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "tsLastChanged",
            "columnName": "tsLastChanged",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "tsLastSynced",
            "columnName": "tsLastSynced",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "tsTableId"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ChangeLog",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`changeLogUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `chTableId` INTEGER NOT NULL, `chEntityPk` INTEGER NOT NULL, `dispatched` INTEGER NOT NULL, `chTime` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "changeLogUid",
            "columnName": "changeLogUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "chTableId",
            "columnName": "chTableId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "chEntityPk",
            "columnName": "chEntityPk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "dispatched",
            "columnName": "dispatched",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "chTime",
            "columnName": "chTime",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "changeLogUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ZombieAttachmentData",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`zaUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `zaTableName` TEXT, `zaPrimaryKey` INTEGER NOT NULL, `zaUri` TEXT)",
        "fields": [
          {
            "fieldPath": "zaUid",
            "columnName": "zaUid",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "zaTableName",
            "columnName": "zaTableName",
            "affinity": "TEXT",
            "notNull": false
          },
          {
            "fieldPath": "zaPrimaryKey",
            "columnName": "zaPrimaryKey",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "zaUri",
            "columnName": "zaUri",
            "affinity": "TEXT",
            "notNull": false
          }
        ],
        "primaryKey": {
          "columnNames": [
            "zaUid"
          ],
          "autoGenerate": true
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzLog_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzLog_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzLog_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzLog_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzLog_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzLogAttendanceRecord_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzLogAttendanceRecord_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzLogAttendanceRecord_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzLogAttendanceRecord_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzLogAttendanceRecord_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Schedule_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Schedule_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Schedule_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Schedule_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Schedule_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "DateRange_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_DateRange_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_DateRange_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_DateRange_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_DateRange_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "HolidayCalendar_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_HolidayCalendar_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_HolidayCalendar_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_HolidayCalendar_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_HolidayCalendar_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Holiday_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Holiday_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Holiday_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Holiday_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Holiday_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ScheduledCheck_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ScheduledCheck_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ScheduledCheck_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ScheduledCheck_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ScheduledCheck_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "AuditLog_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_AuditLog_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_AuditLog_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_AuditLog_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_AuditLog_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "CustomField_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_CustomField_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_CustomField_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_CustomField_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_CustomField_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "CustomFieldValue_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_CustomFieldValue_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_CustomFieldValue_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_CustomFieldValue_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_CustomFieldValue_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "CustomFieldValueOption_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_CustomFieldValueOption_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_CustomFieldValueOption_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_CustomFieldValueOption_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_CustomFieldValueOption_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Person_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Person_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Person_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Person_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Person_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Clazz_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Clazz_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Clazz_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Clazz_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Clazz_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzMember_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzMember_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzMember_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzMember_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzMember_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "PersonCustomFieldValue_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_PersonCustomFieldValue_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_PersonCustomFieldValue_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_PersonCustomFieldValue_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_PersonCustomFieldValue_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntry_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentEntry_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntry_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContentEntry_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContentEntry_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryContentCategoryJoin_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentEntryContentCategoryJoin_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryContentCategoryJoin_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContentEntryContentCategoryJoin_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContentEntryContentCategoryJoin_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryParentChildJoin_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentEntryParentChildJoin_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryParentChildJoin_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContentEntryParentChildJoin_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContentEntryParentChildJoin_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryRelatedEntryJoin_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentEntryRelatedEntryJoin_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryRelatedEntryJoin_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContentEntryRelatedEntryJoin_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContentEntryRelatedEntryJoin_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentCategorySchema_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentCategorySchema_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentCategorySchema_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContentCategorySchema_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContentCategorySchema_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentCategory_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentCategory_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentCategory_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContentCategory_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContentCategory_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Language_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Language_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Language_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Language_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Language_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "LanguageVariant_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_LanguageVariant_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_LanguageVariant_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_LanguageVariant_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_LanguageVariant_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Role_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Role_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Role_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Role_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Role_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "EntityRole_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_EntityRole_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_EntityRole_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_EntityRole_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_EntityRole_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "PersonGroup_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_PersonGroup_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_PersonGroup_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_PersonGroup_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_PersonGroup_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "PersonGroupMember_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_PersonGroupMember_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_PersonGroupMember_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_PersonGroupMember_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_PersonGroupMember_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "PersonPicture_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_PersonPicture_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_PersonPicture_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_PersonPicture_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_PersonPicture_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Container_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Container_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Container_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Container_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Container_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "VerbEntity_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_VerbEntity_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_VerbEntity_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_VerbEntity_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_VerbEntity_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "XObjectEntity_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_XObjectEntity_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_XObjectEntity_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_XObjectEntity_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_XObjectEntity_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "StatementEntity_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_StatementEntity_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_StatementEntity_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_StatementEntity_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_StatementEntity_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContextXObjectStatementJoin_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContextXObjectStatementJoin_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContextXObjectStatementJoin_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContextXObjectStatementJoin_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContextXObjectStatementJoin_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "AgentEntity_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_AgentEntity_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_AgentEntity_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_AgentEntity_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_AgentEntity_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "StateEntity_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_StateEntity_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_StateEntity_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_StateEntity_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_StateEntity_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "StateContentEntity_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_StateContentEntity_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_StateContentEntity_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_StateContentEntity_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_StateContentEntity_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "XLangMapEntry_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_XLangMapEntry_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_XLangMapEntry_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_XLangMapEntry_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_XLangMapEntry_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "School_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_School_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_School_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_School_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_School_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "SchoolMember_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_SchoolMember_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_SchoolMember_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_SchoolMember_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_SchoolMember_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWork_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzWork_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzWork_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzWork_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzWork_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkContentJoin_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzWorkContentJoin_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzWorkContentJoin_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzWorkContentJoin_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzWorkContentJoin_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Comments_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Comments_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Comments_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Comments_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Comments_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkQuestion_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzWorkQuestion_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzWorkQuestion_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzWorkQuestion_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzWorkQuestion_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkQuestionOption_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzWorkQuestionOption_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzWorkQuestionOption_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzWorkQuestionOption_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzWorkQuestionOption_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkSubmission_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzWorkSubmission_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzWorkSubmission_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzWorkSubmission_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzWorkSubmission_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ClazzWorkQuestionResponse_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ClazzWorkQuestionResponse_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzWorkQuestionResponse_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ClazzWorkQuestionResponse_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ClazzWorkQuestionResponse_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ContentEntryProgress_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ContentEntryProgress_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryProgress_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ContentEntryProgress_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ContentEntryProgress_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Report_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Report_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Report_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Report_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Report_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "ReportFilter_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_ReportFilter_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_ReportFilter_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_ReportFilter_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_ReportFilter_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "Site_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_Site_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_Site_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_Site_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Site_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "LearnerGroup_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_LearnerGroup_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_LearnerGroup_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_LearnerGroup_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_LearnerGroup_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "LearnerGroupMember_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_LearnerGroupMember_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_LearnerGroupMember_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_LearnerGroupMember_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_LearnerGroupMember_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "GroupLearningSession_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_GroupLearningSession_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_GroupLearningSession_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_GroupLearningSession_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_GroupLearningSession_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      },
      {
        "tableName": "SiteTerms_trk",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pk` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `epk` INTEGER NOT NULL, `clientId` INTEGER NOT NULL, `csn` INTEGER NOT NULL, `rx` INTEGER NOT NULL, `reqId` INTEGER NOT NULL, `ts` INTEGER NOT NULL)",
        "fields": [
          {
            "fieldPath": "pk",
            "columnName": "pk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "epk",
            "columnName": "epk",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "clientId",
            "columnName": "clientId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "csn",
            "columnName": "csn",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "rx",
            "columnName": "rx",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "reqId",
            "columnName": "reqId",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "ts",
            "columnName": "ts",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "pk"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_SiteTerms_trk_clientId_epk_csn",
            "unique": false,
            "columnNames": [
              "clientId",
              "epk",
              "csn"
            ],
            "createSql": "CREATE INDEX IF NOT EXISTS `index_SiteTerms_trk_clientId_epk_csn` ON `${TABLE_NAME}` (`clientId`, `epk`, `csn`)"
          },
          {
            "name": "index_SiteTerms_trk_epk_clientId",
            "unique": true,
            "columnNames": [
              "epk",
              "clientId"
            ],
            "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_SiteTerms_trk_epk_clientId` ON `${TABLE_NAME}` (`epk`, `clientId`)"
          }
        ],
        "foreignKeys": []
      }
    ],
    "views": [],
    "setupQueries": [
      "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
      "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, 'b3134b3203de2a0433a17d6ffc4f5aee')"
    ]
  }
}