identifier_sequences

-1 rows


Description

Current state for generating user-facing identifiers (accession number, etc.) for each organization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_id int8 19 null
organizations.id identifier_sequences_organization_id_fkey C
prefix text 2147483647 null
next_value int8 19 null

Indexes

Constraint Name Type Sort Column(s)
identifier_sequences_pkey Primary key Asc/Asc organization_id + prefix

Relationships

Close relationships within degrees of separation