Last active
March 21, 2023 12:03
-
-
Save fischerscode/8439fa1d903a041b46bbe0c62a50c6a6 to your computer and use it in GitHub Desktop.
getCurrentDatabaseDefinition for serverpod_test_server
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "serverpod_test", | |
| "tables": [ | |
| { | |
| "name": "serverpod_auth_key", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_auth_key_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "hash", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "scopeNames", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "method", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_auth_key_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_auth_key_userid_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "userId" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_cloud_storage", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_cloud_storage_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "storageId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "path", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "addedTime", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "expiration", | |
| "columnType": 4, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "byteData", | |
| "columnType": 5, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "verified", | |
| "columnType": 1, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_cloud_storage_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_cloud_storage_path_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "storageId" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "path" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_cloud_storage_expiration", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "expiration" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_cloud_storage_direct_upload", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_cloud_storage_direct_upload_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "storageId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "path", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "expiration", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "authKey", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_cloud_storage_direct_upload_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_cloud_storage_direct_upload_storage_path", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "storageId" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "path" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_future_call", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_future_call_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "name", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "time", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serializedObject", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serverId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "identifier", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_future_call_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_future_call_time_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "time" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_future_call_serverid_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "serverId" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_future_call_identifier_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "identifier" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_health_connection_info", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_health_connection_info_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serverId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "timestamp", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "active", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "closing", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "idle", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "granularity", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_health_connection_info_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_health_connection_info_timestamp_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "timestamp" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "serverId" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "granularity" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_health_metric", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_health_metric_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "name", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serverId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "timestamp", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "isHealthy", | |
| "columnType": 1, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "value", | |
| "columnType": 3, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "granularity", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_health_metric_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_health_metric_timestamp_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "timestamp" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "serverId" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "name" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "granularity" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_method", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_method_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "endpoint", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "method", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_method_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_method_endpoint_method_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "endpoint" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "method" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_readwrite_test", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_readwrite_test_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "number", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_readwrite_test_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_runtime_settings", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_runtime_settings_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "logSettings", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "logSettingsOverrides", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "logServiceCalls", | |
| "columnType": 1, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "logMalformedCalls", | |
| "columnType": 1, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_runtime_settings_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_session_log", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_session_log_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serverId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "time", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "module", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "endpoint", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "method", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "duration", | |
| "columnType": 3, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "numQueries", | |
| "columnType": 2, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "slow", | |
| "columnType": 1, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "error", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "stackTrace", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "authenticatedUserId", | |
| "columnType": 2, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "isOpen", | |
| "columnType": 1, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "touched", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_session_log_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_session_log_serverid_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "serverId" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_session_log_touched_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "touched" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_session_log_isopen_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "isOpen" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_query_log", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_query_log_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serverId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "sessionLogId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "messageId", | |
| "columnType": 2, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "query", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "duration", | |
| "columnType": 3, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "numRows", | |
| "columnType": 2, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "error", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "stackTrace", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "slow", | |
| "columnType": 1, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "order", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [ | |
| { | |
| "constraintName": "serverpod_query_log_fk_0", | |
| "columns": [ | |
| "sessionLogId" | |
| ], | |
| "referenceTable": "serverpod_session_log", | |
| "referenceColumns": [ | |
| "id" | |
| ], | |
| "onUpdate": 3, | |
| "onDelete": 4, | |
| "matchType": 2 | |
| } | |
| ], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_query_log_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_query_log_sessionlogid_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "sessionLogId" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_message_log", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_message_log_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "sessionLogId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serverId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "messageId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "endpoint", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "messageName", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "duration", | |
| "columnType": 3, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "error", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "stackTrace", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "slow", | |
| "columnType": 1, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "order", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [ | |
| { | |
| "constraintName": "serverpod_message_log_fk_0", | |
| "columns": [ | |
| "sessionLogId" | |
| ], | |
| "referenceTable": "serverpod_session_log", | |
| "referenceColumns": [ | |
| "id" | |
| ], | |
| "onUpdate": 3, | |
| "onDelete": 4, | |
| "matchType": 2 | |
| } | |
| ], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_message_log_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_log", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_log_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "sessionLogId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "messageId", | |
| "columnType": 2, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "reference", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "serverId", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "time", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "logLevel", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "message", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "error", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "stackTrace", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "order", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [ | |
| { | |
| "constraintName": "serverpod_log_fk_0", | |
| "columns": [ | |
| "sessionLogId" | |
| ], | |
| "referenceTable": "serverpod_session_log", | |
| "referenceColumns": [ | |
| "id" | |
| ], | |
| "onUpdate": 3, | |
| "onDelete": 4, | |
| "matchType": 2 | |
| } | |
| ], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_log_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_log_sessionlogid_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "sessionLogId" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_email_auth", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_email_auth_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "email", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "hash", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_email_auth_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_email_auth_email", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "email" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_email_create_request", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_email_create_request_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userName", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "email", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "hash", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "verificationCode", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_email_create_request_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_email_auth_create_account_request_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "email" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_email_failed_sign_in", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_email_failed_sign_in_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "email", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "time", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "ipAddress", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_email_failed_sign_in_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_email_failed_sign_in_email_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "email" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_email_failed_sign_in_time_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "time" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_email_reset", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_email_reset_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "verificationCode", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "expiration", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_email_reset_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_email_reset_verification_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "verificationCode" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_google_refresh_token", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_google_refresh_token_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "refreshToken", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_google_refresh_token_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_google_refresh_token_userid_idx", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "userId" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_user_image", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_user_image_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userId", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "version", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "url", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_user_image_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_user_image_user_id", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "userId" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "version" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "serverpod_user_info", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('serverpod_user_info_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userIdentifier", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "userName", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "fullName", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "email", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "created", | |
| "columnType": 4, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "imageUrl", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "scopeNames", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "blocked", | |
| "columnType": 1, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "serverpod_user_info_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_user_info_user_identifier", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "userIdentifier" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": false, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "serverpod_user_info_email", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "email" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_field_scopes", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_field_scopes_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "normal", | |
| "columnType": 0, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "database", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "object_field_scopes_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_with_bytedata", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_with_bytedata_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "byteData", | |
| "columnType": 5, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "object_with_bytedata_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_with_duration", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_with_duration_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "duration", | |
| "columnType": 6, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "object_with_duration_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_with_enum", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_with_enum_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "testEnum", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "nullableEnum", | |
| "columnType": 2, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "enumList", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "nullableEnumList", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "enumListList", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "object_with_enum_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_with_index", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_with_index_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "indexed", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "indexed2", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "object_with_index_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| }, | |
| { | |
| "indexName": "object_with_index_test_index", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "indexed" | |
| }, | |
| { | |
| "type": 0, | |
| "definition": "indexed2" | |
| } | |
| ], | |
| "type": "brin", | |
| "isUnique": false, | |
| "isPrimary": false, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_with_object", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_with_object_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "data", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "nullableData", | |
| "columnType": 8, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "dataList", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "nullableDataList", | |
| "columnType": 8, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "listWithNullableData", | |
| "columnType": 8, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "nullableListWithNullableData", | |
| "columnType": 8, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "object_with_object_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_with_parent", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_with_parent_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "other", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [ | |
| { | |
| "constraintName": "object_with_parent_fk_0", | |
| "columns": [ | |
| "other" | |
| ], | |
| "referenceTable": "object_field_scopes", | |
| "referenceColumns": [ | |
| "id" | |
| ], | |
| "onUpdate": 3, | |
| "onDelete": 4, | |
| "matchType": 2 | |
| } | |
| ], | |
| "indexes": [ | |
| { | |
| "indexName": "object_with_parent_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "object_with_uuid", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('object_with_uuid_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "uuid", | |
| "columnType": 7, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "uuidNullable", | |
| "columnType": 7, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "object_with_uuid_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "simple_data", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('simple_data_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "num", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "simple_data_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| }, | |
| { | |
| "name": "types", | |
| "schema": "public", | |
| "tableSpace": null, | |
| "columns": [ | |
| { | |
| "name": "id", | |
| "columnType": 2, | |
| "isNullable": false, | |
| "columnDefault": "nextval('types_id_seq'::regclass)", | |
| "dartType": null | |
| }, | |
| { | |
| "name": "anInt", | |
| "columnType": 2, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "aBool", | |
| "columnType": 1, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "aDouble", | |
| "columnType": 3, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "aDateTime", | |
| "columnType": 4, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "aString", | |
| "columnType": 0, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "aByteData", | |
| "columnType": 5, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "aDuration", | |
| "columnType": 6, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| }, | |
| { | |
| "name": "aUuid", | |
| "columnType": 7, | |
| "isNullable": true, | |
| "columnDefault": null, | |
| "dartType": null | |
| } | |
| ], | |
| "foreignKeys": [], | |
| "indexes": [ | |
| { | |
| "indexName": "types_pkey", | |
| "tableSpace": null, | |
| "elements": [ | |
| { | |
| "type": 0, | |
| "definition": "id" | |
| } | |
| ], | |
| "type": "btree", | |
| "isUnique": true, | |
| "isPrimary": true, | |
| "predicate": null | |
| } | |
| ], | |
| "managed": null | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment