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
editp_id
editPrimary key for the table.
paccount_id
editThe id for the account holder.
p_no
editThe passport no.
p_issued_by
editp_valid_until
editValidity date for the passport.
p_place
editPlace where it was issued.
p_dob
editDate of birth for the account holder
p_country
editSchema summary
editDESCRIBE 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 | | +-----------------------+---------------------+------+-----+---------+----------------+