docs/db_diagrams/hms.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!-- $Header: /cvsroot/autodoc/autodoc/xml.tmpl,v 1.2 2006/05/16 19:01:27 rbt Exp $ -->
<book id="database.jbooker" xreflabel="jbooker database schema"><title>jbooker Model</title>
<chapter id="public.schema"
xreflabel="public">
<title>Schema public</title>
<para>Standard public schema</para>
<section id="public.table.block"
xreflabel="public.block">
<title id="public.table.block-title">
Table:
<structname>block</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>block</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>content</structfield></term>
<listitem><para>
<type>text</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.block-permissions"
xreflabel="public.block_permissions">
<title id="public.table.block-permissions-title">
Table:
<structname>block_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>block_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_block</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_block</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.block-pinned"
xreflabel="public.block_pinned">
<title id="public.table.block-pinned-title">
Table:
<structname>block_pinned</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>block_pinned</structname>
</title>
<varlistentry>
<term><structfield>block_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.boost-permissions"
xreflabel="public.boost_permissions">
<title id="public.table.boost-permissions-title">
Table:
<structname>boost_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>boost_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.calendar-notice"
xreflabel="public.calendar_notice">
<title id="public.table.calendar-notice-title">
Table:
<structname>calendar_notice</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>calendar_notice</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>email</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.calendar-permissions"
xreflabel="public.calendar_permissions">
<title id="public.table.calendar-permissions-title">
Table:
<structname>calendar_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>calendar_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>settings</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_public</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_private</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_schedule</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.calendar-schedule"
xreflabel="public.calendar_schedule">
<title id="public.table.calendar-schedule-title">
Table:
<structname>calendar_schedule</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>calendar_schedule</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(60)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>show_upcoming</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>summary</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>public</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.calendar-suggestions"
xreflabel="public.calendar_suggestions">
<title id="public.table.calendar-suggestions-title">
Table:
<structname>calendar_suggestions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>calendar_suggestions</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>schedule_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>summary</structfield></term>
<listitem><para>
<type>character varying(60)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>location</structfield></term>
<listitem><para>
<type>character varying(60)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>loc_link</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>all_day</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>start_time</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>end_time</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>submitted</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.categories"
xreflabel="public.categories">
<title id="public.table.categories-title">
Table:
<structname>categories</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>categories</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>parent</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>icon</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.categories-permissions"
xreflabel="public.categories_permissions">
<title id="public.table.categories-permissions-title">
Table:
<structname>categories_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>categories_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_categories</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.category-items"
xreflabel="public.category_items">
<title id="public.table.category-items-title">
Table:
<structname>category_items</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>category_items</structname>
</title>
<varlistentry>
<term><structfield>cat_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on category_items</title>
<varlistentry>
<term>categoryitems_idx</term>
<listitem><para>cat_id, module</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.comments-items"
xreflabel="public.comments_items">
<title id="public.table.comments-items-title">
Table:
<structname>comments_items</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>comments_items</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>thread_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>parent</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>author_ip</structfield></term>
<listitem><para>
<type>character varying(15)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>author_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>subject</structfield></term>
<listitem><para>
<type>character varying(100)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>entry</structfield></term>
<listitem><para>
<type>text</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_author</structfield></term>
<listitem><para>
<type>character varying(50)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>create_time</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_time</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_reason</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.comments-permissions"
xreflabel="public.comments_permissions">
<title id="public.table.comments-permissions-title">
Table:
<structname>comments_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>comments_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_comments</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_comments</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>settings</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.comments-threads"
xreflabel="public.comments_threads">
<title id="public.table.comments-threads-title">
Table:
<structname>comments_threads</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>comments_threads</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>total_comments</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>last_poster</structfield></term>
<listitem><para>
<type>character varying(40)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>allow_anon</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.comments-users"
xreflabel="public.comments_users">
<title id="public.table.comments-users-title">
Table:
<structname>comments_users</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>comments_users</structname>
</title>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>display_name</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>comments_made</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>joined_date</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>locked</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.controlpanel-link"
xreflabel="public.controlpanel_link">
<title id="public.table.controlpanel-link-title">
Table:
<structname>controlpanel_link</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>controlpanel_link</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>tab</structfield></term>
<listitem><para>
<type>character(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>label</structfield></term>
<listitem><para>
<type>character(50)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>itemname</structfield></term>
<listitem><para>
<type>character(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>restricted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>url</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>image</structfield></term>
<listitem><para>
<type>character(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>link_order</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.controlpanel-permissions"
xreflabel="public.controlpanel_permissions">
<title id="public.table.controlpanel-permissions-title">
Table:
<structname>controlpanel_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>controlpanel_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>remove_tab</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>add_tab</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>move_link</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.controlpanel-tab"
xreflabel="public.controlpanel_tab">
<title id="public.table.controlpanel-tab-title">
Table:
<structname>controlpanel_tab</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>controlpanel_tab</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>character(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>link</structfield></term>
<listitem><para>
<type>character(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>tab_order</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>itemname</structfield></term>
<listitem><para>
<type>character(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.converted"
xreflabel="public.converted">
<title id="public.table.converted-title">
Table:
<structname>converted</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>converted</structname>
</title>
<varlistentry>
<term><structfield>convert_name</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.core-version"
xreflabel="public.core_version">
<title id="public.table.core-version-title">
Table:
<structname>core_version</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>core_version</structname>
</title>
<varlistentry>
<term><structfield>version</structfield></term>
<listitem><para>
<type>character varying(10)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.demographics"
xreflabel="public.demographics">
<title id="public.table.demographics-title">
Table:
<structname>demographics</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>demographics</structname>
</title>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>avatar</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>signature</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>contact_email</structfield></term>
<listitem><para>
<type>character varying(30)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>website</structfield></term>
<listitem><para>
<type>character varying(60)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on demographics</title>
<varlistentry>
<term>user_id</term>
<listitem><para>user_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.dependencies"
xreflabel="public.dependencies">
<title id="public.table.dependencies-title">
Table:
<structname>dependencies</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>dependencies</structname>
</title>
<varlistentry>
<term><structfield>source_mod</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>depended_on</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>version</structfield></term>
<listitem><para>
<type>character varying(20)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.documents"
xreflabel="public.documents">
<title id="public.table.documents-title">
Table:
<structname>documents</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>documents</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_name</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_directory</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>folder_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_type</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>size</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>downloaded</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.filecabinet-permissions"
xreflabel="public.filecabinet_permissions">
<title id="public.table.filecabinet-permissions-title">
Table:
<structname>filecabinet_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>filecabinet_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_folders</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_folders</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>settings</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>classify</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.filecabinet-pins"
xreflabel="public.filecabinet_pins">
<title id="public.table.filecabinet-pins-title">
Table:
<structname>filecabinet_pins</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>filecabinet_pins</structname>
</title>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>folder_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.folders"
xreflabel="public.folders">
<title id="public.table.folders-title">
Table:
<structname>folders</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>folders</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(60)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>ftype</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 1</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>public_folder</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 1</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>icon</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>module_created</structfield></term>
<listitem><para>
<type>character varying(40)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-activity-log"
xreflabel="public.hms_activity_log">
<title id="public.table.hms-activity-log-title">
Table:
<structname>hms_activity_log</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_activity_log</structname>
</title>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>activity</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>actor</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>notes</structfield></term>
<listitem><para>
<type>character varying(512)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-application"
xreflabel="public.hms_application">
<title id="public.table.hms-application-title">
Table:
<structname>hms_application</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_application</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>hms_student_id</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>UNIQUE#1</literal>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>student_status</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term_classification</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meal_option</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>lifestyle_option</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>preferred_bedtime</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>room_condition</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>in_relationship</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>currently_employed</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_interest</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>agreed_to_terms</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>aggregate</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>created_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>created_by</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>UNIQUE#1</literal>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>physical_disability</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>psych_disability</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>medical_need</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender_need</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-assignment"
xreflabel="public.hms_assignment">
<title id="public.table.hms-assignment-title">
Table:
<structname>hms_assignment</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_assignment</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>asu_username</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>bed_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-bed"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-bed"
xreflabel="public.hms_bed">
<title id="public.table.hms-bed-title">
Table:
<structname>hms_bed</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_bed</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>bed_letter</structfield></term>
<listitem><para>
<type>character(1)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>banner_id</structfield></term>
<listitem><para>
<type>character varying(15)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>phone_number</structfield></term>
<listitem><para>
<type>character(4)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>room_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-room"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>bedroom_label</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>ra_bed</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_assignment via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-assignment"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-bedroom"
xreflabel="public.hms_bedroom">
<title id="public.table.hms-bedroom-title">
Table:
<structname>hms_bedroom</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_bedroom</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>room_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-room"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_by</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>bedroom_letter</structfield></term>
<listitem><para>
<type>character(1)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-cached-student-info"
xreflabel="public.hms_cached_student_info">
<title id="public.table.hms-cached-student-info-title">
Table:
<structname>hms_cached_student_info</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_cached_student_info</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>asu_username</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>room_number</structfield></term>
<listitem><para>
<type>character varying(10)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>hall_name</structfield></term>
<listitem><para>
<type>character varying(64)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>first_name</structfield></term>
<listitem><para>
<type>character varying(64)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>middle_name</structfield></term>
<listitem><para>
<type>character varying(64)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>last_name</structfield></term>
<listitem><para>
<type>character varying(64)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>address1</structfield></term>
<listitem><para>
<type>character varying(128)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>address2</structfield></term>
<listitem><para>
<type>character varying(128)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>address3</structfield></term>
<listitem><para>
<type>character varying(128)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>city</structfield></term>
<listitem><para>
<type>character varying(64)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>state</structfield></term>
<listitem><para>
<type>character varying(5)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>zip</structfield></term>
<listitem><para>
<type>character varying(11)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_name</structfield></term>
<listitem><para>
<type>character varying(172)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_user</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>room_phone</structfield></term>
<listitem><para>
<type>character varying(20)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>phone_number</structfield></term>
<listitem><para>
<type>character varying(20)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender</structfield></term>
<listitem><para>
<type>character(1)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>student_type</structfield></term>
<listitem><para>
<type>character(5)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>class</structfield></term>
<listitem><para>
<type>character(5)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>credit_hours</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deposit_date</structfield></term>
<listitem><para>
<type>character(10)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deposit_waived</structfield></term>
<listitem><para>
<type>character(5)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>movein_time</structfield></term>
<listitem><para>
<type>character varying(64)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-deadlines"
xreflabel="public.hms_deadlines">
<title id="public.table.hms-deadlines-title">
Table:
<structname>hms_deadlines</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_deadlines</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>submit_application_begin_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>submit_application_end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_application_end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_profile_begin_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_profile_end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>search_profiles_begin_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>search_profiles_end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>submit_rlc_application_end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>view_assignment_begin_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>view_assignment_end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>lottery_signup_begin_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>lottery_signup_end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-floor"
xreflabel="public.hms_floor">
<title id="public.table.hms-floor-title">
Table:
<structname>hms_floor</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_floor</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>floor_number</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>residence_hall_id</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-residence-hall"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>is_online</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender_type</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_by</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>ft_movein_time_id</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-movein-time"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rt_movein_time_id</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-movein-time"/>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_room via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-room"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-suite"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-hall-communities"
xreflabel="public.hms_hall_communities">
<title id="public.table.hms-hall-communities-title">
Table:
<structname>hms_hall_communities</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_hall_communities</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>community_name</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-learning-communities"
xreflabel="public.hms_learning_communities">
<title id="public.table.hms-learning-communities-title">
Table:
<structname>hms_learning_communities</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_learning_communities</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>community_name</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>abbreviation</structfield></term>
<listitem><para>
<type>character varying(16)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>capacity</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_learning_community_applications via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-learning-community-applications"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-learning-community-assignment"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-learning-community-floors"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-learning-community-questions"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-learning-community-applications"
xreflabel="public.hms_learning_community_applications">
<title id="public.table.hms-learning-community-applications-title">
Table:
<structname>hms_learning_community_applications</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_learning_community_applications</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>UNIQUE</literal>
<literal>UNIQUE#1</literal>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>date_submitted</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_first_choice_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-learning-communities"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_second_choice_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-learning-communities"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_third_choice_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-learning-communities"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>why_specific_communities</structfield></term>
<listitem><para>
<type>character varying(2048)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>strengths_weaknesses</structfield></term>
<listitem><para>
<type>character varying(2048)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_question_0</structfield></term>
<listitem><para>
<type>character varying(2048)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_question_1</structfield></term>
<listitem><para>
<type>character varying(2048)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_question_2</structfield></term>
<listitem><para>
<type>character varying(2048)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>required_course</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>hms_assignment_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-learning-community-assignment"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>UNIQUE#1</literal>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-learning-community-assignment"
xreflabel="public.hms_learning_community_assignment">
<title id="public.table.hms-learning-community-assignment-title">
Table:
<structname>hms_learning_community_assignment</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_learning_community_assignment</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>asu_username</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>UNIQUE</literal>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rlc_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-learning-communities"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender</structfield></term>
<listitem><para>
<type>character varying(2)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>assigned_by</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_learning_community_applications via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-learning-community-applications"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-learning-community-floors"
xreflabel="public.hms_learning_community_floors">
<title id="public.table.hms-learning-community-floors-title">
Table:
<structname>hms_learning_community_floors</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_learning_community_floors</structname>
</title>
<varlistentry>
<term><structfield>learning_communities_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-learning-communities"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>floor_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-learning-community-questions"
xreflabel="public.hms_learning_community_questions">
<title id="public.table.hms-learning-community-questions-title">
Table:
<structname>hms_learning_community_questions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_learning_community_questions</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>learning_community_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-learning-communities"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>question_text</structfield></term>
<listitem><para>
<type>text</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-movein-time"
xreflabel="public.hms_movein_time">
<title id="public.table.hms-movein-time-title">
Table:
<structname>hms_movein_time</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_movein_time</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>begin_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>UNIQUE#1</literal>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>end_timestamp</structfield></term>
<listitem><para>
<type>integer</type>
<literal>UNIQUE#1</literal>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>UNIQUE#1</literal>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_floor via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-floor"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-pending-assignment"
xreflabel="public.hms_pending_assignment">
<title id="public.table.hms-pending-assignment-title">
Table:
<structname>hms_pending_assignment</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_pending_assignment</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>lifestyle_option</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>chosen</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_zero</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meal_zero</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_one</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meal_one</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-pricing-tiers"
xreflabel="public.hms_pricing_tiers">
<title id="public.table.hms-pricing-tiers-title">
Table:
<structname>hms_pricing_tiers</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_pricing_tiers</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>tier_value</structfield></term>
<listitem><para>
<type>numeric</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-residence-hall"
xreflabel="public.hms_residence_hall">
<title id="public.table.hms-residence-hall-title">
Table:
<structname>hms_residence_hall</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_residence_hall</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>banner_building_code</structfield></term>
<listitem><para>
<type>character varying(6)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>hall_name</structfield></term>
<listitem><para>
<type>character varying(64)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender_type</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>air_conditioned</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>is_online</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_by</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>per_freshmen_rsvd</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>per_sophomore_rsvd</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>per_junior_rsvd</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>per_senior_rsvd</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_floor via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-floor"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-room"
xreflabel="public.hms_room">
<title id="public.table.hms-room-title">
Table:
<structname>hms_room</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_room</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>floor_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-floor"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender_type</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>learning_community_id</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>is_medical</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>is_reserved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>is_online</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_by</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT (0)::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>room_number</structfield></term>
<listitem><para>
<type>character varying(8)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>ra_room</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>private_room</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>is_lobby</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>pricing_tier</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>suite_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-suite"/>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_bed via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-bed"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-bedroom"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-roommate-approval"
xreflabel="public.hms_roommate_approval">
<title id="public.table.hms-roommate-approval-title">
Table:
<structname>hms_roommate_approval</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_roommate_approval</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>number_roommates</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_zero</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_zero_approved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_zero_personal_hash</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_one</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_one_approved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_one_personal_hash</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_two</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_two_approved</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_two_personal_hash</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_three</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_three_approved</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_three_personal_hash</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-roommates"
xreflabel="public.hms_roommates">
<title id="public.table.hms-roommates-title">
Table:
<structname>hms_roommates</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_roommates</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_zero</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_one</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_two</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>roommate_three</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-student"
xreflabel="public.hms_student">
<title id="public.table.hms-student-title">
Table:
<structname>hms_student</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_student</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>asu_username</structfield></term>
<listitem><para>
<type>character varying(10)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>first_name</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>middle_name</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>last_name</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gender</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>application_received</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_by</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_on</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-student-profiles"
xreflabel="public.hms_student_profiles">
<title id="public.table.hms-student-profiles-title">
Table:
<structname>hms_student_profiles</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_student_profiles</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>character varying(32)</type>
<literal>UNIQUE</literal>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>date_submitted</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>alternate_email</structfield></term>
<listitem><para>
<type>character varying(64)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>aim_sn</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>yahoo_sn</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>msn_sn</structfield></term>
<listitem><para>
<type>character varying(32)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>arts_and_crafts</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>books_and_reading</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>cars</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>church_activities</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>collecting</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>computers_and_technology</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>dancing</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>fashion</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>fine_arts</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>gardening</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>games</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>humor</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>investing_personal_finance</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>movies</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>music</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>outdoor_activities</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>pets_and_animals</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>photography</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>politics</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>sports</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>travel</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>tv_shows</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>volunteering</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>writing</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>alternative</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>ambient</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>beach</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>bluegrass</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>blues</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>classical</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>classic_rock</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>country</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>electronic</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>folk</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>heavy_metal</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>hip_hop</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>house</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>industrial</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>jazz</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>popular_music</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>progressive</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>punk</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>r_and_b</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rap</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>reggae</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>rock</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>world_music</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>study_early_morning</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>study_morning_afternoon</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>study_afternoon_evening</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>study_evening</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>study_late_night</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>political_view</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>major</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>experience</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>sleep_time</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>wakeup_time</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>overnight_guests</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>loudness</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>cleanliness</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>free_time</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.hms-suite"
xreflabel="public.hms_suite">
<title id="public.table.hms-suite-title">
Table:
<structname>hms_suite</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_suite</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>floor_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-floor"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
<literal>REFERENCES</literal> <xref linkend="public.table.hms-term"/>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>added_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_by</structfield></term>
<listitem><para>
<type>smallint</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deleted_on</structfield></term>
<listitem><para>
<type>integer</type>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_room via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-room"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.hms-term"
xreflabel="public.hms_term">
<title id="public.table.hms-term-title">
Table:
<structname>hms_term</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>hms_term</structname>
</title>
<varlistentry>
<term><structfield>term</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<itemizedlist>
<title>
Tables referencing hms_application via Foreign Key Constraints
</title>
<listitem>
<para>
<xref linkend="public.table.hms-application"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-assignment"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-bed"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-bedroom"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-deadlines"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-floor"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-learning-community-applications"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-movein-time"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-residence-hall"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-room"/>
</para>
</listitem>
<listitem>
<para>
<xref linkend="public.table.hms-suite"/>
</para>
</listitem>
</itemizedlist>
</para>
</section>
<section id="public.table.images"
xreflabel="public.images">
<title id="public.table.images-title">
Table:
<structname>images</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>images</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_name</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_directory</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>folder_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_type</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>size</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>width</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>height</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>parent_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>url</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>alt</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.layout-box"
xreflabel="public.layout_box">
<title id="public.table.layout-box-title">
Table:
<structname>layout_box</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>layout_box</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>theme</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>content_var</structfield></term>
<listitem><para>
<type>character varying(40)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character varying(40)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>theme_var</structfield></term>
<listitem><para>
<type>character varying(40)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>box_order</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.layout-config"
xreflabel="public.layout_config">
<title id="public.table.layout-config-title">
Table:
<structname>layout_config</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>layout_config</structname>
</title>
<varlistentry>
<term><structfield>default_theme</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>userallow</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>page_title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_keywords</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_description</structfield></term>
<listitem><para>
<type>character varying(180)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_robots</structfield></term>
<listitem><para>
<type>character(2)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_owner</structfield></term>
<listitem><para>
<type>character varying(40)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_author</structfield></term>
<listitem><para>
<type>character varying(40)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_content</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>header</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>footer</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>cache</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.layout-metatags"
xreflabel="public.layout_metatags">
<title id="public.table.layout-metatags-title">
Table:
<structname>layout_metatags</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>layout_metatags</structname>
</title>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>page_title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_keywords</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>meta_robots</structfield></term>
<listitem><para>
<type>character(2)</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 11</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.layout-permissions"
xreflabel="public.layout_permissions">
<title id="public.table.layout-permissions-title">
Table:
<structname>layout_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>layout_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.layout-styles"
xreflabel="public.layout_styles">
<title id="public.table.layout-styles-title">
Table:
<structname>layout_styles</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>layout_styles</structname>
</title>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>style</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on layout_styles</title>
<varlistentry>
<term>layoutstyles_idx</term>
<listitem><para>key_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.menu-assoc"
xreflabel="public.menu_assoc">
<title id="public.table.menu-assoc-title">
Table:
<structname>menu_assoc</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>menu_assoc</structname>
</title>
<varlistentry>
<term><structfield>menu_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.menu-links"
xreflabel="public.menu_links">
<title id="public.table.menu-links-title">
Table:
<structname>menu_links</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>menu_links</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>menu_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>url</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>parent</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>link_order</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.menu-permissions"
xreflabel="public.menu_permissions">
<title id="public.table.menu-permissions-title">
Table:
<structname>menu_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>menu_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>create_new_menu</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_menu</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.menus"
xreflabel="public.menus">
<title id="public.table.menus-title">
Table:
<structname>menus</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>menus</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>template</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>restricted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>pin_all</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.mod-settings"
xreflabel="public.mod_settings">
<title id="public.table.mod-settings-title">
Table:
<structname>mod_settings</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>mod_settings</structname>
</title>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>setting_name</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>setting_type</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 4</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>small_num</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>large_num</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>small_char</structfield></term>
<listitem><para>
<type>character varying(100)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>large_char</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on mod_settings</title>
<varlistentry>
<term>modsettings_idx</term>
<listitem><para>module, setting_name</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.modules"
xreflabel="public.modules">
<title id="public.table.modules-title">
Table:
<structname>modules</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>modules</structname>
</title>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character(40)</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>proper_name</structfield></term>
<listitem><para>
<type>character(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>priority</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>version</structfield></term>
<listitem><para>
<type>character(20)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>register</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>unregister</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.multimedia"
xreflabel="public.multimedia">
<title id="public.table.multimedia-title">
Table:
<structname>multimedia</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>multimedia</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_name</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_directory</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>folder_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>file_type</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>size</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>width</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>height</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>thumbnail</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.notes"
xreflabel="public.notes">
<title id="public.table.notes-title">
Table:
<structname>notes</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>notes</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>sender_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(60)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>content</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>read_once</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>encrypted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>date_sent</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on notes</title>
<varlistentry>
<term>notes_idx</term>
<listitem><para>user_id, key_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.notes-permissions"
xreflabel="public.notes_permissions">
<title id="public.table.notes-permissions-title">
Table:
<structname>notes_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>notes_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>search_usernames</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.phpws-key"
xreflabel="public.phpws_key">
<title id="public.table.phpws-key-title">
Table:
<structname>phpws_key</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>phpws_key</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>item_name</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>item_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>summary</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>url</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 1</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>restricted</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>create_date</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>update_date</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>creator</structfield></term>
<listitem><para>
<type>character varying(60)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>creator_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updater</structfield></term>
<listitem><para>
<type>character varying(60)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updater_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>times_viewed</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_permission</structfield></term>
<listitem><para>
<type>character varying(30)</type>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on phpws_key</title>
<varlistentry>
<term>phpwskey_idx</term>
<listitem><para>restricted, active, module, create_date, update_date</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.phpws-key-edit"
xreflabel="public.phpws_key_edit">
<title id="public.table.phpws-key-edit-title">
Table:
<structname>phpws_key_edit</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>phpws_key_edit</structname>
</title>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on phpws_key_edit</title>
<varlistentry>
<term>phpwskeyedit_idx</term>
<listitem><para>key_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.phpws-key-register"
xreflabel="public.phpws_key_register">
<title id="public.table.phpws-key-register-title">
Table:
<structname>phpws_key_register</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>phpws_key_register</structname>
</title>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.phpws-key-view"
xreflabel="public.phpws_key_view">
<title id="public.table.phpws-key-view-title">
Table:
<structname>phpws_key_view</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>phpws_key_view</structname>
</title>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on phpws_key_view</title>
<varlistentry>
<term>phpwskeyview_idx</term>
<listitem><para>key_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.registered"
xreflabel="public.registered">
<title id="public.table.registered-title">
Table:
<structname>registered</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>registered</structname>
</title>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>registered_to</structfield></term>
<listitem><para>
<type>character(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.rss-channel"
xreflabel="public.rss_channel">
<title id="public.table.rss-channel-title">
Table:
<structname>rss_channel</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>rss_channel</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(100)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>description</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>pub_date</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>ttl</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>image_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 1</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.rss-feeds"
xreflabel="public.rss_feeds">
<title id="public.table.rss-feeds-title">
Table:
<structname>rss_feeds</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>rss_feeds</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(100)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>address</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>display</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>refresh_time</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>item_limit</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.rss-permissions"
xreflabel="public.rss_permissions">
<title id="public.table.rss-permissions-title">
Table:
<structname>rss_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>rss_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.search"
xreflabel="public.search">
<title id="public.table.search-title">
Table:
<structname>search</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>search</structname>
</title>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>module</structfield></term>
<listitem><para>
<type>character(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>created</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>keywords</structfield></term>
<listitem><para>
<type>text</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on search</title>
<varlistentry>
<term>search_index</term>
<listitem><para>key_id, module, created</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.search-permissions"
xreflabel="public.search_permissions">
<title id="public.table.search-permissions-title">
Table:
<structname>search_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>search_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.search-stats"
xreflabel="public.search_stats">
<title id="public.table.search-stats-title">
Table:
<structname>search_stats</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>search_stats</structname>
</title>
<varlistentry>
<term><structfield>keyword</structfield></term>
<listitem><para>
<type>character varying(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>query_success</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>query_failure</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>mixed_query</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>total_query</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>highest_result</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>last_called</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>multiple_word</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>exact_success</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>ignored</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on search_stats</title>
<varlistentry>
<term>search_stats_index</term>
<listitem><para>keyword</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.user-authorization"
xreflabel="public.user_authorization">
<title id="public.table.user-authorization-title">
Table:
<structname>user_authorization</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>user_authorization</structname>
</title>
<varlistentry>
<term><structfield>username</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>password</structfield></term>
<listitem><para>
<type>character(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users"
xreflabel="public.users">
<title id="public.table.users-title">
Table:
<structname>users</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>last_logged</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>log_count</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>authorize</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>created</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>approved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>username</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>display_name</structfield></term>
<listitem><para>
<type>character varying(30)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>email</structfield></term>
<listitem><para>
<type>character varying(100)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deity</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-auth-scripts"
xreflabel="public.users_auth_scripts">
<title id="public.table.users-auth-scripts-title">
Table:
<structname>users_auth_scripts</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_auth_scripts</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>display_name</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>filename</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-banned"
xreflabel="public.users_banned">
<title id="public.table.users-banned-title">
Table:
<structname>users_banned</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_banned</structname>
</title>
<varlistentry>
<term><structfield>banned_ip</structfield></term>
<listitem><para>
<type>character(15)</type>
<literal>UNIQUE</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-groups"
xreflabel="public.users_groups">
<title id="public.table.users-groups-title">
Table:
<structname>users_groups</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_groups</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>name</structfield></term>
<listitem><para>
<type>character(50)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-members"
xreflabel="public.users_members">
<title id="public.table.users-members-title">
Table:
<structname>users_members</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_members</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>member_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-my-page-mods"
xreflabel="public.users_my_page_mods">
<title id="public.table.users-my-page-mods-title">
Table:
<structname>users_my_page_mods</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_my_page_mods</structname>
</title>
<varlistentry>
<term><structfield>mod_title</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-permissions"
xreflabel="public.users_permissions">
<title id="public.table.users-permissions-title">
Table:
<structname>users_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_users</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_users</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>add_edit_groups</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_groups</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_permissions</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>settings</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-pw-reset"
xreflabel="public.users_pw_reset">
<title id="public.table.users-pw-reset-title">
Table:
<structname>users_pw_reset</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_pw_reset</structname>
</title>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>authhash</structfield></term>
<listitem><para>
<type>character(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>timeout</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.users-signup"
xreflabel="public.users_signup">
<title id="public.table.users-signup-title">
Table:
<structname>users_signup</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>users_signup</structname>
</title>
<varlistentry>
<term><structfield>authkey</structfield></term>
<listitem><para>
<type>character(32)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>deadline</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on users_signup</title>
<varlistentry>
<term>userssignup_idx</term>
<listitem><para>authkey</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.version-permissions"
xreflabel="public.version_permissions">
<title id="public.table.version-permissions-title">
Table:
<structname>version_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>version_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.webpage-featured"
xreflabel="public.webpage_featured">
<title id="public.table.webpage-featured-title">
Table:
<structname>webpage_featured</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>webpage_featured</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vol_order</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.webpage-page"
xreflabel="public.webpage_page">
<title id="public.table.webpage-page-title">
Table:
<structname>webpage_page</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>webpage_page</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>volume_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>content</structfield></term>
<listitem><para>
<type>text</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>page_number</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>template</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>approved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>image_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on webpage_page</title>
<varlistentry>
<term>webpagepage_idx</term>
<listitem><para>volume_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.webpage-permissions"
xreflabel="public.webpage_permissions">
<title id="public.table.webpage-permissions-title">
Table:
<structname>webpage_permissions</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>webpage_permissions</structname>
</title>
<varlistentry>
<term><structfield>group_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>permission_level</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>edit_page</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>delete_page</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>featured</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.webpage-volume"
xreflabel="public.webpage_volume">
<title id="public.table.webpage-volume-title">
Table:
<structname>webpage_volume</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>webpage_volume</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>summary</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>date_created</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>date_updated</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>create_user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>created_user</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>update_user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_user</structfield></term>
<listitem><para>
<type>character varying(40)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>frontpage</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>approved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on webpage_volume</title>
<varlistentry>
<term>webpagevolume_idx</term>
<listitem><para>key_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
<section id="public.table.webpage-volume-version"
xreflabel="public.webpage_volume_version">
<title id="public.table.webpage-volume-version-title">
Table:
<structname>webpage_volume_version</structname>
</title>
<para>
<variablelist>
<title>
Structure of <structname>webpage_volume_version</structname>
</title>
<varlistentry>
<term><structfield>id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>PRIMARY KEY</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>source_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>key_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>title</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>summary</structfield></term>
<listitem><para>
<type>text</type>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>date_created</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>date_updated</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>create_user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>created_user</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>update_user_id</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>updated_user</structfield></term>
<listitem><para>
<type>character varying(255)</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>frontpage</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>approved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>active</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 0::smallint</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_creator</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_editor</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_create_date</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_edit_date</structfield></term>
<listitem><para>
<type>integer</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_number</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
<literal>DEFAULT 1</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_current</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_approved</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><structfield>vr_locked</structfield></term>
<listitem><para>
<type>smallint</type>
<literal>NOT NULL</literal>
</para>
</listitem>
</varlistentry>
</variablelist>
<variablelist>
<title>Indexes on webpage_volume_version</title>
<varlistentry>
<term>webpagevolumeversion_idx</term>
<listitem><para>source_id</para></listitem>
</varlistentry>
</variablelist>
</para>
</section>
</chapter>
</book>