Seitenhistorie

...

• setting_name = "familyName", "givenName", "affiliation", "country", "orcid", "url" or "biography"

• setting_value = correspondent values (e.g. "Delgado Mas", "Elisabet", "University of Vienna", "AT")

Queries:

...

authors

SELECT email FROM ojs.authors x WHERE author_id = 256

authors

Links author_id with:

email

publication_id

...

A single user / author / standard student has two rows in this table, and two different author_id values! One row is for their first year publication and the other for their second. 

• Example: Elisabet Delgado Mas (a12013592 add unet.univie.ac.at) has one row in the authors table with author_id = 270 and publication_id = 147 ("EMG reproducibility using neuronavigated TMS"), and another row with author_id = 525 and publication_id = 328 ("Human-AI Interaction").

Queries:

-- Check main table related to authors.

SELECT * FROM ojs.author_settings

-- Note that the table author_settings ≠ table authors, where you can find the email. 

SELECT * FROM ojs.authors

-- Note table authors ≠ table Authors.

SELECT * FROM ojs.Authors

-- Given one of the user's author_id, get email.

SELECT email FROM ojs.authors x WHERE author_id = 256"), and another row with author_id = 525 and publication_id = 328 ("Human-AI Interaction").

publication_settings 

Nested structure: columns setting_name and setting_value, linked by publication_id (≠submission_id) .

...

last_modified can be used in the query as a filter for the submissions of the current year (e.g. AND p.last_modified >= '2024-03-03 00:00:00';).

submission_id can be used to create the links to the backend and the frontend of each submission:

...

Links user_id with everything else related to a user, including:

username

password

email

date_registered

username = elisabet

password = (encripted) $2y$16$m2Wp95TAKo9Fg8V7hCoCEuC/3Z8zCDC/q8f2Py6C3Yl1LxC2kGnIG   

email = a000000000@unet.univie.ac.at

date_registered = YYYY-MM-DD HH:MM:SS.000    

date_last_login = YYYY-MM-DD HH:MM:SS.000date_last_login   

user_settings

Similar to author_settings. Nested structure: columns setting_name and setting_value, linked by user_id.

• setting_name = "familyName", "givenName", "affiliation" + "preferredPublicName", "signature", "orcid"

• setting_value = correspondent values (e.g. "Delgado Mas", "Elisabet", "University of Vienna", "", "", "")

sections

(journal_id = 3, ours)
3
4
7
8
(journal_id = 4, who knows)
5
6

...

It means order.
Values: 1,2,3,4
Section_idsids: 7, 8, 3, 4
Corresponding to: Workshops, plenary talks, talks, posters.

...

get-authors-and-submissions.sql

...

authors-registration.sql

05-01_authors_registration.sql

...

• Authors
• access_keys
• announcement_settings
• announcement_type_settings
• announcement_types
• announcements
• auth_sources
• author_settings
• authors
• books_for_review
• books_for_review_authors
• books_for_review_settings
• captchas
• categories
• category_settings
• citation_settings
• citations
• comments
• completed_payments
• controlled_vocab_entries
• controlled_vocab_entry_settings
• controlled_vocabs
• custom_issue_orders
• custom_section_orders
• data_object_tombstone_oai_set_objects
• data_object_tombstone_settings
• data_object_tombstones
•  dataverse_files
•  dataverse_studies
•  edit_assignments
•  edit_decisions
•  email_log
•  email_log_users  
•  email_templates
•  email_templates_default
•  email_templates_default_data
•  external_feeds 
•  external_feed_settings 
•  email_templates_settings 
•  event_log 
•  event_log_settings 
•  failed_jobs
•  files 
•  filter_groups 
•  filter_settings 
•  filters 
•  genre_settings 
•  genres 
•  group_memberships 
•  group_settings 
•  groups 
•  institutional_subscription_ip 
•  institutional_subscriptions 
•  issue_files 
•  issue_galley_settings 
•  issue_galleys 
•  issue_settings 
•  issues 
•  item_views 
•  jobs 
•  journal_settings 
•  journals 
•  library_file_settings 
•  library_files 
•  metadata_description_settings 
•  metadata_descriptions 
•  metrics 
•  mutex 
•  navigation_menu_item_assignment_settings 
• navigation_menu_item_assignments
•  navigation_menu_item_settings 
•  navigation_menu_items 
•  navigation_menus 
•  notes 
•  notification_mail_list 
•  notification_settings 
•  notification_subscription_settings 
•  notifications 
•  oai_resumption_tokens 
•  object_for_review_assignments 
•  object_for_review_persons 
•  object_for_review_settings 
•  objects_for_review 
•  paypal_transactions 
•  pln_deposit_objects 
•  pln_deposits 
•  plugin_settings 
•  processes 
•  publication_categories 
•  publication_galley_settings 
•  publication_galleys 
•  publication_settings 
•  publications 
•  queries 
•  query_participants 
•  queued_payments 
•  referral_settings 
•  referrals 
•  review_assignments 
•  review_files 
•  review_form_element_settings
•  referral_settings 
•  referrals 
•  review_assignments 
• review_files
• review_form_element_settings
•  review_form_elements           
•  review_form_responses                    
•  review_form_settings 
•  review_forms 
•  review_object_metadata 
•  review_object_metadata_settings 
•  review_object_type_settings 
•  review_object_types 
•  review_round_files 
•  review_rounds 
•  roles 
•  rt_contexts 
•  rt_searches 
•  rt_versions 
•  scheduled_tasks 
•  section_settings 
•  sections 
•  sessions 
•  site 
•  site_settings 
•  stage_assignments 
•  static_page_settings 
•  static_pages 
•  subeditor_submission_group 
•  submission_artwork_files 
•  submission_comments 
•  submission_file_revisions 
•  submission_file_settings 
•  submission_files 
•  submission_search_keyword_list 
•  submission_search_object_keywords
•  submission_search_objects 
•  submission_settings 
•  submission_supplementary_files 
•  submission_tombstones 
•  submission_xml_galleys 
•  submissions 
•  subscription_type_settings 
•  subscription_types 
•  subscriptions 
•  temporary_files 
•  theses 
•  usage_stats_temporary_records 
•  user_group_settings 
•  user_group_stage 
•  user_groups 
•  user_interests 
•  user user_settings 
•  user_user_groups 
•  users 

...