Geodigraph Hub/Database

From Geodigraph Documentation
Jump to navigation Jump to search

Database Tables

webwarecl

webwarecl.appfields

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| Description   | varchar(45)         | NO   |     | NULL    |                |
| FromDB        | varchar(45)         | NO   |     | NULL    |                |
| FromTable     | varchar(45)         | NO   |     | NULL    |                |
| FromField     | varchar(45)         | NO   |     | NULL    |                |
| Searchable    | tinyint(3) unsigned | NO   |     | NULL    |                |
| ShowInResults | tinyint(3) unsigned | NO   |     | NULL    |                |
| FieldType     | varchar(45)         | NO   |     | NULL    |                |
| AppObjectID   | bigint(20) unsigned | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

webwarecl.applicationcontexts

+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| contextName | varchar(255)     | NO   |     |         |                |
| sideBarURL  | text             | NO   |     | NULL    |                |
| contentURL  | text             | NO   |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+

webwarecl.applications

+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| id                  | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| AppName             | varchar(255)        | NO   |     | NULL    |                |
| AppIcon             | varchar(45)         | NO   |     | NULL    |                |
| RequiredPermissions | text                | NO   |     | NULL    |                |
| GlobalLoad          | tinyint(3) unsigned | NO   |     | NULL    |                |
| AppDescription      | text                | NO   |     | NULL    |                |
| ShortName           | varchar(45)         | NO   |     | NULL    |                |
| AccountType         | varchar(45)         | NO   |     | NULL    |                |
| Developer           | varchar(45)         | NO   |     | NULL    |                |
+---------------------+---------------------+------+-----+---------+----------------+

webwarecl.apps

+-------------+--------------+------+-----+-----------------------------------------------------------+-------+
| Field       | Type         | Null | Key | Default                                                   | Extra |
+-------------+--------------+------+-----+-----------------------------------------------------------+-------+
| AppID       | varchar(255) | NO   | PRI | NULL                                                      |       |
| AppName     | varchar(255) | NO   |     | NULL                                                      |       |
| VendorDBKey | bigint(20)   | NO   |     | NULL                                                      |       |
| Authorized  | int(11)      | NO   |     | 0                                                         |       |
| Version     | varchar(255) | NO   |     | NULL                                                      |       |
| Description | text         | YES  |     | NULL                                                      |       |
| WSDLURL     | varchar(255) | NO   |     | NULL                                                      |       |
| Icon        | varchar(255) | NO   |     | http://prefiniti15.prefiniti.com/graphics/application.png |       |
+-------------+--------------+------+-----+-----------------------------------------------------------+-------+

webwarecl.apps_installed

+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| InstallID    | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| AppID        | varchar(255) | NO   |     | NULL    |                |
| MembershipID | bigint(20)   | NO   |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+

webwarecl.auth_tokens

+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| id                  | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| username            | varchar(255)        | NO   |     | NULL    |                |
| token               | varchar(255)        | NO   |     | NULL    |                |
| user_id             | bigint(20) unsigned | NO   |     | NULL    |                |
| HP_CGI_NetworkNode  | varchar(45)         | YES  |     | NULL    |                |
| HP_CGI_Browser      | varchar(255)        | YES  |     | NULL    |                |
| HP_PrefinitiHostKey | varchar(255)        | YES  |     | NULL    |                |
| login_date          | datetime            | YES  |     | NULL    |                |
| logout_date         | datetime            | YES  |     | NULL    |                |
| active              | tinyint(3) unsigned | NO   |     | 0       |                |
| session_key         | varchar(255)        | YES  |     | NULL    |                |
| HP_OS               | varchar(255)        | YES  |     | NULL    |                |
+---------------------+---------------------+------+-----+---------+----------------+

webwarecl.basescripts

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| ScriptPath | text                | NO   |     | NULL    |                |
| ScriptName | text                | NO   |     | NULL    |                |
| RunAt      | int(10) unsigned    | NO   |     | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

webwarecl.blogs

+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key | Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id   | bigint(20) unsigned | NO   |     | NULL    |                |
| subject   | varchar(255)        | NO   |     | NULL    |                |
| body_copy | text                | NO   |     | NULL    |                |
| post_date | datetime            | NO   |     | NULL    |                |
| public    | tinyint(3) unsigned | NO   |     | NULL    |                |
+-----------+---------------------+------+-----+---------+----------------+

webwarecl.browse_references

+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| holder       | bigint(20)   | NO   |     | NULL    |                |
| action       | varchar(45)  | NO   |     | NULL    |                |
| object_id    | varchar(45)  | NO   |     | NULL    |                |
| application  | varchar(255) | NO   |     | NULL    |                |
| object_type  | varchar(255) | NO   |     | NULL    |                |
| description  | varchar(255) | NO   |     | NULL    |                |
| creator      | bigint(20)   | YES  |     | NULL    |                |
| date         | datetime     | YES  |     | NULL    |                |
| classic_link | varchar(255) | YES  |     | NULL    |                |
| om_uuid      | varchar(255) | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+

webwarecl.chat_channels

+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id            | varchar(255) | NO   | PRI | NULL    |       |
| channel_name  | varchar(255) | NO   |     | NULL    |       |
| channel_class | varchar(20)  | NO   |     | NULL    |       |
| channel_oid   | bigint(20)   | NO   |     | 0       |       |
| channel_opts  | text         | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+

webwarecl.chat_entries

+------------+--------------+------+-----+-------------------+----------------+
| Field      | Type         | Null | Key | Default           | Extra          |
+------------+--------------+------+-----+-------------------+----------------+
| id         | bigint(20)   | NO   | PRI | NULL              | auto_increment |
| channel_id | varchar(255) | NO   | MUL | NULL              |                |
| ts         | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
| sender_id  | bigint(20)   | NO   |     | NULL              |                |
| msg_body   | text         | YES  |     | NULL              |                |
+------------+--------------+------+-----+-------------------+----------------+

webwarecl.companies

+-----------------+------------------+------+-----+---------+----------------+
| Field           | Type             | Null | Key | Default | Extra          |
+-----------------+------------------+------+-----+---------+----------------+
| id              | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name            | varchar(100)     | NO   |     |         |                |
| billing_address | varchar(255)     | NO   |     |         |                |
| billing_city    | varchar(255)     | NO   |     |         |                |
| billing_state   | varchar(255)     | NO   |     |         |                |
| billing_zip     | varchar(255)     | NO   |     |         |                |
| mailing_address | varchar(255)     | NO   |     |         |                |
| mailing_city    | varchar(255)     | NO   |     |         |                |
| mailing_state   | varchar(255)     | NO   |     |         |                |
| mailing_zip     | varchar(255)     | NO   |     |         |                |
| phone           | varchar(255)     | NO   |     |         |                |
| website         | varchar(255)     | NO   |     |         |                |
| confirm_id      | varchar(255)     | NO   |     |         |                |
+-----------------+------------------+------+-----+---------+----------------+

webwarecl.components

+-------+---------------------+------+-----+---------+----------------+
| Field | Type                | Null | Key | Default | Extra          |
+-------+---------------------+------+-----+---------+----------------+
| id    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| name  | varchar(255)        | NO   |     | NULL    |                |
+-------+---------------------+------+-----+---------+----------------+

webwarecl.config

+-----------------+------------------+------+-----+---------+----------------+
| Field           | Type             | Null | Key | Default | Extra          |
+-----------------+------------------+------+-----+---------+----------------+
| idconfig        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| jobapprover     | text             | NO   |     | NULL    |                |
| maintenance     | int(10) unsigned | NO   |     | 0       |                |
| logins_disabled | int(10) unsigned | NO   |     | 0       |                |
+-----------------+------------------+------+-----+---------+----------------+

webwarecl.configuration

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id    | bigint(20) unsigned | NO   |     | NULL    |                |
| conf_key   | varchar(255)        | NO   |     | NULL    |                |
| conf_value | text                | NO   |     | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

webwarecl.contact_fields

+---------------+-------------+------+-----+---------+----------------+
| Field         | Type        | Null | Key | Default | Extra          |
+---------------+-------------+------+-----+---------+----------------+
| id            | bigint(20)  | NO   | PRI | NULL    | auto_increment |
| field_name    | varchar(45) | NO   |     | NULL    |                |
| contact_id    | bigint(20)  | NO   |     | NULL    |                |
| str_value     | varchar(45) | YES  |     | NULL    |                |
| date_value    | datetime    | YES  |     | NULL    |                |
| field_type    | varchar(10) | NO   |     | NULL    |                |
| numeric_value | double      | YES  |     | NULL    |                |
+---------------+-------------+------+-----+---------+----------------+

webwarecl.contacts

+----------+------------+------+-----+---------+----------------+
| Field    | Type       | Null | Key | Default | Extra          |
+----------+------------+------+-----+---------+----------------+
| id       | bigint(20) | NO   | PRI | NULL    | auto_increment |
| owner_id | bigint(20) | NO   |     | NULL    |                |
+----------+------------+------+-----+---------+----------------+

webwarecl.crew_entries

+--------+---------------------+------+-----+---------+----------------+
| Field  | Type                | Null | Key | Default | Extra          |
+--------+---------------------+------+-----+---------+----------------+
| id     | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| userid | bigint(20) unsigned | NO   |     | 0       |                |
| chief  | int(10) unsigned    | NO   |     | 0       |                |
| crewid | int(10) unsigned    | NO   |     | 0       |                |
+--------+---------------------+------+-----+---------+----------------+

webwarecl.crews

+-------+------------------+------+-----+---------+----------------+
| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+
| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name  | varchar(255)     | NO   |     |         |                |
+-------+------------------+------+-----+---------+----------------+

webwarecl.documents

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| doc_id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| help_context_id | int(10) unsigned    | YES  |     | NULL    |                |
| author_id       | bigint(20) unsigned | NO   |     | NULL    |                |
| doc_title       | varchar(255)        | NO   |     | NULL    |                |
| doc_body        | text                | NO   |     | NULL    |                |
| keywords        | text                | NO   |     | NULL    |                |
| created_date    | datetime            | NO   |     | NULL    |                |
| catalog_id      | bigint(20) unsigned | NO   |     | 1       |                |
+-----------------+---------------------+------+-----+---------+----------------+

webwarecl.employee_info

+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| id              | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| user_id         | bigint(20)   | NO   |     | NULL    |                |
| work_week_start | int(11)      | YES  |     | NULL    |                |
| wage            | float        | YES  |     | NULL    |                |
| wage_type       | varchar(45)  | YES  |     | NULL    |                |
| title           | varchar(255) | YES  |     | NULL    |                |
| hire_date       | date         | YES  |     | NULL    |                |
| active          | tinyint(4)   | YES  |     | NULL    |                |
| release_date    | date         | YES  |     | NULL    |                |
| emp_type        | varchar(255) | YES  |     | NULL    |                |
| om_uuid         | varchar(255) | YES  |     | NULL    |                |
| site_id         | bigint(20)   | YES  |     | NULL    |                |
| work_week_end   | int(11)      | YES  |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+

webwarecl.exportedobjects

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| id                    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| AppID                 | bigint(20) unsigned | NO   |     | NULL    |                |
| Description           | varchar(45)         | NO   |     | NULL    |                |
| Icon                  | varchar(45)         | NO   |     | NULL    |                |
| MasterTable           | varchar(45)         | NO   |     | NULL    |                |
| IDFieldName           | varchar(45)         | NO   |     | NULL    |                |
| ObjectNameFieldName   | varchar(45)         | NO   |     | NULL    |                |
| ObjectSiteIDFieldName | varchar(45)         | NO   |     | NULL    |                |
| ObjectUserIDFieldName | varchar(45)         | NO   |     | NULL    |                |
| Datasource            | varchar(45)         | NO   |     | NULL    |                |
| IconContext           | varchar(45)         | NO   |     | NULL    |                |
| LegacyCreator         | varchar(255)        | NO   |     | NULL    |                |
| CreateVerb            | varchar(45)         | NO   |     | NULL    |                |
| CreatorDialog         | varchar(45)         | NO   |     | NULL    |                |
| OpenerDialog          | varchar(45)         | NO   |     | NULL    |                |
| DefaultView           | bigint(20) unsigned | YES  |     | NULL    |                |
| ObjectUUIDFieldName   | varchar(45)         | NO   |     | NULL    |                |
| CreateFormID          | bigint(20) unsigned | NO   |     | 0       |                |
+-----------------------+---------------------+------+-----+---------+----------------+

webwarecl.favorites

+---------+---------------------+------+-----+---------+----------------+
| Field   | Type                | Null | Key | Default | Extra          |
+---------+---------------------+------+-----+---------+----------------+
| id      | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id | bigint(20) unsigned | NO   |     | NULL    |                |
| url     | varchar(255)        | NO   |     | NULL    |                |
| title   | varchar(255)        | NO   |     | NULL    |                |
| docked  | tinyint(3) unsigned | NO   |     | 0       |                |
+---------+---------------------+------+-----+---------+----------------+

webwarecl.file_types

+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name      | varchar(45)      | NO   |     |         |                |
| extension | varchar(45)      | NO   |     |         |                |
+-----------+------------------+------+-----+---------+----------------+

webwarecl.files

+----------------+---------------------+------+-----+---------------------+----------------+
| Field          | Type                | Null | Key | Default             | Extra          |
+----------------+---------------------+------+-----+---------------------+----------------+
| id             | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment |
| projectID      | bigint(20) unsigned | NO   |     | 0                   |                |
| clientID       | bigint(20) unsigned | NO   |     | 0                   |                |
| filePath       | text                | NO   |     | NULL                |                |
| uploaderID     | bigint(20) unsigned | NO   |     | 0                   |                |
| uploadDateTime | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| longName       | text                | NO   |     | NULL                |                |
| fileType       | varchar(45)         | NO   |     |                     |                |
| needsReview    | int(10) unsigned    | NO   |     | 0                   |                |
| approved       | int(10) unsigned    | NO   |     | 0                   |                |
| approvalDate   | datetime            | NO   |     | 1900-01-01 00:00:00 |                |
| subdivisionID  | bigint(20) unsigned | YES  |     | NULL                |                |
| keywords       | text                | YES  |     | NULL                |                |
+----------------+---------------------+------+-----+---------------------+----------------+

webwarecl.folder_items

+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| id               | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| ItemType         | varchar(45)         | NO   |     | NULL    |                |
| ItemName         | varchar(255)        | NO   |     | NULL    |                |
| ObjectTypeID     | bigint(20) unsigned | NO   |     | NULL    |                |
| ObjectID         | bigint(20) unsigned | NO   |     | NULL    |                |
| TargetFolderID   | bigint(20) unsigned | YES  |     | NULL    |                |
| ContainingFolder | bigint(20) unsigned | YES  |     | NULL    |                |
| UserID           | bigint(20) unsigned | NO   |     | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+

webwarecl.folders

+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| id             | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| ParentFolderID | bigint(20) unsigned | NO   |     | NULL    |                |
| FolderName     | varchar(255)        | NO   |     | NULL    |                |
| UserID         | bigint(20) unsigned | NO   |     | NULL    |                |
| GenCode        | varchar(45)         | NO   |     | NULL    |                |
| IsBin          | tinyint(3) unsigned | NO   |     | 0       |                |
+----------------+---------------------+------+-----+---------+----------------+

webwarecl.form_fields

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| FormID        | bigint(20) unsigned | NO   |     | NULL    |                |
| Label         | varchar(45)         | NO   |     | NULL    |                |
| ObjectFieldID | bigint(20) unsigned | NO   |     | NULL    |                |
| PresentOrder  | int(10) unsigned    | YES  |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

webwarecl.forms

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| ObjectTypeID    | bigint(20) unsigned | NO   |     | NULL    |                |
| ActionType      | varchar(45)         | NO   |     | NULL    |                |
| FormName        | varchar(255)        | NO   |     | NULL    |                |
| FormDescription | text                | NO   |     | NULL    |                |
+-----------------+---------------------+------+-----+---------+----------------+

webwarecl.friends

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| source_id    | bigint(20) unsigned | NO   |     | NULL    |                |
| target_id    | bigint(20) unsigned | NO   |     | NULL    |                |
| confirmed    | tinyint(3) unsigned | NO   |     | 0       |                |
| request_date | datetime            | NO   |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+

webwarecl.fu

+-------+------------------+------+-----+---------+----------------+
| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+
| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| mode  | varchar(45)      | NO   |     | NULL    |                |
+-------+------------------+------+-----+---------+----------------+

webwarecl.gis_locations

+----------------------+---------------------+------+-----+---------+----------------+
| Field                | Type                | Null | Key | Default | Extra          |
+----------------------+---------------------+------+-----+---------+----------------+
| id                   | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| location_name        | varchar(255)        | NO   |     | NULL    |                |
| address              | varchar(255)        | YES  |     | NULL    |                |
| city                 | varchar(45)         | YES  |     | NULL    |                |
| state                | varchar(45)         | YES  |     | NULL    |                |
| zip                  | varchar(45)         | YES  |     | NULL    |                |
| latitude             | varchar(45)         | YES  |     | NULL    |                |
| longitude            | varchar(45)         | YES  |     | NULL    |                |
| section              | varchar(45)         | YES  |     | NULL    |                |
| township             | varchar(45)         | YES  |     | NULL    |                |
| range                | varchar(45)         | YES  |     | NULL    |                |
| county               | varchar(45)         | YES  |     | NULL    |                |
| visibility           | text                | YES  |     | NULL    |                |
| accessibility        | text                | YES  |     | NULL    |                |
| terrain              | text                | YES  |     | NULL    |                |
| special_instructions | text                | YES  |     | NULL    |                |
| usgs_quad            | varchar(45)         | YES  |     | NULL    |                |
| fema_map             | varchar(45)         | YES  |     | NULL    |                |
| station              | varchar(45)         | YES  |     | NULL    |                |
| pid                  | varchar(45)         | YES  |     | NULL    |                |
| designation          | varchar(45)         | YES  |     | NULL    |                |
| projection           | varchar(45)         | YES  |     | NULL    |                |
| grid_scale_factor    | float               | YES  |     | NULL    |                |
| ground_scale_factor  | float               | YES  |     | NULL    |                |
| history              | text                | YES  |     | NULL    |                |
| observation_type     | varchar(45)         | YES  |     | NULL    |                |
| geoid                | varchar(45)         | YES  |     | NULL    |                |
| horizontal_datum     | varchar(45)         | YES  |     | NULL    |                |
| vertical_datum       | varchar(45)         | YES  |     | NULL    |                |
| live_feed            | tinyint(3) unsigned | NO   |     | NULL    |                |
| publisher_id         | bigint(20) unsigned | NO   |     | NULL    |                |
| component            | varchar(45)         | NO   |     | NULL    |                |
| object_id            | bigint(20) unsigned | NO   |     | NULL    |                |
+----------------------+---------------------+------+-----+---------+----------------+

webwarecl.help_catalogs

+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| CatalogName | varchar(45)         | NO   |     | NULL    |                |
+-------------+---------------------+------+-----+---------+----------------+

webwarecl.hits

+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| hit_date | datetime            | NO   |     | NULL    |                |
| hit_page | varchar(45)         | NO   |     | NULL    |                |
| hit_ip   | varchar(45)         | NO   |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+

webwarecl.home_quotes

+-----------------------+------------------+------+-----+---------+----------------+
| Field                 | Type             | Null | Key | Default | Extra          |
+-----------------------+------------------+------+-----+---------+----------------+
| id                    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| what_the_homie_said   | text             | NO   |     | NULL    |                |
| the_homie_who_said_it | varchar(255)     | NO   |     | NULL    |                |
+-----------------------+------------------+------+-----+---------+----------------+

webwarecl.hosts

+-----------------+------------------+------+-----+---------+-------+
| Field           | Type             | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+-------+
| HostKey         | varchar(255)     | NO   | PRI | NULL    |       |
| HostName        | varchar(255)     | NO   |     | NULL    |       |
| HostDescription | varchar(255)     | NO   |     | NULL    |       |
| DefaultRunLevel | int(10) unsigned | NO   |     | 3       |       |
| BootTimeout     | int(10) unsigned | NO   |     | 5       |       |
+-----------------+------------------+------+-----+---------+-------+

webwarecl.installed_toolbars

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| toolbar_id | bigint(20) unsigned | NO   |     | NULL    |                |
| user_id    | bigint(20) unsigned | NO   |     | NULL    |                |
| display    | tinyint(3) unsigned | NO   |     | 1       |                |
+------------+---------------------+------+-----+---------+----------------+

webwarecl.installedapplications

+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| assoc_id | bigint(20) unsigned | NO   |     | NULL    |                |
| app_id   | bigint(20) unsigned | NO   |     | NULL    |                |
| AppName  | varchar(255)        | NO   |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+

webwarecl.item_customizations

+---------+---------------------+------+-----+---------+----------------+
| Field   | Type                | Null | Key | Default | Extra          |
+---------+---------------------+------+-----+---------+----------------+
| id      | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| site_id | bigint(20) unsigned | NO   |     | NULL    |                |
| price   | float               | NO   |     | 0       |                |
| ic_name | varchar(255)        | NO   |     | NULL    |                |
+---------+---------------------+------+-----+---------+----------------+

webwarecl.jobnotes

+----------+------------------+------+-----+---------------------+----------------+
| Field    | Type             | Null | Key | Default             | Extra          |
+----------+------------------+------+-----+---------------------+----------------+
| id       | int(10) unsigned | NO   | PRI | NULL                | auto_increment |
| employee | varchar(255)     | NO   |     |                     |                |
| date     | datetime         | NO   |     | 0000-00-00 00:00:00 |                |
| note     | text             | NO   |     | NULL                |                |
| jobid    | int(10) unsigned | NO   |     | 0                   |                |
| submit   | varchar(45)      | NO   |     |                     |                |
+----------+------------------+------+-----+---------------------+----------------+

webwarecl.locations

+-----------------+----------------------+------+-----+---------+----------------+
| Field           | Type                 | Null | Key | Default | Extra          |
+-----------------+----------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned  | NO   | PRI | NULL    | auto_increment |
| address         | varchar(255)         | NO   |     | NULL    |                |
| city            | varchar(255)         | NO   |     | NULL    |                |
| state           | varchar(2)           | NO   |     | NULL    |                |
| zip             | varchar(255)         | NO   |     | NULL    |                |
| mailing         | tinyint(3) unsigned  | NO   |     | NULL    |                |
| billing         | tinyint(3) unsigned  | NO   |     | NULL    |                |
| description     | varchar(255)         | NO   |     | NULL    |                |
| user_id         | bigint(20) unsigned  | NO   |     | NULL    |                |
| public_location | smallint(5) unsigned | NO   |     | 0       |                |
+-----------------+----------------------+------+-----+---------+----------------+

webwarecl.mail_attachments

+---------+---------------------+------+-----+---------+----------------+
| Field   | Type                | Null | Key | Default | Extra          |
+---------+---------------------+------+-----+---------+----------------+
| id      | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| msg_id  | bigint(20) unsigned | NO   | MUL | NULL    |                |
| file_id | bigint(20) unsigned | NO   | MUL | NULL    |                |
+---------+---------------------+------+-----+---------+----------------+

webwarecl.menu_entries

+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| menu_id  | bigint(20) unsigned | NO   |     | NULL    |                |
| caption  | varchar(45)         | NO   |     | NULL    |                |
| image    | varchar(45)         | NO   |     | NULL    |                |
| target   | varchar(255)        | NO   |     | NULL    |                |
| perm_key | varchar(45)         | NO   |     | NULL    |                |
| direct   | tinyint(3) unsigned | NO   |     | 0       |                |
+----------+---------------------+------+-----+---------+----------------+

webwarecl.menus

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| caption      | varchar(45)         | NO   |     | NULL    |                |
| handle       | varchar(45)         | NO   |     | NULL    |                |
| component_id | bigint(20) unsigned | NO   |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+

webwarecl.messageinbox

+-------------------------+---------------------+------+-----+---------+----------------+
| Field                   | Type                | Null | Key | Default | Extra          |
+-------------------------+---------------------+------+-----+---------+----------------+
| id                      | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| fromuser                | bigint(20) unsigned | YES  | MUL | NULL    |                |
| touser                  | bigint(20) unsigned | YES  | MUL | NULL    |                |
| tsubject                | text                | YES  |     | NULL    |                |
| tbody                   | text                | YES  |     | NULL    |                |
| draft                   | tinyint(4)          | NO   |     | 1       |                |
| tdate                   | datetime            | YES  |     | NULL    |                |
| tread                   | tinyint(4)          | NO   |     | 0       |                |
| read_receipt            | tinyint(4)          | NO   |     | 0       |                |
| deleted_recipient_inbox | tinyint(4)          | NO   |     | 0       |                |
| deleted_sender_outbox   | tinyint(4)          | NO   |     | 0       |                |
| req_id                  | varchar(255)        | NO   |     | NULL    |                |
+-------------------------+---------------------+------+-----+---------+----------------+

webwarecl.multiselect_items

+---------+---------------------+------+-----+---------+----------------+
| Field   | Type                | Null | Key | Default | Extra          |
+---------+---------------------+------+-----+---------+----------------+
| id      | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| caption | varchar(255)        | NO   |     | NULL    |                |
| value   | text                | NO   |     | NULL    |                |
| ms_id   | bigint(20) unsigned | NO   |     | NULL    |                |
+---------+---------------------+------+-----+---------+----------------+

webwarecl.news_categories

+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| description | varchar(255)     | NO   |     |         |                |
| img         | varchar(255)     | NO   |     |         |                |
+-------------+------------------+------+-----+---------+----------------+

webwarecl.news_items

+---------------+---------------------+------+-----+---------------------+----------------+
| Field         | Type                | Null | Key | Default             | Extra          |
+---------------+---------------------+------+-----+---------------------+----------------+
| id            | int(10) unsigned    | NO   | PRI | NULL                | auto_increment |
| headline      | varchar(255)        | NO   |     |                     |                |
| body          | text                | NO   |     | NULL                |                |
| date          | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| item_category | int(10) unsigned    | NO   |     | 0                   |                |
| site_id       | bigint(20) unsigned | NO   |     | NULL                |                |
+---------------+---------------------+------+-----+---------------------+----------------+

webwarecl.notification_entries

+-----------------+----------------------+------+-----+---------+----------------+
| Field           | Type                 | Null | Key | Default | Extra          |
+-----------------+----------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned  | NO   | PRI | NULL    | auto_increment |
| user_id         | bigint(20) unsigned  | NO   | MUL | NULL    |                |
| notification_id | int(10) unsigned     | NO   | MUL | NULL    |                |
| method          | smallint(5) unsigned | NO   |     | NULL    |                |
+-----------------+----------------------+------+-----+---------+----------------+

webwarecl.notification_log

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id      | bigint(20) unsigned | NO   |     | NULL    |                |
| event_key    | varchar(255)        | NO   |     | NULL    |                |
| body_text    | text                | NO   |     | NULL    |                |
| event_link   | text                | NO   |     | NULL    |                |
| sent_date    | datetime            | NO   |     | NULL    |                |
| acknowledged | tinyint(3) unsigned | NO   |     | 0       |                |
| site_id      | bigint(20) unsigned | NO   |     | 5       |                |
| OTID         | bigint(20) unsigned | NO   |     | 0       |                |
| OIID         | varchar(45)         | NO   |     | 0       |                |
+--------------+---------------------+------+-----+---------+----------------+

webwarecl.notifications

+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| n_key       | varchar(45)      | NO   |     | NULL    |                |
| description | varchar(255)     | NO   |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+

webwarecl.object_acl

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| UserID       | bigint(20) unsigned | NO   |     | NULL    |                |
| PView        | tinyint(3) unsigned | NO   |     | NULL    |                |
| PEdit        | tinyint(3) unsigned | NO   |     | NULL    |                |
| PDelete      | tinyint(3) unsigned | NO   |     | NULL    |                |
| PAdd         | tinyint(3) unsigned | NO   |     | NULL    |                |
| ObjectTypeID | bigint(20) unsigned | NO   |     | NULL    |                |
| ObjectID     | bigint(20) unsigned | NO   |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+

webwarecl.object_fields

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| id                | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| ExportedObjectID  | bigint(20) unsigned | NO   |     | NULL    |                |
| FieldName         | varchar(255)        | NO   |     | NULL    |                |
| FieldType         | varchar(45)         | NO   |     | NULL    |                |
| BindToDBTable     | varchar(255)        | NO   |     | NULL    |                |
| BindToDBField     | varchar(255)        | NO   |     | NULL    |                |
| DBForeignKeyTable | bigint(20) unsigned | YES  |     | NULL    |                |
| DBForeignKeyField | bigint(20) unsigned | YES  |     | NULL    |                |
| IsForeignKey      | tinyint(3) unsigned | NO   |     | 0       |                |
| XMLFieldName      | varchar(45)         | YES  |     | NULL    |                |
| QuoteSQL          | tinyint(3) unsigned | NO   |     | 1       |                |
| MultiSelectID     | bigint(20) unsigned | NO   |     | 0       |                |
+-------------------+---------------------+------+-----+---------+----------------+

webwarecl.object_relationships

+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| SourceOTID  | bigint(20) unsigned | NO   |     | NULL    |                |
| SourceOIID  | bigint(20) unsigned | NO   |     | NULL    |                |
| DestOTID    | bigint(20) unsigned | YES  |     | NULL    |                |
| DestOIID    | bigint(20) unsigned | YES  |     | NULL    |                |
| Description | varchar(255)        | NO   |     | NULL    |                |
| Self        | tinyint(3) unsigned | NO   |     | 0       |                |
| om_uuid     | varchar(255)        | NO   |     | NULL    |                |
+-------------+---------------------+------+-----+---------+----------------+

webwarecl.object_views

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| XSLT          | text                | NO   |     | NULL    |                |
| Media         | bigint(20) unsigned | NO   |     | NULL    |                |
| PermissionKey | bigint(20) unsigned | NO   |     | NULL    |                |
| ObjectTypeID  | bigint(20) unsigned | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

webwarecl.order_annotations

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| order_id        | bigint(20) unsigned | NO   |     | NULL    |                |
| user_id         | bigint(20) unsigned | NO   |     | NULL    |                |
| annotation_date | datetime            | NO   |     | NULL    |                |
| annotation      | text                | NO   |     | NULL    |                |
+-----------------+---------------------+------+-----+---------+----------------+

webwarecl.order_items

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| id                | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| OriginalCatalogID | bigint(20) unsigned | NO   |     | NULL    |                |
| ProductName       | varchar(255)        | NO   |     | NULL    |                |
| ItemNumber        | varchar(255)        | NO   |     | NULL    |                |
| ProductWeight     | float               | NO   |     | 0       |                |
| QuantityOrdered   | bigint(20) unsigned | NO   |     | NULL    |                |
| UnitPrice         | float               | NO   |     | 0       |                |
| order_id          | bigint(20) unsigned | NO   |     | NULL    |                |
| done              | tinyint(3) unsigned | NO   |     | 0       |                |
| survey_id         | bigint(20) unsigned | NO   |     | 0       |                |
| om_uuid           | varchar(255)        | NO   |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+

webwarecl.orders

+----------------------+---------------------+------+-----+---------+----------------+
| Field                | Type                | Null | Key | Default | Extra          |
+----------------------+---------------------+------+-----+---------+----------------+
| id                   | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| vendor_id            | bigint(20) unsigned | NO   |     | NULL    |                |
| customer_id          | bigint(20) unsigned | NO   |     | NULL    |                |
| stage                | tinyint(3) unsigned | NO   |     | 0       |                |
| fulfillment_method   | varchar(45)         | NO   |     | NULL    |                |
| fulfillment_location | bigint(20) unsigned | YES  |     | NULL    |                |
| payment_profile      | bigint(20) unsigned | NO   |     | NULL    |                |
| om_uuid              | varchar(255)        | NO   |     | NULL    |                |
| order_date           | datetime            | NO   |     | NULL    |                |
+----------------------+---------------------+------+-----+---------+----------------+

webwarecl.orms

+-----------+---------------------+------+-----+----------------------------+-----------------------------+
| Field     | Type                | Null | Key | Default                    | Extra                       |
+-----------+---------------------+------+-----+----------------------------+-----------------------------+
| id        | varchar(255)        | NO   | PRI | NULL                       |                             |
| r_type    | varchar(255)        | NO   |     | NULL                       |                             |
| r_owner   | bigint(20) unsigned | NO   |     | NULL                       |                             |
| r_site    | bigint(20) unsigned | NO   |     | NULL                       |                             |
| r_name    | varchar(255)        | NO   |     | NULL                       |                             |
| r_edit    | varchar(255)        | NO   |     | javascript:ORMSNoAction(); |                             |
| r_view    | varchar(255)        | NO   |     | javascript:ORMSNoAction(); |                             |
| r_delete  | varchar(255)        | NO   |     | javascript:ORMSNoAction(); |                             |
| r_thumb   | varchar(255)        | NO   |     | /graphics/error.png        |                             |
| r_created | timestamp           | NO   |     | CURRENT_TIMESTAMP          | on update CURRENT_TIMESTAMP |
| r_pk      | bigint(20) unsigned | NO   |     | NULL                       |                             |
| r_status  | varchar(255)        | YES  |     | NULL                       |                             |
| r_parent  | varchar(255)        | NO   |     | NONE                       |                             |
+-----------+---------------------+------+-----+----------------------------+-----------------------------+

webwarecl.orms_access_log

+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key | Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| r_id      | varchar(255)        | NO   |     | NULL    |                |
| a_type    | varchar(45)         | NO   |     | NULL    |                |
| a_date    | datetime            | NO   |     | NULL    |                |
| a_user_id | bigint(20) unsigned | NO   |     | NULL    |                |
+-----------+---------------------+------+-----+---------+----------------+

webwarecl.orms_app_sections

+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| id             | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| r_type         | varchar(255)        | NO   |     | NULL    |                |
| industry       | bigint(20) unsigned | NO   |     | NULL    |                |
| section_name   | varchar(255)        | NO   |     | NULL    |                |
| section_loader | varchar(255)        | NO   |     | NULL    |                |
| section_file   | varchar(255)        | NO   |     | NULL    |                |
| display_order  | int(10) unsigned    | NO   |     | NULL    |                |
+----------------+---------------------+------+-----+---------+----------------+

webwarecl.orms_comments

+--------------+---------------------+------+-----+-------------------+-----------------------------+
| Field        | Type                | Null | Key | Default           | Extra                       |
+--------------+---------------------+------+-----+-------------------+-----------------------------+
| id           | bigint(20) unsigned | NO   | PRI | NULL              | auto_increment              |
| r_id         | varchar(255)        | NO   |     | NULL              |                             |
| user_id      | bigint(20) unsigned | NO   |     | NULL              |                             |
| post_date    | timestamp           | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| comment_body | text                | NO   |     | NULL              |                             |
| rating       | int(10) unsigned    | NO   |     | 0                 |                             |
+--------------+---------------------+------+-----+-------------------+-----------------------------+

webwarecl.orms_creators

+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key | Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| r_type    | varchar(255)        | NO   |     | NULL    |                |
| file_path | varchar(255)        | NO   |     | NULL    |                |
| icon      | varchar(255)        | NO   |     | NULL    |                |
+-----------+---------------------+------+-----+---------+----------------+

webwarecl.orms_files

+-------------+---------------------+------+-----+---------+-------+
| Field       | Type                | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| file_id     | varchar(255)        | NO   | PRI | NULL    |       |
| orms_id     | varchar(255)        | NO   |     | NULL    |       |
| poster_id   | bigint(20) unsigned | NO   |     | NULL    |       |
| post_date   | datetime            | NO   |     | NULL    |       |
| post_name   | varchar(255)        | NO   |     | NULL    |       |
| post_edited | tinyint(3) unsigned | NO   |     | 0       |       |
+-------------+---------------------+------+-----+---------+-------+

webwarecl.orms_keywords

+---------+---------------------+------+-----+---------+----------------+
| Field   | Type                | Null | Key | Default | Extra          |
+---------+---------------------+------+-----+---------+----------------+
| id      | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| k_word  | varchar(255)        | NO   |     | NULL    |                |
| k_value | text                | NO   |     | NULL    |                |
| r_id    | varchar(255)        | NO   |     | NULL    |                |
+---------+---------------------+------+-----+---------+----------------+

webwarecl.orms_relations

+-------------+---------------------+------+-----+-------------------+-----------------------------+
| Field       | Type                | Null | Key | Default           | Extra                       |
+-------------+---------------------+------+-----+-------------------+-----------------------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL              | auto_increment              |
| rel_source  | varchar(255)        | NO   |     | NULL              |                             |
| rel_target  | varchar(255)        | NO   |     | NULL              |                             |
| rel_type    | varchar(255)        | NO   |     | NULL              |                             |
| rel_created | timestamp           | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| rel_expires | datetime            | YES  |     | NULL              |                             |
+-------------+---------------------+------+-----+-------------------+-----------------------------+

webwarecl.password_reset_requests

+------------+---------------------+------+-----+---------+-------+
| Field      | Type                | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| id         | varchar(255)        | NO   | PRI | NULL    |       |
| user_id    | bigint(20) unsigned | NO   |     | NULL    |       |
| expiration | datetime            | NO   |     | NULL    |       |
+------------+---------------------+------+-----+---------+-------+

webwarecl.payment_profiles

+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| id                  | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id             | bigint(20) unsigned | NO   |     | NULL    |                |
| card_number         | varchar(255)        | NO   |     | NULL    |                |
| expiration_date     | datetime            | NO   |     | NULL    |                |
| name_on_card        | varchar(255)        | NO   |     | NULL    |                |
| cvv                 | varchar(5)          | NO   |     | NULL    |                |
| profile_name        | varchar(255)        | NO   |     | NULL    |                |
| billing_location_id | bigint(20) unsigned | NO   |     | NULL    |                |
| card_type           | varchar(100)        | NO   |     | NULL    |                |
| credit_card         | tinyint(3) unsigned | NO   |     | 1       |                |
+---------------------+---------------------+------+-----+---------+----------------+

webwarecl.phones

+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| companyid   | int(10) unsigned | NO   |     | 0       |                |
| phonetypeid | int(10) unsigned | NO   |     | 0       |                |
| number      | varchar(45)      | NO   |     |         |                |
+-------------+------------------+------+-----+---------+----------------+

webwarecl.phonetypes

+-------+------------------+------+-----+---------+----------------+
| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+
| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name  | varchar(45)      | NO   |     |         |                |
+-------+------------------+------+-----+---------+----------------+

webwarecl.pm_blocking_tasks

+------------------+------------+------+-----+---------+----------------+
| Field            | Type       | Null | Key | Default | Extra          |
+------------------+------------+------+-----+---------+----------------+
| id               | bigint(20) | NO   | PRI | NULL    | auto_increment |
| blocked_task_id  | bigint(20) | NO   | MUL | NULL    |                |
| blocking_task_id | bigint(20) | NO   | MUL | NULL    |                |
+------------------+------------+------+-----+---------+----------------+

webwarecl.pm_deliverables

+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| id                  | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| project_id          | bigint(20)   | NO   | MUL | NULL    |                |
| deliverable_name    | varchar(45)  | NO   |     | NULL    |                |
| deliverable_file_id | bigint(20)   | YES  |     | NULL    |                |
| create_id           | varchar(255) | NO   |     | NULL    |                |
+---------------------+--------------+------+-----+---------+----------------+

webwarecl.pm_dispatches

+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| id                   | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| task_id              | bigint(20)   | NO   | MUL | NULL    |                |
| dispatcher_assoc_id  | bigint(20)   | NO   |     | NULL    |                |
| dispatchee_assoc_id  | bigint(20)   | NO   |     | NULL    |                |
| dispatch_date        | datetime     | NO   |     | NULL    |                |
| dispatch_description | text         | YES  |     | NULL    |                |
| create_id            | varchar(255) | NO   |     | NULL    |                |
+----------------------+--------------+------+-----+---------+----------------+

webwarecl.pm_filed_documents

+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| id                   | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| project_id           | bigint(20)   | NO   | MUL | NULL    |                |
| location_id          | bigint(20)   | NO   |     | 0       |                |
| document_name        | varchar(45)  | NO   |     | NULL    |                |
| document_number      | varchar(45)  | YES  |     | NULL    |                |
| filing_authority     | varchar(45)  | NO   |     |         |                |
| filing_category      | varchar(15)  | NO   |     | FILE    |                |
| filing_container     | varchar(15)  | NO   |     | CABINET |                |
| filing_division      | varchar(50)  | NO   |     |         |                |
| filing_material_type | varchar(10)  | NO   |     | PAGE    |                |
| filing_number        | varchar(20)  | NO   |     |         |                |
| filing_date          | datetime     | NO   |     | NULL    |                |
| create_id            | varchar(255) | NO   |     | NULL    |                |
+----------------------+--------------+------+-----+---------+----------------+

webwarecl.pm_locations

+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| project_id    | bigint(20)   | NO   | MUL | NULL    |                |
| location_name | varchar(45)  | NO   |     | NULL    |                |
| address       | varchar(100) | YES  |     | NULL    |                |
| city          | varchar(100) | YES  |     | NULL    |                |
| state         | varchar(100) | YES  |     | NULL    |                |
| zip           | varchar(10)  | YES  |     | NULL    |                |
| subdivision   | varchar(100) | YES  |     | NULL    |                |
| lot           | varchar(45)  | YES  |     | NULL    |                |
| block         | varchar(45)  | YES  |     | NULL    |                |
| trs_section   | varchar(45)  | YES  |     | NULL    |                |
| trs_township  | varchar(45)  | YES  |     | NULL    |                |
| trs_range     | varchar(45)  | YES  |     | NULL    |                |
| trs_meridian  | varchar(45)  | YES  |     | NULL    |                |
| latitude      | varchar(45)  | YES  |     | NULL    |                |
| longitude     | varchar(45)  | YES  |     | NULL    |                |
| elevation     | varchar(45)  | YES  |     | NULL    |                |
| create_id     | varchar(255) | NO   |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+

webwarecl.pm_project_tags

+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | bigint(20)  | NO   | PRI | NULL    | auto_increment |
| project_id | bigint(20)  | NO   | MUL | NULL    |                |
| tag_text   | varchar(45) | NO   |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+

webwarecl.pm_projects

+------------------------------+--------------+------+-----+---------+----------------+
| Field                        | Type         | Null | Key | Default | Extra          |
+------------------------------+--------------+------+-----+---------+----------------+
| id                           | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| employee_assoc               | bigint(20)   | NO   |     | NULL    |                |
| client_assoc                 | bigint(20)   | NO   |     | NULL    |                |
| template_id                  | bigint(20)   | NO   |     | 0       |                |
| project_priority             | tinyint(4)   | NO   |     | 0       |                |
| project_name                 | varchar(255) | NO   |     | NULL    |                |
| project_status               | varchar(45)  | NO   |     | NULL    |                |
| project_start_date           | datetime     | YES  |     | NULL    |                |
| project_due_date             | datetime     | YES  |     | NULL    |                |
| project_description          | text         | YES  |     | NULL    |                |
| project_created              | datetime     | NO   |     | NULL    |                |
| create_id                    | varchar(255) | NO   |     | NULL    |                |
| pm_base_cabinets_created     | tinyint(4)   | NO   |     | 0       |                |
| pm_template_cabinets_created | tinyint(4)   | NO   |     | 0       |                |
| pm_billing_type              | tinyint(4)   | NO   |     | 0       |                |
| pm_billing_poc               | bigint(20)   | NO   |     | 0       |                |
| pm_bid_amount                | decimal(9,2) | NO   |     | 0.00    |                |
| archived                     | tinyint(4)   | NO   |     | 0       |                |
| is_group                     | tinyint(4)   | NO   |     | 0       |                |
+------------------------------+--------------+------+-----+---------+----------------+

webwarecl.pm_stakeholders

+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| id               | bigint(20)          | NO   | PRI | NULL    | auto_increment |
| project_id       | bigint(20)          | NO   | MUL | NULL    |                |
| assoc_id         | bigint(20) unsigned | NO   | MUL | NULL    |                |
| stakeholder_type | varchar(45)         | NO   |     | Client  |                |
| permissions      | bigint(20)          | NO   |     | 1       |                |
| create_id        | varchar(255)        | NO   |     | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+

webwarecl.pm_tasks

+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| id                   | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| project_id           | bigint(20)   | NO   | MUL | NULL    |                |
| assignee_assoc_id    | bigint(20)   | YES  |     | NULL    |                |
| task_name            | varchar(255) | NO   |     | NULL    |                |
| task_complete        | tinyint(4)   | NO   |     | 0       |                |
| task_description     | text         | YES  |     | NULL    |                |
| task_resolution      | varchar(45)  | NO   |     |         |                |
| task_priority        | varchar(45)  | NO   |     | Normal  |                |
| create_id            | varchar(255) | NO   |     | NULL    |                |
| due_date             | datetime     | YES  |     | NULL    |                |
| time_sensitive       | tinyint(4)   | NO   |     | 0       |                |
| reviewer_assoc_id    | bigint(20)   | NO   |     | 0       |                |
| task_under_review    | tinyint(4)   | NO   |     | 0       |                |
| task_review_accepted | tinyint(4)   | NO   |     | 0       |                |
+----------------------+--------------+------+-----+---------+----------------+

webwarecl.pm_template_deliverables

+------------------+-------------+------+-----+---------+----------------+
| Field            | Type        | Null | Key | Default | Extra          |
+------------------+-------------+------+-----+---------+----------------+
| id               | bigint(20)  | NO   | PRI | NULL    | auto_increment |
| template_id      | bigint(20)  | NO   |     | NULL    |                |
| deliverable_name | varchar(45) | NO   |     | NULL    |                |
| create_id        | varchar(45) | NO   |     | NULL    |                |
+------------------+-------------+------+-----+---------+----------------+

webwarecl.pm_template_tasks

+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| template_id   | bigint(20)   | NO   |     | NULL    |                |
| task_name     | varchar(255) | NO   |     | NULL    |                |
| task_priority | varchar(45)  | NO   |     | NULL    |                |
| create_id     | varchar(45)  | NO   |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+

webwarecl.pm_templates

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| template_site | bigint(20) unsigned | NO   | MUL | 0       |                |
| template_name | varchar(45)         | NO   |     | NULL    |                |
| create_id     | varchar(255)        | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

webwarecl.pm_time_entries

+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| project_id     | bigint(20)   | NO   | MUL | NULL    |                |
| task_id        | bigint(20)   | NO   |     | 0       |                |
| assoc_id       | bigint(20)   | NO   |     | NULL    |                |
| task_code_id   | bigint(20)   | NO   |     | NULL    |                |
| work_performed | varchar(255) | NO   |     | NULL    |                |
| start_time     | datetime     | NO   |     | NULL    |                |
| end_time       | datetime     | NO   |     | NULL    |                |
| closed         | tinyint(4)   | NO   |     | 0       |                |
| approved       | tinyint(4)   | NO   |     | 0       |                |
| billed         | tinyint(4)   | NO   |     | 0       |                |
| create_id      | varchar(255) | NO   |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+

webwarecl.pm_travel_entries

+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| project_id     | bigint(20)   | NO   | MUL | NULL    |                |
| task_id        | bigint(20)   | NO   |     | 0       |                |
| assoc_id       | bigint(20)   | NO   |     | NULL    |                |
| task_code_id   | bigint(20)   | NO   |     | NULL    |                |
| travel_date    | datetime     | NO   |     | NULL    |                |
| travel_name    | varchar(255) | NO   |     | NULL    |                |
| odometer_start | double       | NO   |     | 0       |                |
| odometer_end   | double       | NO   |     | 0       |                |
| closed         | tinyint(4)   | NO   |     | 0       |                |
| create_id      | varchar(255) | NO   |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+

webwarecl.post_reactions

+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | bigint(20)  | NO   | PRI | NULL    | auto_increment |
| post_id  | bigint(20)  | NO   |     | NULL    |                |
| reaction | varchar(10) | NO   |     | NULL    |                |
| user_id  | bigint(20)  | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+

webwarecl.posts

+----------------+------------+------+-----+-------------------+----------------+
| Field          | Type       | Null | Key | Default           | Extra          |
+----------------+------------+------+-----+-------------------+----------------+
| id             | bigint(20) | NO   | PRI | NULL              | auto_increment |
| post_class     | char(4)    | NO   |     | USER              |                |
| parent_post_id | bigint(20) | NO   |     | 0                 |                |
| author_id      | bigint(20) | NO   |     | NULL              |                |
| recipient_id   | bigint(20) | NO   |     | 0                 |                |
| post_date      | timestamp  | NO   |     | CURRENT_TIMESTAMP |                |
| edit_date      | datetime   | YES  |     | NULL              |                |
| post_read      | tinyint(4) | NO   |     | 0                 |                |
| body_copy      | text       | YES  |     | NULL              |                |
+----------------+------------+------+-----+-------------------+----------------+

webwarecl.profile_visits

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| source_id  | bigint(20) unsigned | NO   |     | NULL    |                |
| target_id  | bigint(20) unsigned | NO   |     | NULL    |                |
| visit_date | date                | NO   |     | NULL    |                |
| source_age | int(10) unsigned    | NO   |     | NULL    |                |
| target_age | int(10) unsigned    | NO   |     | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

webwarecl.realtime_notifications

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| id                | bigint(20)          | NO   | PRI | NULL    | auto_increment |
| created_date      | datetime            | NO   |     | NULL    |                |
| delivered         | tinyint(4)          | NO   |     | 0       |                |
| viewed            | tinyint(4)          | NO   |     | 0       |                |
| recipient_id      | bigint(20) unsigned | NO   | MUL | NULL    |                |
| notification_text | text                | YES  |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+

webwarecl.schedule_entries

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| id                | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id           | bigint(20) unsigned | NO   |     | 0       |                |
| start_block       | int(10) unsigned    | NO   |     | NULL    |                |
| event_description | text                | NO   |     | NULL    |                |
| end_block         | int(10) unsigned    | NO   |     | NULL    |                |
| scheduler_id      | bigint(20) unsigned | NO   |     | NULL    |                |
| scheduled_on      | datetime            | NO   |     | NULL    |                |
| address           | varchar(255)        | YES  |     | NULL    |                |
| city              | varchar(45)         | YES  |     | NULL    |                |
| state             | varchar(45)         | YES  |     | NULL    |                |
| zip               | varchar(45)         | YES  |     | NULL    |                |
| latitude          | varchar(45)         | YES  |     | NULL    |                |
| longitude         | varchar(45)         | YES  |     | NULL    |                |
| date              | date                | YES  |     | NULL    |                |
| event_title       | varchar(255)        | NO   |     | NULL    |                |
| event_guid        | varchar(255)        | YES  |     | NULL    |                |
| confirmed         | tinyint(3) unsigned | NO   |     | 1       |                |
+-------------------+---------------------+------+-----+---------+----------------+

webwarecl.scheduled_business_notifications

+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| id              | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| site_id         | bigint(20)   | NO   |     | NULL    |                |
| event_key       | varchar(255) | NO   |     | NULL    |                |
| date_time       | datetime     | NO   |     | NULL    |                |
| scheduler_task  | varchar(255) | NO   |     | NULL    |                |
| om_uuid         | varchar(255) | NO   |     | NULL    |                |
| concerning_user | bigint(20)   | YES  |     | NULL    |                |
| body_text       | varchar(255) | NO   |     | NULL    |                |
+-----------------+--------------+------+-----+---------+----------------+

webwarecl.scheduled_notifications

+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| user_id        | bigint(20)   | NO   |     | NULL    |                |
| event_key      | varchar(255) | NO   |     | NULL    |                |
| body_text      | varchar(255) | NO   |     | NULL    |                |
| date_time      | datetime     | NO   |     | NULL    |                |
| scheduler_task | varchar(255) | NO   |     | NULL    |                |
| sender_id      | bigint(20)   | NO   |     | NULL    |                |
| om_uuid        | varchar(255) | NO   |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+

webwarecl.session_events

+------------+--------------+------+-----+-------------------+----------------+
| Field      | Type         | Null | Key | Default           | Extra          |
+------------+--------------+------+-----+-------------------+----------------+
| id         | bigint(20)   | NO   | PRI | NULL              | auto_increment |
| session_id | varchar(255) | NO   | MUL | NULL              |                |
| ts         | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
| delivered  | tinyint(4)   | NO   |     | 0                 |                |
| js_payload | text         | YES  |     | NULL              |                |
+------------+--------------+------+-----+-------------------+----------------+

webwarecl.sessions

+---------------+--------------+------+-----+-------------------+-----------------------------+
| Field         | Type         | Null | Key | Default           | Extra                       |
+---------------+--------------+------+-----+-------------------+-----------------------------+
| id            | varchar(255) | NO   | PRI | NULL              |                             |
| accessed      | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| user_id       | bigint(20)   | NO   |     | NULL              |                             |
| site_id       | bigint(20)   | NO   |     | NULL              |                             |
| rmt_ip        | varchar(45)  | YES  |     | NULL              |                             |
| rmt_useragent | varchar(255) | YES  |     | NULL              |                             |
+---------------+--------------+------+-----+-------------------+-----------------------------+

webwarecl.site_errors

+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| userid        | varchar(45)      | YES  |     | NULL    |                |
| date          | datetime         | YES  |     | NULL    |                |
| diagnostics   | text             | YES  |     | NULL    |                |
| browser       | text             | YES  |     | NULL    |                |
| remoteAddress | text             | YES  |     | NULL    |                |
| HTTPReferer   | text             | YES  |     | NULL    |                |
| template      | text             | YES  |     | NULL    |                |
| queryString   | text             | YES  |     | NULL    |                |
| message       | text             | YES  |     | NULL    |                |
| type          | text             | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+

webwarecl.stats

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| id                | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| snap_date         | datetime            | NO   |     | NULL    |                |
| users_confirmed   | bigint(20) unsigned | NO   |     | NULL    |                |
| users_unconfirmed | bigint(20) unsigned | NO   |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+

webwarecl.subdivisions

+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key | Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| name      | varchar(255)        | NO   |     | NULL    |                |
| site_id   | bigint(20) unsigned | NO   |     | 1       |                |
| approved  | tinyint(3) unsigned | NO   |     | 0       |                |
| conf_id   | varchar(45)         | YES  |     | NULL    |                |
| latitude  | double              | YES  |     | NULL    |                |
| longitude | double              | YES  |     | NULL    |                |
+-----------+---------------------+------+-----+---------+----------------+

webwarecl.task_codes

+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| task_id     | int(10) unsigned    | NO   |     | 0       |                |
| item        | varchar(255)        | NO   |     |         |                |
| rate        | float               | NO   |     | 0       |                |
| charge_type | varchar(45)         | NO   |     |         |                |
| site_id     | bigint(20) unsigned | NO   | MUL | NULL    |                |
| billable    | tinyint(4)          | NO   |     | 1       |                |
+-------------+---------------------+------+-----+---------+----------------+

webwarecl.task_status_changes

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| site_id         | bigint(20) unsigned | NO   | MUL | NULL    |                |
| task_id         | bigint(20)          | NO   | MUL | NULL    |                |
| event_timestamp | date                | NO   |     | NULL    |                |
| previous_status | tinyint(4)          | NO   |     | NULL    |                |
| new_status      | tinyint(4)          | NO   |     | NULL    |                |
| assoc_id        | bigint(20)          | NO   |     | 0       |                |
+-----------------+---------------------+------+-----+---------+----------------+

webwarecl.time_card

+----------------+---------------------+------+-----+------------+----------------+
| Field          | Type                | Null | Key | Default    | Extra          |
+----------------+---------------------+------+-----+------------+----------------+
| id             | int(10) unsigned    | NO   | PRI | NULL       | auto_increment |
| emp_id         | int(10) unsigned    | NO   |     | 0          |                |
| date           | date                | NO   |     | 0000-00-00 |                |
| clsJobNumber   | varchar(45)         | NO   |     |            |                |
| JobDescription | text                | YES  |     | NULL       |                |
| signed         | datetime            | YES  |     | NULL       |                |
| startTime      | datetime            | YES  |     | NULL       |                |
| submitID       | varchar(45)         | YES  |     | NULL       |                |
| closed         | int(10) unsigned    | YES  |     | 0          |                |
| initials       | varchar(45)         | YES  |     | NULL       |                |
| site_id        | bigint(20) unsigned | NO   |     | 1          |                |
| billed         | tinyint(3) unsigned | NO   |     | 0          |                |
| paid           | tinyint(3) unsigned | NO   |     | 0          |                |
| billed_date    | datetime            | YES  |     | NULL       |                |
| paid_date      | datetime            | YES  |     | NULL       |                |
| check_number   | varchar(255)        | YES  |     | NULL       |                |
+----------------+---------------------+------+-----+------------+----------------+

webwarecl.time_lookup

+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| block_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| time_12hour | varchar(45)      | NO   |     | NULL    |                |
| time_24hour | varchar(45)      | YES  |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+

webwarecl.toolbars

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| toolbar_name | varchar(255)        | NO   |     | NULL    |                |
| landing_page | varchar(255)        | NO   |     | NULL    |                |
| icon         | varchar(255)        | NO   |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+

webwarecl.user_content

+----------------+---------------------+------+-----+---------------------+----------------+
| Field          | Type                | Null | Key | Default             | Extra          |
+----------------+---------------------+------+-----+---------------------+----------------+
| id             | int(10) unsigned    | NO   | PRI | NULL                | auto_increment |
| filePath       | text                | NO   |     | NULL                |                |
| uploaderID     | bigint(20) unsigned | NO   |     | 0                   |                |
| uploadDateTime | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| fileType       | bigint(20) unsigned | NO   |     | 0                   |                |
| subdivisionID  | bigint(20) unsigned | YES  |     | NULL                |                |
+----------------+---------------------+------+-----+---------------------+----------------+

webwarecl.user_events

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id    | bigint(20) unsigned | NO   |     | NULL    |                |
| event_date | datetime            | NO   |     | NULL    |                |
| event_icon | varchar(255)        | NO   |     | NULL    |                |
| event_text | text                | YES  |     | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

webwarecl.users

+--------------------------+---------------------+------+-----+---------+----------------+
| Field                    | Type                | Null | Key | Default | Extra          |
+--------------------------+---------------------+------+-----+---------+----------------+
| id                       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| username                 | varchar(45)         | NO   | UNI |         |                |
| password                 | varchar(255)        | NO   |     |         |                |
| tfa_enabled              | tinyint(4)          | NO   |     | 0       |                |
| tfa_secret               | varchar(255)        | YES  |     | NULL    |                |
| longName                 | varchar(255)        | NO   |     | NULL    |                |
| email                    | varchar(255)        | NO   | UNI | NULL    |                |
| smsNumber                | varchar(45)         | YES  |     | NULL    |                |
| picture                  | text                | YES  |     | NULL    |                |
| account_enabled          | int(10) unsigned    | NO   |     | 0       |                |
| gender                   | char(1)             | YES  |     | NULL    |                |
| bio                      | text                | YES  |     | NULL    |                |
| title                    | varchar(60)         | YES  |     | NULL    |                |
| confirm_id               | varchar(255)        | NO   |     |         |                |
| phone                    | varchar(45)         | YES  |     | NULL    |                |
| fax                      | varchar(45)         | YES  |     | NULL    |                |
| confirmed                | int(10) unsigned    | NO   |     | 0       |                |
| online                   | int(10) unsigned    | NO   |     | 0       |                |
| sms_conf                 | varchar(45)         | YES  |     | NULL    |                |
| sms_confirmed            | int(10) unsigned    | NO   |     | 0       |                |
| last_pwchange            | datetime            | YES  |     | NULL    |                |
| last_loaded_page         | text                | YES  |     | NULL    |                |
| last_loaded_page_onload  | varchar(255)        | YES  |     | NULL    |                |
| last_loaded_page_onerror | varchar(255)        | YES  |     | NULL    |                |
| remember_page            | int(10) unsigned    | YES  |     | 0       |                |
| firstName                | varchar(255)        | YES  |     | NULL    |                |
| lastName                 | varchar(255)        | YES  |     | NULL    |                |
| webware_admin            | tinyint(4)          | NO   |     | 0       |                |
| middleInitial            | varchar(1)          | YES  |     | NULL    |                |
| allowSearch              | tinyint(3) unsigned | NO   |     | 1       |                |
| birthday                 | date                | YES  |     | NULL    |                |
| profile_views            | bigint(20) unsigned | NO   |     | 0       |                |
| last_login               | datetime            | YES  |     | NULL    |                |
| show_tour                | tinyint(4)          | NO   |     | 1       |                |
| last_site_id             | bigint(20) unsigned | YES  |     | 0       |                |
| last_event               | datetime            | YES  |     | NULL    |                |
| background               | text                | YES  |     | NULL    |                |
| interests                | text                | YES  |     | NULL    |                |
| music                    | text                | YES  |     | NULL    |                |
| last_song                | varchar(255)        | YES  |     | NULL    |                |
| relationship_status      | varchar(255)        | YES  |     | NULL    |                |
| so_id                    | bigint(20) unsigned | YES  |     | 0       |                |
| zip_code                 | varchar(45)         | NO   |     | 88001   |                |
| last_assoc_id            | bigint(20) unsigned | NO   |     | 0       |                |
| password_question        | varchar(255)        | YES  |     | NULL    |                |
| password_answer          | varchar(255)        | YES  |     | NULL    |                |
| status                   | varchar(255)        | YES  |     | NULL    |                |
| maps_username            | varchar(255)        | YES  |     | NULL    |                |
| maps_password            | varchar(255)        | YES  |     | NULL    |                |
| account_cabinets_applied | tinyint(4)          | NO   |     | 0       |                |
| profile_pictures_cabinet | bigint(20)          | NO   |     | 0       |                |
+--------------------------+---------------------+------+-----+---------+----------------+

webwarecl.webgrams

+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key | Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id   | bigint(20) unsigned | NO   |     | NULL    |                |
| w_body    | text                | NO   |     | NULL    |                |
| post_date | datetime            | NO   |     | NULL    |                |
| dev_blog  | tinyint(3) unsigned | NO   |     | 0       |                |
+-----------+---------------------+------+-----+---------+----------------+

sites

sites.association_roles

+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| role_name   | varchar(45)         | NO   |     | NULL    |                |
| role_weight | int(11)             | NO   |     | 0       |                |
| site_id     | bigint(20) unsigned | NO   | MUL | NULL    |                |
| create_id   | varchar(255)        | NO   |     |         |                |
+-------------+---------------------+------+-----+---------+----------------+

sites.association_roles_allowed

+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| assoc_id | bigint(20) unsigned | NO   | MUL | NULL    |                |
| role_id  | bigint(20) unsigned | NO   | MUL | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+

sites.association_types

+-----------------------+------------------+------+-----+---------+----------------+
| Field                 | Type             | Null | Key | Default | Extra          |
+-----------------------+------------------+------+-----+---------+----------------+
| id                    | int(11)          | NO   | PRI | NULL    | auto_increment |
| association_type      | int(11)          | NO   |     | NULL    |                |
| association_type_name | varchar(255)     | NO   |     | NULL    |                |
| permission_order      | int(10) unsigned | NO   |     | 0       |                |
+-----------------------+------------------+------+-----+---------+----------------+

sites.billing_events

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| event_date | datetime            | NO   |     | NULL    |                |
| site_id    | bigint(20) unsigned | NO   |     | NULL    |                |
| event_type | varchar(45)         | NO   |     | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

sites.billing_plans

+--------------------+---------------------+------+-----+---------+----------------+
| Field              | Type                | Null | Key | Default | Extra          |
+--------------------+---------------------+------+-----+---------+----------------+
| id                 | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| plan_name          | varchar(45)         | NO   |     | NULL    |                |
| base_rate          | float               | NO   |     | NULL    |                |
| max_employees      | bigint(20) unsigned | NO   |     | NULL    |                |
| orders_included    | bigint(20) unsigned | NO   |     | NULL    |                |
| price_per_order    | float               | NO   |     | NULL    |                |
| price_per_employee | float               | NO   |     | NULL    |                |
| gis_included       | tinyint(3) unsigned | NO   |     | NULL    |                |
| gis_price          | float               | NO   |     | NULL    |                |
+--------------------+---------------------+------+-----+---------+----------------+

sites.clients

+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| assoc_id     | bigint(20)  | NO   | PRI | NULL    |       |
| company_name | varchar(45) | NO   |     | NULL    |       |
| notes        | text        | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+

sites.department_entries

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| department_id | bigint(20) unsigned | NO   |     | NULL    |                |
| user_id       | bigint(20) unsigned | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

sites.department_events

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| id         | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| event_name | varchar(255)        | NO   |     | NULL    |                |
| event_key  | varchar(45)         | NO   |     | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

sites.departments

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| site_id         | bigint(20) unsigned | NO   |     | NULL    |                |
| manager_id      | bigint(20) unsigned | YES  |     | NULL    |                |
| department_name | varchar(150)        | NO   |     | NULL    |                |
+-----------------+---------------------+------+-----+---------+----------------+

sites.employees

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| assoc_id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| application_date  | datetime            | YES  |     | NULL    |                |
| hire_date         | datetime            | YES  |     | NULL    |                |
| termination_date  | datetime            | YES  |     | NULL    |                |
| title             | varchar(45)         | YES  |     | NULL    |                |
| application       | text                | YES  |     | NULL    |                |
| resume            | text                | YES  |     | NULL    |                |
| notes             | text                | YES  |     | NULL    |                |
| employment_status | varchar(45)         | NO   |     | Active  |                |
| wage_basis        | varchar(20)         | YES  |     | NULL    |                |
| wage              | double              | NO   |     | 0       |                |
| payroll_frequency | varchar(20)         | YES  |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+

sites.equipment_categories

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20)          | NO   | PRI | NULL    | auto_increment |
| industry_id   | bigint(20) unsigned | NO   | MUL | NULL    |                |
| category_name | varchar(45)         | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

sites.equipment_hours

+---------------+------------+------+-----+---------+----------------+
| Field         | Type       | Null | Key | Default | Extra          |
+---------------+------------+------+-----+---------+----------------+
| id            | bigint(20) | NO   | PRI | NULL    | auto_increment |
| equipment_id  | bigint(20) | NO   | MUL | NULL    |                |
| time_entry_id | bigint(20) | NO   | MUL | NULL    |                |
+---------------+------------+------+-----+---------+----------------+

sites.equipment_inventory

+-----------------------+---------------------+------+-----+---------+----------------+
| Field                 | Type                | Null | Key | Default | Extra          |
+-----------------------+---------------------+------+-----+---------+----------------+
| id                    | bigint(20)          | NO   | PRI | NULL    | auto_increment |
| site_id               | bigint(20) unsigned | NO   | MUL | NULL    |                |
| category_id           | bigint(20)          | NO   | MUL | NULL    |                |
| subcategory_id        | bigint(20)          | NO   | MUL | NULL    |                |
| status                | tinyint(4)          | NO   |     | NULL    |                |
| year                  | varchar(4)          | YES  |     | NULL    |                |
| make                  | varchar(45)         | NO   |     | NULL    |                |
| model                 | varchar(45)         | NO   |     | NULL    |                |
| serial_number         | varchar(255)        | YES  |     | NULL    |                |
| purchase_date         | datetime            | NO   |     | NULL    |                |
| purchase_price        | decimal(13,4)       | YES  |     | NULL    |                |
| equipment_description | text                | YES  |     | NULL    |                |
+-----------------------+---------------------+------+-----+---------+----------------+

sites.equipment_loans

+---------------------+---------------------+------+-----+---------+----------------+
| Field               | Type                | Null | Key | Default | Extra          |
+---------------------+---------------------+------+-----+---------+----------------+
| id                  | bigint(20)          | NO   | PRI | NULL    | auto_increment |
| equipment_id        | bigint(20)          | NO   | MUL | NULL    |                |
| loaned_to_site_id   | bigint(20) unsigned | NO   | MUL | NULL    |                |
| poc_user_id         | bigint(20) unsigned | NO   | MUL | NULL    |                |
| loan_begin          | datetime            | NO   |     | NULL    |                |
| loan_end            | datetime            | NO   |     | NULL    |                |
| loan_rate           | decimal(13,4)       | NO   |     | 0.0000  |                |
| hours_when_loaned   | double              | NO   |     | NULL    |                |
| hours_when_returned | double              | NO   |     | NULL    |                |
| loan_paid           | tinyint(4)          | NO   |     | 0       |                |
+---------------------+---------------------+------+-----+---------+----------------+

sites.equipment_subcategories

+------------------+-------------+------+-----+---------+----------------+
| Field            | Type        | Null | Key | Default | Extra          |
+------------------+-------------+------+-----+---------+----------------+
| id               | bigint(20)  | NO   | PRI | NULL    | auto_increment |
| category_id      | bigint(20)  | NO   | MUL | NULL    |                |
| subcategory_name | varchar(45) | NO   |     | NULL    |                |
+------------------+-------------+------+-----+---------+----------------+

sites.event_entries

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| department_id | bigint(20) unsigned | NO   |     | NULL    |                |
| event_id      | bigint(20) unsigned | NO   |     | NULL    |                |
| site_id       | bigint(20) unsigned | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

sites.in_out_board

+----------+-------------+------+-----+-------------------+----------------+
| Field    | Type        | Null | Key | Default           | Extra          |
+----------+-------------+------+-----+-------------------+----------------+
| id       | bigint(20)  | NO   | PRI | NULL              | auto_increment |
| assoc_id | bigint(20)  | NO   |     | NULL              |                |
| ts       | timestamp   | NO   |     | CURRENT_TIMESTAMP |                |
| status   | varchar(50) | NO   |     | NULL              |                |
| mood     | varchar(50) | NO   |     | NULL              |                |
| comment  | text        | YES  |     | NULL              |                |
+----------+-------------+------+-----+-------------------+----------------+

sites.industries

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| industry_name | varchar(255)        | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

sites.permission_entries

+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| assoc_id | bigint(20) unsigned | NO   | MUL | NULL    |                |
| perm_id  | bigint(20) unsigned | NO   | MUL | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+

sites.permissions

+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| name     | varchar(255)        | NO   |     | NULL    |                |
| perm_key | varchar(45)         | NO   |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+

sites.res_amendments

+-----------------+---------------------+------+-----+-------------------+----------------+
| Field           | Type                | Null | Key | Default           | Extra          |
+-----------------+---------------------+------+-----+-------------------+----------------+
| id              | bigint(20) unsigned | NO   | PRI | NULL              | auto_increment |
| res_id          | bigint(20) unsigned | NO   | MUL | NULL              |                |
| author_assoc_id | bigint(20) unsigned | NO   | MUL | NULL              |                |
| am_create_date  | timestamp           | NO   |     | CURRENT_TIMESTAMP |                |
| am_accepted     | tinyint(4)          | NO   |     | 0                 |                |
| am_title        | varchar(255)        | NO   |     | NULL              |                |
| am_text         | text                | NO   |     | NULL              |                |
| create_id       | varchar(255)        | NO   |     | NULL              |                |
+-----------------+---------------------+------+-----+-------------------+----------------+

sites.res_resolutions

+---------------------+---------------------+------+-----+-------------------+----------------+
| Field               | Type                | Null | Key | Default           | Extra          |
+---------------------+---------------------+------+-----+-------------------+----------------+
| id                  | bigint(20) unsigned | NO   | PRI | NULL              | auto_increment |
| site_id             | bigint(20) unsigned | NO   | MUL | NULL              |                |
| sponsor_assoc_id    | bigint(20) unsigned | NO   | MUL | NULL              |                |
| res_carry_threshold | tinyint(4)          | NO   |     | 100               |                |
| res_quorum          | int(11)             | NO   |     | 0                 |                |
| res_eligibility     | tinyint(4)          | NO   |     | 0                 |                |
| res_tabled          | tinyint(4)          | NO   |     | 0                 |                |
| res_voting_open     | datetime            | NO   |     | NULL              |                |
| res_voting_close    | datetime            | NO   |     | NULL              |                |
| res_create_date     | timestamp           | NO   |     | CURRENT_TIMESTAMP |                |
| res_repeals         | bigint(20) unsigned | NO   |     | 0                 |                |
| res_title           | varchar(255)        | NO   |     | NULL              |                |
| res_text            | text                | NO   |     | NULL              |                |
| create_id           | varchar(255)        | NO   |     | NULL              |                |
+---------------------+---------------------+------+-----+-------------------+----------------+

sites.res_votes

+----------------+---------------------+------+-----+-------------------+----------------+
| Field          | Type                | Null | Key | Default           | Extra          |
+----------------+---------------------+------+-----+-------------------+----------------+
| id             | bigint(20) unsigned | NO   | PRI | NULL              | auto_increment |
| res_id         | bigint(20) unsigned | NO   | MUL | NULL              |                |
| vote_date      | timestamp           | NO   |     | CURRENT_TIMESTAMP |                |
| voter_assoc_id | bigint(20) unsigned | NO   | MUL | NULL              |                |
| vote_type      | tinyint(4)          | NO   |     | NULL              |                |
| create_id      | varchar(255)        | NO   |     | NULL              |                |
+----------------+---------------------+------+-----+-------------------+----------------+

sites.role_events

+-------------------+-------------+------+-----+---------+----------------+
| Field             | Type        | Null | Key | Default | Extra          |
+-------------------+-------------+------+-----+---------+----------------+
| id                | bigint(20)  | NO   | PRI | NULL    | auto_increment |
| assoc_id          | bigint(20)  | NO   |     | NULL    |                |
| event_author      | bigint(20)  | NO   |     | NULL    |                |
| event_date        | datetime    | NO   |     | NULL    |                |
| event_type        | varchar(45) | NO   |     | NULL    |                |
| event_description | text        | YES  |     | NULL    |                |
+-------------------+-------------+------+-----+---------+----------------+

sites.site_associations

+------------------+----------------------+------+-----+---------+----------------+
| Field            | Type                 | Null | Key | Default | Extra          |
+------------------+----------------------+------+-----+---------+----------------+
| id               | bigint(20) unsigned  | NO   | PRI | NULL    | auto_increment |
| user_id          | bigint(20) unsigned  | NO   | MUL | NULL    |                |
| site_id          | bigint(20) unsigned  | NO   | MUL | NULL    |                |
| assoc_type       | smallint(5) unsigned | NO   |     | NULL    |                |
| conf_id          | varchar(255)         | YES  |     | NULL    |                |
| association_role | bigint(20) unsigned  | NO   |     | 0       |                |
+------------------+----------------------+------+-----+---------+----------------+

sites.site_ratings

+--------------+----------------------+------+-----+---------+----------------+
| Field        | Type                 | Null | Key | Default | Extra          |
+--------------+----------------------+------+-----+---------+----------------+
| id           | bigint(20) unsigned  | NO   | PRI | NULL    | auto_increment |
| user_id      | bigint(20) unsigned  | NO   |     | NULL    |                |
| site_id      | bigint(20) unsigned  | NO   |     | NULL    |                |
| rating_date  | datetime             | NO   |     | NULL    |                |
| rating_value | smallint(5) unsigned | NO   |     | NULL    |                |
+--------------+----------------------+------+-----+---------+----------------+

sites.sites

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| SiteID            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| SiteName          | text                | NO   |     | NULL    |                |
| logo_file_id      | bigint(20) unsigned | YES  | MUL | NULL    |                |
| admin_id          | bigint(20) unsigned | NO   |     | NULL    |                |
| enabled           | tinyint(3) unsigned | NO   |     | NULL    |                |
| summary           | text                | YES  |     | NULL    |                |
| about             | text                | YES  |     | NULL    |                |
| mission_statement | text                | YES  |     | NULL    |                |
| vision_statement  | text                | YES  |     | NULL    |                |
| slogan            | text                | YES  |     | NULL    |                |
| billing_plan      | bigint(20) unsigned | YES  |     | NULL    |                |
| conf_id           | varchar(45)         | YES  |     | NULL    |                |
| salestax_rate     | float               | NO   |     | 0       |                |
| address           | varchar(255)        | YES  |     | NULL    |                |
| city              | varchar(255)        | YES  |     | NULL    |                |
| state             | varchar(255)        | YES  |     | NULL    |                |
| zip               | varchar(255)        | YES  |     | NULL    |                |
| phone             | varchar(45)         | YES  |     | NULL    |                |
| fax               | varchar(45)         | YES  |     | NULL    |                |
| website           | varchar(45)         | YES  |     | NULL    |                |
| contact_email     | varchar(255)        | YES  |     | NULL    |                |
| sales_email       | varchar(255)        | YES  |     | NULL    |                |
| billing_email     | varchar(255)        | YES  |     | NULL    |                |
| facebook_handle   | varchar(255)        | YES  |     | NULL    |                |
| twitter_handle    | varchar(255)        | YES  |     | NULL    |                |
| instagram_handle  | varchar(255)        | YES  |     | NULL    |                |
| linkedin_handle   | varchar(255)        | YES  |     | NULL    |                |
| youtube_handle    | varchar(255)        | YES  |     | NULL    |                |
| industry_id       | bigint(20)          | NO   |     | 0       |                |
+-------------------+---------------------+------+-----+---------+----------------+

webware_cms

webware_cms.file_associations

+-------------+----------------------+------+-----+---------+----------------+
| Field       | Type                 | Null | Key | Default | Extra          |
+-------------+----------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned  | NO   | PRI | NULL    | auto_increment |
| project_id  | bigint(20) unsigned  | NO   |     | NULL    |                |
| assoc_type  | bigint(20) unsigned  | NO   |     | NULL    |                |
| description | text                 | NO   |     | NULL    |                |
| file_id     | bigint(20) unsigned  | NO   |     | NULL    |                |
| releasable  | smallint(5) unsigned | NO   |     | NULL    |                |
+-------------+----------------------+------+-----+---------+----------------+

webware_cms.file_types

+----------+---------------------+------+-----+---------+----------------+
| Field    | Type                | Null | Key | Default | Extra          |
+----------+---------------------+------+-----+---------+----------------+
| id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| site_id  | bigint(20) unsigned | NO   |     | NULL    |                |
| typename | varchar(45)         | NO   |     | NULL    |                |
+----------+---------------------+------+-----+---------+----------------+

webware_cms.fm_catalogs

+---------------+--------------+------+-----+-------------------+----------------+
| Field         | Type         | Null | Key | Default           | Extra          |
+---------------+--------------+------+-----+-------------------+----------------+
| id            | bigint(20)   | NO   | PRI | NULL              | auto_increment |
| app_name      | varchar(20)  | NO   |     | NULL              |                |
| app_object_id | bigint(20)   | NO   |     | NULL              |                |
| user_id       | bigint(20)   | NO   |     | NULL              |                |
| site_id       | bigint(20)   | NO   |     | NULL              |                |
| permissions   | tinyint(4)   | NO   |     | 0                 |                |
| created       | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
| catalog_name  | varchar(255) | NO   |     | NULL              |                |
| create_id     | varchar(255) | NO   |     | NULL              |                |
| w_permissions | tinyint(4)   | NO   |     | 0                 |                |
+---------------+--------------+------+-----+-------------------+----------------+

webware_cms.fm_directories

+----------------+--------------+------+-----+-------------------+----------------+
| Field          | Type         | Null | Key | Default           | Extra          |
+----------------+--------------+------+-----+-------------------+----------------+
| id             | bigint(20)   | NO   | PRI | NULL              | auto_increment |
| catalog_id     | bigint(20)   | NO   |     | NULL              |                |
| user_id        | bigint(20)   | NO   |     | NULL              |                |
| site_id        | bigint(20)   | NO   |     | NULL              |                |
| permissions    | tinyint(4)   | NO   |     | 0                 |                |
| parent_id      | bigint(20)   | NO   |     | 0                 |                |
| created        | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
| directory_name | varchar(255) | NO   |     | NULL              |                |
| default_view   | varchar(20)  | NO   |     | list              |                |
| create_id      | varchar(255) | NO   |     | NULL              |                |
| w_permissions  | tinyint(4)   | NO   |     | 0                 |                |
+----------------+--------------+------+-----+-------------------+----------------+

webware_cms.fm_directory_tags

+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| directory_id | bigint(20)   | NO   | MUL | NULL    |                |
| tag_text     | varchar(255) | NO   |     | NULL    |                |
| create_id    | varchar(255) | NO   |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+

webware_cms.fm_favorites

+-----------+------------+------+-----+---------+----------------+
| Field     | Type       | Null | Key | Default | Extra          |
+-----------+------------+------+-----+---------+----------------+
| id        | bigint(20) | NO   | PRI | NULL    | auto_increment |
| item_type | tinyint(4) | NO   |     | NULL    |                |
| item_id   | bigint(20) | NO   |     | NULL    |                |
| user_id   | bigint(20) | NO   |     | NULL    |                |
+-----------+------------+------+-----+---------+----------------+

webware_cms.fm_file_tags

+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| file_id   | bigint(20)   | NO   | MUL | NULL    |                |
| tag_text  | varchar(255) | NO   |     | NULL    |                |
| create_id | varchar(255) | NO   |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+

webware_cms.fm_files

+---------------+--------------+------+-----+-------------------+----------------+
| Field         | Type         | Null | Key | Default           | Extra          |
+---------------+--------------+------+-----+-------------------+----------------+
| id            | bigint(20)   | NO   | PRI | NULL              | auto_increment |
| directory_id  | bigint(20)   | NO   | MUL | NULL              |                |
| user_id       | bigint(20)   | NO   |     | NULL              |                |
| site_id       | bigint(20)   | NO   |     | NULL              |                |
| permissions   | tinyint(4)   | NO   |     | 0                 |                |
| created       | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
| mime_type     | varchar(255) | NO   |     | NULL              |                |
| file_name     | varchar(255) | NO   |     | NULL              |                |
| create_id     | varchar(255) | NO   |     | NULL              |                |
| w_permissions | tinyint(4)   | NO   |     | 0                 |                |
+---------------+--------------+------+-----+-------------------+----------------+

webware_cms.map_associations

+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| id             | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| file_id        | bigint(20) unsigned | NO   |     | NULL    |                |
| subdivision_id | bigint(20) unsigned | NO   |     | NULL    |                |
+----------------+---------------------+------+-----+---------+----------------+

webware_cms.playlist_entries

+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| playlist_id | bigint(20) unsigned | NO   |     | NULL    |                |
| file_id     | bigint(20) unsigned | NO   |     | NULL    |                |
+-------------+---------------------+------+-----+---------+----------------+

webware_cms.playlists

+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| id            | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id       | bigint(20) unsigned | NO   |     | NULL    |                |
| playlist_name | varchar(255)        | NO   |     | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+

webware_cms.site_files

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| site_id         | bigint(20) unsigned | NO   |     | NULL    |                |
| filename        | varchar(255)        | NO   |     | NULL    |                |
| basedir         | varchar(255)        | NO   |     | NULL    |                |
| subdir          | varchar(255)        | NO   |     | NULL    |                |
| user_id         | bigint(20) unsigned | NO   |     | NULL    |                |
| description     | text                | NO   |     | NULL    |                |
| creation_date   | datetime            | NO   |     | NULL    |                |
| SWFUploadFileID | varchar(255)        | YES  |     | NULL    |                |
| om_uuid         | varchar(255)        | YES  |     | NULL    |                |
+-----------------+---------------------+------+-----+---------+----------------+

webware_cms.user_files

+-----------------+---------------------+------+-----+---------+----------------+
| Field           | Type                | Null | Key | Default | Extra          |
+-----------------+---------------------+------+-----+---------+----------------+
| id              | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| basedir         | varchar(255)        | NO   |     | NULL    |                |
| filename        | varchar(255)        | NO   |     | NULL    |                |
| creation_date   | datetime            | NO   |     | NULL    |                |
| user_id         | bigint(20) unsigned | NO   | MUL | NULL    |                |
| description     | text                | NO   |     | NULL    |                |
| access_level    | int(10) unsigned    | NO   |     | 1       |                |
| CreateID        | varchar(45)         | YES  |     | NULL    |                |
| SWFUploadFileID | varchar(255)        | YES  |     | NULL    |                |
| last_access     | datetime            | NO   |     | NULL    |                |
| favorite        | tinyint(4)          | NO   |     | 0       |                |
+-----------------+---------------------+------+-----+---------+----------------+

Site Permissions

+-----+-------------------------+-------------------+
| id  | name                    | perm_key          |
+-----+-------------------------+-------------------+
|  12 | Create Member           | AS_CREATE         |
|  13 | Edit Member             | AS_EDIT           |
|  14 | Delete Member           | AS_DELETE         |
|  15 | Site Maintainer         | WW_SITEMAINTAINER |
|  16 | Login                   | AS_LOGIN          |
|  20 | View Memberships        | AS_VIEW           |
|  21 | Upload File             | CM_UPLOAD         |
|  22 | Download File           | CM_DOWNLOAD       |
|  23 | Delete File             | CM_DELETE         |
|  32 | Browse Files            | CM_BROWSE         |
|  34 | View Mail Message       | MA_VIEW           |
|  35 | Write Mail Message      | MA_WRITE          |
|  36 | Create News Article     | RSS_CREATE        |
|  40 | Search Projects         | WF_SEARCH         |
|  53 | View Project Statistics | WF_VIEWSTATS      |
|  54 | View Project            | PRJ_VIEW          |
|  55 | Edit Project            | PRJ_EDIT          |
|  56 | Delete Project          | PRJ_DELETE        |
|  57 | Log Time                | TIME_LOG          |
|  58 | Edit Time Log (Self)    | TIME_EDIT         |
|  59 | Manage Travel Log       | TIME_APPROVE      |
|  60 | Delete Time Log         | TIME_DELETE       |
|  61 | Log Travel              | TRAVEL_LOG        |
|  62 | Edit Travel Log         | TRAVEL_EDIT       |
|  63 | Manage Travel Log       | TRAVEL_APPROVE    |
|  64 | Delete Travel Log       | TRAVEL_DELETE     |
|  65 | Create Task             | TASK_ADD          |
|  66 | Edit Task               | TASK_EDIT         |
|  67 | Delete Task             | TASK_DELETE       |
|  68 | Create Stakeholder      | SH_ADD            |
|  69 | Edit Stakeholder        | SH_EDIT           |
|  70 | Delete Stakeholder      | SH_DELETE         |
|  71 | Create Deliverable      | DEL_ADD           |
|  72 | Edit Deliverable        | DEL_EDIT          |
|  73 | Delete Deliverable      | DEL_DELETE        |
|  74 | Create Location         | LOC_ADD           |
|  75 | Edit Location           | LOC_EDIT          |
|  76 | Delete Location         | LOC_DELETE        |
|  77 | Create Document         | DOC_ADD           |
|  78 | Edit Document           | DOC_EDIT          |
|  79 | Delete Document         | DOC_DELETE        |
|  80 | Create Dispatch         | DISP_ADD          |
|  81 | Cancel Dispatch         | DISP_CANCEL       |
|  83 | View Project            | PRJ_VIEW          |
|  84 | Edit Project            | PRJ_EDIT          |
|  85 | Delete Project          | PRJ_DELETE        |
|  86 | Log Time                | TIME_LOG          |
|  87 | Edit Time Log (Self)    | TIME_EDIT         |
|  88 | Manage Travel Log       | TIME_APPROVE      |
|  89 | Delete Time Log         | TIME_DELETE       |
|  90 | Log Travel              | TRAVEL_LOG        |
|  91 | Edit Travel Log         | TRAVEL_EDIT       |
|  92 | Manage Travel Log       | TRAVEL_APPROVE    |
|  93 | Delete Travel Log       | TRAVEL_DELETE     |
|  94 | Create Task             | TASK_ADD          |
|  95 | Edit Task               | TASK_EDIT         |
|  96 | Delete Task             | TASK_DELETE       |
|  97 | Create Stakeholder      | SH_ADD            |
|  98 | Edit Stakeholder        | SH_EDIT           |
|  99 | Delete Stakeholder      | SH_DELETE         |
| 100 | Create Deliverable      | DEL_ADD           |
| 101 | Edit Deliverable        | DEL_EDIT          |
| 102 | Delete Deliverable      | DEL_DELETE        |
| 103 | Create Location         | LOC_ADD           |
| 104 | Edit Location           | LOC_EDIT          |
| 105 | Delete Location         | LOC_DELETE        |
| 106 | Create Document         | DOC_ADD           |
| 107 | Edit Document           | DOC_EDIT          |
| 108 | Delete Document         | DOC_DELETE        |
| 109 | Create Dispatch         | DISP_ADD          |
| 110 | Cancel Dispatch         | DISP_CANCEL       |
| 111 | View Resolutions        | RES_VIEW          |
| 112 | Create Resolutions      | RES_CREATE        |
| 113 | Propose Amendments      | RES_AMEND         |
| 114 | Vote on Resolutions     | RES_VOTE          |
+-----+-------------------------+-------------------+

Notification Types

+----+--------------------------------+------------------------------------+
| id | n_key                          | description                        |
+----+--------------------------------+------------------------------------+
|  1 | SN_COMMENT_POSTED              | New Comment Posted                 |
|  2 | SN_FRIEND_REQUEST              | New Friend Request                 |
|  3 | SN_FRIEND_DELETE               | Friend Deleted                     |
|  5 | SN_FRIEND_ACCEPT               | Friend Request Accepted            |
| 19 | WF_PROJECT_STATUS_CHANGED      | Project Status Changed             |
| 21 | WF_PROJECT_EDITED              | Project Edited                     |
| 38 | SN_FRIEND_REJECT               | Friend Request Rejected            |
| 39 | SN_POST_LIKED                  | Post Liked                         |
| 40 | SN_POST_DISLIKED               | Post Disliked                      |
| 41 | WF_TASK_CREATED                | Task Created                       |
| 42 | WF_TASK_ASSIGNED               | Task Assigned                      |
| 43 | WF_TASK_PRIORITY_CHANGED       | Task Priority Changed              |
| 44 | WF_TASK_STATUS_CHANGED         | Task Status Changed                |
| 45 | WF_TASK_DELETED                | Task Deleted                       |
| 46 | WF_TASK_EDITED                 | Task Edited                        |
| 47 | WF_STAKEHOLDER_EDITED          | Stakeholder Edited                 |
| 48 | WF_STAKEHOLDER_ADDED           | Stakeholder Added                  |
| 49 | WF_STAKEHOLDER_DELETED         | Stakeholder Deleted                |
| 50 | WF_STAKEHOLDER_DISPATCHED      | Dispatch Sent                      |
| 51 | WF_STAKEHOLDER_DISPATCH_CANCEL | Dispatch Canceled                  |
| 52 | WF_DELIVERABLE_CREATED         | Deliverable Added                  |
| 53 | WF_DELIVERABLE_FULFILLED       | Deliverable Fulfilled              |
| 54 | WF_DELIVERABLE_EDITED          | Deliverable Edited                 |
| 55 | WF_DELIVERABLE_DELETED         | Deliverable Deleted                |
| 56 | WF_FILEDOC_DELETED             | Filed Document Deleted             |
| 57 | WF_FILEDOC_CREATED             | Filed Document Added               |
| 58 | WF_FILEDOC_EDITED              | Filed Document Edited              |
| 59 | WF_PROJECT_CREATED             | Project Created                    |
| 60 | WF_PROJECT_DELETED             | Project Deleted                    |
| 61 | WF_LOCATION_DELETED            | Location Deleted                   |
| 62 | WF_LOCATION_CREATED            | Location Created                   |
| 63 | WF_LOCATION_EDITED             | Location Edited                    |
| 64 | WF_TIME_LOGGED                 | Time Logged                        |
| 65 | WF_TIME_DELETED                | Time Log Deleted                   |
| 67 | WF_TRAVEL_LOGGED               | Travel Logged                      |
| 68 | WF_TRAVEL_DELETED              | Travel Log Deleted                 |
| 70 | WF_TIME_CLOSED                 | Time Log Closed                    |
| 83 | RES_PROPOSED                   | Resolutions-Resolution Proposed    |
| 84 | RES_VOTING_OPENED              | Resolutions-Vote Opened            |
| 85 | RES_VOTING_CLOSED              | Resolutions-Vote Closed            |
| 86 | RES_AMENDMENT_PROPOSED         | Resolutions-Amendment Proposed     |
| 87 | RES_AMENDMENT_ADOPTED          | Resolutions-Amendment Adopted      |
| 88 | RES_VOTE_TALLIED_YEA           | Resolutions-New Yea Vote Tallied   |
| 89 | RES_VOTE_TALLIED_NAY           | Resolutions-New Nay Vote Tallied   |
| 90 | RES_VOTE_TALLIED_ABSTAIN       | Resolutions-New Abstention Tallied |
| 91 | RES_CARRIED                    | Resolutions-Resolution Carried     |
| 92 | RES_FAILED                     | Resolutions-Resolution Failed      |
| 93 | RES_TABLED                     | Resolutions-Resolution Tabled      |
| 94 | RES_TABLED                     | Resolutions-Resolution Withdrawn   |
| 95 | REV_REQUESTED                  | Task Review Requested              |
| 96 | REV_TASK_ACCEPTED              | Task Review Accepted               |
| 97 | REV_TASK_REJECTED              | Task Review Rejected               |
+----+--------------------------------+------------------------------------+