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

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

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