bac_status

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
bac_status_id bigserial 19 √ nextval('sgn_people.bac_status_bac_status_id_seq'::regclass)
bac_id int8 19 √ null
person_id int8 19 √ null
sp_person.sp_person_id person_id_fk R
status varchar 13 √ null
genbank_status varchar 5 √ null
timestamp timestamp 29,6 ('now'::text)::timestamp(6) with time zone

Indexes

Constraint Name Type Sort Column(s)
bac_status_pkey Primary key Asc bac_status_id
bac_id_key Must be unique Asc bac_id
bac_status_idx Performance Asc/Asc bac_id + status
status_idx Performance Asc status

Check Constraints

Constraint Name Constraint
chk_bac_status_genbank_status ((((genbank_status)::text = 'htgs1'::text) OR ((genbank_status)::text = 'htgs2'::text) OR ((genbank_status)::text = 'htgs3'::text) OR ((genbank_status)::text = 'htgs4'::text) OR ((genbank_status)::text = ''::text) OR (genbank_status IS NULL)))
chk_bac_status_status ((((status)::text = 'not_sequenced'::text) OR ((status)::text = 'in_progress'::text) OR ((status)::text = 'complete'::text) OR ((status)::text = ''::text) OR (status IS NULL)))

Relationships

Close relationships within degrees of separation