organismgroup

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
organismgroup_id serial 10 √ nextval('sgn.organismgroup_organismgroup_id_seq'::regclass)
organismgroup_member.organismgroup_id organismgroup_member_organismgroup_id_fkey R
name varchar 255 √ null
type varchar 32 √ null

Indexes

Constraint Name Type Sort Column(s)
organismgroup_pkey Primary key Asc organismgroup_id

Check Constraints

Constraint Name Constraint
organismgroup_type_check ((((type)::text = 'common name'::text) OR ((type)::text = 'unigene build'::text) OR ((type)::text = ''::text)))

Relationships

Close relationships within degrees of separation