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.

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