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

edit

sub_id

edit

Primary key for the table.

sub_author_id

edit

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

sub_title

edit

The title of the proposal as set by the speaker.

sub_type

edit

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

abstract

edit

The abstract for the proposal.

track

edit

The track type it belongs to.

length

edit

The length of the presentation ( in mins).

slides_info

edit

Extra information about the slides.

slot_req

edit

Some preference for the slot

sub_ref_id

edit

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

edit

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