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.

Fields

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.  Note: 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    |                |
+-----------------------+---------------------+------+-----+---------+----------------+