Database tables related to properties

Database table - TIDMA_PROPERTY

DB attribute	Java data type (max. size), defaults	Description
access_create	String(3), not NULL	Possible values are: rw (read/write: render value as input control field, manipulation allowed) In this case, the property is visible on the GUI as an editable input field. It is possible for the user to enter a value into the field. ro (read-only: render value as text, manipulation not allowed) In this case, the property is visible on the GUI as an non-editable field. It is not possible to change the field's (property's) value in the GUI. off (same as "ro" but value is not rendered at all) In this case, the property is not visible at all on the GUI. If a user's role includes the permission "PropertyAttributeAccessOverride", the system ignores the setting of the access_create attribute for this user and this property. Such a user can always change the value of the property, independent of the attribute's value ("read/write", "read-only" or "off").
access_modify	String(3), not NULL	Possible values are: rw (read/write: render value as input control field, manipulation allowed) In this case, the property is visible on the GUI as an editable input field. The user is allowed to modify the property's value. ro (read-only: render value as text, manipulation not allowed) In this case, the property is visible on the GUI as an non-editable field. It is not possible to modify the value of the property in the GUI. off (same as "ro" but value is not rendered at all) In this case, the property is not visible at all on the GUI. If a user's role includes the permission "PropertyAttributeAccessOverride", the system ignores the setting of theaccess_modifyattribute for this user and this property. Such a user can always change the value of the property, independent of the attribute's value ("read/write", "read-only" or "off").
application_id	Long, nullable	Defines the application to which the property is restricted. Foreign key that links to information in the table TIDMA_APPLICATION. Only used for the property scopes 5 and 6.
client_id	Long, nullable	If set, the property becomes specific to the referred client. Otherwise, the property is client-independent. Client-independency is available for all property scopes, client-dependency only for the scopes: onEnterpriseRoleGlobal, onUserGlobal, onProfileGlobal, onUnitGlobal, onCredentialCertificateGlobal, onCredentialGenericGlobal, onMobileSignatureGlobal, onSamlFederationGlobal, onSecurityQuestionsGlobal. Foreign key that links to information in the table TIDMA_CLIENT.
description	String(1000), nullable
displayname_dict_entry_id	Long, nullable	Foreign key that links to information in the table TIDMA_DICT_ENTRY. The property's name in various languages.
encrypted	Boolean, not NULL	Defines if the values of the property are encrypted.
gui_precedence	Integer, not NULL	Defines the rendering order of the property on the GUI. The properties are orderd by gui_precedence ASC, name ASC. Negative values are also allowed.
mandatory_on_gui	Boolean, nullable	Defines if an error is shown if the property is not defined in the web GUI.
name	String(100), not NULL	Technical name of the property. The name has to be unique among the properties of the same scope and within the same client.
propagated	Boolean, not NULL	Defines if the values of the property are propagated to other systems.
property_id	Long, not NULL	Primary key (uniquely identifies each individual DB entry)
scope	Short, not NULL	The property scope. Possible values are: 1 (application-global); 2 (unit-global); 3 (profile-global); 4 (profile for application-global); 5 (profile for application); 6 (role for application); 7 (user-global); 8 (enterprise role-global); 20 (credential certificate-global); 21 (credential generic-global); 22 (credential mobile signature-global); 23 (credential SAML federation-global); 24 (credential security question-global)
str_max_len	Short, nullable	Only for properties of type String. Defines the maximum length of the String value.
str_regex	String(1000), nullable	Only for properties of type String. Defines a regular expression to restrict the possible String values.
type	Short, not NULL	The type of the property. Possible values are: 1 (Enum); 2 (String)
uniqueness_scope	Short, nullable	Defines the uniqueness of the property. Possible values are: NULL (values of the property have no uniqueness constraint) 1 (absolute: values of the property have to be unique) 2 (absolute_user: values of the property have to be unique between users, but the same property value defined various times for the same user is valid) 11 (relative unit: values of the property have to be unique within the unit of the entity. This uniqueness scope is currently only implemented for properties with scope user global).

Database table - TIDMA_PROPERTY_ALLOWED_VAL

DB attribute	Java data type (max. size), defaults	Description
property_ald_val_id	Long, not NULL	Primary key (uniquely identifies each individual DB entry)
property_id	Long, not NULL	The property the allowed value belongs to. The referred property must be of type Enum. Foreign key that links to information in the table TIDMA_PROPERTY.
value	String(1000), nullable	The allowed value.

Database table - TIDMA_PROPERTY_VALUE

DB attribute	Java data type (max size), defaults	Description
entity_id	Long, not NULL	Primary key of the entity the value belongs to. The type of entity depends on the property scope.
property_ald_val_id	Long, nullable	Defines the current allowed value of the property value. Only for properties of type Enum. Foreign key that links to information in the table TIDMA_PROPERTY_ALLOWED_VAL.
property_id	Long, not NULL	Defines the property the values belong to. Foreign key that links to information in the table TIDMA_PROPERTY.
property_value_id	Long, not NULL	Primary key (uniquely identifies each individual DB entry)
value	String(1000), nullable	Defines the current value. Only for properties of type String.