Table testsql_comments.course_items 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
ci_id int 10  √ 
course_reserves
course item id
itemnumber int 10
items
items.itemnumber for the item on reserve
itype varchar 10  √  null new itemtype for the item to have while on reserve (optional)
ccode varchar 10  √  null new category code for the item to have while on reserve (optional)
holdingbranch varchar 10  √  null
branches
new holding branch for the item to have while on reserve (optional)
location varchar 80  √  null new shelving location for the item to have while on reseve (optional)
enabled enum 4 no if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
timestamp timestamp 19 CURRENT_TIMESTAMP

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

Indexes:
Column(s) Type Sort
ci_id Primary key Asc
holdingbranch Performance Asc
itemnumber Must be unique Asc

Close relationships  within of separation: