User:Chughakshay16/speakerstable

From mediawiki.org
Jump to navigation Jump to search

The speakers table consist of all the authors/speakers who have submitted their proposals. So the information concerning a speaker is stored in this table, whenever a speaker wishes to submit his/her proposal a Submission Form is presented to him/her. All the details in that form are loaded into this table, and a corresponding submission page is created for that speaker which only he has rights to modify .

Fields[edit]

speaker_id[edit]

Primary key for this table. Every time a submission is made a new entry is created in this table.

speaker-ref-id[edit]

Foreign key to the user table(user_id). This maintains a reference to the user row in user table, so it helps in knowing about all the other relevant information about the user(or speaker in our case).
Note Note: Every speaker who wishes to submit a proposal for the conference should already have an account for this wiki.(i.e only logged in users would have the rights to submit a proposal)

affiliation[edit]

This field just has a value which was submitted during the submission form.

blog_url[edit]

Personal blog url of the speaker.

country[edit]

Country of the speaker.

Schema summary[edit]

DESCRIBE page; :

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| speaker_id            | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| speaker_ref_id        | int(10)unsigned     | NO   | UNI | NULL    |                |
| affiliation           | varchar(100)        | NO   |     | NULL    |                |
| blog_url              | varchar(200)        | NO   |     | NULL    |                |
| country               | varchar(45)         | NO   |     | NULL    |                |
+-----------------------+---------------------+------+-----+---------+----------------+