Google Git
Sign in
apache / fineract-site / 16ba5983c9422dd738854dabeb45574fb6b399d3 / . / docs / database / diagrams / tables / m_share_account_charge.2degrees.dot
blob: ae04c0902a869ca3a2244f4c2359a7c8fea0e82f [file] [log] [blame]
digraph "twoDegreesRelationshipsDiagram" {
graph [
rankdir="RL"
bgcolor="#ffffff"
label="\nGenerated by SchemaSpy"
labeljust="l"
nodesep="0.18"
ranksep="0.46"
fontname="Helvetica"
fontsize="11"
ration="compress"
];
node [
fontname="Helvetica"
fontsize="11"
shape="plaintext"
];
edge [
arrowsize="0.8"
];
"acc_product_mapping":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"acc_product_mapping":"elipses":w -> "m_payment_type":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_charge":"income_or_liability_account_id":w -> "acc_gl_account":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_charge":"payment_type_id":w -> "m_payment_type":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_charge":"tax_group_id":w -> "m_tax_group":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_client":"elipses":w -> "m_savings_account":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_client_charge":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_client_charge":"elipses":w -> "m_client":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_loan_charge":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_loan_tranche_charges":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_product_loan_charge":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_savings_account":"elipses":w -> "m_client":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_savings_account":"elipses":w -> "m_tax_group":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_savings_account_charge":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_savings_account_charge":"elipses":w -> "m_savings_account":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_savings_product_charge":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"activated_userid":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"approved_userid":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"client_id":w -> "m_client":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"closed_userid":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"lastmodifiedby_id":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"product_id":w -> "m_share_product":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"rejected_userid":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"savings_account_id":w -> "m_savings_account":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account":"submitted_userid":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account_charge":"account_id":w -> "m_share_account":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account_charge":"charge_id":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account_charge_paid_by":"charge_transaction_id":w -> "m_share_account_charge":"id.type":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account_charge_paid_by":"share_transaction_id":w -> "m_share_account_transactions":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account_dividend_details":"elipses":w -> "m_share_account":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_account_transactions":"elipses":w -> "m_share_account":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_product":"elipses":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_product":"elipses":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_product_charge":"elipses":w -> "m_charge":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"m_share_product_charge":"elipses":w -> "m_share_product":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_tax_group":"elipses":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"m_tax_group":"elipses":w -> "m_appuser":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"acc_gl_account" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>acc_gl_account</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">14 &gt;</TD></TR>
</TABLE>>
URL="../../tables/acc_gl_account.html"
target="_top"
tooltip="acc_gl_account"
];
"acc_product_mapping" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>acc_product_mapping</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/acc_product_mapping.html"
target="_top"
tooltip="acc_product_mapping"
];
"m_appuser" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_appuser</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">57 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_appuser.html"
target="_top"
tooltip="m_appuser"
];
"m_charge" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="235" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="name" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="235" HEIGHT="16">name</TD></TR></TABLE></TD></TR>
<TR><TD PORT="payment_type_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="235" HEIGHT="16">payment_type_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="income_or_liability_account_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="235" HEIGHT="16">income_or_liability_account_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="tax_group_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="235" HEIGHT="16">tax_group_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">9 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_charge.html"
target="_top"
tooltip="m_charge"
];
"m_client" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_client</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 13</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">23 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_client.html"
target="_top"
tooltip="m_client"
];
"m_client_charge" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_client_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_client_charge.html"
target="_top"
tooltip="m_client_charge"
];
"m_loan_charge" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_loan_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">4 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_loan_charge.html"
target="_top"
tooltip="m_loan_charge"
];
"m_loan_tranche_charges" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_loan_tranche_charges</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/m_loan_tranche_charges.html"
target="_top"
tooltip="m_loan_tranche_charges"
];
"m_payment_type" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_payment_type</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff"> </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">3 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_payment_type.html"
target="_top"
tooltip="m_payment_type"
];
"m_product_loan_charge" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_product_loan_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/m_product_loan_charge.html"
target="_top"
tooltip="m_product_loan_charge"
];
"m_savings_account" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_savings_account</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 5</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">17 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_savings_account.html"
target="_top"
tooltip="m_savings_account"
];
"m_savings_account_charge" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_savings_account_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_savings_account_charge.html"
target="_top"
tooltip="m_savings_account_charge"
];
"m_savings_product_charge" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_savings_product_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/m_savings_product_charge.html"
target="_top"
tooltip="m_savings_product_charge"
];
"m_share_account" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_share_account</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="product_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">product_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="client_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">client_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="submitted_userid" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">submitted_userid</TD></TR></TABLE></TD></TR>
<TR><TD PORT="approved_userid" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">approved_userid</TD></TR></TABLE></TD></TR>
<TR><TD PORT="rejected_userid" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">rejected_userid</TD></TR></TABLE></TD></TR>
<TR><TD PORT="activated_userid" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">activated_userid</TD></TR></TABLE></TD></TR>
<TR><TD PORT="closed_userid" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">closed_userid</TD></TR></TABLE></TD></TR>
<TR><TD PORT="savings_account_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">savings_account_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="lastmodifiedby_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="277" HEIGHT="16">lastmodifiedby_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 9</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">3 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_share_account.html"
target="_top"
tooltip="m_share_account"
];
"m_share_account_charge" [
label=<
<TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="4" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_share_account_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">id</TD></TR></TABLE></TD><TD PORT="id.type" ALIGN="LEFT">bigint[19]</TD></TR>
<TR><TD PORT="account_id" COLSPAN="2" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">account_id</TD></TR></TABLE></TD><TD PORT="account_id.type" ALIGN="LEFT">bigint[19]</TD></TR>
<TR><TD PORT="charge_id" COLSPAN="2" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">charge_id</TD></TR></TABLE></TD><TD PORT="charge_id.type" ALIGN="LEFT">bigint[19]</TD></TR>
<TR><TD PORT="charge_time_enum" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">charge_time_enum</TD></TR></TABLE></TD><TD PORT="charge_time_enum.type" ALIGN="LEFT">smallint[5]</TD></TR>
<TR><TD PORT="charge_calculation_enum" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">charge_calculation_enum</TD></TR></TABLE></TD><TD PORT="charge_calculation_enum.type" ALIGN="LEFT">smallint[5]</TD></TR>
<TR><TD PORT="charge_payment_mode_enum" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">charge_payment_mode_enum</TD></TR></TABLE></TD><TD PORT="charge_payment_mode_enum.type" ALIGN="LEFT">smallint[5]</TD></TR>
<TR><TD PORT="calculation_percentage" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">calculation_percentage</TD></TR></TABLE></TD><TD PORT="calculation_percentage.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="calculation_on_amount" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">calculation_on_amount</TD></TR></TABLE></TD><TD PORT="calculation_on_amount.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="charge_amount_or_percentage" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">charge_amount_or_percentage</TD></TR></TABLE></TD><TD PORT="charge_amount_or_percentage.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="amount" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">amount</TD></TR></TABLE></TD><TD PORT="amount.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="amount_paid_derived" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">amount_paid_derived</TD></TR></TABLE></TD><TD PORT="amount_paid_derived.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="amount_waived_derived" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">amount_waived_derived</TD></TR></TABLE></TD><TD PORT="amount_waived_derived.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="amount_writtenoff_derived" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">amount_writtenoff_derived</TD></TR></TABLE></TD><TD PORT="amount_writtenoff_derived.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="amount_outstanding_derived" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">amount_outstanding_derived</TD></TR></TABLE></TD><TD PORT="amount_outstanding_derived.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="is_paid_derived" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">is_paid_derived</TD></TR></TABLE></TD><TD PORT="is_paid_derived.type" ALIGN="LEFT">bit[1]</TD></TR>
<TR><TD PORT="waived" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">waived</TD></TR></TABLE></TD><TD PORT="waived.type" ALIGN="LEFT">bit[1]</TD></TR>
<TR><TD PORT="min_cap" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">min_cap</TD></TR></TABLE></TD><TD PORT="min_cap.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="max_cap" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">max_cap</TD></TR></TABLE></TD><TD PORT="max_cap.type" ALIGN="LEFT">decimal[19,6]</TD></TR>
<TR><TD PORT="is_active" COLSPAN="2" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="207" HEIGHT="16">is_active</TD></TR></TABLE></TD><TD PORT="is_active.type" ALIGN="LEFT">bit[1]</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_share_account_charge.html"
target="_top"
tooltip="m_share_account_charge"
];
"m_share_account_charge_paid_by" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_share_account_charge_paid_by</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="225" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="share_transaction_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="225" HEIGHT="16">share_transaction_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="charge_transaction_id" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="225" HEIGHT="16">charge_transaction_id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/m_share_account_charge_paid_by.html"
target="_top"
tooltip="m_share_account_charge_paid_by"
];
"m_share_account_dividend_details" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_share_account_dividend_details</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/m_share_account_dividend_details.html"
target="_top"
tooltip="m_share_account_dividend_details"
];
"m_share_account_transactions" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_share_account_transactions</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">2 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_share_account_transactions.html"
target="_top"
tooltip="m_share_account_transactions"
];
"m_share_product" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_share_product</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">4 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_share_product.html"
target="_top"
tooltip="m_share_product"
];
"m_share_product_charge" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_share_product_charge</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/m_share_product_charge.html"
target="_top"
tooltip="m_share_product_charge"
];
"m_tax_group" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>m_tax_group</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">4 &gt;</TD></TR>
</TABLE>>
URL="../../tables/m_tax_group.html"
target="_top"
tooltip="m_tax_group"
];
}