Table testsql_comments.itemtypes 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
itemtype varchar 10
biblioitems.itemtype Implied Constraint R
branch_item_rules.itemtype branch_item_rules_ibfk_1 C
branch_transfer_limits.itemtype Implied Constraint R
default_branch_item_rules.itemtype default_branch_item_rules_ibfk_1 C
deletedbiblioitems.itemtype Implied Constraint R
issuingrules.itemtype Implied Constraint R
old_reserves.itemtype old_reserves_ibfk_4 N
reserves.itemtype reserves_ibfk_5 C
statistics.itemtype Implied Constraint R
subscription.itemtype Implied Constraint R
unique key, a code associated with the item type
description longtext 2147483647  √  null a plain text explanation of the item type
rentalcharge decimal 28,6  √  null the amount charged when this item is checked out/issued
defaultreplacecost decimal 28,6  √  null default replacement cost
processfee decimal 28,6  √  null default text be recorded in the column note when the processing fee is applied
notforloan smallint 5  √  null 1 if the item is not for loan, 0 if the item is available for loan
imageurl varchar 200  √  null URL for the item type icon
summary mediumtext 16777215  √  null information from the summary field, may include HTML
checkinmsg varchar 255  √  null message that is displayed when an item with the given item type is checked in
checkinmsgtype char 16 message type (CSS class) for the checkinmsg, can be "alert" or "message"
sip_media_type varchar 3  √  null SIP2 protocol media type for this itemtype
hideinopac bit 0 0 Hide the item type from the search options in OPAC
searchcategory varchar 80  √  null Group this item type with others with the same value on OPAC search options

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
itemtype Primary key Asc PRIMARY
itemtype Must be unique Asc itemtype

Close relationships  within of separation: