project


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('project_id_seq'::regclass)
projecttenantlink.project_id projecttenantlink_project_id_fkey R
savedquery.project_id savedquery_project_id_fkey R
summarypage.project_id summarypage_project_id_fkey R
survey.project_id survey_project_id_fkey R
uuid varchar 2147483647 null
name varchar 2147483647 null
description varchar 2147483647 √ null
r varchar 2147483647 null
path varchar 2147483647 √ null
by_variable varchar 2147483647 √ null
table_name varchar 2147483647 √ null
filename_pattern varchar 2147483647 √ null
is_ready_for_data int4 10 null
is_legacy int4 10 null
is_shareable int4 10 null
is_active int4 10 null
is_favorite int4 10 null
is_complete int4 10 null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null

Indexes

Constraint Name Type Sort Column(s)
project_pkey Primary key Asc id
project_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation