Table testsql_comments.branchcategories
information related to library/branch groups

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
categorycode varchar 10
branchrelations
unique identifier for the library/branch group
categoryname varchar 32  √  null name of the library/branch group
codedescription mediumtext 16777215  √  null longer description of the library/branch group
categorytype varchar 16  √  null says whether this is a search group or a properties group
show_in_pulldown bit 0 0 says this group should be in the opac libararies pulldown if it is enabled

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort
categorycode Primary key Asc
show_in_pulldown Performance Asc

Close relationships  within of separation: