User:Chughakshay16/registrationstable

From mediawiki.org
Jump to navigation Jump to search

The registrations table stores all the transactions made by an account holder.One account holder can make more than one registration for a particular conference.

Fields[edit]

reg_id[edit]

Primary key for the table.

reg_account_id[edit]

References the account_id in the accounts table.

reg_type[edit]

Type of registration for the conference.(for eg . a student type registration)

reg_dietary_rest[edit]

Dietary restrictions specified by the account holder while making this registration.

reg_other_diet_opts[edit]

Other dietary options.

reg_other_opts[edit]

Extra information.

reg_badge_info[edit]

Badge information type( only first name on the badge, or just the nickname or the mediawiki username)

Schema summary[edit]

DESCRIBE registrations;:

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| reg_id                | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| reg_account_id        | int(11)             | NO   | MUL | NULL    |                |
| reg_type              | varchar(10)         | NO   |     | NULL    |                |
| reg_ dietary_rest     | tinyblob            | NO   |     | NULL    |                |
| reg_other_diet_opts   | tinyblob            | NO   |     | NULL    |                |
| reg_other_opts        | tinyblob            | NO   |     | NULL    |                |
| reg_badge_info        | tinyint(1)          | NO   |     | 1       |                |
+-----------------------+---------------------+------+-----+---------+----------------+