m_share_product

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_share_account.product_id m_share_account_ibfk_1R
m_share_product_charge.product_id m_share_product_charge_ibfk_2R
m_share_product_dividend_pay_out.product_id FK_m_share_product_dividend_pay_out_product_idR
m_share_product_market_price.product_id m_share_product_market_price_ibfk_1R
name VARCHAR 200 null
short_name VARCHAR 4 null
external_id VARCHAR 100 √ NULL
description VARCHAR 500 null
start_date DATETIME 19 √ NULL
end_date DATETIME 19 √ NULL
currency_code VARCHAR 3 null
currency_digits SMALLINT 5 null
currency_multiplesof SMALLINT 5 √ NULL
total_shares BIGINT 19 null
issued_shares BIGINT 19 √ NULL
totalsubscribed_shares BIGINT 19 √ NULL
unit_price DECIMAL 10,2 null
capital_amount DECIMAL 20,2 null
minimum_client_shares BIGINT 19 √ NULL
nominal_client_shares BIGINT 19 null
maximum_client_shares BIGINT 19 √ NULL
minimum_active_period_frequency DECIMAL 19,6 √ NULL
minimum_active_period_frequency_enum SMALLINT 5 √ NULL
lockin_period_frequency DECIMAL 19,6 √ NULL
lockin_period_frequency_enum SMALLINT 5 √ NULL
allow_dividends_inactive_clients BIT 1 √ b'0'
createdby_id BIGINT 19 √ NULL
m_appuser.id m_share_product_ibfk_1R
created_date DATETIME 19 √ NULL
lastmodifiedby_id BIGINT 19 √ NULL
m_appuser.id m_share_product_ibfk_2R
lastmodified_date DATETIME 19 √ NULL
accounting_type SMALLINT 5 null

Indexes

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

Relationships

Close relationships within degrees of separation