User:Chughakshay16/organizerstable
The organizers table consist of all the organizers who are set by the admin during the conference setup. There would be a separate page for displaying the organizers of the conference. So the list of organizers for that page are taken from this table, and then the organizers can put other necessary information about them on that page itself. There is no point in storing that other information in the database.
Fields
editorg_id
editPrimary key for the table.
org_conf_id
editReference to the conference_id of the conferences table.
org_ref_id
editThis points to the user_id of this organizer in the user (core) table.
org_cat
editAn organizer can be classified in different categories, such as in a Sponsorship Team, or the Developing team.
org_post
editEvery organizer can be assigned a post as well within a particular category.
Note: org_cat and org_post are just used to display the role and category of the organizer on the page. No rights or permissions are calculated on the basis of these two fields.
Schema summary
editDESCRIBE organizers;
:
+-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+----------------+ | org_id | int(8) unsigned | NO | PRI | NULL | auto_increment | | org_conf_id | int(8) unsigned | NO | | NULL | | | org_ref_id | int(11)unsigned | NO | | NULL | | | org_cat | varchar(20) | NO | | NULL | | | org_post | varchar(20) | NO | | NULL | | +-----------------------+---------------------+------+-----+---------+----------------+