| 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 : C:/Old Sites/Libteiser - Ojs/ojs/dbscripts/xml/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE schema SYSTEM "dtd/xmlschema.dtd"> <!-- * ojs_schema.xml * * Copyright (c) 2003-2008 John Willinsky * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING. * * OJS database schema in XML. * * $Id: ojs_schema.xml,v 1.165 2008/07/02 17:15:57 asmecher Exp $ --> <schema version="0.2"> <!-- * * TABLE review_forms * --> <table name="review_forms"> <field name="review_form_id" type="I8"> <KEY/> <AUTOINCREMENT/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="seq" type="F" /> <field name="is_active" type="I1" /> <descr>Review forms.</descr> <index name="review_forms_review_form_id"> <col>review_form_id</col> </index> </table> <!-- * * TABLE review_form_settings * --> <table name="review_form_settings"> <field name="review_form_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>Review form settings</descr> <index name="review_form_settings_review_form_id"> <col>review_form_id</col> </index> <index name="review_form_settings_pkey"> <col>review_form_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE /> </index> </table> <!-- * * TABLE review_form_elements * --> <table name="review_form_elements"> <field name="review_form_element_id" type="I8"> <KEY/> <AUTOINCREMENT/> </field> <field name="review_form_id" type="I8"> <NOTNULL/> </field> <field name="seq" type="F" /> <field name="element_type" type="I8" /> <field name="required" type="I1" /> <descr>Review form elements.</descr> <index name="review_form_elements_review_form_element_id"> <col>review_form_element_id</col> </index> </table> <!-- * * TABLE review_form_element_settings * --> <table name="review_form_element_settings"> <field name="review_form_element_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>Review form element settings</descr> <index name="review_form_element_settings_review_form_element_id"> <col>review_form_element_id</col> </index> <index name="review_form_element_settings_pkey"> <col>review_form_element_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE /> </index> </table> <!-- * * TABLE review_form_responses * --> <table name="review_form_responses"> <field name="review_form_element_id" type="I8"> <NOTNULL /> </field> <field name="review_id" type="I8"> <NOTNULL/> </field> <field name="response_type" type="C2" size="6"/> <field name="response_value" type="X" /> <descr>Review form responses.</descr> <index name="review_form_responses_pkey"> <col>review_form_element_id</col> <col>review_id</col> </index> </table> <!-- * * 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> <index name="versions_pkey"> <col>major</col> <col>minor</col> <col>revision</col> <col>build</col> <UNIQUE /> </index> </table> <!-- * * TABLE site * --> <table name="site"> <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/> <descr>Primary locale for the site.</descr> </field> <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> <index name="site_settings_pkey"> <col>setting_name</col> <col>locale</col> <UNIQUE /> </index> </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> <index name="scheduled_tasks_pkey"> <col>class_name</col> <UNIQUE /> </index> </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="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="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="date_end_membership" type="T"/> <field name="must_change_password" type="I1"/> <field name="auth_id" type="I8"/> <field name="auth_str" type="C2" size="255"/> <field name="disabled" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="disabled_reason" type="X"/> <descr>User authentication credentials and profile data.</descr> <index name="users_username"> <col>username</col> <UNIQUE /> </index> <index name="users_email"> <col>email</col> <UNIQUE /> </index> </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"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="setting_value" type="X"/> <field name="setting_type" type="C2" size="6"> <NOTNULL/> </field> <descr>Locale-specific user data</descr> <index name="user_settings_user_id"> <col>user_id</col> </index> <index name="user_settings_pkey"> <col>user_id</col> <col>locale</col> <col>setting_name</col> <col>journal_id</col> <UNIQUE /> </index> </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="39"> <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> <index name="sessions_user_id"> <col>user_id</col> </index> <index name="sessions_pkey"> <col>session_id</col> <UNIQUE /> </index> </table> <!-- * * TABLE journals * --> <table name="journals"> <field name="journal_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <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"> <NOTNULL/> </field> <field name="enabled" type="I1"> <NOTNULL/> <DEFAULT VALUE="1"/> </field> <descr>Journals and basic journal settings.</descr> <index name="journals_path"> <col>path</col> <UNIQUE /> </index> </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> <index name="journal_settings_journal_id"> <col>journal_id</col> </index> <index name="journal_settings_pkey"> <col>journal_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE /> </index> </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>Plugin settings.</descr> <index name="plugin_settings_plugin_name"> <col>plugin_name</col> </index> <index name="plugin_settings_pkey"> <col>plugin_name</col> <col>locale</col> <col>journal_id</col> <col>setting_name</col> <UNIQUE /> </index> </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> <index name="roles_journal_id"> <col>journal_id</col> </index> <index name="roles_user_id"> <col>user_id</col> </index> <index name="roles_role_id"> <col>role_id</col> </index> <index name="roles_pkey"> <col>journal_id</col> <col>user_id</col> <col>role_id</col> <UNIQUE /> </index> </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> <index name="notification_status_pkey"> <col>journal_id</col> <col>user_id</col> <UNIQUE /> </index> </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="review_form_id" type="I8" /> <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_not_required" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="hide_title" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="hide_author" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="hide_about" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="disable_comments" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Journal sections.</descr> <index name="sections_journal_id"> <col>journal_id</col> </index> </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> <index name="section_settings_section_id"> <col>section_id</col> </index> <index name="section_settings_pkey"> <col>section_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE /> </index> </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> <index name="section_editors_journal_id"> <col>journal_id</col> </index> <index name="section_editors_section_id"> <col>section_id</col> </index> <index name="section_editors_user_id"> <col>user_id</col> </index> <index name="section_editors_pkey"> <col>journal_id</col> <col>section_id</col> <col>user_id</col> <UNIQUE /> </index> </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="volume" type="I2"/> <field name="number" type="C2" size="10" /> <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="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="style_file_name" type="C2" size="90"/> <field name="original_style_file_name" type="C2" size="255"/> <descr>Journal issues.</descr> <index name="issues_journal_id"> <col>journal_id</col> </index> <index name="issues_public_issue_id"> <col>public_issue_id</col> <col>journal_id</col> <UNIQUE /> </index> </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> <index name="issue_settings_issue_id"> <col>issue_id</col> </index> <index name="issue_settings_pkey"> <col>issue_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE /> </index> </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> <index name="custom_issue_orders_pkey"> <col>issue_id</col> <UNIQUE/> </index> </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> <index name="custom_section_orders_pkey"> <col>issue_id</col> <col>section_id</col> <UNIQUE/> </index> </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="language" type="C2" size="10"> <DEFAULT VALUE="en"/> </field> <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"/> <field name="fast_tracked" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="hide_author" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="comments_status" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <descr>Journal articles.</descr> <index name="articles_user_id"> <col>user_id</col> </index> <index name="articles_journal_id"> <col>journal_id</col> </index> <index name="articles_section_id"> <col>section_id</col> </index> </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> <index name="article_settings_article_id"> <col>article_id</col> </index> <index name="article_settings_pkey"> <col>article_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE/> </index> </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> <index name="published_articles_article_id"> <col>article_id</col> <UNIQUE/> </index> <index name="published_articles_issue_id"> <col>issue_id</col> </index> <index name="published_articles_public_article_id"> <col>public_article_id</col> </index> </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> <index name="comments_article_id"> <col>article_id</col> </index> <index name="comments_user_id"> <col>user_id</col> </index> </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"/> <descr>Author metadata for articles.</descr> <index name="article_authors_article_id"> <col>article_id</col> </index> </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> <index name="article_author_settings_author_id"> <col>author_id</col> </index> <index name="article_author_settings_pkey"> <col>author_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE/> </index> </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> <index name="article_files_article_id"> <col>article_id</col> </index> </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="type" 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> <index name="article_supplementary_files_file_id"> <col>file_id</col> </index> <index name="article_supplementary_files_article_id"> <col>article_id</col> </index> <index name="supp_public_supp_file_id"> <col>public_supp_file_id</col> </index> </table> <!-- * * TABLE article_supp_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> <index name="article_supp_file_settings_supp_id"> <col>supp_id</col> </index> <index name="article_supp_file_settings_pkey"> <col>supp_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE/> </index> </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> <index name="article_notes_article_id"> <col>article_id</col> </index> <index name="article_notes_user_id"> <col>user_id</col> </index> <index name="article_notes_file_id"> <col>file_id</col> </index> </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> <index name="edit_assignments_article_id"> <col>article_id</col> </index> <index name="edit_assignments_editor_id"> <col>editor_id</col> </index> </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> <index name="edit_decisions_article_id"> <col>article_id</col> </index> <index name="edit_decisions_editor_id"> <col>editor_id</col> </index> </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> <index name="review_rounds_article_id"> <col>article_id</col> </index> <index name="review_rounds_pkey"> <col>article_id</col> <col>round</col> <UNIQUE/> </index> </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="competing_interests" type="X"/> <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> <field name="review_form_id" type="I8"/> <descr>Reviewing assignments.</descr> <index name="review_assignments_article_id"> <col>article_id</col> </index> <index name="review_assignments_reviewer_id"> <col>reviewer_id</col> </index> </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> <index name="copyed_assignments_article_id"> <col>article_id</col> </index> <index name="copyed_assignments_copyeditor_id"> <col>copyeditor_id</col> </index> </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> <index name="layouted_assignments_article_id"> <col>article_id</col> <UNIQUE/> </index> <index name="layouted_assignments_editor_id"> <col>editor_id</col> </index> </table> <!-- * * TABLE article_galleys * --> <table name="article_galleys"> <field name="galley_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="public_galley_id" type="C2" size="255" /> <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> <index name="article_galleys_article_id"> <col>article_id</col> </index> <index name="article_galleys_public_id"> <col>public_galley_id</col> <col>article_id</col> <UNIQUE/> </index> </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> <index name="article_html_galley_images_pkey"> <col>galley_id</col> <col>file_id</col> <UNIQUE/> </index> </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> <index name="proof_assignments_article_id"> <col>article_id</col> </index> <index name="proof_assignments_proofreader_id"> <col>proofreader_id</col> </index> </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> <index name="article_event_log_article_id"> <col>article_id</col> </index> </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> <index name="article_email_log_article_id"> <col>article_id</col> </index> </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> <index name="article_comments_article_id"> <col>article_id</col> </index> </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> <index name="email_templates_default_email_key"> <col>email_key</col> </index> </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> <index name="email_templates_default_data_pkey"> <col>email_key</col> <col>locale</col> <UNIQUE /> </index> </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> <index name="email_templates_email_key"> <col>email_key</col> <col>journal_id</col> <UNIQUE/> </index> <index name="email_templates_journal_id"> <col>journal_id</col> </index> </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> <index name="email_templates_data_pkey"> <col>email_key</col> <col>locale</col> <col>journal_id</col> <UNIQUE/> </index> </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> <index name="article_search_keyword_text"> <col>keyword_text</col> <UNIQUE/> </index> </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> <index name="article_search_object_keywords_keyword_id"> <col>keyword_id</col> </index> <index name="article_search_object_keywords_pkey"> <col>object_id</col> <col>pos</col> <UNIQUE /> </index> </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> <index name="oai_resumption_tokens_pkey"> <col>token</col> <UNIQUE/> </index> </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> <index name="rt_versions_journal_id"> <col>journal_id</col> </index> <index name="rt_versions_version_key"> <col>version_key</col> </index> </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> <index name="rt_contexts_version_id"> <col>version_id</col> </index> </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> <index name="rt_searches_context_id"> <col>context_id</col> </index> </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="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> <index name="subscription_type_settings_type_id"> <col>type_id</col> </index> <index name="subscription_type_settings_pkey"> <col>type_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE/> </index> </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> <index name="subscription_journal_id"> <col>journal_id</col> <col>user_id</col> <UNIQUE/> </index> <index name="subscription_domain"> <col>domain</col> </index> </table> <!-- * * TABLE subscription_ip * --> <table name="subscription_ip"> <field name="subscription_ip_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="subscription_id" type="I8"> <NOTNULL/> </field> <field name="ip_start" type="I8"> <NOTNULL/> </field> <field name="ip_end" type="I8"> </field> <descr>Journal subscription IPs and IP ranges.</descr> <index name="subscription_ip_subscription_id"> <col>subscription_id</col> </index> <index name="subscription_ip_start"> <col>ip_start</col> </index> <index name="subscription_ip_end"> <col>ip_end</col> </index> </table> <!-- * * TABLE queued_payments * --> <table name="queued_payments"> <field name="queued_payment_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="key_hash" type="C2" size="40"> <NOTNULL/> </field> <field name="date_created" type="T"> <NOTNULL/> </field> <field name="date_modified" type="T"> <NOTNULL/> </field> <field name="payment_data" type="X" /> <descr>Logs queued (unfulfilled) payments.</descr> <index name="queued_payments_hash"> <col>key_hash</col> <col>queued_payment_id</col> </index> </table> <!-- * * TABLE completed_payments * --> <table name="completed_payments"> <field name="completed_payment_id" type="I8"> <KEY /> <AUTOINCREMENT/> </field> <field name="timestamp" type="T"> <NOTNULL/> </field> <field name="payment_type" type="I8"> <NOTNULL/> </field> <field name="journal_id" type="I8"> <NOTNULL/> </field> <field name="user_id" type="I8" /> <field name="assoc_id" type="I8" /> <field name="amount" type="F"> <NOTNULL/> </field> <field name="currency_code_alpha" type="C2" size="3" /> <field name="payment_method_plugin_name" type="C2" size="80" /> <descr>Logs completed (fulfilled) payments.</descr> <index name="completed_payments_hash"> <col>key_hash</col> <col>completed_payment_id</col> </index> </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> <descr>Journal announcement types.</descr> <index name="announcement_types_journal_id"> <col>journal_id</col> </index> </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> <index name="announcement_type_settings_type_id"> <col>type_id</col> </index> <index name="announcement_type_settings_pkey"> <col>type_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE/> </index> </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="date_expire" type="T"/> <field name="date_posted" type="T"> <NOTNULL/> </field> <descr>Journal announcements</descr> <index name="announcements_journal_id"> <col>journal_id</col> </index> </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> <index name="announcement_settings_announcement_id"> <col>announcement_id</col> </index> <index name="announcement_settings_pkey"> <col>announcement_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE /> </index> </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> <index name="temporary_files_user_id"> <col>user_id</col> </index> </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> <index name="access_keys_hash"> <col>key_hash</col> <col>user_id</col> <col>context</col> </index> </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="about_displayed" type="I1"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <field name="seq" type="F"> <NOTNULL/> <DEFAULT VALUE="0"/> </field> <index name="groups_journal_id"> <col>journal_id</col> </index> </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> <index name="group_settings_group_id"> <col>group_id</col> </index> <index name="group_settings_pkey"> <col>group_id</col> <col>locale</col> <col>setting_name</col> <UNIQUE /> </index> </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> <index name="group_memberships_pkey"> <col>user_id</col> <col>group_id</col> <UNIQUE/> </index> </table> </schema>