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.

p_id
Primary key for the table.

paccount_id
The id for the account holder.

p_no
The passport no.

p_valid_until
Validity date for the passport.

p_place
Place where it was issued.

p_dob
Date of birth for the account holder

Schema summary
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    |                |