database_info


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uuid uuid 2147483647 gen_random_uuid()
connection.id_database connection_id_database_fkey C
dashboard.id_database dashboard_id_database_fkey C
role.id_database role_id_database_fkey C
schema_info.id_database schema_info_id_database_fkey C
shared_query.id_database shared_query_id_database_fkey C
name text 2147483647 null

The actual name of this database
alias text 2147483647 null

An alias for this database that may be found in legacy DDL files
created_on timestamptz 35,6 now()
updated_on timestamptz 35,6 now()
version int8 19 1
is_default bool 1 false

True if this is the default database
id_owned_by uuid 2147483647 null
user.uuid database_info_id_owned_by_fkey R

Table contained 2 rows

Indexes

Constraint Name Type Sort Column(s)
database_info_pkey Primary key Asc uuid
uk_md_db Must be unique
uk_md_db_alias Must be unique

Relationships

Close relationships within degrees of separation