Skip to main content

Person PII

Data Dictionary - Entity Table: Person_PII#

Table with person's PII. It could be as individual as well as organization name. Personally identifiable information (PII) is information that, when used alone or with other relevant data, can identify an individual. Due to CID (Client Identifying Data) concerns data needs to be separated and individually deployable e.g. in a public and private cloud.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
PersonBIGINT(12)NULL1Person ID
First_NameVARCHAR(45)NULLJaneFirst Name upto 45 characters, if Person table represnts an individual
Middle_NameVARCHAR(45)NULLAnnMiddle Name upto 45 characters , if Person table represnts an individual
Last_NameVARCHAR(45)NULLDoeLast Name upto 45 characters, if Person table represnts an individual
Birth_DateDATENULL15Jan91Birthdate if individual, can also mean 'date of establishment' if Person represents legal entity
TitleBIGINT(12)NULL3Title id of person. see Table-Title
LanguageBIGINT(12)NULL4Language id used for communication. see Table-Language
Organization_NameVARCHAR(45)NULLABC BankName of the organization, if Person table represents legal entity
Title(Title)Title (id)NO ACTIONNO ACTION
Language(Language)Language (id)NO ACTIONNO ACTION
Person(Person)Person (id)NO ACTIONNO ACTION
Title_idxPerson_PII(Title ASC)VISIBLE.
Language_idxPerson_PII(Language ASC)VISIBLE.
Person_idxPerson_PII(Person ASC)VISIBLE.