User:Chughakshay16/passportinfo
The passport_info table maintains a 1:1 relationship with the accounts table. But just to keep things clear, I have built a separate table for storing the passport information of an account holder.
Fields[edit]
p_id[edit]
Primary key for the table.
paccount_id[edit]
The id for the account holder.
p_no[edit]
The passport no.
p_issued_by[edit]
p_valid_until[edit]
Validity date for the passport.
p_place[edit]
Place where it was issued.
p_dob[edit]
Date of birth for the account holder
p_country[edit]
Schema summary[edit]
DESCRIBE passport_info;:
+-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+----------------+ | p_id | int(8) unsigned | NO | PRI | NULL | auto_increment | | paccount_id | int(8)unsigned | NO | UNI | NULL | | | p_no | int(11) unsigned | NO | UNI | NULL | | | p_issued_by | varchar(45) | NO | | NULL | | | p_valid_until | timestamp | NO | | NULL | | | p_place | varchar(20) | NO | | NULL | | | p_dob | timestamp | NO | | NULL | | | p_country | varchar(3) | NO | | NULL | | +-----------------------+---------------------+------+-----+---------+----------------+