dbo.DPRSchemaType
Schema types are target system equivalent to database tables. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 76SizeMB 0.104
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSchemaType | varchar(38) | no | Schema type | 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 | |
Description | nvarchar(2048) | yes | Description | |
DisplayName | nvarchar(512) | yes | Display name | |
DisplayPattern | nvarchar(512) | yes | Display pattern | |
IsAdditional | bit(1) | yes | Additional | |
IsMNType | bit(1) | yes | M:N type | |
IsReadOnly | bit(1) | yes | Read only | |
IsVirtual | bit(1) | yes | Virtual | |
IsInActive | bit(1) | yes | Inactive | |
Name | nvarchar(512) | no | Name | |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
UID_DPRSchema | varchar(38) | no | Schema | FKUID |
SerializationBag | nvarchar(-1) | yes | Serialization bag | |
NameFormat | nvarchar(64) | yes | Name format | |
IsLocked | bit(1) | yes | Locked | |
MetaData | nvarchar(2048) | yes | Meta data | |
DesignTags | nvarchar(128) | yes | Processing information | |
IsObsolete | bit(1) | yes | Obsolete | |
ShrinkLock | int(4) | yes | No shrinking | bitmask |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2407 | DPRSchemaType.UID_QBMClrType | QBMClrType.UID_QBMClrType |
Triggers
GEN_T1459EB27B8C58A5F5CCE78A04 SQL_TRIGGER
GEN_T237E28B0AFA0DB2F801EC2F59 SQL_TRIGGER
GEN_T353941C5D932D4A381E0AD0EC SQL_TRIGGER
GEN_T4020DE2B08A1E804C810E54D4 SQL_TRIGGER
GEN_T54216735D7FEBB72C253AC710 SQL_TRIGGER
GEN_T6132DA1FD2B65E0A93656E303 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_T10F8871981F7CF0A396AD221E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T123C0AE0A54037E8FE746ECE5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13F7A5FC09E28DBEE4BD1C2D8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T17C731B6F0016FF03FB9ACF05 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AE3C98C547FE70138EACC9D8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E82B9F55F8273B830071AEF4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T23A111C4CEBAA94E6EBFC67AC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T241051F8E636D139C8011CB6B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T28E0A47BCAA4E1CD272123E09 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2922ED4FC3A250E392F226038 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T29ADB04C1238119232ABE43D6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2DDB28458F11E04FE60673ED9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3D466D5C4953840BA3CFC4FBA | 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.DPRJournalObjectResultView | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2407: DPRSchemaType.UID_QBMClrType -> QBMClrType.UID_QBMClrType |
| dbo.DPR_PAttachedDataStoreCleanUp | source text reference | has TRY/CATCH error handling |