Updated: 2009-09-17
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to store all User and Store configuration options.
The information is stored using a keyfield
Information on Table Data
- ClassTypeIDs Stores in Table:
- 1100 - User Options
- 1101 - Store Options
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| UserOption.ClassTypeID | int | Identifier for the Type of Object | |||||
| UserOption.ID | int | Primary Key for the Table | |||||
| UserOption.IsActive | bit | Not Used for This Table | |||||
| UserOption.IsSystem | bit | Used to Mark Required Records | |||||
| UserOption.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| UserOption.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| UserOption.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| UserOption.OptionMemo | text | ||||||
| UserOption.OptionName | nvarchar(25) | ||||||
| UserOption.OptionValue | nvarchar(25) | ||||||
| UserOption.ParentClassTypeID | int | ClassTypeID of the object this option belongs to. 1000 Store Options 6000 User Options | |||||
| UserOption.ParentID | int | ID of the object this option applies to. | sql_structure_-_username_table.ID for User Options, sql_structure_-_store_table.ID for Store Options |
||||
| UserOption.SeqID | int |
Related Tables
You could leave a comment if you were logged in.