SchemaSpy - Table testsql_comments.refund_lost_item_fee

refund lost item fee rules tbale

Generated by
SchemaSpy

Legend:

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

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

control wether to refund lost item fees on return

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

Indexes:

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