m_share_product_dividend_pay_out

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_share_account_dividend_details.dividend_pay_out_id FK_m_share_account_dividend_details_dividend_pay_out_idR
product_id BIGINT 19 null
m_share_product.id FK_m_share_product_dividend_pay_out_product_idR
amount DECIMAL 19,6 null
dividend_period_start_date DATE 10 null
dividend_period_end_date DATE 10 null
status SMALLINT 5 null
createdby_id BIGINT 19 √ NULL
m_appuser.id FK_m_share_product_dividend_pay_out_createdby_idR
created_date DATETIME 19 √ NULL
lastmodifiedby_id BIGINT 19 √ NULL
m_appuser.id FK_m_share_product_dividend_pay_out_lastmodifiedby_idR
lastmodified_date DATETIME 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_m_share_product_dividend_pay_out_createdby_id Performance Asc createdby_id
FK_m_share_product_dividend_pay_out_lastmodifiedby_id Performance Asc lastmodifiedby_id
FK_m_share_product_dividend_pay_out_product_id Performance Asc product_id

Relationships

Close relationships within degrees of separation