releases

31 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('releases_id_seq'::regclass)
release_actor_node_inds.release_id release_actor_node_inds_release_id_fkey R
release_actor_node_quals.release_id release_actor_node_quals_release_id_fkey R
release_actor_node_quants.release_id release_actor_node_quants_release_id_fkey R
release_context_node_inds.release_id release_node_inds_release_id_fkey R
release_context_node_quals.release_id release_node_quals_release_id_fkey R
release_context_node_quants.release_id release_node_quants_release_id_fkey R
release_country_node_inds.release_id release_country_node_inds_release_id_fkey R
release_country_node_quals.release_id release_country_node_quals_release_id_fkey R
release_country_node_quants.release_id release_country_node_quants_release_id_fkey R
release_flows_references.release_id release_refs_release_id_fkey R
release_in_tables.release_id release_in_tables_release_id_fkey R
symbol text 2147483647 √ null
current bool 1 √ null
description text 2147483647 √ null
public bool 1 √ null
official bool 1 √ null

Indexes

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

Check Constraints

Constraint Name Constraint
at_most_one_release_current ( CASE WHEN (current <> true) THEN true ELSE (NOT already_current_release(id)) END)
at_most_one_release_public ( CASE WHEN (public <> true) THEN true ELSE (NOT already_public_release(id)) END)

Relationships

Close relationships within degrees of separation