Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| accession_id | int8 | 19 | null |
|
|
||||||
| position | int4 | 10 | null |
|
|
||||||
| name | text | 2147483647 | null |
|
|
||||||
| organization_id | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| accession_collectors_pkey | Primary key | Asc/Asc | accession_id + position |
| accession_collectors_organization_id_name_idx | Performance | Asc/Asc | organization_id + name |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| accession_collectors_position_check | ("position" >= 0) |
| name_not_empty | (length(name) > 0) |
| name_whitespace | ((name !~ ('\s\s'::text COLLATE "en-x-icu")) AND (name !~ ('^\s'::text COLLATE "en-x-icu")) AND (name !~ ('\s$'::text COLLATE "en-x-icu"))) |