Table pm_passport_details |
Description: Passport Details |
PRIMARY KEY | ||
p_partner_key_n
bigint default: 0 NOT NULL | This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number. | p_person |
pm_passport_number_c
varchar (40) NOT NULL | Passport Number | |
pm_main_passport_l
boolean default: '0' | Is this the main passport? | |
pm_active_flag_c
varchar (6) | Indicates whether the passport is active or not. | |
pm_full_passport_name_c
varchar (80) | Full passport name. | |
pm_passport_dob_d
date | Date of Birth | |
pm_place_of_birth_c
varchar (60) | Location of birth, eg. Cleveland, Ohio, USA, or Oswestry,Shropshire, England. | |
p_passport_nationality_code_c
varchar (8) | Nationality of the passport holder. | p_country |
pm_date_of_expiration_d
date | Date the passport expires | |
pm_place_of_issue_c
varchar (40) | Place the passport was issued. | |
p_country_of_issue_c
varchar (8) | Country the passport was issued. | p_country |
pm_date_of_issue_d
date | The date the passport was issued. | |
pm_passport_details_type_c
varchar (32) | Details the type of passport, e.g. Residence, Diplomatic, etc. | pt_passport_type |
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
s_date_modified_d
date | The date the record was modified. | |
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY pm_passport_details_fk1: p_partner_key_n => p_person pm_passport_details_fk2: pm_passport_details_type_c => pt_passport_type pm_passport_details_fk3: p_passport_nationality_code_c => p_country pm_passport_details_fk4: p_country_of_issue_c => p_country pm_passport_details_fkcr: s_created_by_c => s_user pm_passport_details_fkmd: s_modified_by_c => s_user |