Legal Identification
#
Data Dictionary - Entity Table: Legal_IdentificationStores Legal Identification documents of the person.
Primary Key ('idLegal_Identification') | . | ENGINE = InnoDB | . | . |
---|---|---|---|---|
Table Name | Column Name | Data Type | PK Primary Key, NN-Not Null, Null | Example |
idLegal_Identification | INT | PK, NN | 1 | PrimaryKey-ID, Not Null (auto creates) |
Identification | VARCHAR(45) | NULL | AA 11 111 | Identification document number |
Identification_type | VARCHAR(45) | NULL | 1 | Type of identification, e.g. national passport, driver license |
Issuer_Country | BIGINT(12) | NULL | 12 | country id from Country table |
Issuer_place | BIGINT(12) | NULL | 33 | Address ID from Address table |
Issue_Date | DATE | NULL | 10/10/99 | issue date of id |
Expiry_Date | DATE | NULL | 12/12/22 | expiration date on id |
Person | BIGINT(12) | NULL | 12 | Person ID found in the Person_PII table |
CONSTRAINT | FOREIGN KEY | REFERENCES | ON DELETE | ON UPDATE |
LIPerson | (Person ) | Person_PII (id ) | NO ACTION | NO ACTION |
Issuer_Country | ('Id') | Country (id ) | NO ACTION | NO ACTION |
Issuer_Place | ('Id') | Address (id ) | NO ACTION | NO ACTION |
CREATE INDEX | ON | ASC | VISIBLE | . |
Person_idx | Legal_Identification | (Person ASC) | VISIBLE | . |
Issuer_Country | Legal_Identification | (Issuer_Country ASC) | VISIBLE | . |
Issuer_Place | Legal_Identification | (Issuer_Place ASC) | VISIBLE | . |