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

edit

org_id

edit

Primary key for the table.

org_conf_id

edit

Reference to the conference_id of the conferences table.

org_ref_id

edit

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

org_cat

edit

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

org_post

edit

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

edit

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