config.identification_type

Types of valid patron identification.

Each patron must display at least one valid form of identification in order to get a library card. This table lists those forms.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.identification_type_id_seq'::regclass)
name	`text`	No

id PK

integer

nextval('config.identification_type_id_seq'::regclass)

name

text

(id)

Index Method Definition

Index	Method	Definition
`identification_type_pkey` PK	btree	`CREATE UNIQUE INDEX identification_type_pkey ON config.identification_type USING btree (id)`
`identification_type_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX identification_type_name_key ON config.identification_type USING btree (name)`

identification_type_pkey PK

btree

CREATE UNIQUE INDEX identification_type_pkey ON config.identification_type USING btree (id)

identification_type_name_key UNIQUE

btree

CREATE UNIQUE INDEX identification_type_name_key ON config.identification_type USING btree (name)

The following tables have foreign keys pointing to config.identification_type (2 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
actor.usr	`ident_type`	`id`	`usr_ident_type_fkey`
actor.usr	`ident_type2`	`id`	`usr_ident_type2_fkey`

ident_type

id

usr_ident_type_fkey

ident_type2

id

usr_ident_type2_fkey