projects_project


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('projects_project_id_seq'::regclass)
alerts_projectalert.project_id alerts_projectalert_project_id_d72e26b7_fk_projects_project_id R
difs_debuginformationfile.project_id difs_debuginformatio_project_id_98b3bcff_fk_projects_ R
environments_environmentproject.project_id environments_environ_project_id_f1b49983_fk_projects_ R
issues_issue.project_id issues_issue_project_id_4b0f3e2f_fk_projects_project_id R
performance_transactiongroup.project_id performance_transact_project_id_0d3abdaf_fk_projects_ R
projects_projectcounter.project_id projects_projectcoun_project_id_c04e0a63_fk_projects_ R
projects_projectkey.project_id projects_projectkey_project_id_4643220b_fk_projects_project_id R
releases_release_projects.project_id releases_release_pro_project_id_375a83f0_fk_projects_ R
releases_releaseproject.project_id releases_releaseproj_project_id_69d8217c_fk_projects_ R
teams_team_projects.project_id teams_team_projects_project_id_66bc9dde_fk_projects_project_id R
uptime_monitor.project_id uptime_monitor_project_id_99a888b1_fk_projects_project_id R
user_reports_userreport.project_id user_reports_userrep_project_id_2625dd63_fk_projects_ R
users_userprojectalert.project_id users_userprojectale_project_id_ed3bf990_fk_projects_ R
slug varchar 50 null
name varchar 64 null
created timestamptz 35,6 null
platform varchar 64 √ null
organization_id int4 10 null
organizations_ext_organization.id projects_project_organization_id_c93e5ca2_fk_organizat R
first_event timestamptz 35,6 √ null
scrub_ip_addresses bool 1 null

Indexes

Constraint Name Type Sort Column(s)
projects_project_pkey Primary key Asc id
projects_project_created_857f80bc Performance Asc created
projects_project_organization_id_c93e5ca2 Performance Asc organization_id
projects_project_organization_id_slug_ccb1507a_uniq Must be unique Asc/Asc organization_id + slug
projects_project_slug_2d50067a Performance Asc slug
projects_project_slug_2d50067a_like Performance Asc slug

Relationships

Close relationships within degrees of separation