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