authorised_values

0 rows


Columns

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

unique key, used to identify the authorized value

category VARCHAR 32
authorised_value_categories.category_name authorised_values_authorised_values_categoryC

key used to identify the authorized value category

authorised_value VARCHAR 80
illrequests.status_alias illrequests_safkN

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