{ "formatVersion": 1, "database": { "version": 162, "identityHash": "abd4ed3f5c06497ed4cc81b8010abf18", "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": { "autoGenerate": true, "columnNames": [ "nodeId" ] }, "indices": [ { "name": "index_NetworkNode_bluetoothMacAddress", "unique": false, "columnNames": [ "bluetoothMacAddress" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_NetworkNode_bluetoothMacAddress` ON `${TABLE_NAME}` (`bluetoothMacAddress`)" }, { "name": "index_NetworkNode_lastUpdateTimeStamp", "unique": false, "columnNames": [ "lastUpdateTimeStamp" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_NetworkNode_lastUpdateTimeStamp` ON `${TABLE_NAME}` (`lastUpdateTimeStamp`)" } ], "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, `clazzLogLastChangedTime` 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 }, { "fieldPath": "clazzLogLastChangedTime", "columnName": "clazzLogLastChangedTime", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "clazzLogUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ClazzLogAttendanceRecord", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzLogAttendanceRecordUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzLogAttendanceRecordClazzLogUid` INTEGER NOT NULL, `clazzLogAttendanceRecordPersonUid` INTEGER NOT NULL, `attendanceStatus` INTEGER NOT NULL, `clazzLogAttendanceRecordMasterChangeSeqNum` INTEGER NOT NULL, `clazzLogAttendanceRecordLocalChangeSeqNum` INTEGER NOT NULL, `clazzLogAttendanceRecordLastChangedBy` INTEGER NOT NULL, `clazzLogAttendanceRecordLastChangedTime` INTEGER NOT NULL)", "fields": [ { "fieldPath": "clazzLogAttendanceRecordUid", "columnName": "clazzLogAttendanceRecordUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzLogAttendanceRecordClazzLogUid", "columnName": "clazzLogAttendanceRecordClazzLogUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzLogAttendanceRecordPersonUid", "columnName": "clazzLogAttendanceRecordPersonUid", "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 }, { "fieldPath": "clazzLogAttendanceRecordLastChangedTime", "columnName": "clazzLogAttendanceRecordLastChangedTime", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "clazzLogAttendanceRecordUid" ] }, "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, `scheduleLastChangedTime` 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": "scheduleLastChangedTime", "columnName": "scheduleLastChangedTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "scheduleActive", "columnName": "scheduleActive", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "scheduleUid" ] }, "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, `umCalendarLct` 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 }, { "fieldPath": "umCalendarLct", "columnName": "umCalendarLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "umCalendarUid" ] }, "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, `holLct` 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": "holLct", "columnName": "holLct", "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": { "autoGenerate": true, "columnNames": [ "holUid" ] }, "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, `personLct` INTEGER NOT NULL, `personCountry` TEXT, `personType` INTEGER NOT NULL DEFAULT 0)", "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 }, { "fieldPath": "personLct", "columnName": "personLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "personCountry", "columnName": "personCountry", "affinity": "TEXT", "notNull": false }, { "fieldPath": "personType", "columnName": "personType", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "personUid" ] }, "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, `clazzEnrolmentPolicy` INTEGER NOT NULL DEFAULT 102, `clazzTerminologyUid` INTEGER NOT NULL DEFAULT 25966, `clazzMasterChangeSeqNum` INTEGER NOT NULL, `clazzLocalChangeSeqNum` INTEGER NOT NULL, `clazzLastChangedBy` INTEGER NOT NULL, `clazzLct` INTEGER NOT NULL, `clazzTimeZone` TEXT, `clazzStudentsPersonGroupUid` INTEGER NOT NULL, `clazzTeachersPersonGroupUid` INTEGER NOT NULL, `clazzPendingStudentsPersonGroupUid` INTEGER NOT NULL, `clazzParentsPersonGroupUid` INTEGER NOT NULL, `clazzCode` TEXT, `clazzOwnerPersonUid` INTEGER NOT NULL DEFAULT 0)", "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": "clazzEnrolmentPolicy", "columnName": "clazzEnrolmentPolicy", "affinity": "INTEGER", "notNull": true, "defaultValue": "102" }, { "fieldPath": "clazzTerminologyUid", "columnName": "clazzTerminologyUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "25966" }, { "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": "clazzLct", "columnName": "clazzLct", "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": "clazzParentsPersonGroupUid", "columnName": "clazzParentsPersonGroupUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzCode", "columnName": "clazzCode", "affinity": "TEXT", "notNull": false }, { "fieldPath": "clazzOwnerPersonUid", "columnName": "clazzOwnerPersonUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "clazzUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ClazzEnrolment", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`clazzEnrolmentUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `clazzEnrolmentPersonUid` INTEGER NOT NULL, `clazzEnrolmentClazzUid` INTEGER NOT NULL, `clazzEnrolmentDateJoined` INTEGER NOT NULL, `clazzEnrolmentDateLeft` INTEGER NOT NULL, `clazzEnrolmentRole` INTEGER NOT NULL, `clazzEnrolmentAttendancePercentage` REAL NOT NULL, `clazzEnrolmentActive` INTEGER NOT NULL, `clazzEnrolmentLeavingReasonUid` INTEGER NOT NULL, `clazzEnrolmentOutcome` INTEGER NOT NULL, `clazzEnrolmentLocalChangeSeqNum` INTEGER NOT NULL, `clazzEnrolmentMasterChangeSeqNum` INTEGER NOT NULL, `clazzEnrolmentLastChangedBy` INTEGER NOT NULL, `clazzEnrolmentLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "clazzEnrolmentUid", "columnName": "clazzEnrolmentUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentPersonUid", "columnName": "clazzEnrolmentPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentClazzUid", "columnName": "clazzEnrolmentClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentDateJoined", "columnName": "clazzEnrolmentDateJoined", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentDateLeft", "columnName": "clazzEnrolmentDateLeft", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentRole", "columnName": "clazzEnrolmentRole", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentAttendancePercentage", "columnName": "clazzEnrolmentAttendancePercentage", "affinity": "REAL", "notNull": true }, { "fieldPath": "clazzEnrolmentActive", "columnName": "clazzEnrolmentActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentLeavingReasonUid", "columnName": "clazzEnrolmentLeavingReasonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentOutcome", "columnName": "clazzEnrolmentOutcome", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentLocalChangeSeqNum", "columnName": "clazzEnrolmentLocalChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentMasterChangeSeqNum", "columnName": "clazzEnrolmentMasterChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentLastChangedBy", "columnName": "clazzEnrolmentLastChangedBy", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "clazzEnrolmentLct", "columnName": "clazzEnrolmentLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "clazzEnrolmentUid" ] }, "indices": [ { "name": "index_ClazzEnrolment_clazzEnrolmentPersonUid_clazzEnrolmentClazzUid", "unique": false, "columnNames": [ "clazzEnrolmentPersonUid", "clazzEnrolmentClazzUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzEnrolment_clazzEnrolmentPersonUid_clazzEnrolmentClazzUid` ON `${TABLE_NAME}` (`clazzEnrolmentPersonUid`, `clazzEnrolmentClazzUid`)" }, { "name": "index_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentPersonUid", "unique": false, "columnNames": [ "clazzEnrolmentClazzUid", "clazzEnrolmentPersonUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentPersonUid` ON `${TABLE_NAME}` (`clazzEnrolmentClazzUid`, `clazzEnrolmentPersonUid`)" }, { "name": "index_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentRole", "unique": false, "columnNames": [ "clazzEnrolmentClazzUid", "clazzEnrolmentRole" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzEnrolment_clazzEnrolmentClazzUid_clazzEnrolmentRole` ON `${TABLE_NAME}` (`clazzEnrolmentClazzUid`, `clazzEnrolmentRole`)" }, { "name": "index_ClazzEnrolment_clazzEnrolmentPersonUid", "unique": false, "columnNames": [ "clazzEnrolmentPersonUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzEnrolment_clazzEnrolmentPersonUid` ON `${TABLE_NAME}` (`clazzEnrolmentPersonUid`)" }, { "name": "index_ClazzEnrolment_clazzEnrolmentClazzUid", "unique": false, "columnNames": [ "clazzEnrolmentClazzUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzEnrolment_clazzEnrolmentClazzUid` ON `${TABLE_NAME}` (`clazzEnrolmentClazzUid`)" } ], "foreignKeys": [] }, { "tableName": "LeavingReason", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`leavingReasonUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `leavingReasonTitle` TEXT, `leavingReasonMCSN` INTEGER NOT NULL, `leavingReasonCSN` INTEGER NOT NULL, `leavingReasonLCB` INTEGER NOT NULL, `leavingReasonLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "leavingReasonUid", "columnName": "leavingReasonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "leavingReasonTitle", "columnName": "leavingReasonTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "leavingReasonMCSN", "columnName": "leavingReasonMCSN", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "leavingReasonCSN", "columnName": "leavingReasonCSN", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "leavingReasonLCB", "columnName": "leavingReasonLCB", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "leavingReasonLct", "columnName": "leavingReasonLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "leavingReasonUid" ] }, "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, `completionCriteria` INTEGER NOT NULL, `minScore` INTEGER NOT NULL, `contentTypeFlag` INTEGER NOT NULL, `contentOwner` INTEGER NOT NULL, `contentEntryLocalChangeSeqNum` INTEGER NOT NULL, `contentEntryMasterChangeSeqNum` INTEGER NOT NULL, `contentEntryLastChangedBy` INTEGER NOT NULL, `contentEntryLct` 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": "completionCriteria", "columnName": "completionCriteria", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "minScore", "columnName": "minScore", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "contentTypeFlag", "columnName": "contentTypeFlag", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "contentOwner", "columnName": "contentOwner", "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 }, { "fieldPath": "contentEntryLct", "columnName": "contentEntryLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "contentEntryUid" ] }, "indices": [ { "name": "index_ContentEntry_primaryLanguageUid", "unique": false, "columnNames": [ "primaryLanguageUid" ], "orders": [], "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, `ceccjLct` 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 }, { "fieldPath": "ceccjLct", "columnName": "ceccjLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "ceccjUid" ] }, "indices": [ { "name": "index_ContentEntryContentCategoryJoin_ceccjContentEntryUid", "unique": false, "columnNames": [ "ceccjContentEntryUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryContentCategoryJoin_ceccjContentEntryUid` ON `${TABLE_NAME}` (`ceccjContentEntryUid`)" } ], "foreignKeys": [] }, { "tableName": "ContentEntryParentChildJoin", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cepcjParentContentEntryUid` INTEGER NOT NULL, `cepcjChildContentEntryUid` INTEGER NOT NULL, `childIndex` INTEGER NOT NULL, `cepcjUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cepcjLocalChangeSeqNum` INTEGER NOT NULL, `cepcjMasterChangeSeqNum` INTEGER NOT NULL, `cepcjLastChangedBy` INTEGER NOT NULL, `cepcjLct` INTEGER NOT NULL, `cepcjDeleted` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "cepcjParentContentEntryUid", "columnName": "cepcjParentContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cepcjChildContentEntryUid", "columnName": "cepcjChildContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "childIndex", "columnName": "childIndex", "affinity": "INTEGER", "notNull": true }, { "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": "cepcjLct", "columnName": "cepcjLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cepcjDeleted", "columnName": "cepcjDeleted", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cepcjUid" ] }, "indices": [ { "name": "parent_child", "unique": false, "columnNames": [ "cepcjChildContentEntryUid", "cepcjParentContentEntryUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `parent_child` ON `${TABLE_NAME}` (`cepcjChildContentEntryUid`, `cepcjParentContentEntryUid`)" }, { "name": "index_ContentEntryParentChildJoin_cepcjParentContentEntryUid", "unique": false, "columnNames": [ "cepcjParentContentEntryUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryParentChildJoin_cepcjParentContentEntryUid` ON `${TABLE_NAME}` (`cepcjParentContentEntryUid`)" }, { "name": "index_ContentEntryParentChildJoin_cepcjChildContentEntryUid", "unique": false, "columnNames": [ "cepcjChildContentEntryUid" ], "orders": [], "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, `cerejLct` 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 }, { "fieldPath": "cerejLct", "columnName": "cerejLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cerejUid" ] }, "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, `contentCategorySchemaLct` 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 }, { "fieldPath": "contentCategorySchemaLct", "columnName": "contentCategorySchemaLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "contentCategorySchemaUid" ] }, "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, `contentCategoryLct` 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 }, { "fieldPath": "contentCategoryLct", "columnName": "contentCategoryLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "contentCategoryUid" ] }, "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, `languageActive` INTEGER NOT NULL, `langLocalChangeSeqNum` INTEGER NOT NULL, `langMasterChangeSeqNum` INTEGER NOT NULL, `langLastChangedBy` INTEGER NOT NULL, `langLct` 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": "languageActive", "columnName": "languageActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "langLocalChangeSeqNum", "columnName": "langLocalChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "langMasterChangeSeqNum", "columnName": "langMasterChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "langLastChangedBy", "columnName": "langLastChangedBy", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "langLct", "columnName": "langLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "langUid" ] }, "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, `langVariantLct` 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 }, { "fieldPath": "langVariantLct", "columnName": "langVariantLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "langVariantUid" ] }, "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": { "autoGenerate": false, "columnNames": [ "token" ] }, "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": { "autoGenerate": true, "columnNames": [ "personAuthUid" ] }, "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, `roleLct` 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": "roleLct", "columnName": "roleLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "rolePermissions", "columnName": "rolePermissions", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "roleUid" ] }, "indices": [ { "name": "index_Role_rolePermissions", "unique": false, "columnNames": [ "rolePermissions" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_Role_rolePermissions` ON `${TABLE_NAME}` (`rolePermissions`)" } ], "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, `groupLct` 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": "groupLct", "columnName": "groupLct", "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": { "autoGenerate": true, "columnNames": [ "groupUid" ] }, "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, `groupMemberLct` 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 }, { "fieldPath": "groupMemberLct", "columnName": "groupMemberLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "groupMemberUid" ] }, "indices": [ { "name": "index_PersonGroupMember_groupMemberPersonUid", "unique": false, "columnNames": [ "groupMemberPersonUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_PersonGroupMember_groupMemberPersonUid` ON `${TABLE_NAME}` (`groupMemberPersonUid`)" }, { "name": "index_PersonGroupMember_groupMemberGroupUid", "unique": false, "columnNames": [ "groupMemberGroupUid" ], "orders": [], "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, `personPictureLct` INTEGER NOT NULL, `personPictureUri` TEXT, `personPictureThumbnailUri` TEXT, `fileSize` INTEGER NOT NULL, `personPictureActive` INTEGER NOT NULL)", "fields": [ { "fieldPath": "personPictureUid", "columnName": "personPictureUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "personPictureLct", "columnName": "personPictureLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "personPictureUri", "columnName": "personPictureUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "personPictureThumbnailUri", "columnName": "personPictureThumbnailUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "fileSize", "columnName": "fileSize", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "personPictureActive", "columnName": "personPictureActive", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "personPictureUid" ] }, "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": { "autoGenerate": true, "columnNames": [ "sqiUid" ] }, "indices": [ { "name": "index_ScrapeQueueItem_status_itemType", "unique": false, "columnNames": [ "status", "itemType" ], "orders": [], "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": { "autoGenerate": true, "columnNames": [ "scrapeRunUid" ] }, "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": { "autoGenerate": false, "columnNames": [ "csUid" ] }, "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, `cntLct` 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": "cntLct", "columnName": "cntLct", "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": { "autoGenerate": true, "columnNames": [ "containerUid" ] }, "indices": [ { "name": "cnt_uid_to_most_recent", "unique": false, "columnNames": [ "containerContentEntryUid", "cntLastModified" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `cnt_uid_to_most_recent` ON `${TABLE_NAME}` (`containerContentEntryUid`, `cntLastModified`)" }, { "name": "index_Container_cntLastModified", "unique": false, "columnNames": [ "cntLastModified" ], "orders": [], "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": { "autoGenerate": true, "columnNames": [ "ceUid" ] }, "indices": [ { "name": "index_ContainerEntry_ceContainerUid", "unique": false, "columnNames": [ "ceContainerUid" ], "orders": [], "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": { "autoGenerate": true, "columnNames": [ "cefUid" ] }, "indices": [ { "name": "index_ContainerEntryFile_cefMd5", "unique": false, "columnNames": [ "cefMd5" ], "orders": [], "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, `verbInActive` INTEGER NOT NULL, `verbMasterChangeSeqNum` INTEGER NOT NULL, `verbLocalChangeSeqNum` INTEGER NOT NULL, `verbLastChangedBy` INTEGER NOT NULL, `verbLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "verbUid", "columnName": "verbUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "urlId", "columnName": "urlId", "affinity": "TEXT", "notNull": false }, { "fieldPath": "verbInActive", "columnName": "verbInActive", "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 }, { "fieldPath": "verbLct", "columnName": "verbLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "verbUid" ] }, "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, `objectStatementRefUid` INTEGER NOT NULL DEFAULT 0, `xObjectMasterChangeSeqNum` INTEGER NOT NULL, `xObjectocalChangeSeqNum` INTEGER NOT NULL, `xObjectLastChangedBy` INTEGER NOT NULL, `xObjectLct` 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": "objectStatementRefUid", "columnName": "objectStatementRefUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "xObjectMasterChangeSeqNum", "columnName": "xObjectMasterChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "xObjectocalChangeSeqNum", "columnName": "xObjectocalChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "xObjectLastChangedBy", "columnName": "xObjectLastChangedBy", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "xObjectLct", "columnName": "xObjectLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "xObjectUid" ] }, "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, `statementLct` INTEGER NOT NULL, `extensionProgress` INTEGER NOT NULL, `contentEntryRoot` INTEGER NOT NULL, `statementContentEntryUid` INTEGER NOT NULL, `statementLearnerGroupUid` INTEGER NOT NULL, `statementClazzUid` 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": "statementLct", "columnName": "statementLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "extensionProgress", "columnName": "extensionProgress", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "contentEntryRoot", "columnName": "contentEntryRoot", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "statementContentEntryUid", "columnName": "statementContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "statementLearnerGroupUid", "columnName": "statementLearnerGroupUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "statementClazzUid", "columnName": "statementClazzUid", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "statementUid" ] }, "indices": [ { "name": "index_StatementEntity_statementContentEntryUid_statementPersonUid_contentEntryRoot_timestamp_statementLocalChangeSeqNum", "unique": false, "columnNames": [ "statementContentEntryUid", "statementPersonUid", "contentEntryRoot", "timestamp", "statementLocalChangeSeqNum" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_StatementEntity_statementContentEntryUid_statementPersonUid_contentEntryRoot_timestamp_statementLocalChangeSeqNum` ON `${TABLE_NAME}` (`statementContentEntryUid`, `statementPersonUid`, `contentEntryRoot`, `timestamp`, `statementLocalChangeSeqNum`)" }, { "name": "index_StatementEntity_statementPersonUid", "unique": false, "columnNames": [ "statementPersonUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_StatementEntity_statementPersonUid` ON `${TABLE_NAME}` (`statementPersonUid`)" } ], "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, `contextXObjectLct` 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 }, { "fieldPath": "contextXObjectLct", "columnName": "contextXObjectLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "contextXObjectStatementJoinUid" ] }, "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, `agentLct` 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 }, { "fieldPath": "agentLct", "columnName": "agentLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "agentUid" ] }, "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, `stateLct` 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 }, { "fieldPath": "stateLct", "columnName": "stateLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "stateUid" ] }, "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, `stateContentLct` 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 }, { "fieldPath": "stateContentLct", "columnName": "stateContentLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "stateContentUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "XLangMapEntry", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`verbLangMapUid` INTEGER NOT NULL, `objectLangMapUid` INTEGER NOT NULL, `languageLangMapUid` INTEGER NOT NULL, `languageVariantLangMapUid` INTEGER NOT NULL, `valueLangMap` TEXT, `statementLangMapMasterCsn` INTEGER NOT NULL, `statementLangMapLocalCsn` INTEGER NOT NULL, `statementLangMapLcb` INTEGER NOT NULL, `statementLangMapLct` INTEGER NOT NULL, `statementLangMapUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)", "fields": [ { "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": false }, { "fieldPath": "statementLangMapMasterCsn", "columnName": "statementLangMapMasterCsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "statementLangMapLocalCsn", "columnName": "statementLangMapLocalCsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "statementLangMapLcb", "columnName": "statementLangMapLcb", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "statementLangMapLct", "columnName": "statementLangMapLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "statementLangMapUid", "columnName": "statementLangMapUid", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "statementLangMapUid" ] }, "indices": [ { "name": "index_XLangMapEntry_verbLangMapUid", "unique": false, "columnNames": [ "verbLangMapUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_XLangMapEntry_verbLangMapUid` ON `${TABLE_NAME}` (`verbLangMapUid`)" } ], "foreignKeys": [] }, { "tableName": "SyncNode", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`nodeClientId` INTEGER NOT NULL, PRIMARY KEY(`nodeClientId`))", "fields": [ { "fieldPath": "nodeClientId", "columnName": "nodeClientId", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": false, "columnNames": [ "nodeClientId" ] }, "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": { "autoGenerate": false, "columnNames": [ "laContainerUid" ] }, "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": { "autoGenerate": false, "columnNames": [ "ceContainerUid" ] }, "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, `schoolLct` 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": "schoolLct", "columnName": "schoolLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "schoolTimeZone", "columnName": "schoolTimeZone", "affinity": "TEXT", "notNull": false } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "schoolUid" ] }, "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, `schoolMemberLct` 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 }, { "fieldPath": "schoolMemberLct", "columnName": "schoolMemberLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "schoolMemberUid" ] }, "indices": [ { "name": "index_SchoolMember_schoolMemberSchoolUid_schoolMemberActive_schoolMemberRole", "unique": false, "columnNames": [ "schoolMemberSchoolUid", "schoolMemberActive", "schoolMemberRole" ], "orders": [], "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" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_SchoolMember_schoolMemberPersonUid` ON `${TABLE_NAME}` (`schoolMemberPersonUid`)" }, { "name": "index_SchoolMember_schoolMemberSchoolUid", "unique": false, "columnNames": [ "schoolMemberSchoolUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_SchoolMember_schoolMemberSchoolUid` ON `${TABLE_NAME}` (`schoolMemberSchoolUid`)" } ], "foreignKeys": [] }, { "tableName": "Comments", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`commentsUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `commentsText` TEXT, `commentsEntityUid` INTEGER NOT NULL, `commentsStatus` INTEGER NOT NULL, `commentsFromPersonUid` INTEGER NOT NULL, `commentsForSubmitterUid` INTEGER NOT NULL, `commentsFromSubmitterUid` INTEGER NOT NULL, `commentsFlagged` INTEGER NOT NULL, `commentsDeleted` INTEGER NOT NULL, `commentsDateTimeAdded` INTEGER NOT NULL, `commentsLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "commentsUid", "columnName": "commentsUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsText", "columnName": "commentsText", "affinity": "TEXT", "notNull": false }, { "fieldPath": "commentsEntityUid", "columnName": "commentsEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsStatus", "columnName": "commentsStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsFromPersonUid", "columnName": "commentsFromPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsForSubmitterUid", "columnName": "commentsForSubmitterUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsFromSubmitterUid", "columnName": "commentsFromSubmitterUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsFlagged", "columnName": "commentsFlagged", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsDeleted", "columnName": "commentsDeleted", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsDateTimeAdded", "columnName": "commentsDateTimeAdded", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "commentsLct", "columnName": "commentsLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "commentsUid" ] }, "indices": [ { "name": "idx_comments_entity_submitter", "unique": false, "columnNames": [ "commentsEntityUid", "commentsForSubmitterUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_comments_entity_submitter` ON `${TABLE_NAME}` (`commentsEntityUid`, `commentsForSubmitterUid`)" } ], "foreignKeys": [] }, { "tableName": "Report", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`reportUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `reportOwnerUid` INTEGER NOT NULL, `xAxis` INTEGER NOT NULL, `reportDateRangeSelection` INTEGER NOT NULL, `fromDate` INTEGER NOT NULL, `fromRelTo` INTEGER NOT NULL, `fromRelOffSet` INTEGER NOT NULL, `fromRelUnit` INTEGER NOT NULL, `toDate` INTEGER NOT NULL, `toRelTo` INTEGER NOT NULL, `toRelOffSet` INTEGER NOT NULL, `toRelUnit` INTEGER NOT NULL, `reportTitle` TEXT, `reportDescription` TEXT, `reportSeries` TEXT, `reportInactive` INTEGER NOT NULL, `isTemplate` INTEGER NOT NULL, `priority` INTEGER NOT NULL, `reportTitleId` INTEGER NOT NULL, `reportDescId` INTEGER NOT NULL, `reportMasterChangeSeqNum` INTEGER NOT NULL, `reportLocalChangeSeqNum` INTEGER NOT NULL, `reportLastChangedBy` INTEGER NOT NULL, `reportLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "reportUid", "columnName": "reportUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "reportOwnerUid", "columnName": "reportOwnerUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "xAxis", "columnName": "xAxis", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "reportDateRangeSelection", "columnName": "reportDateRangeSelection", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "fromDate", "columnName": "fromDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "fromRelTo", "columnName": "fromRelTo", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "fromRelOffSet", "columnName": "fromRelOffSet", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "fromRelUnit", "columnName": "fromRelUnit", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "toDate", "columnName": "toDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "toRelTo", "columnName": "toRelTo", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "toRelOffSet", "columnName": "toRelOffSet", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "toRelUnit", "columnName": "toRelUnit", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "reportTitle", "columnName": "reportTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "reportDescription", "columnName": "reportDescription", "affinity": "TEXT", "notNull": false }, { "fieldPath": "reportSeries", "columnName": "reportSeries", "affinity": "TEXT", "notNull": false }, { "fieldPath": "reportInactive", "columnName": "reportInactive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "isTemplate", "columnName": "isTemplate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "priority", "columnName": "priority", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "reportTitleId", "columnName": "reportTitleId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "reportDescId", "columnName": "reportDescId", "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 }, { "fieldPath": "reportLct", "columnName": "reportLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "reportUid" ] }, "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, `siteLct` INTEGER NOT NULL, `siteName` TEXT, `guestLogin` INTEGER NOT NULL, `registrationAllowed` INTEGER NOT NULL, `authSalt` TEXT)", "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": "siteLct", "columnName": "siteLct", "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 }, { "fieldPath": "authSalt", "columnName": "authSalt", "affinity": "TEXT", "notNull": false } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "siteUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ContainerImportJob", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cijUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cijContainerUid` INTEGER NOT NULL, `cijUri` TEXT, `cijImportMode` INTEGER NOT NULL, `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": "cijUri", "columnName": "cijUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cijImportMode", "columnName": "cijImportMode", "affinity": "INTEGER", "notNull": true }, { "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": { "autoGenerate": true, "columnNames": [ "cijUid" ] }, "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, `sTermsLct` 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 }, { "fieldPath": "sTermsLct", "columnName": "sTermsLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "sTermsUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "PersonParentJoin", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`ppjUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `ppjPcsn` INTEGER NOT NULL, `ppjLcsn` INTEGER NOT NULL, `ppjLcb` INTEGER NOT NULL, `ppjLct` INTEGER NOT NULL, `ppjParentPersonUid` INTEGER NOT NULL, `ppjMinorPersonUid` INTEGER NOT NULL, `ppjRelationship` INTEGER NOT NULL, `ppjEmail` TEXT, `ppjPhone` TEXT, `ppjInactive` INTEGER NOT NULL, `ppjStatus` INTEGER NOT NULL, `ppjApprovalTiemstamp` INTEGER NOT NULL, `ppjApprovalIpAddr` TEXT)", "fields": [ { "fieldPath": "ppjUid", "columnName": "ppjUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjPcsn", "columnName": "ppjPcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjLcsn", "columnName": "ppjLcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjLcb", "columnName": "ppjLcb", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjLct", "columnName": "ppjLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjParentPersonUid", "columnName": "ppjParentPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjMinorPersonUid", "columnName": "ppjMinorPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjRelationship", "columnName": "ppjRelationship", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjEmail", "columnName": "ppjEmail", "affinity": "TEXT", "notNull": false }, { "fieldPath": "ppjPhone", "columnName": "ppjPhone", "affinity": "TEXT", "notNull": false }, { "fieldPath": "ppjInactive", "columnName": "ppjInactive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjStatus", "columnName": "ppjStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjApprovalTiemstamp", "columnName": "ppjApprovalTiemstamp", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ppjApprovalIpAddr", "columnName": "ppjApprovalIpAddr", "affinity": "TEXT", "notNull": false } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "ppjUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ScopedGrant", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`sgUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `sgPcsn` INTEGER NOT NULL, `sgLcsn` INTEGER NOT NULL, `sgLcb` INTEGER NOT NULL, `sgLct` INTEGER NOT NULL, `sgTableId` INTEGER NOT NULL, `sgEntityUid` INTEGER NOT NULL, `sgPermissions` INTEGER NOT NULL, `sgGroupUid` INTEGER NOT NULL, `sgIndex` INTEGER NOT NULL, `sgFlags` INTEGER NOT NULL)", "fields": [ { "fieldPath": "sgUid", "columnName": "sgUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgPcsn", "columnName": "sgPcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgLcsn", "columnName": "sgLcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgLcb", "columnName": "sgLcb", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgLct", "columnName": "sgLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgTableId", "columnName": "sgTableId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgEntityUid", "columnName": "sgEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgPermissions", "columnName": "sgPermissions", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgGroupUid", "columnName": "sgGroupUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgIndex", "columnName": "sgIndex", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sgFlags", "columnName": "sgFlags", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "sgUid" ] }, "indices": [ { "name": "idx_group_to_entity", "unique": false, "columnNames": [ "sgGroupUid", "sgPermissions", "sgTableId", "sgEntityUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_group_to_entity` ON `${TABLE_NAME}` (`sgGroupUid`, `sgPermissions`, `sgTableId`, `sgEntityUid`)" }, { "name": "idx_entity_to_group", "unique": false, "columnNames": [ "sgTableId", "sgEntityUid", "sgPermissions", "sgGroupUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_entity_to_group` ON `${TABLE_NAME}` (`sgTableId`, `sgEntityUid`, `sgPermissions`, `sgGroupUid`)" } ], "foreignKeys": [] }, { "tableName": "ErrorReport", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`errUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `errPcsn` INTEGER NOT NULL, `errLcsn` INTEGER NOT NULL, `errLcb` INTEGER NOT NULL, `errLct` INTEGER NOT NULL, `severity` INTEGER NOT NULL, `timestamp` INTEGER NOT NULL, `presenterUri` TEXT, `appVersion` TEXT, `versionCode` INTEGER NOT NULL, `errorCode` INTEGER NOT NULL, `operatingSys` TEXT, `osVersion` TEXT, `stackTrace` TEXT, `message` TEXT)", "fields": [ { "fieldPath": "errUid", "columnName": "errUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "errPcsn", "columnName": "errPcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "errLcsn", "columnName": "errLcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "errLcb", "columnName": "errLcb", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "errLct", "columnName": "errLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "severity", "columnName": "severity", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "timestamp", "columnName": "timestamp", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "presenterUri", "columnName": "presenterUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "appVersion", "columnName": "appVersion", "affinity": "TEXT", "notNull": false }, { "fieldPath": "versionCode", "columnName": "versionCode", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "errorCode", "columnName": "errorCode", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "operatingSys", "columnName": "operatingSys", "affinity": "TEXT", "notNull": false }, { "fieldPath": "osVersion", "columnName": "osVersion", "affinity": "TEXT", "notNull": false }, { "fieldPath": "stackTrace", "columnName": "stackTrace", "affinity": "TEXT", "notNull": false }, { "fieldPath": "message", "columnName": "message", "affinity": "TEXT", "notNull": false } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "errUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ClazzAssignment", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`caUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `caTitle` TEXT, `caDescription` TEXT, `caGroupUid` INTEGER NOT NULL DEFAULT 0, `caActive` INTEGER NOT NULL, `caClassCommentEnabled` INTEGER NOT NULL, `caPrivateCommentsEnabled` INTEGER NOT NULL DEFAULT 1, `caCompletionCriteria` INTEGER NOT NULL DEFAULT 100, `caRequireFileSubmission` INTEGER NOT NULL DEFAULT 1, `caFileType` INTEGER NOT NULL DEFAULT 0, `caSizeLimit` INTEGER NOT NULL DEFAULT 50, `caNumberOfFiles` INTEGER NOT NULL DEFAULT 1, `caSubmissionPolicy` INTEGER NOT NULL DEFAULT 1, `caMarkingType` INTEGER NOT NULL DEFAULT 1, `caRequireTextSubmission` INTEGER NOT NULL DEFAULT 1, `caTextLimitType` INTEGER NOT NULL DEFAULT 1, `caTextLimit` INTEGER NOT NULL DEFAULT 500, `caXObjectUid` INTEGER NOT NULL DEFAULT 0, `caClazzUid` INTEGER NOT NULL, `caPeerReviewerCount` INTEGER NOT NULL DEFAULT 0, `caLocalChangeSeqNum` INTEGER NOT NULL, `caMasterChangeSeqNum` INTEGER NOT NULL, `caLastChangedBy` INTEGER NOT NULL, `caLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "caUid", "columnName": "caUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "caTitle", "columnName": "caTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "caDescription", "columnName": "caDescription", "affinity": "TEXT", "notNull": false }, { "fieldPath": "caGroupUid", "columnName": "caGroupUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "caActive", "columnName": "caActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "caClassCommentEnabled", "columnName": "caClassCommentEnabled", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "caPrivateCommentsEnabled", "columnName": "caPrivateCommentsEnabled", "affinity": "INTEGER", "notNull": true, "defaultValue": "1" }, { "fieldPath": "caCompletionCriteria", "columnName": "caCompletionCriteria", "affinity": "INTEGER", "notNull": true, "defaultValue": "100" }, { "fieldPath": "caRequireFileSubmission", "columnName": "caRequireFileSubmission", "affinity": "INTEGER", "notNull": true, "defaultValue": "1" }, { "fieldPath": "caFileType", "columnName": "caFileType", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "caSizeLimit", "columnName": "caSizeLimit", "affinity": "INTEGER", "notNull": true, "defaultValue": "50" }, { "fieldPath": "caNumberOfFiles", "columnName": "caNumberOfFiles", "affinity": "INTEGER", "notNull": true, "defaultValue": "1" }, { "fieldPath": "caSubmissionPolicy", "columnName": "caSubmissionPolicy", "affinity": "INTEGER", "notNull": true, "defaultValue": "1" }, { "fieldPath": "caMarkingType", "columnName": "caMarkingType", "affinity": "INTEGER", "notNull": true, "defaultValue": "1" }, { "fieldPath": "caRequireTextSubmission", "columnName": "caRequireTextSubmission", "affinity": "INTEGER", "notNull": true, "defaultValue": "1" }, { "fieldPath": "caTextLimitType", "columnName": "caTextLimitType", "affinity": "INTEGER", "notNull": true, "defaultValue": "1" }, { "fieldPath": "caTextLimit", "columnName": "caTextLimit", "affinity": "INTEGER", "notNull": true, "defaultValue": "500" }, { "fieldPath": "caXObjectUid", "columnName": "caXObjectUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "caClazzUid", "columnName": "caClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "caPeerReviewerCount", "columnName": "caPeerReviewerCount", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "caLocalChangeSeqNum", "columnName": "caLocalChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "caMasterChangeSeqNum", "columnName": "caMasterChangeSeqNum", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "caLastChangedBy", "columnName": "caLastChangedBy", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "caLct", "columnName": "caLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "caUid" ] }, "indices": [ { "name": "index_ClazzAssignment_caClazzUid", "unique": false, "columnNames": [ "caClazzUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ClazzAssignment_caClazzUid` ON `${TABLE_NAME}` (`caClazzUid`)" } ], "foreignKeys": [] }, { "tableName": "CourseAssignmentSubmission", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`casUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `casAssignmentUid` INTEGER NOT NULL, `casSubmitterUid` INTEGER NOT NULL, `casSubmitterPersonUid` INTEGER NOT NULL, `casText` TEXT, `casType` INTEGER NOT NULL, `casTimestamp` INTEGER NOT NULL, `casClazzUid` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "casUid", "columnName": "casUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casAssignmentUid", "columnName": "casAssignmentUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casSubmitterUid", "columnName": "casSubmitterUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casSubmitterPersonUid", "columnName": "casSubmitterPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casText", "columnName": "casText", "affinity": "TEXT", "notNull": false }, { "fieldPath": "casType", "columnName": "casType", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casTimestamp", "columnName": "casTimestamp", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casClazzUid", "columnName": "casClazzUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "casUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "CourseAssignmentSubmissionFile", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`casaUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `casaSubmissionUid` INTEGER NOT NULL, `casaSubmitterUid` INTEGER NOT NULL DEFAULT 0, `casaCaUid` INTEGER NOT NULL, `casaClazzUid` INTEGER NOT NULL, `casaMimeType` TEXT, `casaFileName` TEXT, `casaUri` TEXT, `casaSize` INTEGER NOT NULL, `casaTimestamp` INTEGER NOT NULL, `casaDeleted` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "casaUid", "columnName": "casaUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casaSubmissionUid", "columnName": "casaSubmissionUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casaSubmitterUid", "columnName": "casaSubmitterUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "casaCaUid", "columnName": "casaCaUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casaClazzUid", "columnName": "casaClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casaMimeType", "columnName": "casaMimeType", "affinity": "TEXT", "notNull": false }, { "fieldPath": "casaFileName", "columnName": "casaFileName", "affinity": "TEXT", "notNull": false }, { "fieldPath": "casaUri", "columnName": "casaUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "casaSize", "columnName": "casaSize", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casaTimestamp", "columnName": "casaTimestamp", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "casaDeleted", "columnName": "casaDeleted", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "casaUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "CourseAssignmentMark", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`camUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `camAssignmentUid` INTEGER NOT NULL, `camSubmitterUid` INTEGER NOT NULL, `camMarkerSubmitterUid` INTEGER NOT NULL DEFAULT 0, `camMarkerPersonUid` INTEGER NOT NULL DEFAULT 0, `camMarkerComment` TEXT, `camMark` REAL NOT NULL, `camMaxMark` REAL NOT NULL DEFAULT 1, `camPenalty` REAL NOT NULL, `camLct` INTEGER NOT NULL, `camClazzUid` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "camUid", "columnName": "camUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "camAssignmentUid", "columnName": "camAssignmentUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "camSubmitterUid", "columnName": "camSubmitterUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "camMarkerSubmitterUid", "columnName": "camMarkerSubmitterUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "camMarkerPersonUid", "columnName": "camMarkerPersonUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "camMarkerComment", "columnName": "camMarkerComment", "affinity": "TEXT", "notNull": false }, { "fieldPath": "camMark", "columnName": "camMark", "affinity": "REAL", "notNull": true }, { "fieldPath": "camMaxMark", "columnName": "camMaxMark", "affinity": "REAL", "notNull": true, "defaultValue": "1" }, { "fieldPath": "camPenalty", "columnName": "camPenalty", "affinity": "REAL", "notNull": true }, { "fieldPath": "camLct", "columnName": "camLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "camClazzUid", "columnName": "camClazzUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "camUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "PeerReviewerAllocation", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`praUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `praMarkerSubmitterUid` INTEGER NOT NULL, `praToMarkerSubmitterUid` INTEGER NOT NULL, `praAssignmentUid` INTEGER NOT NULL, `praActive` INTEGER NOT NULL, `praLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "praUid", "columnName": "praUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "praMarkerSubmitterUid", "columnName": "praMarkerSubmitterUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "praToMarkerSubmitterUid", "columnName": "praToMarkerSubmitterUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "praAssignmentUid", "columnName": "praAssignmentUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "praActive", "columnName": "praActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "praLct", "columnName": "praLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "praUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "PersonAuth2", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`pauthUid` INTEGER NOT NULL, `pauthMechanism` TEXT, `pauthAuth` TEXT, `pauthLcsn` INTEGER NOT NULL, `pauthPcsn` INTEGER NOT NULL, `pauthLcb` INTEGER NOT NULL, `pauthLct` INTEGER NOT NULL, PRIMARY KEY(`pauthUid`))", "fields": [ { "fieldPath": "pauthUid", "columnName": "pauthUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "pauthMechanism", "columnName": "pauthMechanism", "affinity": "TEXT", "notNull": false }, { "fieldPath": "pauthAuth", "columnName": "pauthAuth", "affinity": "TEXT", "notNull": false }, { "fieldPath": "pauthLcsn", "columnName": "pauthLcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "pauthPcsn", "columnName": "pauthPcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "pauthLcb", "columnName": "pauthLcb", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "pauthLct", "columnName": "pauthLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": false, "columnNames": [ "pauthUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "UserSession", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`usUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `usPcsn` INTEGER NOT NULL, `usLcsn` INTEGER NOT NULL, `usLcb` INTEGER NOT NULL, `usLct` INTEGER NOT NULL, `usPersonUid` INTEGER NOT NULL, `usClientNodeId` INTEGER NOT NULL, `usStartTime` INTEGER NOT NULL, `usEndTime` INTEGER NOT NULL, `usStatus` INTEGER NOT NULL, `usReason` INTEGER NOT NULL, `usAuth` TEXT, `usSessionType` INTEGER NOT NULL)", "fields": [ { "fieldPath": "usUid", "columnName": "usUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usPcsn", "columnName": "usPcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usLcsn", "columnName": "usLcsn", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usLcb", "columnName": "usLcb", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usLct", "columnName": "usLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usPersonUid", "columnName": "usPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usClientNodeId", "columnName": "usClientNodeId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usStartTime", "columnName": "usStartTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usEndTime", "columnName": "usEndTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usStatus", "columnName": "usStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usReason", "columnName": "usReason", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "usAuth", "columnName": "usAuth", "affinity": "TEXT", "notNull": false }, { "fieldPath": "usSessionType", "columnName": "usSessionType", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "usUid" ] }, "indices": [ { "name": "person_status_node_idx", "unique": false, "columnNames": [ "usPersonUid", "usStatus", "usClientNodeId" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `person_status_node_idx` ON `${TABLE_NAME}` (`usPersonUid`, `usStatus`, `usClientNodeId`)" }, { "name": "node_status_person_idx", "unique": false, "columnNames": [ "usClientNodeId", "usStatus", "usPersonUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `node_status_person_idx` ON `${TABLE_NAME}` (`usClientNodeId`, `usStatus`, `usPersonUid`)" } ], "foreignKeys": [] }, { "tableName": "ContentJob", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cjUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `toUri` TEXT, `cjProgress` INTEGER NOT NULL, `cjTotal` INTEGER NOT NULL, `cjNotificationTitle` TEXT, `cjIsMeteredAllowed` INTEGER NOT NULL, `params` TEXT, `cjLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "cjUid", "columnName": "cjUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "toUri", "columnName": "toUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cjProgress", "columnName": "cjProgress", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjTotal", "columnName": "cjTotal", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjNotificationTitle", "columnName": "cjNotificationTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cjIsMeteredAllowed", "columnName": "cjIsMeteredAllowed", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "params", "columnName": "params", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cjLct", "columnName": "cjLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cjUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ContentEntryImportJob", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cjiUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `sourceUri` TEXT, `cjiOriginalFilename` TEXT, `cjiContentEntryUid` INTEGER NOT NULL, `cjiParentContentEntryUid` INTEGER NOT NULL, `cjiContentEntryVersion` INTEGER NOT NULL, `cjiItemProgress` INTEGER NOT NULL, `cjiItemTotal` INTEGER NOT NULL, `cjiStatus` INTEGER NOT NULL, `cjiRecursiveStatus` INTEGER NOT NULL, `cjiPluginId` INTEGER NOT NULL, `cjiParentCjiUid` INTEGER NOT NULL, `cjiStartTime` INTEGER NOT NULL, `cjiFinishTime` INTEGER NOT NULL, `cjiContentDeletedOnCancellation` INTEGER NOT NULL)", "fields": [ { "fieldPath": "cjiUid", "columnName": "cjiUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "sourceUri", "columnName": "sourceUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cjiOriginalFilename", "columnName": "cjiOriginalFilename", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cjiContentEntryUid", "columnName": "cjiContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiParentContentEntryUid", "columnName": "cjiParentContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiContentEntryVersion", "columnName": "cjiContentEntryVersion", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiItemProgress", "columnName": "cjiItemProgress", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiItemTotal", "columnName": "cjiItemTotal", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiStatus", "columnName": "cjiStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiRecursiveStatus", "columnName": "cjiRecursiveStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiPluginId", "columnName": "cjiPluginId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiParentCjiUid", "columnName": "cjiParentCjiUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiStartTime", "columnName": "cjiStartTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiFinishTime", "columnName": "cjiFinishTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cjiContentDeletedOnCancellation", "columnName": "cjiContentDeletedOnCancellation", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cjiUid" ] }, "indices": [ { "name": "index_ContentEntryImportJob_cjiContentEntryUid_cjiFinishTime", "unique": false, "columnNames": [ "cjiContentEntryUid", "cjiFinishTime" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_ContentEntryImportJob_cjiContentEntryUid_cjiFinishTime` ON `${TABLE_NAME}` (`cjiContentEntryUid`, `cjiFinishTime`)" } ], "foreignKeys": [] }, { "tableName": "CourseBlock", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cbUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cbType` INTEGER NOT NULL, `cbIndentLevel` INTEGER NOT NULL, `cbModuleParentBlockUid` INTEGER NOT NULL, `cbTitle` TEXT, `cbDescription` TEXT, `cbCompletionCriteria` INTEGER NOT NULL, `cbHideUntilDate` INTEGER NOT NULL, `cbDeadlineDate` INTEGER NOT NULL, `cbLateSubmissionPenalty` INTEGER NOT NULL, `cbGracePeriodDate` INTEGER NOT NULL, `cbMaxPoints` INTEGER NOT NULL, `cbMinPoints` INTEGER NOT NULL, `cbIndex` INTEGER NOT NULL, `cbClazzUid` INTEGER NOT NULL, `cbActive` INTEGER NOT NULL, `cbHidden` INTEGER NOT NULL, `cbEntityUid` INTEGER NOT NULL, `cbLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "cbUid", "columnName": "cbUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbType", "columnName": "cbType", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbIndentLevel", "columnName": "cbIndentLevel", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbModuleParentBlockUid", "columnName": "cbModuleParentBlockUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbTitle", "columnName": "cbTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cbDescription", "columnName": "cbDescription", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cbCompletionCriteria", "columnName": "cbCompletionCriteria", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbHideUntilDate", "columnName": "cbHideUntilDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbDeadlineDate", "columnName": "cbDeadlineDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbLateSubmissionPenalty", "columnName": "cbLateSubmissionPenalty", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbGracePeriodDate", "columnName": "cbGracePeriodDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbMaxPoints", "columnName": "cbMaxPoints", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbMinPoints", "columnName": "cbMinPoints", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbIndex", "columnName": "cbIndex", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbClazzUid", "columnName": "cbClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbActive", "columnName": "cbActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbHidden", "columnName": "cbHidden", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbEntityUid", "columnName": "cbEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cbLct", "columnName": "cbLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cbUid" ] }, "indices": [ { "name": "index_CourseBlock_cbClazzUid", "unique": false, "columnNames": [ "cbClazzUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_CourseBlock_cbClazzUid` ON `${TABLE_NAME}` (`cbClazzUid`)" } ], "foreignKeys": [] }, { "tableName": "CourseTerminology", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`ctUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `ctTitle` TEXT, `ctTerminology` TEXT, `ctLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "ctUid", "columnName": "ctUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "ctTitle", "columnName": "ctTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "ctTerminology", "columnName": "ctTerminology", "affinity": "TEXT", "notNull": false }, { "fieldPath": "ctLct", "columnName": "ctLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "ctUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "CourseGroupSet", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cgsUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cgsName` TEXT, `cgsTotalGroups` INTEGER NOT NULL, `cgsActive` INTEGER NOT NULL, `cgsClazzUid` INTEGER NOT NULL, `cgsLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "cgsUid", "columnName": "cgsUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgsName", "columnName": "cgsName", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cgsTotalGroups", "columnName": "cgsTotalGroups", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgsActive", "columnName": "cgsActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgsClazzUid", "columnName": "cgsClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgsLct", "columnName": "cgsLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cgsUid" ] }, "indices": [ { "name": "index_CourseGroupSet_cgsClazzUid", "unique": false, "columnNames": [ "cgsClazzUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_CourseGroupSet_cgsClazzUid` ON `${TABLE_NAME}` (`cgsClazzUid`)" } ], "foreignKeys": [] }, { "tableName": "CourseGroupMember", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cgmUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cgmSetUid` INTEGER NOT NULL, `cgmGroupNumber` INTEGER NOT NULL, `cgmPersonUid` INTEGER NOT NULL, `cgmLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "cgmUid", "columnName": "cgmUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgmSetUid", "columnName": "cgmSetUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgmGroupNumber", "columnName": "cgmGroupNumber", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgmPersonUid", "columnName": "cgmPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cgmLct", "columnName": "cgmLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cgmUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "Chat", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`chatUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `chatStartDate` INTEGER NOT NULL, `chatTitle` TEXT, `chatGroup` INTEGER NOT NULL, `chatLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "chatUid", "columnName": "chatUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatStartDate", "columnName": "chatStartDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatTitle", "columnName": "chatTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "chatGroup", "columnName": "chatGroup", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatLct", "columnName": "chatLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "chatUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ContentEntryPicture", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cepUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cepContentEntryUid` INTEGER NOT NULL, `cepUri` TEXT, `cepMd5` TEXT, `cepFileSize` INTEGER NOT NULL, `cepTimestamp` INTEGER NOT NULL, `cepMimeType` TEXT, `cepActive` INTEGER NOT NULL)", "fields": [ { "fieldPath": "cepUid", "columnName": "cepUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cepContentEntryUid", "columnName": "cepContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cepUri", "columnName": "cepUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cepMd5", "columnName": "cepMd5", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cepFileSize", "columnName": "cepFileSize", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cepTimestamp", "columnName": "cepTimestamp", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cepMimeType", "columnName": "cepMimeType", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cepActive", "columnName": "cepActive", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cepUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "DoorNode", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`nodeId` INTEGER NOT NULL, `auth` TEXT, `rel` INTEGER NOT NULL DEFAULT 2, PRIMARY KEY(`nodeId`))", "fields": [ { "fieldPath": "nodeId", "columnName": "nodeId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "auth", "columnName": "auth", "affinity": "TEXT", "notNull": false }, { "fieldPath": "rel", "columnName": "rel", "affinity": "INTEGER", "notNull": true, "defaultValue": "2" } ], "primaryKey": { "autoGenerate": false, "columnNames": [ "nodeId" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "CoursePicture", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`coursePictureUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `coursePictureLct` INTEGER NOT NULL, `coursePictureUri` TEXT, `coursePictureThumbnailUri` TEXT, `coursePictureActive` INTEGER NOT NULL)", "fields": [ { "fieldPath": "coursePictureUid", "columnName": "coursePictureUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "coursePictureLct", "columnName": "coursePictureLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "coursePictureUri", "columnName": "coursePictureUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "coursePictureThumbnailUri", "columnName": "coursePictureThumbnailUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "coursePictureActive", "columnName": "coursePictureActive", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "coursePictureUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "DiscussionPost", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`discussionPostUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `discussionPostReplyToPostUid` INTEGER NOT NULL, `discussionPostTitle` TEXT, `discussionPostMessage` TEXT, `discussionPostStartDate` INTEGER NOT NULL, `discussionPostCourseBlockUid` INTEGER NOT NULL, `dpDeleted` INTEGER NOT NULL, `discussionPostStartedPersonUid` INTEGER NOT NULL, `discussionPostClazzUid` INTEGER NOT NULL, `discussionPostLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "discussionPostUid", "columnName": "discussionPostUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "discussionPostReplyToPostUid", "columnName": "discussionPostReplyToPostUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "discussionPostTitle", "columnName": "discussionPostTitle", "affinity": "TEXT", "notNull": false }, { "fieldPath": "discussionPostMessage", "columnName": "discussionPostMessage", "affinity": "TEXT", "notNull": false }, { "fieldPath": "discussionPostStartDate", "columnName": "discussionPostStartDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "discussionPostCourseBlockUid", "columnName": "discussionPostCourseBlockUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "dpDeleted", "columnName": "dpDeleted", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "discussionPostStartedPersonUid", "columnName": "discussionPostStartedPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "discussionPostClazzUid", "columnName": "discussionPostClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "discussionPostLct", "columnName": "discussionPostLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "discussionPostUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ExternalAppPermission", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`eapUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `eapPersonUid` INTEGER NOT NULL, `eapPackageId` TEXT, `eapStartTime` INTEGER NOT NULL, `eapExpireTime` INTEGER NOT NULL, `eapAuthToken` TEXT, `eapAndroidAccountName` TEXT)", "fields": [ { "fieldPath": "eapUid", "columnName": "eapUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "eapPersonUid", "columnName": "eapPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "eapPackageId", "columnName": "eapPackageId", "affinity": "TEXT", "notNull": false }, { "fieldPath": "eapStartTime", "columnName": "eapStartTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "eapExpireTime", "columnName": "eapExpireTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "eapAuthToken", "columnName": "eapAuthToken", "affinity": "TEXT", "notNull": false }, { "fieldPath": "eapAndroidAccountName", "columnName": "eapAndroidAccountName", "affinity": "TEXT", "notNull": false } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "eapUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ChatMember", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`chatMemberUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `chatMemberChatUid` INTEGER NOT NULL, `chatMemberPersonUid` INTEGER NOT NULL, `chatMemberJoinedDate` INTEGER NOT NULL, `chatMemberLeftDate` INTEGER NOT NULL, `chatMemberLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "chatMemberUid", "columnName": "chatMemberUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatMemberChatUid", "columnName": "chatMemberChatUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatMemberPersonUid", "columnName": "chatMemberPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatMemberJoinedDate", "columnName": "chatMemberJoinedDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatMemberLeftDate", "columnName": "chatMemberLeftDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "chatMemberLct", "columnName": "chatMemberLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "chatMemberUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "Message", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`messageUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `messageSenderPersonUid` INTEGER NOT NULL, `messageToPersonUid` INTEGER NOT NULL, `messageText` TEXT, `messageTimestamp` INTEGER NOT NULL, `messageLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "messageUid", "columnName": "messageUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageSenderPersonUid", "columnName": "messageSenderPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageToPersonUid", "columnName": "messageToPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageText", "columnName": "messageText", "affinity": "TEXT", "notNull": false }, { "fieldPath": "messageTimestamp", "columnName": "messageTimestamp", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageLct", "columnName": "messageLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "messageUid" ] }, "indices": [ { "name": "message_idx_send_to_time", "unique": false, "columnNames": [ "messageSenderPersonUid", "messageToPersonUid", "messageTimestamp" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `message_idx_send_to_time` ON `${TABLE_NAME}` (`messageSenderPersonUid`, `messageToPersonUid`, `messageTimestamp`)" } ], "foreignKeys": [] }, { "tableName": "MessageRead", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`messageReadUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `messageReadPersonUid` INTEGER NOT NULL, `messageReadMessageUid` INTEGER NOT NULL, `messageReadEntityUid` INTEGER NOT NULL, `messageReadLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "messageReadUid", "columnName": "messageReadUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageReadPersonUid", "columnName": "messageReadPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageReadMessageUid", "columnName": "messageReadMessageUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageReadEntityUid", "columnName": "messageReadEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "messageReadLct", "columnName": "messageReadLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "messageReadUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "StudentResult", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`srUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `srSourcedId` TEXT, `srCourseBlockUid` INTEGER NOT NULL, `srClazzUid` INTEGER NOT NULL, `srAssignmentUid` INTEGER NOT NULL, `srLineItemSourcedId` TEXT, `srStatus` INTEGER NOT NULL, `srMetaData` TEXT, `srStudentPersonUid` INTEGER NOT NULL, `srStudentGroupId` INTEGER NOT NULL, `srMarkerPersonUid` INTEGER NOT NULL, `srMarkerGroupId` INTEGER NOT NULL, `srScoreStatus` INTEGER NOT NULL, `srScore` REAL NOT NULL, `srScoreDate` INTEGER NOT NULL, `srLastModified` INTEGER NOT NULL, `srComment` TEXT, `srAppId` TEXT, `srActive` INTEGER NOT NULL)", "fields": [ { "fieldPath": "srUid", "columnName": "srUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srSourcedId", "columnName": "srSourcedId", "affinity": "TEXT", "notNull": false }, { "fieldPath": "srCourseBlockUid", "columnName": "srCourseBlockUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srClazzUid", "columnName": "srClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srAssignmentUid", "columnName": "srAssignmentUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srLineItemSourcedId", "columnName": "srLineItemSourcedId", "affinity": "TEXT", "notNull": false }, { "fieldPath": "srStatus", "columnName": "srStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srMetaData", "columnName": "srMetaData", "affinity": "TEXT", "notNull": false }, { "fieldPath": "srStudentPersonUid", "columnName": "srStudentPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srStudentGroupId", "columnName": "srStudentGroupId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srMarkerPersonUid", "columnName": "srMarkerPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srMarkerGroupId", "columnName": "srMarkerGroupId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srScoreStatus", "columnName": "srScoreStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srScore", "columnName": "srScore", "affinity": "REAL", "notNull": true }, { "fieldPath": "srScoreDate", "columnName": "srScoreDate", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srLastModified", "columnName": "srLastModified", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "srComment", "columnName": "srComment", "affinity": "TEXT", "notNull": false }, { "fieldPath": "srAppId", "columnName": "srAppId", "affinity": "TEXT", "notNull": false }, { "fieldPath": "srActive", "columnName": "srActive", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "srUid" ] }, "indices": [ { "name": "index_StudentResult_srSourcedId", "unique": false, "columnNames": [ "srSourcedId" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `index_StudentResult_srSourcedId` ON `${TABLE_NAME}` (`srSourcedId`)" } ], "foreignKeys": [] }, { "tableName": "ContentEntryVersion", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cevUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cevContentEntryUid` INTEGER NOT NULL, `cevOpenUri` TEXT, `cevContentType` TEXT, `cevManifestUrl` TEXT, `cevSize` INTEGER NOT NULL, `cevInActive` INTEGER NOT NULL, `cevLastModified` INTEGER NOT NULL, `cevLct` INTEGER NOT NULL, `cevStorageSize` INTEGER NOT NULL DEFAULT 0, `cevOriginalSize` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "cevUid", "columnName": "cevUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cevContentEntryUid", "columnName": "cevContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cevOpenUri", "columnName": "cevOpenUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cevContentType", "columnName": "cevContentType", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cevManifestUrl", "columnName": "cevManifestUrl", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cevSize", "columnName": "cevSize", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cevInActive", "columnName": "cevInActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cevLastModified", "columnName": "cevLastModified", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cevLct", "columnName": "cevLct", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cevStorageSize", "columnName": "cevStorageSize", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "cevOriginalSize", "columnName": "cevOriginalSize", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cevUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "TransferJob", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`tjUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `tjType` INTEGER NOT NULL, `tjStatus` INTEGER NOT NULL, `tjName` TEXT, `tjUuid` TEXT, `tjTableId` INTEGER NOT NULL DEFAULT 0, `tjEntityUid` INTEGER NOT NULL DEFAULT 0, `tjTimeCreated` INTEGER NOT NULL DEFAULT 0, `tjCreationType` INTEGER NOT NULL DEFAULT 0, `tjOiUid` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "tjUid", "columnName": "tjUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjType", "columnName": "tjType", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjStatus", "columnName": "tjStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjName", "columnName": "tjName", "affinity": "TEXT", "notNull": false }, { "fieldPath": "tjUuid", "columnName": "tjUuid", "affinity": "TEXT", "notNull": false }, { "fieldPath": "tjTableId", "columnName": "tjTableId", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "tjEntityUid", "columnName": "tjEntityUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "tjTimeCreated", "columnName": "tjTimeCreated", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "tjCreationType", "columnName": "tjCreationType", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "tjOiUid", "columnName": "tjOiUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "tjUid" ] }, "indices": [ { "name": "TransferJob_idx_tjTableId_EntityUid", "unique": false, "columnNames": [ "tjTableId", "tjEntityUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `TransferJob_idx_tjTableId_EntityUid` ON `${TABLE_NAME}` (`tjTableId`, `tjEntityUid`)" } ], "foreignKeys": [] }, { "tableName": "TransferJobItem", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`tjiUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `tjiTjUid` INTEGER NOT NULL, `tjTotalSize` INTEGER NOT NULL, `tjTransferred` INTEGER NOT NULL, `tjAttemptCount` INTEGER NOT NULL, `tjiSrc` TEXT, `tjiDest` TEXT, `tjiType` INTEGER NOT NULL, `tjiStatus` INTEGER NOT NULL, `tjiTableId` INTEGER NOT NULL, `tjiEntityUid` INTEGER NOT NULL, `tjiEntityEtag` INTEGER NOT NULL DEFAULT 0, `tjiLockIdToRelease` INTEGER NOT NULL DEFAULT 0, `tjiPartialTmpFile` TEXT)", "fields": [ { "fieldPath": "tjiUid", "columnName": "tjiUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjiTjUid", "columnName": "tjiTjUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjTotalSize", "columnName": "tjTotalSize", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjTransferred", "columnName": "tjTransferred", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjAttemptCount", "columnName": "tjAttemptCount", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjiSrc", "columnName": "tjiSrc", "affinity": "TEXT", "notNull": false }, { "fieldPath": "tjiDest", "columnName": "tjiDest", "affinity": "TEXT", "notNull": false }, { "fieldPath": "tjiType", "columnName": "tjiType", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjiStatus", "columnName": "tjiStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjiTableId", "columnName": "tjiTableId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjiEntityUid", "columnName": "tjiEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "tjiEntityEtag", "columnName": "tjiEntityEtag", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "tjiLockIdToRelease", "columnName": "tjiLockIdToRelease", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" }, { "fieldPath": "tjiPartialTmpFile", "columnName": "tjiPartialTmpFile", "affinity": "TEXT", "notNull": false } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "tjiUid" ] }, "indices": [ { "name": "tji_table_entity_etag", "unique": false, "columnNames": [ "tjiTableId", "tjiEntityUid", "tjiEntityEtag" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `tji_table_entity_etag` ON `${TABLE_NAME}` (`tjiTableId`, `tjiEntityUid`, `tjiEntityEtag`)" }, { "name": "transferjob_tjuid", "unique": false, "columnNames": [ "tjiTjUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `transferjob_tjuid` ON `${TABLE_NAME}` (`tjiTjUid`)" } ], "foreignKeys": [] }, { "tableName": "CacheLockJoin", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cljId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cljTableId` INTEGER NOT NULL, `cljEntityUid` INTEGER NOT NULL, `cljUrl` TEXT, `cljLockId` INTEGER NOT NULL, `cljStatus` INTEGER NOT NULL, `cljType` INTEGER NOT NULL, `cljOiUid` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "cljId", "columnName": "cljId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cljTableId", "columnName": "cljTableId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cljEntityUid", "columnName": "cljEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cljUrl", "columnName": "cljUrl", "affinity": "TEXT", "notNull": false }, { "fieldPath": "cljLockId", "columnName": "cljLockId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cljStatus", "columnName": "cljStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cljType", "columnName": "cljType", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cljOiUid", "columnName": "cljOiUid", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cljId" ] }, "indices": [ { "name": "idx_clj_table_entity_url", "unique": false, "columnNames": [ "cljTableId", "cljEntityUid", "cljUrl" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_clj_table_entity_url` ON `${TABLE_NAME}` (`cljTableId`, `cljEntityUid`, `cljUrl`)" }, { "name": "idx_clj_offline_item_uid", "unique": false, "columnNames": [ "cljOiUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_clj_offline_item_uid` ON `${TABLE_NAME}` (`cljOiUid`)" } ], "foreignKeys": [] }, { "tableName": "OfflineItem", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`oiUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `oiNodeId` INTEGER NOT NULL, `oiClazzUid` INTEGER NOT NULL, `oiCourseBlockUid` INTEGER NOT NULL, `oiContentEntryUid` INTEGER NOT NULL, `oiActive` INTEGER NOT NULL, `oiLct` INTEGER NOT NULL)", "fields": [ { "fieldPath": "oiUid", "columnName": "oiUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiNodeId", "columnName": "oiNodeId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiClazzUid", "columnName": "oiClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiCourseBlockUid", "columnName": "oiCourseBlockUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiContentEntryUid", "columnName": "oiContentEntryUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiActive", "columnName": "oiActive", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiLct", "columnName": "oiLct", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "oiUid" ] }, "indices": [ { "name": "offline_item_node_content_entry", "unique": false, "columnNames": [ "oiNodeId", "oiContentEntryUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `offline_item_node_content_entry` ON `${TABLE_NAME}` (`oiNodeId`, `oiContentEntryUid`)" } ], "foreignKeys": [] }, { "tableName": "OfflineItemPendingTransferJob", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`oiptjId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `oiptjOiUid` INTEGER NOT NULL, `oiptjTableId` INTEGER NOT NULL, `oiptjEntityUid` INTEGER NOT NULL, `oiptjUrl` TEXT, `oiptjType` INTEGER NOT NULL)", "fields": [ { "fieldPath": "oiptjId", "columnName": "oiptjId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiptjOiUid", "columnName": "oiptjOiUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiptjTableId", "columnName": "oiptjTableId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiptjEntityUid", "columnName": "oiptjEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "oiptjUrl", "columnName": "oiptjUrl", "affinity": "TEXT", "notNull": false }, { "fieldPath": "oiptjType", "columnName": "oiptjType", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "oiptjId" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "DeletedItem", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`delItemUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `delItemName` TEXT, `delItemIconUri` TEXT, `delItemLastModTime` INTEGER NOT NULL, `delItemTimeDeleted` INTEGER NOT NULL, `delItemEntityTable` INTEGER NOT NULL, `delItemEntityUid` INTEGER NOT NULL, `delItemDeletedByPersonUid` INTEGER NOT NULL, `delItemStatus` INTEGER NOT NULL, `delItemIsFolder` INTEGER NOT NULL DEFAULT 0)", "fields": [ { "fieldPath": "delItemUid", "columnName": "delItemUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "delItemName", "columnName": "delItemName", "affinity": "TEXT", "notNull": false }, { "fieldPath": "delItemIconUri", "columnName": "delItemIconUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "delItemLastModTime", "columnName": "delItemLastModTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "delItemTimeDeleted", "columnName": "delItemTimeDeleted", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "delItemEntityTable", "columnName": "delItemEntityTable", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "delItemEntityUid", "columnName": "delItemEntityUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "delItemDeletedByPersonUid", "columnName": "delItemDeletedByPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "delItemStatus", "columnName": "delItemStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "delItemIsFolder", "columnName": "delItemIsFolder", "affinity": "INTEGER", "notNull": true, "defaultValue": "0" } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "delItemUid" ] }, "indices": [ { "name": "delitem_idx_status_time", "unique": false, "columnNames": [ "delItemStatus", "delItemTimeDeleted" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `delitem_idx_status_time` ON `${TABLE_NAME}` (`delItemStatus`, `delItemTimeDeleted`)" } ], "foreignKeys": [] }, { "tableName": "EnrolmentRequest", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`erUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `erClazzUid` INTEGER NOT NULL, `erClazzName` TEXT, `erPersonUid` INTEGER NOT NULL, `erPersonFullname` TEXT, `erPersonPictureUri` TEXT, `erPersonUsername` TEXT, `erRole` INTEGER NOT NULL, `erRequestTime` INTEGER NOT NULL, `erStatus` INTEGER NOT NULL, `erStatusSetByPersonUid` INTEGER NOT NULL, `erDeleted` INTEGER NOT NULL, `erStatusSetAuth` TEXT, `erLastModified` INTEGER NOT NULL)", "fields": [ { "fieldPath": "erUid", "columnName": "erUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erClazzUid", "columnName": "erClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erClazzName", "columnName": "erClazzName", "affinity": "TEXT", "notNull": false }, { "fieldPath": "erPersonUid", "columnName": "erPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erPersonFullname", "columnName": "erPersonFullname", "affinity": "TEXT", "notNull": false }, { "fieldPath": "erPersonPictureUri", "columnName": "erPersonPictureUri", "affinity": "TEXT", "notNull": false }, { "fieldPath": "erPersonUsername", "columnName": "erPersonUsername", "affinity": "TEXT", "notNull": false }, { "fieldPath": "erRole", "columnName": "erRole", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erRequestTime", "columnName": "erRequestTime", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erStatus", "columnName": "erStatus", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erStatusSetByPersonUid", "columnName": "erStatusSetByPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erDeleted", "columnName": "erDeleted", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "erStatusSetAuth", "columnName": "erStatusSetAuth", "affinity": "TEXT", "notNull": false }, { "fieldPath": "erLastModified", "columnName": "erLastModified", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "erUid" ] }, "indices": [ { "name": "idx_enrolmentrequest_by_clazz", "unique": false, "columnNames": [ "erClazzUid", "erStatus" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_enrolmentrequest_by_clazz` ON `${TABLE_NAME}` (`erClazzUid`, `erStatus`)" }, { "name": "idx_enrolmentrequest_by_person", "unique": false, "columnNames": [ "erPersonUid", "erStatus" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_enrolmentrequest_by_person` ON `${TABLE_NAME}` (`erPersonUid`, `erStatus`)" } ], "foreignKeys": [] }, { "tableName": "CoursePermission", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`cpUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `cpLastModified` INTEGER NOT NULL, `cpClazzUid` INTEGER NOT NULL, `cpToEnrolmentRole` INTEGER NOT NULL, `cpToPersonUid` INTEGER NOT NULL, `cpToGroupUid` INTEGER NOT NULL, `cpPermissionsFlag` INTEGER NOT NULL, `cpIsDeleted` INTEGER NOT NULL)", "fields": [ { "fieldPath": "cpUid", "columnName": "cpUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cpLastModified", "columnName": "cpLastModified", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cpClazzUid", "columnName": "cpClazzUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cpToEnrolmentRole", "columnName": "cpToEnrolmentRole", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cpToPersonUid", "columnName": "cpToPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cpToGroupUid", "columnName": "cpToGroupUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cpPermissionsFlag", "columnName": "cpPermissionsFlag", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "cpIsDeleted", "columnName": "cpIsDeleted", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "cpUid" ] }, "indices": [ { "name": "idx_coursepermission_clazzuid", "unique": false, "columnNames": [ "cpClazzUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_coursepermission_clazzuid` ON `${TABLE_NAME}` (`cpClazzUid`)" } ], "foreignKeys": [] }, { "tableName": "SystemPermission", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`spUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `spToPersonUid` INTEGER NOT NULL, `spToGroupUid` INTEGER NOT NULL, `spPermissionsFlag` INTEGER NOT NULL, `spLastModified` INTEGER NOT NULL, `spIsDeleted` INTEGER NOT NULL)", "fields": [ { "fieldPath": "spUid", "columnName": "spUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "spToPersonUid", "columnName": "spToPersonUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "spToGroupUid", "columnName": "spToGroupUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "spPermissionsFlag", "columnName": "spPermissionsFlag", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "spLastModified", "columnName": "spLastModified", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "spIsDeleted", "columnName": "spIsDeleted", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "spUid" ] }, "indices": [ { "name": "idx_systempermission_personuid", "unique": false, "columnNames": [ "spToPersonUid" ], "orders": [], "createSql": "CREATE INDEX IF NOT EXISTS `idx_systempermission_personuid` ON `${TABLE_NAME}` (`spToPersonUid`)" } ], "foreignKeys": [] }, { "tableName": "OutgoingReplication", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`orUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `destNodeId` INTEGER NOT NULL, `orTableId` INTEGER NOT NULL, `orPk1` INTEGER NOT NULL, `orPk2` INTEGER NOT NULL)", "fields": [ { "fieldPath": "orUid", "columnName": "orUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "destNodeId", "columnName": "destNodeId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "orTableId", "columnName": "orTableId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "orPk1", "columnName": "orPk1", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "orPk2", "columnName": "orPk2", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "orUid" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "ReplicationOperation", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`repOpRemoteNodeId` INTEGER NOT NULL, `repOpTableId` INTEGER NOT NULL, `repOpStatus` INTEGER NOT NULL, PRIMARY KEY(`repOpRemoteNodeId`, `repOpTableId`))", "fields": [ { "fieldPath": "repOpRemoteNodeId", "columnName": "repOpRemoteNodeId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "repOpTableId", "columnName": "repOpTableId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "repOpStatus", "columnName": "repOpStatus", "affinity": "INTEGER", "notNull": true } ], "primaryKey": { "autoGenerate": false, "columnNames": [ "repOpRemoteNodeId", "repOpTableId" ] }, "indices": [], "foreignKeys": [] }, { "tableName": "PendingRepositorySession", "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`rsUid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `remoteNodeId` INTEGER NOT NULL, `endpointUrl` TEXT)", "fields": [ { "fieldPath": "rsUid", "columnName": "rsUid", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "remoteNodeId", "columnName": "remoteNodeId", "affinity": "INTEGER", "notNull": true }, { "fieldPath": "endpointUrl", "columnName": "endpointUrl", "affinity": "TEXT", "notNull": false } ], "primaryKey": { "autoGenerate": true, "columnNames": [ "rsUid" ] }, "indices": [], "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, 'abd4ed3f5c06497ed4cc81b8010abf18')" ] } }