DynProp
Dynamic Property.
|
Name |
Type (MS SQL) |
Type (Oracle) |
Type (PostgreSQL) |
Nullable |
Description |
|---|---|---|---|---|---|
|
Id |
BIGINT |
NUMBER(20,0) |
int8 |
not null unique |
Id of the object |
|
Name |
VARCHAR(249) |
VARCHAR2(249) |
varchar(249) |
not null |
Name of the object |
|
Namespace |
VARCHAR(249) |
VARCHAR2(249) |
varchar(249) |
not null |
Namespace of the property |
|
Caption |
VARCHAR(50) |
NVARCHAR2(50) |
varchar(50) |
|
Caption of dynamic property |
|
Description |
VARCHAR(2000) |
NVARCHAR2(2000) |
varchar(2000) |
|
Description of the object |
|
Type |
INT |
NUMBER(10,0) |
int4 |
not null |
The type of the Dynamic Property |
|
AvailableOptionsJson |
NVARCHAR(MAX) |
NCLOB |
text |
|
Available options of SingleChoice or MultiChoice property |
|
DefaultOptionsJson |
NVARCHAR(MAX) |
NCLOB |
text |
|
Default option of SingleChoice or MultiChoice property |
|
AllowCustomValue |
BIT |
NUMBER(1,0) |
boolean |
|
If set, you can set a value that is not in the choice list (Default = False) |
|
Highlighted |
BIT |
NUMBER(1,0) |
boolean |
not null |
True if the value is highlighted |
|
ForceOverrideIn |
INT |
NUMBER(10,0) |
int4 |
|
Property is forced to be overridden on another entity |
|
PromptOrder |
INT |
NUMBER(10,0) |
int4 |
not null |
Order of prompt property |
|
OwnerObjId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to Member |
|
CreationTime |
DATETIME |
TIMESTAMP(4) |
timestamp |
not null |
Creation time |
|
Creator |
NVARCHAR(255) |
NVARCHAR2(255) |
varchar(255) |
not null |
Creator |
|
LastChanged |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
Last modification time |
|
LastModifiedBy |
NVARCHAR(255) |
NVARCHAR2(255) |
varchar(255) |
|
User who modified the item |
Indexes
|
Name |
Fields |
|---|---|
|
IX_DynProp_Name |
Name |
|
IX_DynProp_Ns |
Namespace |
| IX_DynProp_OwnedBy | OwnerObjId |
| IX_DynProp_PromptOrder | PromptOrder |
Foreign Keys
|
Name |
Local References |
Foreign References |
|---|---|---|
|
FK_DynProp_OwnedBy |
OwnerObjId |
RlmObject |