app/schemas/com.futsch1.medtimer.database.MedicineRoomDatabase/2.json
{
"formatVersion": 1,
"database": {
"version": 2,
"identityHash": "7db46ae71507b9d6ca1f4e46de51a762",
"entities": [
{
"tableName": "Medicine",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`medicineName` TEXT, `medicineId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)",
"fields": [
{
"fieldPath": "name",
"columnName": "medicineName",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "medicineId",
"columnName": "medicineId",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"autoGenerate": true,
"columnNames": [
"medicineId"
]
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "Reminder",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`medicineRelId` INTEGER NOT NULL, `reminderId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `timeInMinutes` INTEGER NOT NULL, `createdTimestamp` INTEGER NOT NULL DEFAULT 0, `amount` TEXT)",
"fields": [
{
"fieldPath": "medicineRelId",
"columnName": "medicineRelId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "reminderId",
"columnName": "reminderId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "timeInMinutes",
"columnName": "timeInMinutes",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "createdTimestamp",
"columnName": "createdTimestamp",
"affinity": "INTEGER",
"notNull": true,
"defaultValue": "0"
},
{
"fieldPath": "amount",
"columnName": "amount",
"affinity": "TEXT",
"notNull": false
}
],
"primaryKey": {
"autoGenerate": true,
"columnNames": [
"reminderId"
]
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "ReminderEvent",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`reminderEventId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `medicineName` TEXT, `amount` TEXT, `status` TEXT, `remindedTimestamp` INTEGER NOT NULL, `processedTimestamp` INTEGER NOT NULL, `reminderId` INTEGER NOT NULL)",
"fields": [
{
"fieldPath": "reminderEventId",
"columnName": "reminderEventId",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "medicineName",
"columnName": "medicineName",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "amount",
"columnName": "amount",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "status",
"columnName": "status",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "remindedTimestamp",
"columnName": "remindedTimestamp",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "processedTimestamp",
"columnName": "processedTimestamp",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "reminderId",
"columnName": "reminderId",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"autoGenerate": true,
"columnNames": [
"reminderEventId"
]
},
"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, '7db46ae71507b9d6ca1f4e46de51a762')"
]
}
}