releases_release


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('releases_release_id_seq'::regclass)
events_event.release_id issues_event_release_id_19c73b66_fk_releases_release_id R
releases_release_projects.release_id releases_release_pro_release_id_7053dee2_fk_releases_ R
releases_releasefile.release_id releases_releasefile_release_id_a20b1af5_fk_releases_release_id R
releases_releaseproject.release_id releases_releaseproj_release_id_962ac218_fk_releases_ R
version varchar 255 null
ref varchar 255 √ null
url varchar 200 √ null
created timestamptz 35,6 null
released timestamptz 35,6 √ null
data jsonb 2147483647 null
commit_count int2 5 null
deploy_count int2 5 null
organization_id int4 10 null
organizations_ext_organization.id releases_release_organization_id_d23b0b80_fk_organizat R
owner_id int4 10 √ null
users_user.id releases_release_owner_id_0dd1b0e8_fk_users_user_id R

Indexes

Constraint Name Type Sort Column(s)
releases_release_pkey Primary key Asc id
releases_release_created_e98aff08 Performance Asc created
releases_release_organization_id_d23b0b80 Performance Asc organization_id
releases_release_organization_id_version_3bc93805_uniq Must be unique Asc/Asc organization_id + version
releases_release_owner_id_0dd1b0e8 Performance Asc owner_id

Check Constraints

Constraint Name Constraint
releases_release_deploy_count_check ((deploy_count >= 0))
releases_release_commit_count_check ((commit_count >= 0))

Relationships

Close relationships within degrees of separation