dbo.DPRSchemaProperty
Defines the properties of a schema type. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 5502SizeMB 12.056
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSchemaProperty | varchar(38) | no | Schema property | PKUID |
XObjectKey | varchar(138) | no | Object key | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
AccessConstraint | nvarchar(64) | yes | Access constraint | |
DataType | nvarchar(32) | yes | Data type | |
Description | nvarchar(2048) | yes | Description | |
DisplayName | nvarchar(512) | yes | Display name | |
IsAdditional | int(4) | yes | Additional | |
IsLargeObject | int(4) | yes | Large object (LOB) | |
IsLocked | bit(1) | yes | Locked | |
IsMultiValue | int(4) | yes | Multi valued | |
IsReference | int(4) | yes | Reference | |
IsUniqueKey | int(4) | yes | Unique key | |
IsVirtual | bit(1) | yes | Virtual | |
MaximumLength | int(4) | yes | Maximum length | |
Name | nvarchar(512) | no | Name | |
UID_DPRSchemaType | varchar(38) | no | Schema type | FKUID |
UID_ConverterQBMClrType | varchar(38) | yes | Converter type | FKUID |
ValueFormat | nvarchar(64) | yes | Value format | |
UID_DPRSchemaPropertyReference | varchar(38) | yes | Reference info | FKUID |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
DataTypeSize | int(4) | yes | Data type size | |
NameFormat | nvarchar(64) | yes | Name format | |
ConverterConfig | nvarchar(-1) | yes | Converter configuration | |
UID_BaseDPRSchemaProperty | varchar(38) | yes | Base property | FKUID |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
IsRevisionCounter | bit(1) | yes | Revision counter | |
IsHierarchySortCriterion | bit(1) | yes | Is hierarchy sort criterion | |
IsSecretValue | int(4) | yes | Contains sensible data | |
MandatoryBehavior | nvarchar(128) | yes | Mandatory property | |
MetaData | nvarchar(2048) | yes | Meta data | |
IsPreferredKey | bit(1) | yes | Is preferred key | |
AutoFillBehavior | nvarchar(128) | yes | Auto fill | |
IsObsolete | bit(1) | yes | Obsolete | |
IsMvpOrderSignificant | bit(1) | yes | Multi-value sort order is significiant |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2401 | DPRSchemaMethHasProperty.UID_DPRSchemaProperty | DPRSchemaProperty.UID_DPRSchemaProperty |
| DPR_RFRL2404 | DPRSchemaPropertyRefHasTarget.UID_DPRSchemaProperty | DPRSchemaProperty.UID_DPRSchemaProperty |
| DPR_RFRL2438 | DPRSchemaProperty.UID_ConverterQBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2439 | DPRSchemaProperty.UID_QBMClrType | QBMClrType.UID_QBMClrType |
| DPR_RFRL2482 | DPRSchemaAccess.UID_DPRSchemaPropertyTrg | DPRSchemaProperty.UID_DPRSchemaProperty |
Triggers
DPR_TDDPRSchemaProperty SQL_TRIGGER
GEN_T1E82B9F55F8273B830071AEF4 SQL_TRIGGER
GEN_T2922ED4FC3A250E392F226038 SQL_TRIGGER
GEN_T34872DAFDC6E05701D832502D SQL_TRIGGER
GEN_T4ABE9D098A5346816C1517920 SQL_TRIGGER
GEN_T5214E1D292E1407A99707EA40 SQL_TRIGGER
GEN_T66DDBA2BC31998B00ACD5D3F2 SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.DPR_PAttachedDataStoreCleanUp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E82B9F55F8273B830071AEF4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2922ED4FC3A250E392F226038 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T353941C5D932D4A381E0AD0EC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VWorkflowHandlesProperty | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_VWorkflowReadsProperty | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPRSchemaMNObjectIsLocked | SQL expression dependency | OBJECT_OR_COLUMN |
| DPRSchemaMethHasProperty | foreign key references table | DPR_RFRL2401: DPRSchemaMethHasProperty.UID_DPRSchemaProperty -> DPRSchemaProperty.UID_DPRSchemaProperty |
| DPRSchemaPropertyRefHasTarget | foreign key references table | DPR_RFRL2404: DPRSchemaPropertyRefHasTarget.UID_DPRSchemaProperty -> DPRSchemaProperty.UID_DPRSchemaProperty |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2438: DPRSchemaProperty.UID_ConverterQBMClrType -> QBMClrType.UID_QBMClrType |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2439: DPRSchemaProperty.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| DPRSchemaAccess | foreign key references table | DPR_RFRL2482: DPRSchemaAccess.UID_DPRSchemaPropertyTrg -> DPRSchemaProperty.UID_DPRSchemaProperty |
| dbo.DPR_PAttachedDataStoreCleanUp | source text reference | has TRY/CATCH error handling |