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

p_id

Primary key for the table.

paccount_id

The id for the account holder.

p_no

The passport no.

p_issued_by

p_valid_until

Validity date for the passport.

p_place

Place where it was issued.

p_dob

Date of birth for the account holder

p_country

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