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 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