Skip to main content

Product

Data Dictionary - Entity Table: Product#

Product table contains information regarding the parameters within which a portfolio is managed. Can be arbitraty name or mandate name.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComment
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
NameVARCHAR(45)NULLAdvisory Mandate, Discretionary Mandate, ExecutionOnly MandateName of the product