User:Chughakshay16/registrationstable

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

reg_id

Primary key for the table.

reg_account_id

References the account_id in the accounts table.

reg_type

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

reg_dietary_rest

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

reg_other_diet_opts

Other dietary options.

reg_other_opts

Extra information.

reg_badge_info

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

Schema summary

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