dbo.DPRSchemaMethHasProperty
Defines the properties used and required by the schema methods. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 53SizeMB 0.04
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSchemaMethod | varchar(38) | no | Schema method | PKFKUID |
UID_DPRSchemaProperty | varchar(38) | no | Schema property | PKFKUID |
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 |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2400 | DPRSchemaMethHasProperty.UID_DPRSchemaMethod | DPRSchemaMethod.UID_DPRSchemaMethod |
| DPR_RFRL2401 | DPRSchemaMethHasProperty.UID_DPRSchemaProperty | DPRSchemaProperty.UID_DPRSchemaProperty |
Triggers
GEN_T3FE2EBF2C74F3B6C9C45CDA3B SQL_TRIGGER
GEN_T4FFA7B5CF063DD45B6AB313F6 SQL_TRIGGER
GEN_T6C6A91A0D88D464493336BC31 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.DPRSchemaMNObjectIsLocked | SQL expression dependency | OBJECT_OR_COLUMN |
| DPRSchemaMethod | referenced by foreign key from table | DPR_RFRL2400: DPRSchemaMethHasProperty.UID_DPRSchemaMethod -> DPRSchemaMethod.UID_DPRSchemaMethod |
| DPRSchemaProperty | referenced by foreign key from table | DPR_RFRL2401: DPRSchemaMethHasProperty.UID_DPRSchemaProperty -> DPRSchemaProperty.UID_DPRSchemaProperty |