Geodigraph Hub/Database
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 | | +---------+---------------------+------+-----+---------+----------------+
+----------+---------------------+------+-----+---------+----------------+ | 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 | | +----------+---------------------+------+-----+---------+----------------+
+--------------+---------------------+------+-----+---------+----------------+ | 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 | +----+--------------------------------+------------------------------------+