User:Chughakshay16/speakerstable

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.

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

speaker-ref-id
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). 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
This field just has a value which was submitted during the submission form.

blog_url
Personal blog url of the speaker.

country
Country of the speaker.

Schema summary
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    |                |