User:Chughakshay16/submissions

From mediawiki.org
Jump to navigation Jump to search

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