accession_collectors

0 rows


Description

Names of people who collected each accession.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
accession_id int8 19 null
accessions.id accession_collectors_accession_id_fkeyC
position int4 10 null
name text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
accession_collectors_pkey Primary key Asc/Asc accession_id + position

Check Constraints

Constraint Name Constraint
accession_collectors_position_check (("position" >= 0))
accession_collectors_name_check ((name !~ similar_to_escape('\s*'::text)))

Relationships