dbo.RPSSubscription
Report subscriptions
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_RPSSubscription | varchar(38) | no | Subscription | PKUID |
Ident_RPSSubscription | nvarchar(256) | no | Subscription | |
UID_Person | varchar(38) | no | Identity | FKUID |
UID_RPSReport | varchar(38) | no | Report | FKUID |
UID_DialogSchedule | varchar(38) | yes | Schedule | FKUID |
IsRejected | bit(1) | yes | Unsubscribed | |
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 | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
ExportFormat | varchar(16) | yes | Format (e-mail attachment) | limited |
Relations
| FK | From | To |
|---|---|---|
| RPS_RFRL4177 | RPSSubscription.UID_Person | Person.UID_Person |
Triggers
GEN_T18982FEA1E48BBC7BBED1F2AE SQL_TRIGGER
GEN_T25894CE85FB7F76D27F9EBFB0 SQL_TRIGGER
GEN_T36B6D87BCBDCC7E7B7F72515E SQL_TRIGGER
RPS_TDRPSSubscription SQL_TRIGGER
RPS_TIRPSSubscription SQL_TRIGGER
RPS_TURPSSubscription 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.RPS_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZScheduleStart | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T16ACB3C847703DA576B562D27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C3D78466F05DE84C333B3E26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2630021CB14906358C7D203 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2EFBF6D4086E1073FF944EA6C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T31FDEB2B4FF4B55C745CFF502 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3EF2A24EC8C84ED380F7012C0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TIPersonHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TIRPSSubscription | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TUPersonHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TURPSSubscription | SQL expression dependency | OBJECT_OR_COLUMN |
| Person | referenced by foreign key from table | RPS_RFRL4177: RPSSubscription.UID_Person -> Person.UID_Person |
| dbo.RPS_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZScheduleStart | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.RPS_TIPersonHasRPSReport | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TIRPSSubscription | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TUPersonHasRPSReport | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TURPSSubscription | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-rps-customizer-rps-customizer-rpssubscription.cs | decompiled C# reference | classes RPSSubscription; methods MoveNext, SetStateMachine, _CreateParameterSet; references DialogParameter, DialogParameterSet, RPSReport, RPSSubscription; markers reads entity values, references DB/Dialog objects |
| cs-rps-forms-rps-forms-formrpsreportmasterdata.cs | decompiled C# reference | classes FormRPSReportMasterData; methods OnInit, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged, Task_Preview; references AccProduct, DialogParameter, DialogParameterSet, DialogReport, Person, RPSReport; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |