projects


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('projects_id_seq'::regclass)
label_tree_authorized_project.project_id label_tree_authorized_project_project_id_foreignC
label_tree_project.project_id label_tree_project_project_id_foreignC
pending_volumes.project_id pending_volumes_project_id_foreignC
project_invitations.project_id project_invitations_project_id_foreignC
project_user.project_id project_user_project_id_foreignC
project_volume.project_id project_transect_project_id_foreignR
name varchar 512 null
description text 2147483647 null
creator_id int4 10 √ null
users.id projects_creator_id_foreignN
created_at timestamp 22 √ null
updated_at timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
projects_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation