| Server IP : 195.130.67.5 / Your IP : 216.73.217.154 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /inetpub/wwwroot/Topogeo/ojs/dbscripts/xml/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE schema SYSTEM "../../lib/pkp/dtd/xmlSchema.dtd"> <!-- * ojs_schema.xml * * Copyright (c) 2003-2012 John Willinsky * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING. * * OJS database schema in XML. * * $Id$ --> <schema version="0.2"> <!-- * * TABLE version * --> <table name="versions"> <field name="major" type="I4"> <NOTNULL /> <DEFAULT VALUE="0"/> </field> <field name="minor" type="I4"> <NOTNULL /> <DEFAULT VALUE="0"/> </field> <field name="revision" type="I4"> <NOTNULL /> <DEFAULT VALUE="0"/> </field> <field name="build" type="I4"> <NOTNULL /> <DEFAULT VALUE="0"/> </field> <field name="date_installed" type="T"> <NOTNULL/> </field> <field name="current" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>OJS installation and upgrade version history.</descr> </table> <!-- * * TABLE site * --> <table name="site"> <field name="title" type="C2" size="120"> <NOTNULL /> <DEFAULT VALUE="Open Journal Systems"/> </field> <field name="intro" type="X"/> <field name="journal_redirect" type="I8"> <NOTNULL/> <DEFAULT VALUE="0"/> <descr>If not 0, redirect to the specified journal site.</descr> </field> <field name="primary_locale" type="C2" size="5"> <NOTNULL/> </field> <field name="about" type="X"/> <field name="contact_name" type="C2" size="90"/> <field name="contact_email" type="C2" size="90"/> <field name="min_password_length" type="I1"> <NOTNULL/> <DEFAULT VALUE="6"/> </field> <field name="installed_locales" type="C2" size="255"> <NOTNULL/> <DEFAULT VALUE="en_US"/> <descr>Locales for which support has been installed.</descr> </field> <field name="supported_locales" type="C2" size="255"> <descr>Locales supported by the site (for hosted journals).</descr> </field> <field name="original_style_file_name" type="C2" size="255"/> <descr>Common site settings.</descr> </table> <!-- * * TABLE site_settings * --> <table name="site_settings"> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> <descr>(bool|int|float|string|object)</descr> </field> <descr>Site settings.</descr> </table> <!-- * * TABLE scheduled_tasks * --> <table name="scheduled_tasks"> <field name="class_name" type="C2" size="255"> <NOTNULL /> </field> <field name="last_run" type="T" /> <descr>The last run times of all scheduled tasks.</descr> </table> <!-- * * TABLE users * --> <table name="users"> <field name="user_id" type="I8"> <KEY /> <AUTOINCREMENT /> </field> <field name="username" type="C2" size="32"> <NOTNULL/> </field> <field name="password" type="C2" size="40"> <NOTNULL/> </field> <field name="salutation" type="C2" size="40"/> <field name="first_name" type="C2" size="40"> <NOTNULL/> </field> <field name="middle_name" type="C2" size="40"/> <field name="last_name" type="C2" size="90"> <NOTNULL/> </field> <field name="signature" type="X"/> <field name="gender" type="C" size="1"/> <field name="initials" type="C2" size="5"/> <field name="affiliation" type="C2" size="255"/> <field name="email" type="C2" size="90"> <NOTNULL/> </field> <field name="url" type="C2" size="255"/> <field name="phone" type="C2" size="24"/> <field name="fax" type="C2" size="24"/> <field name="mailing_address" type="C2" size="255"/> <field name="country" type="C2" size="90"/> <field name="biography" type="X"/> <field name="interests" type="C2" size="255"/> <field name="locales" type="C2" size="255"/> <field name="date_last_email" type="T"/> <field name="date_registered" type="T"> <NOTNULL/> </field> <field name="date_validated" type="T"/> <field name="date_last_login" type="T"> <NOTNULL/> </field> <field name="must_change_password" type="I1"/> <field name="auth_id" type="I8"/> <field name="disabled" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="disabled_reason" type="X"/> <descr>User authentication credentials and profile data.</descr> </table> <!-- * * TABLE user_settings * --> <table name="user_settings"> <field name="user_id" type="I8"> <NOTNULL/> </field> <field name="locale" type="C2" size="5"> <NOTNULL/> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL/> </field> <field name="journal_id" type="I8"/> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> </field> <descr>Locale-specific user data</descr> </table> <!-- * * TABLE auth_sources * --> <table name="auth_sources"> <field name="auth_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="title" type="C2" size="60"> <NOTNULL/> </field> <field name="plugin" type="C2" size="32"> <NOTNULL/> </field> <field name="auth_default" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="settings" type="X"/> <descr>User authentication sources.</descr> </table> <!-- * * TABLE sessions * --> <table name="sessions"> <field name="session_id" type="C2" size="32"> <NOTNULL /> </field> <field name="user_id" type="I8"/> <field name="ip_address" type="C2" size="15"> <NOTNULL/> </field> <field name="user_agent" type="C2" size="255"/> <field name="created" type="I8"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="last_used" type="I8"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="remember" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="data" type="X"> <NOTNULL/> <DEFAULT VALUE=""/> </field> <descr>Browser/user sessions and session data.</descr> </table> <!-- * * TABLE journals * --> <table name="journals"> <field name="journal_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="title" type="C2" size="255"> <NOTNULL/> </field> <field name="description" type="X"/> <field name="path" type="C2" size="32"> <NOTNULL/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="primary_locale" type="C2" size="5"/> <field name="enabled" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <descr>Journals and basic journal settings.</descr> </table> <!-- * * TABLE journal_settings * --> <table name="journal_settings"> <field name="journal_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> <descr>(bool|int|float|string|object)</descr> </field> <descr>Journal settings.</descr> </table> <!-- * * TABLE plugin_settings * --> <table name="plugin_settings"> <field name="plugin_name" type="C2" size="80"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="journal_id" type="I8"> <NOTNULL /> </field> <field name="setting_name" type="C2" size="80"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> <descr>(bool|int|float|string|object)</descr> </field> <descr>Journal settings.</descr> </table> <!-- * * TABLE roles * --> <table name="roles"> <field name="journal_id" type="I8"> <NOTNULL /> </field> <field name="user_id" type="I8"> <NOTNULL /> </field> <field name="role_id" type="I8"> <NOTNULL /> </field> <descr>User roles in journals.</descr> </table> <table name="notification_status"> <field name="journal_id" type="I8"> <NOTNULL /> </field> <field name="user_id" type="I8"> <NOTNULL /> </field> <descr>User "mail notifications to my account" flags</descr> </table> <!-- * * TABLE sections * --> <table name="sections"> <field name="section_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="title" type="C2" size="120"> <NOTNULL/> </field> <field name="title_alt1" type="C2" size="120"/> <field name="title_alt2" type="C2" size="120"/> <field name="abbrev" type="C2" size="20"/> <field name="abbrev_alt1" type="C2" size="20"/> <field name="abbrev_alt2" type="C2" size="20"/> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="editor_restricted" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="meta_indexed" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="meta_reviewed" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="abstracts_disabled" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="identify_type" type="C2" size="60"/> <field name="hide_title" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="hide_about" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="policy" type="X"/> <descr>Journal sections.</descr> </table> <!-- * * TABLE section_settings * --> <table name="section_settings"> <field name="section_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> <descr>(bool|int|float|string|object)</descr> </field> <descr>Section-specific settings</descr> </table> <!-- * * TABLE section_editors * --> <table name="section_editors"> <field name="journal_id" type="I8"> <NOTNULL /> </field> <field name="section_id" type="I8"> <NOTNULL /> </field> <field name="user_id" type="I8"> <NOTNULL /> </field> <field name="can_edit" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="can_review" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <descr>Assignments of section editors to sections.</descr> </table> <!-- * * TABLE issues * --> <table name="issues"> <field name="issue_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="title" type="C2" size="120"/> <field name="volume" type="I2"/> <field name="number" type="I2"/> <field name="year" type="I2"/> <field name="published" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="current" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="date_published" type="T"/> <field name="date_notified" type="T"/> <field name="access_status" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="description" type="X"/> <field name="open_access_date" type="T"/> <field name="public_issue_id" type="C2" size="255"/> <field name="show_volume" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="show_number" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="show_year" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="show_title" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="file_name" type="C2" size="90"/> <field name="original_file_name" type="C2" size="127"/> <field name="width" type="I2"/> <field name="height" type="I2"/> <field name="cover_page_description" type="X"/> <field name="show_cover_page" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="style_file_name" type="C2" size="90"/> <field name="original_style_file_name" type="C2" size="255"/> <descr>Journal issues.</descr> </table> <!-- * * TABLE issue_settings * --> <table name="issue_settings"> <field name="issue_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> </field> <descr>Locale-specific issue data</descr> </table> <!-- * TABLE custom_issue_orders * --> <table name="custom_issue_orders"> <field name="issue_id" type="I8"> <NOTNULL /> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Custom sequencing information for journal issues, when available</descr> </table> <table name="custom_section_orders"> <field name="issue_id" type="I8"> <NOTNULL /> </field> <field name="section_id" type="I8"> <NOTNULL /> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Custom sequencing information for journal sections by issue, when available.</descr> </table> <!-- * * TABLE articles * --> <table name="articles"> <field name="article_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="user_id" type="I8"> <NOTNULL/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="section_id" type="I8" /> <field name="title" type="C2" size="255"> <NOTNULL/> </field> <field name="title_alt1" type="C2" size="255"/> <field name="title_alt2" type="C2" size="255"/> <field name="abstract" type="X"/> <field name="abstract_alt1" type="X"/> <field name="abstract_alt2" type="X"/> <field name="discipline" type="C2" size="255"/> <field name="subject_class" type="C2" size="255"/> <field name="subject" type="C2" size="255"/> <field name="coverage_geo" type="C2" size="255"/> <field name="coverage_chron" type="C2" size="255"/> <field name="coverage_sample" type="C2" size="255"/> <field name="type" type="C2" size="255"/> <field name="language" type="C2" size="10"> <DEFAULT VALUE="en"/> </field> <field name="sponsor" type="C2" size="255"/> <field name="comments_to_ed" type="X"/> <field name="date_submitted" type="T"/> <field name="last_modified" type="T"/> <field name="date_status_modified" type="T"/> <field name="status" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="submission_progress" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="current_round" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="submission_file_id" type="I8"/> <field name="revised_file_id" type="I8"/> <field name="review_file_id" type="I8"/> <field name="editor_file_id" type="I8"/> <field name="copyedit_file_id" type="I8"/> <field name="pages" type="C2" size="255"/> <descr>Journal articles.</descr> </table> <!-- * * TABLE article_settings * --> <table name="article_settings"> <field name="article_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> <descr>(bool|int|float|string|object)</descr> </field> <descr>Journal article metadata.</descr> </table> <!-- * * TABLE published_articles * --> <table name="published_articles"> <field name="pub_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="issue_id" type="I8"> <NOTNULL/> </field> <field name="date_published" type="T"> <NOTNULL/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="views" type="I4"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="access_status" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="public_article_id" type="C2" size="255"/> <descr>Journal articles.</descr> </table> <!-- * * TABLE comments * --> <table name="comments"> <field name="comment_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="parent_comment_id" type="I8"/> <field name="num_children" type="I4"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="user_id" type="I8"/> <field name="poster_ip" type="C2" size="15"> <NOTNULL/> </field> <field name="poster_name" type="C2" size="90"/> <field name="poster_email" type="C2" size="90"/> <field name="title" type="C2" size="255"> <NOTNULL/> </field> <field name="body" type="X"/> <field name="date_posted" type="T"/> <field name="date_modified" type="T"/> <descr>Reader comments on articles.</descr> </table> <!-- * * TABLE article_authors * --> <table name="article_authors"> <field name="author_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="primary_contact" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="first_name" type="C2" size="40"> <NOTNULL/> </field> <field name="middle_name" type="C2" size="40"/> <field name="last_name" type="C2" size="90"> <NOTNULL/> </field> <field name="affiliation" type="C2" size="255"/> <field name="country" type="C2" size="90"/> <field name="email" type="C2" size="90"> <NOTNULL/> </field> <field name="url" type="C2" size="255"/> <field name="biography" type="X"/> <descr>Author metadata for articles.</descr> </table> <!-- * * TABLE article_author_settings * --> <table name="article_author_settings"> <field name="author_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> <descr>(bool|int|float|string|object)</descr> </field> <descr>Language dependent author metadata.</descr> </table> <!-- * * TABLE article_files * --> <table name="article_files"> <field name="file_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="revision" type="I8"> <KEY /> </field> <field name="source_file_id" type="I8" /> <field name="source_revision" type="I8" /> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="file_name" type="C2" size="90"> <NOTNULL/> </field> <field name="file_type" type="C2" size="255"> <NOTNULL/> </field> <field name="file_size" type="I8"> <NOTNULL/> </field> <field name="original_file_name" type="C2" size="127"/> <field name="type" type="C2" size="40"> <NOTNULL/> </field> <field name="status" type="C2" size="40"> <NOTNULL/> </field> <field name="viewable" type="I1" /> <field name="date_uploaded" type="T"> <NOTNULL/> </field> <field name="date_modified" type="T"> <NOTNULL/> </field> <field name="round" type="I1"> <NOTNULL/> </field> <field name="assoc_id" type="I8"/> <descr>Files associated with articles. Includes submission files, supplementary files, etc.</descr> </table> <!-- * * TABLE article_supplementary_files * --> <table name="article_supplementary_files"> <field name="supp_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="file_id" type="I8"> <NOTNULL/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="title" type="C2" size="255"/> <field name="creator" type="C2" size="255"/> <field name="subject" type="C2" size="255"/> <field name="type" type="C2" size="255"/> <field name="type_other" type="C2" size="255"/> <field name="description" type="X"/> <field name="publisher" type="C2" size="255"/> <field name="sponsor" type="C2" size="255"/> <field name="source" type="C2" size="255"/> <field name="language" type="C2" size="10"/> <field name="public_supp_file_id" type="C2" size="255"/> <field name="date_created" type="D"/> <field name="show_reviewers" type="I1"> <DEFAULT VALUE="0"/> </field> <field name="date_submitted" type="T"> <NOTNULL/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Supplementary files attached to articles.</descr> </table> <!-- * * TABLE article_supplementary_file_settings * --> <table name="article_supp_file_settings"> <field name="supp_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> <descr>(bool|int|float|string|object|date)</descr> </field> <descr>Article supplementary file metadata.</descr> </table> <!-- * * TABLE article_notes * --> <table name="article_notes"> <field name="note_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="user_id" type="I8"> <NOTNULL/> </field> <field name="date_created" type="T"> <NOTNULL/> </field> <field name="date_modified" type="T"> <NOTNULL/> </field> <field name="title" type="C2" size="255"> <NOTNULL/> </field> <field name="note" type="X"/> <field name="file_id" type="I8"> <NOTNULL/> </field> <descr>Article submission notes added by editors to each submission</descr> </table> <!-- * * TABLE edit_assignments * --> <table name="edit_assignments"> <field name="edit_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="editor_id" type="I8"> <NOTNULL/> </field> <field name="can_edit" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="can_review" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="date_assigned" type="T"/> <field name="date_notified" type="T"/> <field name="date_underway" type="T"/> <descr>Editing assignments.</descr> </table> <!-- * * TABLE edit_decisions * --> <table name="edit_decisions"> <field name="edit_decision_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="round" type="I1"> <NOTNULL/> </field> <field name="editor_id" type="I8"> <NOTNULL/> </field> <field name="decision" type="I1"> <NOTNULL/> </field> <field name="date_decided" type="T"> <NOTNULL/> </field> <descr>Editor decisions.</descr> </table> <!-- * * TABLE review_rounds * --> <table name="review_rounds"> <field name="article_id" type="I8"> <NOTNULL /> </field> <field name="round" type="I1"> <NOTNULL /> </field> <field name="review_revision" type="I8" /> <descr>Review rounds.</descr> </table> <!-- * * TABLE review_assignments * --> <table name="review_assignments"> <field name="review_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="reviewer_id" type="I8"> <NOTNULL/> </field> <field name="recommendation" type="I1"/> <field name="date_assigned" type="T"/> <field name="date_notified" type="T"/> <field name="date_confirmed" type="T"/> <field name="date_completed" type="T"/> <field name="date_acknowledged" type="T"/> <field name="date_due" type="T"/> <field name="last_modified" type="T"/> <field name="reminder_was_automatic" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="declined" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="replaced" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="cancelled" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="reviewer_file_id" type="I8"/> <field name="date_rated" type="T"/> <field name="date_reminded" type="T"/> <field name="quality" type="I1"/> <field name="round" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <descr>Reviewing assignments.</descr> </table> <!-- * * TABLE copyed_assignments * --> <table name="copyed_assignments"> <field name="copyed_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="copyeditor_id" type="I8"> <NOTNULL/> </field> <field name="copyedit_revision" type="I8"/> <field name="date_notified" type="T"/> <field name="date_underway" type="T"/> <field name="date_completed" type="T"/> <field name="date_acknowledged" type="T"/> <field name="date_author_notified" type="T"/> <field name="date_author_underway" type="T"/> <field name="date_author_completed" type="T"/> <field name="date_author_acknowledged" type="T"/> <field name="date_final_notified" type="T"/> <field name="date_final_underway" type="T"/> <field name="date_final_completed" type="T"/> <field name="date_final_acknowledged" type="T"/> <field name="initial_revision" type="I8"/> <field name="editor_author_revision" type="I8"/> <field name="final_revision" type="I8"/> <descr>Copyediting assignments.</descr> </table> <!-- * * TABLE layouted_assignments * --> <table name="layouted_assignments"> <field name="layouted_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="editor_id" type="I8"> <NOTNULL/> </field> <field name="date_notified" type="T"/> <field name="date_underway" type="T"/> <field name="date_completed" type="T"/> <field name="date_acknowledged" type="T"/> <field name="layout_file_id" type="I8"/> <descr>Layout editing assignments.</descr> </table> <!-- * * TABLE article_galleys * --> <table name="article_galleys"> <field name="galley_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="locale" type="C2" size="5"/> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="file_id" type="I8"> <NOTNULL/> </field> <field name="label" type="C2" size="32"/> <field name="html_galley" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="style_file_id" type="I8"/> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="views" type="I4"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Article galleys.</descr> </table> <!-- * * TABLE article_html_galley_images * --> <table name="article_html_galley_images"> <field name="galley_id" type="I8"> <NOTNULL /> </field> <field name="file_id" type="I8"> <NOTNULL /> </field> <descr>Images associated with an article HTML galley.</descr> </table> <!-- * * TABLE proof_assignments * --> <table name="proof_assignments"> <field name="proof_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="proofreader_id" type="I8"> <NOTNULL/> </field> <field name="date_author_notified" type="T"/> <field name="date_author_underway" type="T"/> <field name="date_author_completed" type="T"/> <field name="date_author_acknowledged" type="T"/> <field name="date_proofreader_notified" type="T"/> <field name="date_proofreader_underway" type="T"/> <field name="date_proofreader_completed" type="T"/> <field name="date_proofreader_acknowledged" type="T"/> <field name="date_layouteditor_notified" type="T"/> <field name="date_layouteditor_underway" type="T"/> <field name="date_layouteditor_completed" type="T"/> <field name="date_layouteditor_acknowledged" type="T"/> <descr>Proofreading assignments.</descr> </table> <!-- * * TABLE article_event_log * --> <table name="article_event_log"> <field name="log_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="user_id" type="I8"> <NOTNULL/> </field> <field name="date_logged" type="T"> <NOTNULL/> </field> <field name="ip_address" type="C2" size="15"> <NOTNULL/> </field> <field name="log_level" type="C2" size="1"/> <field name="event_type" type="I8"/> <field name="assoc_type" type="I8"/> <field name="assoc_id" type="I8"/> <field name="message" type="X"/> <descr>A log of all events associated with a submission.</descr> </table> <!-- * * TABLE article_email_log * --> <table name="article_email_log"> <field name="log_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="sender_id" type="I8"> <NOTNULL/> </field> <field name="date_sent" type="T"> <NOTNULL/> </field> <field name="ip_address" type="C2" size="15"/> <field name="event_type" type="I8"/> <field name="assoc_type" type="I8"/> <field name="assoc_id" type="I8"/> <field name="from_address" type="C2" size="255"/> <field name="recipients" type="X"/> <field name="cc_recipients" type="X"/> <field name="bcc_recipients" type="X"/> <field name="subject" type="C2" size="255"/> <field name="body" type="X"/> <descr>A log of all emails sent out related to a submission.</descr> </table> <!-- * * TABLE article_comments * --> <table name="article_comments"> <field name="comment_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="comment_type" type="I8"/> <field name="role_id" type="I8"> <NOTNULL/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="assoc_id" type="I8"> <NOTNULL/> </field> <field name="author_id" type="I8"> <NOTNULL/> </field> <field name="comment_title" type="C2" size="90"> <NOTNULL/> </field> <field name="comments" type="X"/> <field name="date_posted" type="T"/> <field name="date_modified" type="T"/> <field name="viewable" type="I1" /> <descr>Comments posted on articles.</descr> </table> <!-- * * TABLE email_templates_default * --> <table name="email_templates_default"> <field name="email_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="email_key" type="C2" size="30"> <NOTNULL/> <descr>Unique identifier for this email.</descr> </field> <field name="can_disable" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="can_edit" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="from_role_id" type="I8"/> <field name="to_role_id" type="I8"/> <descr>Default journal email templates.</descr> </table> <!-- * * TABLE email_templates_default_data * --> <table name="email_templates_default_data"> <field name="email_key" type="C2" size="30"> <NOTNULL /> <descr>Unique identifier for this email.</descr> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE="en_US"/> </field> <field name="subject" type="C2" size="120"> <NOTNULL/> </field> <field name="body" type="X"/> <field name="description" type="X"/> <descr>Default data for journal email templates.</descr> </table> <!-- * * TABLE email_templates * --> <table name="email_templates"> <field name="email_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="email_key" type="C2" size="30"> <NOTNULL/> <descr>Unique identifier for this email.</descr> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="enabled" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <descr>Templates for journal emails.</descr> </table> <!-- * * TABLE email_templates_data * --> <table name="email_templates_data"> <field name="email_key" type="C2" size="30"> <NOTNULL /> <descr>Unique identifier for this email.</descr> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE="en_US"/> </field> <field name="journal_id" type="I8"> <NOTNULL /> </field> <field name="subject" type="C2" size="120"> <NOTNULL/> </field> <field name="body" type="X"/> <descr>Data for journal email templates.</descr> </table> <!-- * * TABLE article_search_keyword_list * --> <table name="article_search_keyword_list"> <field name="keyword_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="keyword_text" type="C2" size="60"> <NOTNULL/> </field> <descr>List of all keywords.</descr> </table> <!-- * * TABLE article_search_objects * --> <table name="article_search_objects"> <field name="object_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="article_id" type="I8"> <NOTNULL/> </field> <field name="type" type="I4"> <NOTNULL/> <descr>Type of item. E.g., abstract, fulltext, etc.</descr> </field> <field name="assoc_id" type="I8"> <descr>Optional ID of an associated record (e.g., a file_id)</descr> </field> <descr>Indexed objects.</descr> </table> <!-- * * TABLE article_search_object_keywords * --> <table name="article_search_object_keywords"> <field name="object_id" type="I8"> <NOTNULL /> </field> <field name="keyword_id" type="I8"> <NOTNULL/> </field> <field name="pos" type="I4"> <NOTNULL /> <descr>Word position of the keyword in the object.</descr> </field> <descr>Keyword occurrences for each indexed object.</descr> </table> <!-- OAI Tables --> <!-- * * TABLE oai_resumption_tokens * --> <table name="oai_resumption_tokens"> <field name="token" type="C2" size="32"> <NOTNULL /> </field> <field name="expire" type="I8"> <NOTNULL/> </field> <field name="record_offset" type="I4"> <NOTNULL/> </field> <field name="params" type="X" /> <descr>Resumption tokens for the OAI protocol interface.</descr> </table> <!-- Reading Tools Tables --> <!-- * * TABLE rt_versions * --> <table name="rt_versions"> <field name="version_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="version_key" type="C2" size="40"> <NOTNULL/> </field> <field name="locale" type="C2" size="5"> <DEFAULT VALUE="en_US"/> </field> <field name="title" type="C2" size="120"> <NOTNULL/> </field> <field name="description" type="X"/> <descr>Reading Tools versions.</descr> </table> <!-- * * TABLE rt_contexts * --> <table name="rt_contexts"> <field name="context_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="version_id" type="I8"> <NOTNULL/> </field> <field name="title" type="C2" size="120"> <NOTNULL/> </field> <field name="abbrev" type="C2" size="32"> <NOTNULL/> </field> <field name="description" type="X"/> <field name="cited_by" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="author_terms" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="define_terms" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="geo_terms" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Reading Tools contexts (within versions).</descr> </table> <!-- * * TABLE rt_searches * --> <table name="rt_searches"> <field name="search_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="context_id" type="I8"> <NOTNULL/> </field> <field name="title" type="C2" size="120"> <NOTNULL/> </field> <field name="description" type="X"/> <field name="url" type="X"/> <field name="search_url" type="X"/> <field name="search_post" type="X"/> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Reading Tools searches (within contexts).</descr> </table> <!-- * * TABLE subscription_types * --> <table name="subscription_types"> <field name="type_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="type_name" type="C2" size="80"> <NOTNULL/> </field> <field name="description" type="X"/> <field name="cost" type="F"> <NOTNULL/> </field> <field name="currency_code_alpha" type="C2" size="3"> <NOTNULL/> </field> <field name="duration" type="I2"> <NOTNULL/> </field> <field name="format" type="I2"> <NOTNULL/> </field> <field name="institutional" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="membership" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="disable_public_display" type="I1"> <NOTNULL/> </field> <field name="seq" type="F"> <NOTNULL/> </field> <descr>Subscription types.</descr> </table> <!-- * * TABLE subscription_type_settings * --> <table name="subscription_type_settings"> <field name="type_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> </field> <descr>Locale-specific subscription type data</descr> </table> <!-- * * TABLE subscriptions * --> <table name="subscriptions"> <field name="subscription_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="user_id" type="I8"> <NOTNULL/> </field> <field name="type_id" type="I8"> <NOTNULL/> </field> <field name="date_start" type="D"> <NOTNULL/> </field> <field name="date_end" type="D"> <NOTNULL/> </field> <field name="membership" type="C2" size="40"/> <field name="domain" type="C2" size="255"/> <field name="ip_range" type="X"/> <descr>Journal subscriptions.</descr> </table> <!-- * * TABLE announcement_types * --> <table name="announcement_types"> <field name="type_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="type_name" type="C2" size="80"> <NOTNULL/> </field> <descr>Journal announcement types.</descr> </table> <!-- * * TABLE announcement_type_settings * --> <table name="announcement_type_settings"> <field name="type_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> </field> <descr>Language dependent journal announcement type data.</descr> </table> <!-- * * TABLE announcements * --> <table name="announcements"> <field name="announcement_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="type_id" type="I8"/> <field name="title" type="C2" size="255"> <NOTNULL/> </field> <field name="description_short" type="X"> <NOTNULL/> <DEFAULT VALUE=""/> </field> <field name="description" type="X"> <NOTNULL/> <DEFAULT VALUE=""/> </field> <field name="date_expire" type="T"/> <field name="date_posted" type="T"> <NOTNULL/> </field> <descr>Journal announcements</descr> </table> <!-- * * TABLE announcement_settings * --> <table name="announcement_settings"> <field name="announcement_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> </field> <descr>Language dependent journal announcement data.</descr> </table> <!-- * * TABLE captchas * --> <table name="captchas"> <field name="captcha_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="session_id" type="C2" size="32"> <NOTNULL/> </field> <field name="value" type="C2" size="20"> <NOTNULL/> </field> <field name="date_created" type="T"> <NOTNULL/> </field> </table> <!-- * * TABLE temporary_files * --> <table name="temporary_files"> <field name="file_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="user_id" type="I8"> <NOTNULL/> </field> <field name="file_name" type="C2" size="90"> <NOTNULL/> </field> <field name="file_type" type="C2" size="255"> </field> <field name="file_size" type="I8"> <NOTNULL/> </field> <field name="original_file_name" type="C2" size="127"/> <field name="date_uploaded" type="T"> <NOTNULL/> </field> <descr>Temporary file storage; used to keep attachments across multiple email composition requests</descr> </table> <!-- * * TABLE access_keys * --> <table name="access_keys"> <field name="access_key_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="context" type="C2" size="40"> <NOTNULL/> </field> <field name="key_hash" type="C2" size="40"> <NOTNULL/> </field> <field name="user_id" type="I8"> <NOTNULL/> </field> <field name="assoc_id" type="I8"/> <field name="expiry_date" type="T"> <NOTNULL/> </field> <descr>Access keys are used to provide pseudo-login functionality for security-minimal tasks. Passkeys can be emailed directly to users, who can use them for a limited time in lieu of standard username and password.</descr> </table> <!-- * * TABLE groups * --> <table name="groups"> <field name="group_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="context" type="I8"/> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="title" type="C2" size="255"> <NOTNULL/> </field> <field name="title_alt1" type="C2" size="255"/> <field name="title_alt2" type="C2" size="255"/> <field name="about_displayed" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> </table> <!-- * * TABLE group_settings * --> <table name="group_settings"> <field name="group_id" type="I8"> <NOTNULL /> </field> <field name="locale" type="C2" size="5"> <NOTNULL /> <DEFAULT VALUE=""/> </field> <field name="setting_name" type="C2" size="255"> <NOTNULL /> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> </field> <descr>Language dependent group data.</descr> </table> <!-- * * TABLE group_memberships * --> <table name="group_memberships"> <field name="user_id" type="I8"> <NOTNULL /> </field> <field name="group_id" type="I8"> <NOTNULL /> </field> <field name="about_displayed" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> </table> </schema>