User:Chughakshay16/passportinfo

From mediawiki.org
Jump to navigation Jump to search

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