| Table Name: | web_user |
| Table Number: | 400 |
| Group: | WebSupport |
| Description: | Stores the profile of a WebSupport user |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| login_name | CHAR | varchar | 2 | 30 | WebSupport user login name | Search (6) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (7) | ||
| passwd_chg | CLK_TIME | datetime | Date/Time password was last changed; supports password expiration | Search (4) | ||||
| password | CHAR | varchar | 30 | WebSupport user password | Search (4) | |||
| ship_via | CHAR | varchar | 80 | Default means of shipment for the web_user. This is from a Clarify-defined popup list with default name SHIP_VIA | ||||
| status | LONG | int | 1 | DIRECT | WebSupport user Status; i.e., 0=inactive, 1=Active | Search (4) | ||
| user_key | CHAR | varchar | 30 | System-generated key value to locate WebSupport user | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| web_user2contact | MTO | contact | contact2web_user | Contact for the web_user | Search (4) | ||
| web_user2lead | MTO | lead | lead2web_user | If the web_user is a lead, the lead | |||
| web_user2preference | OTM | preference | pref2web_user | Preferences for the web_user | |||
| web_user2user | MTO | user | user2web_user | Database user for the web_user | Search (1) | ||
| web_user2web_filter | OTM | web_filter | web_filter2web_user | Web_filters owned by the web_user | |||
| web_user2web_lease | OTM | web_lease | owner2web_user | Lease owned by the web_user | |||
| web_user2web_log | OTM | web_log | web_log2web_user | Activities of the web_user |
| Index Name | Fields | Flags |
|---|---|---|
| key_index | user_key | UNIQUE |
| name_index | login_name | UNIQUE |
| contact_index | web_user2user:web_user2contact | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| contact_index | web_user2user, web_user2contact | nonclustered, unique located on PRIMARY |
| key_index | user_key | nonclustered, unique located on PRIMARY |
| name_index | login_name | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5164 | web_cntlst | contact, web_user |
| 5165 | web_usrlst | employee, privclass, user, web_user |
| 5198 | web_liclst | web_lease, web_user |
| 5368 | v_web_filter | web_filter, web_user |
| 5374 | cnt_weblst | address, contact, contact_role, country, site, web_user |
| 5460 | ctct_web_acct_vw | bus_org, contact, ct_bus_role, web_user |
| 5463 | contact_web | address, contact, contact_role, country, site, web_user |
| web_user | |||