managed_table


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dtype text 2147483647 null
uuid uuid 2147483647 gen_random_uuid()
managed_table_column.id_managed_table managed_table_column_id_managed_table_fkey C
periodic_statement_status.id_managed_table periodic_statement_status_id_managed_table_fkey C
widget.tableid widget_tableid_fkey R
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
id serial 10 √ nextval('warehouse.managed_table_id_seq'::regclass)
filemon_config.id Implied Constraint R
npartitions int4 10 4
parserspec text 2147483647 √ null
periodicstatementperiod text 2147483647 √ null
periodicstatementstatement text 2147483647 √ null
query text 2147483647 √ null
extschemaname text 2147483647 √ null
exttablename text 2147483647 √ null
id_owned_by uuid 2147483647 null
user.uuid managed_table_id_owned_by_fkey R
id_schema uuid 2147483647 null
schema_info.uuid managed_table_id_schema_fkey C
extconn_uuid uuid 2147483647 √ null
connection.uuid managed_table_extconn_uuid_fkey C
source text 2147483647 √ null

Table contained 133 rows

Indexes

Constraint Name Type Sort Column(s)
managed_table_pkey Primary key Asc uuid
uk_md_table Must be unique Asc id_schema

Relationships

Close relationships within degrees of separation