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