Table testsql_comments.branchcategories
information related to library/branch groups

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
categorycode varchar 10
branchrelations.categorycode branchrelations_ibfk_2 C
default_borrower_circ_rules.categorycode Implied Constraint R
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 Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: