docs/db_diagrams/hms.html
<!-- $Header: /cvsroot/autodoc/autodoc/html.tmpl,v 1.4 2006/05/16 19:01:27 rbt Exp $ -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Index for jbooker</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">
BODY {
color: #000000;
background-color: #FFFFFF;
font-family: Helvetica, sans-serif;
}
P {
margin-top: 5px;
margin-bottom: 5px;
}
P.w3ref {
font-size: 8pt;
font-style: italic;
text-align: right;
}
P.detail {
font-size: 10pt;
}
.error {
color: #FFFFFF;
background-color: #FF0000;
}
H1, H2, H3, H4, H5, H6 {
}
OL {
list-style-type: upper-alpha;
}
UL.topic {
list-style-type: upper-alpha;
}
LI.topic {
font-weight : bold;
}
HR {
color: #00FF00;
background-color: #808080;
}
TABLE {
border-width: medium;
padding: 3px;
background-color: #000000;
width: 90%;
}
CAPTION {
text-transform: capitalize;
font-weight : bold;
font-size: 14pt;
}
TH {
color: #FFFFFF;
background-color: #000000;
text-align: left;
}
TR {
color: #000000;
background-color: #000000;
vertical-align: top;
}
TR.tr0 {
background-color: #F0F0F0;
}
TR.tr1 {
background-color: #D8D8D8;
}
TD {
font-size: 12pt;
}
TD.col0 {
font-weight : bold;
width: 20%;
}
TD.col1 {
font-style: italic;
width: 15%;
}
TD.col2 {
font-size: 12px;
}
</style>
<link rel="stylesheet" type="text/css" media="all" href="all.css">
<link rel="stylesheet" type="text/css" media="screen" href="screen.css">
<link rel="stylesheet" type="text/css" media="print" href="print.css">
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
</head>
<body>
<!-- Primary Index -->
<p><br><br>Dumped on 2008-02-25</p>
<h1><a name="index">Index of database - jbooker</a></h1>
<ul>
<li><a name="public.schema">public</a></li><ul>
<li><a href="#public.table.block">block</a></li><li><a href="#public.table.block-permissions">block_permissions</a></li><li><a href="#public.table.block-pinned">block_pinned</a></li><li><a href="#public.table.boost-permissions">boost_permissions</a></li><li><a href="#public.table.calendar-notice">calendar_notice</a></li><li><a href="#public.table.calendar-permissions">calendar_permissions</a></li><li><a href="#public.table.calendar-schedule">calendar_schedule</a></li><li><a href="#public.table.calendar-suggestions">calendar_suggestions</a></li><li><a href="#public.table.categories">categories</a></li><li><a href="#public.table.categories-permissions">categories_permissions</a></li><li><a href="#public.table.category-items">category_items</a></li><li><a href="#public.table.comments-items">comments_items</a></li><li><a href="#public.table.comments-permissions">comments_permissions</a></li><li><a href="#public.table.comments-threads">comments_threads</a></li><li><a href="#public.table.comments-users">comments_users</a></li><li><a href="#public.table.controlpanel-link">controlpanel_link</a></li><li><a href="#public.table.controlpanel-permissions">controlpanel_permissions</a></li><li><a href="#public.table.controlpanel-tab">controlpanel_tab</a></li><li><a href="#public.table.converted">converted</a></li><li><a href="#public.table.core-version">core_version</a></li><li><a href="#public.table.demographics">demographics</a></li><li><a href="#public.table.dependencies">dependencies</a></li><li><a href="#public.table.documents">documents</a></li><li><a href="#public.table.filecabinet-permissions">filecabinet_permissions</a></li><li><a href="#public.table.filecabinet-pins">filecabinet_pins</a></li><li><a href="#public.table.folders">folders</a></li><li><a href="#public.table.hms-activity-log">hms_activity_log</a></li><li><a href="#public.table.hms-application">hms_application</a></li><li><a href="#public.table.hms-assignment">hms_assignment</a></li><li><a href="#public.table.hms-bed">hms_bed</a></li><li><a href="#public.table.hms-bedroom">hms_bedroom</a></li><li><a href="#public.table.hms-cached-student-info">hms_cached_student_info</a></li><li><a href="#public.table.hms-deadlines">hms_deadlines</a></li><li><a href="#public.table.hms-floor">hms_floor</a></li><li><a href="#public.table.hms-hall-communities">hms_hall_communities</a></li><li><a href="#public.table.hms-learning-communities">hms_learning_communities</a></li><li><a href="#public.table.hms-learning-community-applications">hms_learning_community_applications</a></li><li><a href="#public.table.hms-learning-community-assignment">hms_learning_community_assignment</a></li><li><a href="#public.table.hms-learning-community-floors">hms_learning_community_floors</a></li><li><a href="#public.table.hms-learning-community-questions">hms_learning_community_questions</a></li><li><a href="#public.table.hms-movein-time">hms_movein_time</a></li><li><a href="#public.table.hms-pending-assignment">hms_pending_assignment</a></li><li><a href="#public.table.hms-pricing-tiers">hms_pricing_tiers</a></li><li><a href="#public.table.hms-residence-hall">hms_residence_hall</a></li><li><a href="#public.table.hms-room">hms_room</a></li><li><a href="#public.table.hms-roommate-approval">hms_roommate_approval</a></li><li><a href="#public.table.hms-roommates">hms_roommates</a></li><li><a href="#public.table.hms-student">hms_student</a></li><li><a href="#public.table.hms-student-profiles">hms_student_profiles</a></li><li><a href="#public.table.hms-suite">hms_suite</a></li><li><a href="#public.table.hms-term">hms_term</a></li><li><a href="#public.table.images">images</a></li><li><a href="#public.table.layout-box">layout_box</a></li><li><a href="#public.table.layout-config">layout_config</a></li><li><a href="#public.table.layout-metatags">layout_metatags</a></li><li><a href="#public.table.layout-permissions">layout_permissions</a></li><li><a href="#public.table.layout-styles">layout_styles</a></li><li><a href="#public.table.menu-assoc">menu_assoc</a></li><li><a href="#public.table.menu-links">menu_links</a></li><li><a href="#public.table.menu-permissions">menu_permissions</a></li><li><a href="#public.table.menus">menus</a></li><li><a href="#public.table.mod-settings">mod_settings</a></li><li><a href="#public.table.modules">modules</a></li><li><a href="#public.table.multimedia">multimedia</a></li><li><a href="#public.table.notes">notes</a></li><li><a href="#public.table.notes-permissions">notes_permissions</a></li><li><a href="#public.table.phpws-key">phpws_key</a></li><li><a href="#public.table.phpws-key-edit">phpws_key_edit</a></li><li><a href="#public.table.phpws-key-register">phpws_key_register</a></li><li><a href="#public.table.phpws-key-view">phpws_key_view</a></li><li><a href="#public.table.registered">registered</a></li><li><a href="#public.table.rss-channel">rss_channel</a></li><li><a href="#public.table.rss-feeds">rss_feeds</a></li><li><a href="#public.table.rss-permissions">rss_permissions</a></li><li><a href="#public.table.search">search</a></li><li><a href="#public.table.search-permissions">search_permissions</a></li><li><a href="#public.table.search-stats">search_stats</a></li><li><a href="#public.table.user-authorization">user_authorization</a></li><li><a href="#public.table.users">users</a></li><li><a href="#public.table.users-auth-scripts">users_auth_scripts</a></li><li><a href="#public.table.users-banned">users_banned</a></li><li><a href="#public.table.users-groups">users_groups</a></li><li><a href="#public.table.users-members">users_members</a></li><li><a href="#public.table.users-my-page-mods">users_my_page_mods</a></li><li><a href="#public.table.users-permissions">users_permissions</a></li><li><a href="#public.table.users-pw-reset">users_pw_reset</a></li><li><a href="#public.table.users-signup">users_signup</a></li><li><a href="#public.table.version-permissions">version_permissions</a></li><li><a href="#public.table.webpage-featured">webpage_featured</a></li><li><a href="#public.table.webpage-page">webpage_page</a></li><li><a href="#public.table.webpage-permissions">webpage_permissions</a></li><li><a href="#public.table.webpage-volume">webpage_volume</a></li><li><a href="#public.table.webpage-volume-version">webpage_volume_version</a></li>
</ul>
</ul>
<!-- Schema Creation -->
<!-- publicpublic -->
<hr>
<h2>Table:
<a name="public.table.block">block</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>block Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.block-permissions">block_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>block_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_block</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_block</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.block-pinned">block_pinned</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>block_pinned Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>block_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.boost-permissions">boost_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>boost_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.calendar-notice">calendar_notice</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>calendar_notice Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>email</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.calendar-permissions">calendar_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>calendar_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>settings</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>edit_public</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_private</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_schedule</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.calendar-schedule">calendar_schedule</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>calendar_schedule Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(60)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>show_upcoming</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>summary</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>public</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.calendar-suggestions">calendar_suggestions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>calendar_suggestions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>schedule_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>summary</td>
<td>character varying(60)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>location</td>
<td>character varying(60)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>loc_link</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>all_day</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>start_time</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>end_time</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>submitted</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.categories">categories</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>categories Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>parent</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>icon</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.categories-permissions">categories_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>categories_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>delete_categories</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.category-items">category_items</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>category_items Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>cat_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>module</td>
<td>character(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
categoryitems_idx cat_id, module
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.comments-items">comments_items</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>comments_items Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>thread_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>parent</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>author_ip</td>
<td>character varying(15)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>author_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>subject</td>
<td>character varying(100)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>entry</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>edit_author</td>
<td>character varying(50)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>create_time</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>edit_time</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_reason</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.comments-permissions">comments_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>comments_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_comments</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_comments</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>settings</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.comments-threads">comments_threads</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>comments_threads Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>total_comments</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_poster</td>
<td>character varying(40)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>allow_anon</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.comments-users">comments_users</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>comments_users Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>display_name</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>comments_made</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>joined_date</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>locked</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.controlpanel-link">controlpanel_link</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>controlpanel_link Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>tab</td>
<td>character(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>label</td>
<td>character(50)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>itemname</td>
<td>character(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>restricted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>url</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>image</td>
<td>character(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>link_order</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.controlpanel-permissions">controlpanel_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>controlpanel_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>remove_tab</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>add_tab</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>move_link</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.controlpanel-tab">controlpanel_tab</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>controlpanel_tab Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>character(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>link</td>
<td>character(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>tab_order</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>itemname</td>
<td>character(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.converted">converted</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>converted Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>convert_name</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.core-version">core_version</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>core_version Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>version</td>
<td>character varying(10)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.demographics">demographics</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>demographics Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>avatar</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>signature</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>contact_email</td>
<td>character varying(30)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>website</td>
<td>character varying(60)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
user_id user_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.dependencies">dependencies</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>dependencies Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>source_mod</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>depended_on</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>version</td>
<td>character varying(20)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.documents">documents</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>documents Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>file_name</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>file_directory</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>folder_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>file_type</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>size</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>downloaded</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.filecabinet-permissions">filecabinet_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>filecabinet_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_folders</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_folders</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>settings</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>classify</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.filecabinet-pins">filecabinet_pins</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>filecabinet_pins Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>folder_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.folders">folders</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>folders Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>title</td>
<td>character varying(60)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>ftype</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>public_folder</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>icon</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>module_created</td>
<td>character varying(40)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-activity-log">hms_activity_log</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_activity_log Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>activity</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>actor</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>notes</td>
<td>character varying(512)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-application">hms_application</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_application Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>hms_student_id</td>
<td>character varying(32)</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>student_status</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>term_classification</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>gender</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>meal_option</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>lifestyle_option</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>preferred_bedtime</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_condition</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>in_relationship</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>currently_employed</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>rlc_interest</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>agreed_to_terms</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>aggregate</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>created_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>created_by</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>physical_disability</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>psych_disability</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>medical_need</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>gender_need</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-assignment">hms_assignment</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_assignment Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>asu_username</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-bed">hms_bed.id</a>
</td>
<td>bed_id</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>added_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-bed">hms_bed</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_bed Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>bed_letter</td>
<td>character(1)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>banner_id</td>
<td>character varying(15)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>phone_number</td>
<td>character(4)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-room">hms_room.id</a>
</td>
<td>room_id</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>bedroom_label</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>ra_bed</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-assignment">hms_assignment</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-bedroom">hms_bedroom</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_bedroom Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-room">hms_room.id</a>
</td>
<td>room_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_by</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>added_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_by</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_by</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>bedroom_letter</td>
<td>character(1)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-cached-student-info">hms_cached_student_info</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_cached_student_info Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>asu_username</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_number</td>
<td>character varying(10)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>hall_name</td>
<td>character varying(64)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>first_name</td>
<td>character varying(64)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>middle_name</td>
<td>character varying(64)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_name</td>
<td>character varying(64)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>address1</td>
<td>character varying(128)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>address2</td>
<td>character varying(128)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>address3</td>
<td>character varying(128)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>city</td>
<td>character varying(64)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>state</td>
<td>character varying(5)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>zip</td>
<td>character varying(11)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_name</td>
<td>character varying(172)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_user</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>room_phone</td>
<td>character varying(20)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>phone_number</td>
<td>character varying(20)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>gender</td>
<td>character(1)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>student_type</td>
<td>character(5)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>class</td>
<td>character(5)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>credit_hours</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deposit_date</td>
<td>character(10)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deposit_waived</td>
<td>character(5)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>movein_time</td>
<td>character varying(64)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-deadlines">hms_deadlines</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_deadlines Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>submit_application_begin_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>submit_application_end_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_application_end_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>edit_profile_begin_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_profile_end_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>search_profiles_begin_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>search_profiles_end_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>submit_rlc_application_end_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>view_assignment_begin_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>view_assignment_end_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_by</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>lottery_signup_begin_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>lottery_signup_end_timestamp</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-floor">hms_floor</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_floor Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>floor_number</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-residence-hall">hms_residence_hall.id</a>
</td>
<td>residence_hall_id</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_online</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>gender_type</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_by</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>added_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_by</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-movein-time">hms_movein_time.id</a>
</td>
<td>ft_movein_time_id</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-movein-time">hms_movein_time.id</a>
</td>
<td>rt_movein_time_id</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-room">hms_room</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-suite">hms_suite</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-hall-communities">hms_hall_communities</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_hall_communities Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>community_name</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-learning-communities">hms_learning_communities</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_learning_communities Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>community_name</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>abbreviation</td>
<td>character varying(16)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>capacity</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-learning-community-applications">hms_learning_community_applications</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-learning-community-assignment">hms_learning_community_assignment</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-learning-community-floors">hms_learning_community_floors</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-learning-community-questions">hms_learning_community_questions</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-learning-community-applications">hms_learning_community_applications</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_learning_community_applications Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>character varying(32)</td>
<td><i>
UNIQUE
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>date_submitted</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-learning-communities">hms_learning_communities.id</a>
</td>
<td>rlc_first_choice_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-learning-communities">hms_learning_communities.id</a>
</td>
<td>rlc_second_choice_id</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-learning-communities">hms_learning_communities.id</a>
</td>
<td>rlc_third_choice_id</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>why_specific_communities</td>
<td>character varying(2048)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>strengths_weaknesses</td>
<td>character varying(2048)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>rlc_question_0</td>
<td>character varying(2048)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>rlc_question_1</td>
<td>character varying(2048)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>rlc_question_2</td>
<td>character varying(2048)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>required_course</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-learning-community-assignment">hms_learning_community_assignment.id</a>
</td>
<td>hms_assignment_id</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-learning-community-assignment">hms_learning_community_assignment</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_learning_community_assignment Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>asu_username</td>
<td>character varying(32)</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-learning-communities">hms_learning_communities.id</a>
</td>
<td>rlc_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>gender</td>
<td>character varying(2)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>assigned_by</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-learning-community-applications">hms_learning_community_applications</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-learning-community-floors">hms_learning_community_floors</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_learning_community_floors Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-learning-communities">hms_learning_communities.id</a>
</td>
<td>learning_communities_id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>floor_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-learning-community-questions">hms_learning_community_questions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_learning_community_questions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-learning-communities">hms_learning_communities.id</a>
</td>
<td>learning_community_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>question_text</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-movein-time">hms_movein_time</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_movein_time Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>begin_timestamp</td>
<td>integer</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>end_timestamp</td>
<td>integer</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
UNIQUE#1
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-floor">hms_floor</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-pending-assignment">hms_pending_assignment</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_pending_assignment Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>gender</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>lifestyle_option</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>chosen</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_zero</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>meal_zero</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_one</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>meal_one</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-pricing-tiers">hms_pricing_tiers</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_pricing_tiers Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>tier_value</td>
<td>numeric</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-residence-hall">hms_residence_hall</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_residence_hall Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>banner_building_code</td>
<td>character varying(6)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>hall_name</td>
<td>character varying(64)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>gender_type</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>air_conditioned</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_online</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_by</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>added_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>per_freshmen_rsvd</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>per_sophomore_rsvd</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>per_junior_rsvd</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>per_senior_rsvd</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-floor">hms_floor</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-room">hms_room</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_room Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-floor">hms_floor.id</a>
</td>
<td>floor_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>gender_type</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>learning_community_id</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_medical</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_reserved</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>is_online</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>added_by</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT (0)::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>room_number</td>
<td>character varying(8)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ra_room</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>private_room</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>is_lobby</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>pricing_tier</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-suite">hms_suite.id</a>
</td>
<td>suite_id</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-bed">hms_bed</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-bedroom">hms_bedroom</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-roommate-approval">hms_roommate_approval</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_roommate_approval Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>number_roommates</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_zero</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_zero_approved</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_zero_personal_hash</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_one</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_one_approved</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_one_personal_hash</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_two</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_two_approved</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_two_personal_hash</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_three</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_three_approved</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_three_personal_hash</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-roommates">hms_roommates</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_roommates Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_zero</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_one</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>roommate_two</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>roommate_three</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-student">hms_student</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_student Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>asu_username</td>
<td>character varying(10)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>first_name</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>middle_name</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_name</td>
<td>character varying(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>gender</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>application_received</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>added_by</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_on</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-student-profiles">hms_student_profiles</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_student_profiles Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>character varying(32)</td>
<td><i>
UNIQUE
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>date_submitted</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>alternate_email</td>
<td>character varying(64)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>aim_sn</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>yahoo_sn</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>msn_sn</td>
<td>character varying(32)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>arts_and_crafts</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>books_and_reading</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>cars</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>church_activities</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>collecting</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>computers_and_technology</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>dancing</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>fashion</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>fine_arts</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>gardening</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>games</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>humor</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>investing_personal_finance</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>movies</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>music</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>outdoor_activities</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>pets_and_animals</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>photography</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>politics</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sports</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>travel</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>tv_shows</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>volunteering</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>writing</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>alternative</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>ambient</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>beach</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>bluegrass</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>blues</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>classical</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>classic_rock</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>country</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>electronic</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>folk</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>heavy_metal</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>hip_hop</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>house</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>industrial</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>jazz</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>popular_music</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>progressive</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>punk</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>r_and_b</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>rap</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>reggae</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>rock</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>world_music</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>study_early_morning</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>study_morning_afternoon</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>study_afternoon_evening</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>study_evening</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>study_late_night</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>political_view</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>major</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>experience</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sleep_time</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>wakeup_time</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>overnight_guests</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>loudness</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>cleanliness</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>free_time</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-suite">hms_suite</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_suite Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
<a href="#public.table.hms-floor">hms_floor.id</a>
</td>
<td>floor_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
<a href="#public.table.hms-term">hms_term.term</a>
</td>
<td>term</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>added_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>added_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deleted_by</td>
<td>smallint</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deleted_on</td>
<td>integer</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-room">hms_room</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.hms-term">hms_term</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>hms_term Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>term</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<ul>
<li><a href="#public.table.hms-application">hms_application</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-assignment">hms_assignment</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-bed">hms_bed</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-bedroom">hms_bedroom</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-deadlines">hms_deadlines</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-floor">hms_floor</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-learning-community-applications">hms_learning_community_applications</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-movein-time">hms_movein_time</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-residence-hall">hms_residence_hall</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-room">hms_room</a></li>
</ul>
<ul>
<li><a href="#public.table.hms-suite">hms_suite</a></li>
</ul>
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.images">images</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>images Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>file_name</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>file_directory</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>folder_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>file_type</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>size</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>width</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>height</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>parent_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>url</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>alt</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.layout-box">layout_box</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>layout_box Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>theme</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>content_var</td>
<td>character varying(40)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>module</td>
<td>character varying(40)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>theme_var</td>
<td>character varying(40)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>box_order</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.layout-config">layout_config</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>layout_config Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>default_theme</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>userallow</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>page_title</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>meta_keywords</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>meta_description</td>
<td>character varying(180)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>meta_robots</td>
<td>character(2)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>meta_owner</td>
<td>character varying(40)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>meta_author</td>
<td>character varying(40)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>meta_content</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>header</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>footer</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>cache</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.layout-metatags">layout_metatags</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>layout_metatags Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>page_title</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>meta_description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>meta_keywords</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>meta_robots</td>
<td>character(2)</td>
<td><i>
NOT NULL
DEFAULT 11
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.layout-permissions">layout_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>layout_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.layout-styles">layout_styles</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>layout_styles Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>style</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
layoutstyles_idx key_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.menu-assoc">menu_assoc</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>menu_assoc Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>menu_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.menu-links">menu_links</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>menu_links Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>menu_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>url</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>parent</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>link_order</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.menu-permissions">menu_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>menu_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>create_new_menu</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_menu</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.menus">menus</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>menus Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>template</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>restricted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>pin_all</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.mod-settings">mod_settings</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>mod_settings Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>module</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>setting_name</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>setting_type</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 4
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>small_num</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>large_num</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>small_char</td>
<td>character varying(100)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>large_char</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
modsettings_idx module, setting_name
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.modules">modules</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>modules Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>title</td>
<td>character(40)</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>proper_name</td>
<td>character(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>priority</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>version</td>
<td>character(20)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>register</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>unregister</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.multimedia">multimedia</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>multimedia Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>file_name</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>file_directory</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>folder_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>file_type</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>size</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>width</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>height</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>thumbnail</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.notes">notes</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>notes Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>sender_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(60)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>read_once</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>encrypted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>date_sent</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
notes_idx user_id, key_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.notes-permissions">notes_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>notes_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>search_usernames</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.phpws-key">phpws_key</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>phpws_key Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>module</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>item_name</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>item_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>summary</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>url</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 1
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>restricted</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>create_date</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>update_date</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>creator</td>
<td>character varying(60)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>creator_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updater</td>
<td>character varying(60)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updater_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>times_viewed</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_permission</td>
<td>character varying(30)</td>
<td><i>
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
phpwskey_idx restricted, active, module, create_date, update_date
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.phpws-key-edit">phpws_key_edit</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>phpws_key_edit Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
phpwskeyedit_idx key_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.phpws-key-register">phpws_key_register</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>phpws_key_register Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>module</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.phpws-key-view">phpws_key_view</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>phpws_key_view Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
phpwskeyview_idx key_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.registered">registered</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>registered Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>module</td>
<td>character(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>registered_to</td>
<td>character(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.rss-channel">rss_channel</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>rss_channel Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>module</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>title</td>
<td>character varying(100)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>description</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>pub_date</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ttl</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>image_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 1
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.rss-feeds">rss_feeds</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>rss_feeds Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(100)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>address</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>display</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>refresh_time</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>item_limit</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.rss-permissions">rss_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>rss_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.search">search</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>search Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>module</td>
<td>character(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>created</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>keywords</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
search_index key_id, module, created
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.search-permissions">search_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>search_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.search-stats">search_stats</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>search_stats Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>keyword</td>
<td>character varying(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>query_success</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>query_failure</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>mixed_query</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>total_query</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>highest_result</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>last_called</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>multiple_word</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>exact_success</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>ignored</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
search_stats_index keyword
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.user-authorization">user_authorization</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>user_authorization Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>username</td>
<td>character varying(30)</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>password</td>
<td>character(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users">users</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>last_logged</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>log_count</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>authorize</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>created</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>approved</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>username</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>display_name</td>
<td>character varying(30)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>email</td>
<td>character varying(100)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>deity</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-auth-scripts">users_auth_scripts</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_auth_scripts Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>smallint</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>display_name</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>filename</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-banned">users_banned</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_banned Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>banned_ip</td>
<td>character(15)</td>
<td><i>
UNIQUE
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-groups">users_groups</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_groups Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>name</td>
<td>character(50)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-members">users_members</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_members Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>member_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-my-page-mods">users_my_page_mods</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_my_page_mods Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>mod_title</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-permissions">users_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_users</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_users</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>add_edit_groups</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_groups</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_permissions</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>settings</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-pw-reset">users_pw_reset</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_pw_reset Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>authhash</td>
<td>character(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>timeout</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.users-signup">users_signup</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>users_signup Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>authkey</td>
<td>character(32)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>deadline</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
userssignup_idx authkey
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.version-permissions">version_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>version_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.webpage-featured">webpage_featured</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>webpage_featured Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>vol_order</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.webpage-page">webpage_page</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>webpage_page Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>volume_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>content</td>
<td>text</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>page_number</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>template</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>approved</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>image_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
webpagepage_idx volume_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.webpage-permissions">webpage_permissions</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>webpage_permissions Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>group_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>permission_level</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>edit_page</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>delete_page</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>featured</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.webpage-volume">webpage_volume</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>webpage_volume Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>summary</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>date_created</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>date_updated</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>create_user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>created_user</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>update_user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>updated_user</td>
<td>character varying(40)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>frontpage</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>approved</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
webpagevolume_idx key_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<hr>
<h2>Table:
<a name="public.table.webpage-volume-version">webpage_volume_version</a>
</h2>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>webpage_volume_version Structure</caption>
<tr>
<th>F-Key</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<tr class="tr0">
<td>
</td>
<td>id</td>
<td>integer</td>
<td><i>
PRIMARY KEY
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>source_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>key_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>summary</td>
<td>text</td>
<td><i>
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>date_created</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>date_updated</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>create_user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>created_user</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>update_user_id</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>updated_user</td>
<td>character varying(255)</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>frontpage</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>approved</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>active</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 0::smallint
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>vr_creator</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>vr_editor</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>vr_create_date</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>vr_edit_date</td>
<td>integer</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>vr_number</td>
<td>smallint</td>
<td><i>
NOT NULL
DEFAULT 1
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>vr_current</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>vr_approved</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>vr_locked</td>
<td>smallint</td>
<td><i>
NOT NULL
</i>
</td>
</tr>
</table>
<!-- Inherits -->
<!-- Constraint List -->
<!-- Foreign Key Discovery -->
<!-- Indexes -->
webpagevolumeversion_idx source_id
<!-- View Definition -->
<!-- List off permissions -->
<p>
<a href="#index">Index</a> -
<a href="#public.schema">Schema public</a>
</p>
<!-- We've gone through the table structure, now lets take a look at user functions -->
<p class="w3ref">Generated by <a href="http://www.rbt.ca/autodoc/">PostgreSQL Autodoc</a></p>
<p class="w3ref"><a href="http://validator.w3.org/check/referer">W3C HTML 4.01 Strict</a></p>
</body></html>