Skip to content

Instantly share code, notes, and snippets.

@fischerscode
Last active March 21, 2023 12:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fischerscode/8439fa1d903a041b46bbe0c62a50c6a6 to your computer and use it in GitHub Desktop.
Save fischerscode/8439fa1d903a041b46bbe0c62a50c6a6 to your computer and use it in GitHub Desktop.
getCurrentDatabaseDefinition for serverpod_test_server
{
"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