User:Chughakshay16/submissions

The submissions table holds the information of all the proposals submitted during the conference. A speaker can have more than one submissions for a particular conference. Speaker is supposed to register just once, and then he/she can submit as many proposals he/she can.

sub_id
Primary key for the table.

sub_author_id
Foreign key to the speakers table(speaker_id). More than one rows in this table can point to the same speaker_id.

sub_title
The title of the proposal as set by the speaker.

sub_type
The type of the proposal. It would be one of the following values (workshop,presentation,tutorial,panel)

abstract
The abstract for the proposal.

track
The track type it belongs to.

length
The length of the presentation ( in mins).

slides_info
Extra information about the slides.

slot_req
Some preference for the slot

sub_ref_id
References the page_id(page table) which holds the information about this submission.Its a wiki page but all its displayed information will be fetched from this table. This field cant be empty, If a submission page is deleted then its corresponding entry here should be deleted as well.

Schema summary
DESCRIBE submissions; : +---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field                | Type                | Null | Key | Default | Extra          |
 * sub_id               | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
 * sub_author_id        | int(8) unsigned     | NO   | UNI | NULL    |                |
 * sub_title            | varbinary(255)      | NO   | UNI | NULL    |                |
 * sub_type             | varchar(15)         | NO   |     | NULL    |                |
 * sub_track            | varchar(25)         | NO   |     | NULL    |                |
 * sub_abstract         | blob                | NO   |     | NULL    |                |
 * sub_length           | int(3) unsigned     | NO   |     | 25      |                |
 * sub_slides_info      | blob                | NO   |     | NULL    |                |
 * sub_slot_req         | int(8) unsigned     | NO   |     | NULL    |                |
 * sub_ref_id           | int(8) unsigned     | NO   | UNI | NULL    |                |