Skip to main content

Citizenship Type

Data Dictionary - Entity Table: Citizenship_Type#

This is a lookup table for Citizenship_Type column in the table Citizenship. There could be different types of citizenships. For example, by birth, naturalized, by marriage, by investment, etc. They impose different regulatory rules on the clients and their portfolios.

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)NULLBy investmentName of citizenship Type