card

380 rows


Description

Library Cards

Each User has one or more library cards. The current “main” card is linked to here from the actor.usr table, and it is up to the consortium policy whether more than one card can be active for any one user at a given time.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.card_id_seq'::regclass)
usr int4 10 null
usr.id card_usr_fkey R
barcode text 2147483647 null
active bool 1 true

Indexes

Constraint Name Type Sort Column(s)
card_pkey Primary key Asc id
actor_card_barcode_evergreen_lowercase_idx Performance
actor_card_usr_idx Performance Asc usr
card_barcode_key Must be unique Asc barcode

Relationships

Close relationships within degrees of separation