authorised_values

505 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
authorised_values_branches.av_id authorised_values_branches_ibfk_1 C

unique key, used to identify the authorized value
category VARCHAR 32 ''
authorised_value_categories.category_name authorised_values_authorised_values_category C

key used to identify the authorized value category
authorised_value VARCHAR 80 ''
illrequests.status_alias illrequests_safk N

code use to identify the authorized value
lib VARCHAR 200 √ NULL

authorized value description as printed in the staff interface
lib_opac VARCHAR 200 √ NULL

authorized value description as printed in the OPAC
imageurl VARCHAR 200 √ NULL

authorized value URL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
auth_value_idx Performance Asc authorised_value
av_uniq Must be unique Asc/Asc category + authorised_value
lib Performance Asc lib
name Performance Asc category

Relationships

Close relationships within degrees of separation