User:Chughakshay16/accountstable

From mediawiki.org
Jump to navigation Jump to search

The accounts table stores the information of all the users who have made an account for this conference.
Note Note: These accounts are different from users which are present in the user table. Not every wiki account holder(in user table) is present in the accounts table but every entry in accounts table would be present in the user table.

Fields[edit]

account_id[edit]

Primary key for the table.

account_ref_id[edit]

Reference to the user_id in the user table.Whenever someone creates an account for the conference first of all an entry is created for that user in the user table and that user_id is passed over to this table to store a reference for it.

account_first_name[edit]

First name of the account holder.

acount_last_name[edit]

Last name of the account holder.

Schema summary[edit]

DESCRIBE accounts;:

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| account_id            | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| account_ref_id        | int(11)unsigned     | NO   |     | NULL    |                |
| account_first_name    | varchar(20)         | NO   |     | NULL    |                |
| account_last_name     | varchar(20)         | NO   |     | NULL    |                |
+-----------------------+---------------------+------+-----+---------+----------------+