A version of this file also lives at https://github.com/dylan-k/bestrew/blob/master/writers-database_data-model.md
TABLE: Submissions
DESCRIPTION: Each row describes a unique submission
FIELD NAME | DATA TYPE | DESCRIPTION |
---|---|---|
sub_id | integer | Primary Key for submissions table |
cover_letter | text | Text-only contents of submission cover letter |
send_date | date | Submission date |
reply_date | date | Reply date |
sub_status | text | Options like 'pending' 'accepted' or 'declined' |
sub_note | text | Useful for storing archive of e-mail threads, etc. |
TABLE: works_SUBS
DESCRIPTION: There is a one-to-many relationship from Submissions to Manuscripts
NOTE: If you submit multiple files, .zip or merge them first?
Manuscrpts can undergo revisions from one submission to the next
It is useful to store a reference to which (git?) version was sent
FIELD NAME | DATA TYPE | DESCRIPTION |
---|---|---|
sub_nbr | integer | Foreign Key to indicate a Submission |
venue_nbr | integer | Foreign Key to indicate a Venue |
works_nbr | integer | Foreign Key to indicate a Manuscript |
sub_file | text | Path/Filename/Version of submission |
TABLE: Works
DESCRIPTION: Each row describes a unique work that could be submitted
FIELD NAME | DATA TYPE | DESCRIPTION |
---|---|---|
works_id | integer | Primary Key for Manuscripts table |
works_title | text | Title of manuscript |
works_type | text | e.g. 'poem' 'novel' 'screenplay' etc. |
works_status | text | e.g. 'open' 'in-progress' 'trunked' or 'published' |
pub_date | date | Date this manuscript was published |
venue_nbr | integer | Foreign Key for Venue if published |
TABLE: Venues
DESCRIPTION: Each row describes a place where a submission could be sent
FIELD NAME | DATA TYPE | DESCRIPTION |
---|---|---|
venue_id | integer | Primary Key for Venues table |
venue_title | text | Name of this venue |
venue_type | text | e.g. 'journal' 'website' etc. |
venue_url | text | Link to publication or submission guidelines |
venue_address | text | Contact info for venue (e.g. email address) |
venue_person | text | Name of person at venue |
venue_note | text | Notes about deadlines, preferences, etc. |
venue_simul | boolean | if 'yes,' venue accepts simultaneous submissions |