Table testsql_comments.refund_lost_item_fee_rules 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
branchcode varchar 10
borrower_modifications.branchcode Implied Constraint R
branches.branchcode Implied Constraint R
deletedborrowers.branchcode Implied Constraint R
import_batches.branchcode Implied Constraint R
import_items.branchcode Implied Constraint R
import_records.branchcode Implied Constraint R
issues.branchcode Implied Constraint R
issuingrules.branchcode Implied Constraint R
item_circulation_alert_preferences.branchcode Implied Constraint R
letter.branchcode Implied Constraint R
message_transports.branchcode Implied Constraint R
messages.branchcode Implied Constraint R
old_issues.branchcode Implied Constraint R
old_reserves.branchcode Implied Constraint R
overduerules.branchcode Implied Constraint R
pending_offline_operations.branchcode Implied Constraint R
repeatable_holidays.branchcode Implied Constraint R
special_holidays.branchcode Implied Constraint R
subscription.branchcode Implied Constraint R
suggestions.branchcode Implied Constraint R
the branch this rule is for (branches.branchcode)
refund bit 0 0 control wether to refund lost item fees on return

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

Indexes:
Column(s) Type Sort Constraint Name
branchcode Primary key Asc PRIMARY

Close relationships: