qnvr5yZY

1  "tableName": "motivation_groups",
2        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`uid` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `user_id` INTEGER NOT NULL, `group_id` TEXT, FOREIGN KEY(`user_id`) REFERENCES `users`(`uid`) ON UPDATE NO ACTION ON DELETE CASCADE )",
3        "fields": [
4          {
5            "fieldPath": "uid",
6            "columnName": "uid",
7            "affinity": "INTEGER",
8            "notNull": true
9          },
10          {
11            "fieldPath": "userId",
12            "columnName": "user_id",
13            "affinity": "INTEGER",
14            "notNull": true
15          },
16          {
17            "fieldPath": "groupId",
18            "columnName": "group_id",
19            "affinity": "TEXT",
20            "notNull": false
21          }
22        ],
23        "primaryKey": {
24          "columnNames": [
25            "uid"
26          ],
27          "autoGenerate": true
28        },
29        "indices": [
30          {
31            "name": "index_motivation_groups_user_id",
32            "unique": false,
33            "columnNames": [
34              "user_id"
35            ],
36            "createSql": "CREATE  INDEX `index_motivation_groups_user_id` ON `${TABLE_NAME}` (`user_id`)"
37          }
38        ],
39        "foreignKeys": [
40          {
41            "table": "users",
42            "onDelete": "CASCADE",
43            "onUpdate": "NO ACTION",
44            "columns": [
45              "user_id"
46            ],
47            "referencedColumns": [
48              "uid"
49            ]
50          }
51        ]
52      }
53    ],