User:Chughakshay16/organizerstable

From mediawiki.org
Jump to navigation Jump to search

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