nCiqydFD

1{
2  "formatVersion": 1,
3  "database": {
4    "version": 1,
5    "identityHash": "f0cd29d11d4a03881fedffb2c12feb23",
6    "entities": [
7      {
8        "tableName": "Certificates",
9        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `userId` INTEGER NOT NULL, `title` TEXT, `description` TEXT, `dateCreated` TEXT, `expirationDate` TEXT, `certificateLink` TEXT, `deliveryStatus` INTEGER, PRIMARY KEY(`id`), FOREIGN KEY(`userId`) REFERENCES `Users`(`id`) ON UPDATE SET NULL ON DELETE SET NULL )",
10        "fields": [
11          {
12            "fieldPath": "id",
13            "columnName": "id",
14            "affinity": "INTEGER",
15            "notNull": true
16          },
17          {
18            "fieldPath": "userId",
19            "columnName": "userId",
20            "affinity": "INTEGER",
21            "notNull": true
22          },
23          {
24            "fieldPath": "title",
25            "columnName": "title",
26            "affinity": "TEXT",
27            "notNull": false
28          },
29          {
30            "fieldPath": "description",
31            "columnName": "description",
32            "affinity": "TEXT",
33            "notNull": false
34          },
35          {
36            "fieldPath": "dateCreated",
37            "columnName": "dateCreated",
38            "affinity": "TEXT",
39            "notNull": false
40          },
41          {
42            "fieldPath": "expirationDate",
43            "columnName": "expirationDate",
44            "affinity": "TEXT",
45            "notNull": false
46          },
47          {
48            "fieldPath": "certificateLink",
49            "columnName": "certificateLink",
50            "affinity": "TEXT",
51            "notNull": false
52          },
53          {
54            "fieldPath": "deliveryStatus",
55            "columnName": "deliveryStatus",
56            "affinity": "INTEGER",
57            "notNull": false
58          }
59        ],
60        "primaryKey": {
61          "columnNames": [
62            "id"
63          ],
64          "autoGenerate": false
65        },
66        "indices": [],
67        "foreignKeys": [
68          {
69            "table": "Users",
70            "onDelete": "SET NULL",
71            "onUpdate": "SET NULL",
72            "columns": [
73              "userId"
74            ],
75            "referencedColumns": [
76              "id"
77            ]
78          }
79        ]
80      },
81      {
82        "tableName": "Users",
83        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `firstName` TEXT, `lastName` TEXT, `email` TEXT, `password` TEXT, PRIMARY KEY(`id`))",
84        "fields": [
85          {
86            "fieldPath": "id",
87            "columnName": "id",
88            "affinity": "INTEGER",
89            "notNull": true
90          },
91          {
92            "fieldPath": "firstName",
93            "columnName": "firstName",
94            "affinity": "TEXT",
95            "notNull": false
96          },
97          {
98            "fieldPath": "lastName",
99            "columnName": "lastName",
100            "affinity": "TEXT",
101            "notNull": false
102          },
103          {
104            "fieldPath": "email",
105            "columnName": "email",
106            "affinity": "TEXT",
107            "notNull": false
108          },
109          {
110            "fieldPath": "password",
111            "columnName": "password",
112            "affinity": "TEXT",
113            "notNull": false
114          }
115        ],
116        "primaryKey": {
117          "columnNames": [
118            "id"
119          ],
120          "autoGenerate": false
121        },
122        "indices": [],
123        "foreignKeys": []
124      }
125    ],
126    "setupQueries": [
127      "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
128      "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"f0cd29d11d4a03881fedffb2c12feb23\")"
129    ]
130  }
131}