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.

org_id
Primary key for the table.

org_conf_id
Reference to the conference_id of the conferences table.

org_ref_id
This points to the user_id of this organizer in the user (core) table.

org_cat
An organizer can be classified in different categories, such as in a Sponsorship Team, or the Developing team.

org_post
Every organizer can be assigned a post as well within a particular category. 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
DESCRIBE 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    |                |