Subject Area : 070 - User
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 070 - User The agent or customer application user and types. Details.. Details..
ER Diagram(s) of Subject Area "070 - User"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "070 - User"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 10
. agent Agent true true a user authorized to use the FootPrints agent functions, which enable the agent to provide services to the customer. These include the ability to edit, escalate, and close tickets. Details..
. anonymous_cust Anonymous Customer true true a generic guest user account for users that do not have a unique identity in the system. Typically, this user has read only access to browse the knowledge base. 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..
. app_user_prof_link Application User Profile Link false The link between the application user and the user profile. Details..
. cust Customer true true a user authorized to use the FootPrints customer functions. This includes the ability to enter requests, and interact with requests as they are worked by Agents. Details..
. cust_login_type Customer Login Type false A lookup table for the customer login type. It identifies the method of authenticating customer users. Details..
. lic_type License Type false A lookup table for the type of FootPrints license. Must be secure from tampering. Details..
. shared_cust Shared Customer true true A shared customer does not have a unique identity at login, but uses a customer account with permissions according to this shared customer identity. Details..
. unique_cust Unique Customer true true A unique customer has a unique identity in the system either before identification or once authentication is performed. Details..
. user_prof User Profile false A container for Permissions and Settings (the composite parts are the associated Role and the User Preferences). The permissions for a User to access a particular container according to the capabilities defined. In most cases this will be more defined in a subcategory.
 
Example: Shared User Profile
This profile will be shared between multiple users that access the system with the same User ID.
Details..
Attribute/Column(s) of Entity/Table "Agent"
# Physical Name Name Definition Physical Data Type
Total 2
. lic_type_id License Type Id A Foreign Key to the License Type table. bigint
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
Attribute/Column(s) of Entity/Table "Anonymous Customer"
# Physical Name Name Definition Physical Data Type
Total 1
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
Attribute/Column(s) of Entity/Table "Application User"
# 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
Attribute/Column(s) of Entity/Table "Application User Profile Link"
# Physical Name Name Definition Physical Data Type
Total 3
. user_prof_id User Profile Id A Foreign Key to the User Profile table. bigint
. app_user_prof_link_id Application User Profile Link Id The automatically generated primary key of the app_user_prof_link table. bigint
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
Attribute/Column(s) of Entity/Table "Customer"
# Physical Name Name Definition Physical Data Type
Total 2
. cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
Attribute/Column(s) of Entity/Table "Customer Login Type"
# Physical Name Name Definition Physical Data Type
Total 2
. cust_login_type_name Customer Login Type Name The name of the Customer Login Type. varchar(255)
. cust_login_type_id Customer Login Type Id The automatically generated primary key of the cust_login_type table. int
Attribute/Column(s) of Entity/Table "License Type"
# Physical Name Name Definition Physical Data Type
Total 1
. lic_type_id License Type Id The automatically generated primary key of the lic_type table. bigint
Attribute/Column(s) of Entity/Table "Shared Customer"
# Physical Name Name Definition Physical Data Type
Total 1
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
Attribute/Column(s) of Entity/Table "Unique Customer"
# Physical Name Name Definition Physical Data Type
Total 1
. app_user_id Application User Id A Foreign Key to the Application User table. bigint
Attribute/Column(s) of Entity/Table "User Profile"
# Physical Name Name Definition Physical Data Type
Total 15
. user_prof_id User Profile Id The automatically generated primary key of the user_prof table. bigint
. tmpl_user_prof_id Template User Profile Id A Foreign Key to the User Profile table. This will not be a navigable key in the object model. This indicates which Template User Profile was used to create a built-in template in case some features concerning new properties added to later release of the system will need to be added to existing templates. bigint
. role_grp_id Role Group Id A Foreign Key to the Role Group table. A system level user profile can have a role group, which will have the effect of assigning a collection of workspace, cmdb, and address book roles at the container role level. bigint
. defn_id Definition Id A Foreign Key to the Definition table. Optionally, the container that owns the profile. bigint
. app_role_id Application Role Id A Foreign Key to the Application Role table. The User Profile is the means for setting the default role at the system and workspace levels, and is also the role of a Unique User Profile tied to a application user. bigint
. agent_authcn_type_id Agent Authentication Type Id A Foreign Key to the Agent Authentication Type table. int
. user_prof_name User Profile Name The name of the User Profile. varchar(255)
. is_built_in Is Built In Indicates that this instance of User Profile is a built-in instance that cannot be changed by the end user. bit
. user_type_id User Type Id A Foreign Key to the User Type table. int
. cust_authcn_type_id Customer Authentication Type Id A Foreign Key to the Customer Authentication Type table. int
. is_sys Is System Indicates if this is a system level profile. bit
. defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
. delete_date Delete Date The value of a User Profile, stored as a date. datetime
. last_login Last Login date time of last login in UTC. datetime
. tmpl_level_name tmpl_level_name The value of a Built_in_level, stored as a string. varchar(255)