Table db156.fees Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
FEE_ID smallint 6  √ 
account_fees.FEE_ID account_fees_ibfk_2
customer_fee_schedule.FEE_ID customer_fee_schedule_ibfk_4
fee_frequency.FEE_ID fee_frequency_ibfk_1
feelevel.FEE_ID feelevel_ibfk_1
loan_fee_schedule.FEE_ID loan_fee_schedule_ibfk_4
prd_fee_frequency.FEE_ID prd_fee_frequency_ibfk_1
prd_offering_fees.FEE_ID prd_offering_fees_ibfk_1
GLOBAL_FEE_NUM varchar 50  √  null
FEE_NAME varchar 50
FEE_PAYMENTS_CATEGORY_TYPE_ID smallint 6  √  null
fee_payments_categories_type.FEE_PAYMENTS_CATEGORY_TYPE_ID Implied Constraint
OFFICE_ID smallint 6
office.OFFICE_ID fees_ibfk_4
GLCODE_ID smallint 6
gl_code.GLCODE_ID fees_ibfk_1
STATUS smallint 6
fee_status.STATUS_ID fees_ibfk_3
CATEGORY_ID smallint 6
category_type.CATEGORY_ID fees_ibfk_2
RATE_OR_AMOUNT decimal 16,5  √  null
RATE_OR_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID fees_ibfk_8
RATE_FLAT_FALG smallint 6  √  null
CREATED_DATE date 10
CREATED_BY smallint 6
personnel.PERSONNEL_ID fees_ibfk_5
UPDATED_DATE date 10  √  null
UPDATED_BY smallint 6  √  null
personnel.PERSONNEL_ID fees_ibfk_6
UPDATE_FLAG smallint 6  √  null
FORMULA_ID smallint 6  √  null
fee_formula_master.FORMULAID fees_ibfk_7
DEFAULT_ADMIN_FEE varchar 10  √  null
FEE_AMOUNT decimal 10,3  √  null
FEE_AMOUNT_CURRENCY_ID smallint 6  √  null
currency.CURRENCY_ID fees_ibfk_9
RATE decimal 16,5  √  null
VERSION_NO int 11
DISCRIMINATOR varchar 20  √  null

Table contained 0 rows at Fri Nov 09 16:15 PST 2007

Indexes:
Column(s) Type Sort Constraint Name Anomalies
FEE_ID Primary key Asc PRIMARY  
CATEGORY_ID Performance Asc CATEGORY_ID  
CREATED_BY Performance Asc CREATED_BY  
FEE_AMOUNT_CURRENCY_ID Performance Asc FEE_AMOUNT_CURRENCY_ID  
GLOBAL_FEE_NUM Must be unique Asc FEE_GLOBAL_IDX This unique column is also nullable
OFFICE_ID Performance Asc FEE_OFFICE_IDX  
FEE_PAYMENTS_CATEGORY_TYPE_ID Performance Asc FEE_PMNT_CATG_IDX  
FORMULA_ID Performance Asc FORMULA_ID  
GLCODE_ID Performance Asc GLCODE_ID  
RATE_OR_AMOUNT_CURRENCY_ID Performance Asc RATE_OR_AMOUNT_CURRENCY_ID  
STATUS Performance Asc STATUS  
UPDATED_BY Performance Asc UPDATED_BY  

Close relationships  within one two degrees of separation :