This stores the UMP profiles with one profile record for each user
| Column Name | Column Datatype | Column Null Option | Column Comment |
| user_id | nvarchar(100) | not null | User_id: portal user name. “default” is used to store properties for the default user. |
| prop_name | nvarchar(200) | not null | The system name with which to refer this property. Used only by developer. |
| prop_label | nvarchar(256) | not null | The label that shows up in the web page for this property. It is a string constant and is localized in UMPLocaleBundle.properties file. |
| prop_selected | nvarchar(1500) | with null | Used only when datatype is 'selection/multiselection', otherwise left blank or empty. For 'selection/multiselection' datatype, a value from prop_value is used. In case of multiselection it should be more than 1 value (comma-seperated). |
| prop_datatype | nvarchar(100) | not null | Can be either 'text' for textbox or 'selection' for combobox or 'multiselection' for listbox. |
| prop_value | nvarchar(1500) | not null | In case of 'selection' this could be a comma-seperated list. This is only the 'value' of the combobox entries |
| prop_description | nvarchar(1500) | not null | Use this only when datatype is 'selection', otherwise leave blank or empty. Make sure your list here has same number of elements as in prop_value. This list should be localized string and defined in UMPLocaleBundle.properties. As an example, prop_value could be "true,false" and prop_description could be "LOCALIZED_TRUE,LOCALIZED_FALSE". This is the entry that shows up on the combo box. If localized string not found in resourcebundle, whatever you provide will be displayed |
| prop_unit | nvarchar(256) | with null | The unit of the property. It is a string constant and is localized in UMPLocaleBundle.properties file |
| override | nvarchar(100) | with null | Could be either ‘true’ or ‘false’. This field only shows up for an administrator. A value of ‘true’ indicates that this property cannot be modified by other non-admin users |
| group_name | nvarchar(256) | with null | Because there can be many properties for a particular component. Giving a same group_name to multiple properties ensure that they all show up under a common heading. This heading is what you define here. It is a string constant and is localized in UMPLocaleBundle.properties file |
Product Name: Unicenter Management Portal
Table Type: Table