Table db174.prd_offering 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
PRD_OFFERING_ID smallint 6  √ 
client_initial_savings_offering.PRD_OFFERING_ID client_initial_savings_offering_ibfk_2
insurance_offering.PRD_OFFERING_ID insurance_offering_ibfk_1
loan_account.PRD_OFFERING_ID loan_account_ibfk_11
loan_offering.PRD_OFFERING_ID loan_offering_ibfk_4
offering_fund.PRD_OFFERING_ID offering_fund_ibfk_2
prd_offering_fees.PRD_OFFERING_ID prd_offering_fees_ibfk_2
prd_offering_meeting.PRD_OFFERING_ID prd_offering_meeting_ibfk_1
prd_offering_mix.PRD_OFFERING_ID PRD_OFFERING_MIX_PRD_OFFERING_ID_1
prd_offering_mix.PRD_OFFERING_NOT_ALLOWED_ID PRD_OFFERING_MIX_PRD_OFFERING_ID_2
product_offering_mandatory_savings.PRD_OFFERING_ID product_offering_mandatory_savings_ibfk_1
savings_account.PRD_OFFERING_ID savings_account_ibfk_7
savings_offering.PRD_OFFERING_ID savings_offering_ibfk_1
PRD_APPLICABLE_MASTER_ID smallint 6
prd_applicable_master.PRD_APPLICABLE_MASTER_ID prd_offering_ibfk_6
GLOBAL_PRD_OFFERING_NUM varchar 50
PRD_CATEGORY_ID smallint 6
prd_category.PRD_CATEGORY_ID prd_offering_ibfk_3
PRD_TYPE_ID smallint 6  √  null
prd_type.PRD_TYPE_ID prd_offering_ibfk_5
OFFICE_ID smallint 6  √  null
office.OFFICE_ID prd_offering_ibfk_2
START_DATE date 10
END_DATE date 10  √  null
GLCODE_ID smallint 6  √  null
gl_code.GLCODE_ID prd_offering_ibfk_1
PRD_OFFERING_NAME varchar 50
PRD_OFFERING_SHORT_NAME varchar 50
OFFERING_STATUS_ID smallint 6  √  null
prd_status.OFFERING_STATUS_ID prd_offering_ibfk_4
DESCRIPTION varchar 200  √  null
CREATED_DATE date 10
CREATED_BY int 11
UPDATED_DATE date 10  √  null
UPDATED_BY int 11  √  null
VERSION_NO int 11  √  null
PRD_MIX_FLAG smallint 6  √  null

Table contained 0 rows at Tue Feb 26 10:59 PST 2008

Indexes:
Column(s) Type Sort Constraint Name
PRD_OFFERING_ID Primary key Asc PRIMARY
GLCODE_ID Performance Asc GLCODE_ID
OFFERING_STATUS_ID Performance Asc OFFERING_STATUS_ID
PRD_APPLICABLE_MASTER_ID Performance Asc PRD_APPLICABLE_MASTER_ID
PRD_CATEGORY_ID Performance Asc PRD_CATEGORY_ID
GLOBAL_PRD_OFFERING_NUM Must be unique Asc PRD_OFFERING_GLOBAL_IDX
OFFICE_ID Performance Asc PRD_OFFERING_OFFICE_IDX
PRD_TYPE_ID Performance Asc PRD_TYPE_IDX

Close relationships  within one two degrees of separation :