m_share_account

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_share_account_charge.account_id m_share_account_charge_ibfk_2 R
m_share_account_dividend_details.account_id FK_m_share_account_dividend_details_account_id R
m_share_account_transactions.account_id m_share_account_purchased_shares_ibfk_1 R
account_no varchar 50 null
product_id int8 19 null
m_share_product.id m_share_account_ibfk_1 R
client_id int8 19 null
m_client.id m_share_account_ibfk_9 R
external_id varchar 100 √ null
status_enum int2 5 300
total_approved_shares int8 19 √ null
total_pending_shares int8 19 √ null
submitted_date date 13 null
submitted_userid int8 19 √ null
m_appuser.id m_share_account_ibfk_3 R
approved_date date 13 √ null
approved_userid int8 19 √ null
m_appuser.id m_share_account_ibfk_4 R
rejected_date date 13 √ null
rejected_userid int8 19 √ null
m_appuser.id m_share_account_ibfk_5 R
activated_date date 13 √ null
activated_userid int8 19 √ null
m_appuser.id m_share_account_ibfk_6 R
closed_date date 13 √ null
closed_userid int8 19 √ null
m_appuser.id m_share_account_ibfk_7 R
currency_code varchar 3 null
currency_digits int2 5 null
currency_multiplesof int2 5 √ null
savings_account_id int8 19 null
m_savings_account.id m_share_account_ibfk_2 R
minimum_active_period_frequency numeric 19,6 √ NULL::numeric
minimum_active_period_frequency_enum int2 5 √ null
lockin_period_frequency numeric 19,6 √ NULL::numeric
lockin_period_frequency_enum int2 5 √ null
allow_dividends_inactive_clients bool 1 √ false
created_date timestamp 29,6 √ null
lastmodifiedby_id int8 19 √ null
m_appuser.id m_share_account_ibfk_8 R
lastmodified_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
m_share_account_pkey Primary key Asc id
m_share_account_ibfk_1 Performance Asc product_id
m_share_account_ibfk_2 Performance Asc savings_account_id
m_share_account_ibfk_3 Performance Asc submitted_userid
m_share_account_ibfk_4 Performance Asc approved_userid
m_share_account_ibfk_5 Performance Asc rejected_userid
m_share_account_ibfk_6 Performance Asc activated_userid
m_share_account_ibfk_7 Performance Asc closed_userid
m_share_account_ibfk_8 Performance Asc lastmodifiedby_id
m_share_account_ibfk_9 Performance Asc client_id

Relationships

Close relationships within degrees of separation