m_share_product

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_share_account.product_id m_share_account_ibfk_1 R
m_share_product_charge.product_id m_share_product_charge_ibfk_2 R
m_share_product_dividend_pay_out.product_id FK_m_share_product_dividend_pay_out_product_id R
m_share_product_market_price.product_id m_share_product_market_price_ibfk_1 R
name varchar 200 null
short_name varchar 4 null
external_id varchar 100 √ null
description varchar 500 null
start_date date 13 √ null
end_date date 13 √ null
currency_code varchar 3 null
currency_digits int2 5 null
currency_multiplesof int2 5 √ null
total_shares int8 19 null
issued_shares int8 19 √ null
totalsubscribed_shares int8 19 √ null
unit_price numeric 10,2 null
capital_amount numeric 20,2 null
minimum_client_shares int8 19 √ null
nominal_client_shares int8 19 null
maximum_client_shares int8 19 √ null
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
createdby_id int8 19 √ null
m_appuser.id m_share_product_ibfk_1 R
created_date timestamp 29,6 √ null
lastmodifiedby_id int8 19 √ null
m_appuser.id m_share_product_ibfk_2 R
lastmodified_date timestamp 29,6 √ null
accounting_type int2 5 null

Indexes

Constraint Name Type Sort Column(s)
m_share_product_pkey Primary key Asc id
m_share_product_ibfk_1 Performance Asc createdby_id
m_share_product_ibfk_2 Performance Asc lastmodifiedby_id
m_share_product_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation