fw user
Database Table
| Name |
fw_user |
| Prefix | usr |
| Group Item | User |
| Initial Build | 2006.02 |
Overview
User
Columns
| Name | Description | Datatype | Notes |
|---|---|---|---|
| usr_key | Unique Key | uniqueidentifier | |
| usr_code | Login Name | av_user | |
| usr_name | User Name | av_user | |
| usr_pwd | Password | nvarchar(80) | |
| usr_context_name | Context Name | av_user | |
| usr_friendly_name | Friendly Name | nvarchar(80) | |
| usr_email | av_email | ||
| usr_email_text_only | Send plain text e-mail | av_flag | |
| usr_cst_key | Customer | av_key | |
| usr_EmailBlastLimit | Email Blast Limit | av_integer | |
| usr_sales_staff_flag | Sales Staff? | av_flag | |
| usr_sales_manager_flag | Sales Manager? | av_flag | |
| usr_dep_key | Department | av_key | |
| usr_dep_manager_flag | Department Manager? | av_flag | |
| usr_admin_flag | Super User | av_flag | |
| usr_usr_key_manager | Manager | av_key | |
| usr_department_head_flag | Department Head | av_flag | |
| usr_executive_flag | Executive | av_flag | |
| usr_xweb_readonly_flag | xWeb Read-only Flag | av_flag | Added in 2008.01 for XWeb User Security Attributes |
| usr_xweb_start_date | xWeb Start Date | av_date_small | Added in 2008.01 for XWeb User Security Attributes |
| usr_xweb_end_date | xWeb End Date | av_date_small | Added in 2008.01 for various XWeb User Security Attributes |
| usr_xweb_start_time | xWeb Start Time | nvarchar | Added in 2008.01 for XWeb User Security Attributes |
| usr_xweb_end_time | xWeb End Time | nvarchar | Added in 2008.01 for various XWeb User Security Attributes |
| usr_xweb_query_row_limit | xWeb Query Row Limit | av_integer | Added in 2008.01 but not implemented yet. |
| usr_xweb_enforce_object_security_flag | xWeb Enforce User Object Security | av_flag | Added in 2008.01 for various XWeb User Security Attributes |
| usr_xweb_restrict_ip_address_flag | Restrict User IP Address Flag | av_flag | Added in 2008.01 for Authorizing xWeb Users by IP Address |
| usr_messaging_username | Messaging Username | av_user | 2011 |
| usr_messaging_password | Messaging Password | nvarchar(80) | |
| usr_exclude | exclude user flag | av_flag | |
| usr_last_login | User Last Login | av_date | Last login datetime for that user. Every time user logs in, netFORUM enters the current datetime into this column; this will, at the same time, update the usr_change_date at the same time. |
| usr_add_date | Add Date | av_date_small | |
| usr_add_user | Add User | av_user | |
| usr_change_date | Change Date | av_date_small | |
| usr_change_user | Change User | av_user | |
| usr_delete_flag | Delete Flag | av_delete_flag | |
| usr_entity_key | Entity Key | av_key | |
| usr_salt | varchar(MAX) | ||
| usr_iterations | av_integer |
Parent Tables
| Parent Table | Parent Key | Child Key | Join |
|---|---|---|---|
| fw_department | dep_key | usr_dep_key | usr_dep_key = dep_key |
Child Tables
| Child Table | Parent Key | Child Key | Join |
|---|---|---|---|
| co_request_role | usr_code | rro_usr_code | rro_usr_code = usr_code |
| co_task | usr_code | cot_usr_code | cot_usr_code = usr_code |
| fw_entity_x_user | usr_key | exu_usr_key | exu_usr_key = usr_key |
| fw_user_email_alias | usr_key | uea_usr_key | uea_usr_key = usr_key |
| fw_user_x_group | usr_code | uxg_usr_code | uxg_usr_code = usr_code |
| fw_user_x_option | usr_code | uxo_usr_code | uxo_usr_code = usr_code |
| sf_opportunity | usr_key | sfo_usr_key | sfo_usr_key = usr_key |
| sf_opportunity_history | usr_key | sfh_usr_key | sfh_usr_key = usr_key |
| sf_staff_commission | usr_key | ssc_usr_key | ssc_usr_key = usr_key |
| sf_territory_assignment | usr_key | ste_usr_key | ste_usr_key = usr_key |
| sf_user_x_commission | usr_key | suc_usr_key | suc_usr_key = usr_key |
| tm_expense | usr_key | tex_usr_key | tex_usr_key = usr_key |
| tm_project_resource | usr_key | prr_usr_key | prr_usr_key = usr_key |
| tm_resource_rate | usr_key | trr_usr_key | trr_usr_key = usr_key |
| tm_time | usr_key | tim_usr_key | tim_usr_key = usr_key |