app/schemas/com.futsch1.medtimer.database.MedicineRoomDatabase/1.json
{
"formatVersion": 1,
"database": {
"version": 1,
"identityHash": "2025777bf7a0a4fb50e4c45a4b62894e",
"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, `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": "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, `raisedTimestamp` 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": "raisedTimestamp",
"columnName": "raisedTimestamp",
"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, '2025777bf7a0a4fb50e4c45a4b62894e')"
]
}
}