Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
id | INT | 10 | √ | null |
|
|
unique key, used to identify the authorized value |
||||
category | VARCHAR | 32 |
|
|
key used to identify the authorized value category |
||||||
authorised_value | VARCHAR | 80 |
|
|
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 |