Subject Area : 350 - Chat |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 350 - Chat | Tables that support the Chat communication feature. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 16 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | alert_role_type | Alert Role Type | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user | Application User | false | A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_alert | Broadcast Alert | false | A broadcast alert message. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_msg | Broadcast Message | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_msg_type | Broadcast Message Type | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel | Chat Channel | false | A chat channel. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel_subscriber | Chat Channel Subscriber | false | A subscriber to a chat channel. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | chat_msg | Chat Message | false | A message broadcast on a chat channel. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | chat_status | Chat Status | false |
A lookup table for chat status. Values include: AVAILABLE AWAY INVISIBLE_TO_CUSTOMERS INVISIBLE BUSY OFFLINE |
Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | chat_user_status | Chat User Status | false | The current chat status of an agent or customer application user. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | defn | Definition | false | A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | defn_ver | Definition Version | false | A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | item | Item | true | true | The Item is the abstract class for Issue, Configuration Item, Address Book entry, and other information items that are the main information entities in FootPrints. The Item structure and behavior is defined by its Definition. The Item is namespaced, identified by, and logically stored in the single parent container. It can be referenced in the same manner both inside and outside the container. The Item is the storage model and the implementation for the Item Definition. There are many important specializations of the Item class, and there even more Template definitions of Container/Item that provide an end-user application experience to the End-User. The Item implementation must implement flexible schema in an easy to manage, well engineered, and high performing way. The item can store user-defined and user-named fields defined in its definition. The Item could implement the nice-to-have features such as an inheritance model for Item subtypes, and have the ability to represent collections of subordinate items. The Item data can be imported, exported, or synchronized with external data sources. The Item data can be linked and synchronized with other items in the same Instance. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | item_defn | Item Definition | true | true | The definition of an Item, which includes the Item Name and localizations and the collection of Item Fields. It also includes customizations and localizations of string resources for Item Names, and Item Field names. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | ticket_alert | Ticket Alert | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | wksp_cntnr | Workspace Container | true | true |
A workspace is the principle architectural structure in Numara FootPrints for storing and tracking information. A Workspace is a separate sub-database or work area within the system with its own fields, forms, options, workflow, settings and users. Most of the behaviour of the Workspace comes from the Container Abstract class, and only things that are specific to the Workspace are implemented here. For Example, Current FootPrints allows a single CMDB to be referenced from a Workspace, and a single Address book, yet these are listed as features for improvement. So convenience methods that get and set Container Group Relationship might be appropriate. |
Details.. |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | alert_role_type_id | Alert Role Type Id | The unique identifier for an instance of Alert Role Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. | integer | ||||||||||||||||||||||||||||||||||||||||||||||
. | alert_role_type_name | Alert Role Type Name | The unique string identifier for an instance of Alert Role Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 8 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | pwd | Password | This space intentionally left blank. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_name | User Name | The name of the Application User. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | cust_login_type_id | Customer Login Type Id | A Foreign Key to the Customer Login Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user_id | Application User Id | The automatically generated primary key of the app_user table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | lic_type_id | License Type Id | A Foreign Key to the License Type table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_login | User Login | The login name used to access the Application. This may not be filled in if external application security is used. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | email_addr | Email Address | An email address for the Application User. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | delete_date | Delete Date | The value of a Application User, stored as a date. | datetime |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_alert_id | Broadcast Alert Id | The automatically generated primary key of the broadcast_alert table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | recipient_id | Recipient Id | A Foreign Key to the Application User table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | ticket_alert_id | Ticket Alert Id | A Foreign Key to the Ticket Alert table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_msg_id | Broadcast Message Id | The automatically generated primary key of the broadcast_message table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_msg_type_id | Broadcast Message Type Id | The unique identifier for an instance of Broadcast Message Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. | integer | ||||||||||||||||||||||||||||||||||||||||||||||
. | msg_tmpl_defn_id | Message Template Definition Id | A Foreign Key to the Definition table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | msg_text | Message Text | The value of a Broadcast Message, stored as a long text object. | nvarchar(max) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_msg_type_id | Broadcast Message Type Id | The unique identifier for an instance of Broadcast Message Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. | integer | ||||||||||||||||||||||||||||||||||||||||||||||
. | broadcast_msg_type_name | Broadcast Message Type Name | The unique string identifier for an instance of Broadcast Message Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel_id | Chat Channel Id | The automatically generated primary key of the chat_channel table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel_ctgy | Chat Channel Category | Category of chat. | varchar(50) | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel_subctgy | Chat Channel Subcategory | Subcategory of chat | varchar(50) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel_subscriber_id | Chat Channel Subscriber Id | The automatically generated primary key of the chat_channel_subscriber table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel_id | Chat Channel Id | A Foreign Key to the Chat Channel table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_id | User Id | A Foreign Key to the Application User table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | last_time_queried | Last Time Queried | The value of a Chat Channel Subscriber, stored as a date. | datetime |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | chat_msg_id | Chat Message Id | The automatically generated primary key of the chat_msg table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | arrive_date | Arrive Date | The value of a Chat Message, stored as a date. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | msg | Message | The value of a Chat Message, stored as a long text object. | nvarchar(max) | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_channel_id | Chat Channel Id | A Foreign Key to the Chat Channel table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_id_from | User Id From | A Foreign Key to the Application User table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | chat_status_id | Chat Status Id | The automatically generated primary key of the chat_status table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_status_name | Chat Status Name | The name of the Chat Status. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_status_descr | Chat Status Description | A descriptive name of the Chat Status. This descriptive name may be localized. | varchar(512) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | chat_user_status_id | Chat User Status Id | The automatically generated primary key of the chat_user_status table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user_id | Application User Id | A Foreign Key to the Application User table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | chat_status_id | Chat Status Id | A Foreign Key to the Chat Status table. | int |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | The automatically generated primary key of the defn table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_name | Definition Name | The name of the Definition. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | dsble_date | Disabled Date | The date that this instance of Definition is logically deleted and disabled. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_guid | Definition GUID | A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. | varchar(50) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_id | Definition Subtype Id | A Foreign Key to the Definition Subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_export_guid | Template Export GUID | The value of a Definition, stored as a string. | VARCHAR(50) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_ver_id | Definition Version Id | The automatically generated primary key of the defn_ver table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_ver_name | Definition Version Name | The name of the Definition Version. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_ver_status_id | Definition Version Status Id | A Foreign Key to the Definition Version Status table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_ver_guid | Definition Version GUID | A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data. | varchar(50) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_key | Item Key | A search key for the Item, composed of letters and numbers. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | The automatically generated primary key of the item table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | cntnr_id | Container Id | A Foreign Key to the Container table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_defn_id | Item Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_table_name | Item Table Name | The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. | varchar(30) | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_defn_id | Item Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | ticket_alert_id | Ticket Alert Id | The automatically generated primary key of the ticket_alert table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | alert_role_type_id | Alert Role Type Id | The unique identifier for an instance of Alert Role Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. | integer | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_ver_id | Definition Version Id | A Foreign Key to the Definition Version table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_defn_id | Item Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | cntnr_id | Container Id | A Foreign Key to the Container table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | time_zone_region_name | Time Zone Region Name | The name of the Time Zone Region. This is 2. The 'primary key' of the java timezone is the string region identifier in English, example 'America/Phoenix'. There is no numeric identifier. As the JRE is updated, or specific classes are updated, the list could change to include new entries, and the detail data behind the regions could change. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | cntnr_type_id | Container Type Id | A Foreign Key to the Container Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | cntnr_id | Container Id | A Foreign Key to the Container table. | bigint |