bac_status_log

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
bac_status_log_id bigserial 19 √ nextval('sgn_people.bac_status_log_bac_status_log_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_log_id_key Primary key Asc bac_status_log_id

Check Constraints

Constraint Name Constraint
chk_bac_status_log_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)))
chk_bac_status_log_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)))

Relationships

Close relationships within degrees of separation