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 | | +-----------------------+---------------------+------+-----+---------+----------------+