shared_query


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uuid uuid 2147483647 gen_random_uuid()
comment text 2147483647 √ null
created_on timestamptz 35,6 now()
props jsonb 2147483647 √ null
tags jsonb 2147483647 √ null
updated_on timestamptz 35,6 now()
version int8 19 1
certified bool 1 false
name text 2147483647 null
operations jsonb 2147483647 √ null
mode text 2147483647 √ null
parameters jsonb 2147483647 √ null
query text 2147483647 √ null
ttl text 2147483647 √ null
intervalstart text 2147483647 √ null
intervalend text 2147483647 √ null
results text 2147483647 √ null
id_owned_by uuid 2147483647 null
user.uuid shared_query_id_owned_by_fkey R
id_database uuid 2147483647 null
database_info.uuid shared_query_id_database_fkey C
source text 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
shared_query_pkey Primary key Asc uuid
uk_md_shared_query Must be unique Asc id_database

Relationships

Close relationships within degrees of separation