dbo.ShoppingCartOrder
Carts
TableType TUsage USERDATARows 3SizeMB 0.032
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ShoppingCartOrder | varchar(38) | no | Cart | PKUID |
Ident_ShoppingCartOrder | nvarchar(256) | yes | Cart | |
Description | nvarchar(512) | yes | Description | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
UID_Person | varchar(38) | yes | Requester | FKUID |
DocumentNumber | nvarchar(128) | yes | Request number | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
ValidUntilUnsubscribe | datetime(8) | yes | Unsubscribed as from | |
CheckStatus | int(4) | yes | Processing state | limited |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1560 | ShoppingCartOrder.UID_Person | Person.UID_Person |
Triggers
GEN_T2A8D6B69A8FD39257CBA56BD0 SQL_TRIGGER
GEN_T31EC3716F8EE9DF11DE8931FF 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.QER_ZITShopDeleteClosed | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T106341A935920D1948D2514AD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T188DD67DF85747021270D2320 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C55DA64CBBD1170C3DF3A929 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T281A1B36D942EA78BB1D128B8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2AFB68DA99F57F16FAA180AD7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2E410FDD0F422F68DA5855BC7 | SQL expression dependency | OBJECT_OR_COLUMN |
| Person | referenced by foreign key from table | QER_RFRL1560: ShoppingCartOrder.UID_Person -> Person.UID_Person |
| dbo.QER_ZITShopDeleteClosed | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-compositionapi-qer-compositionapi-itshop-cartselection.cs | decompiled C# reference | classes CartSelection; methods MoveNext, SetStateMachine, GetOrCreateCartAsync; references Person, ShoppingCartOrder; markers reads entity values, saves entities, references DB/Dialog objects, IT Shop related markers |
| cs-qer-compositionapi-qer-compositionapi-itshop-shoppingcartsubmit.cs | decompiled C# reference | classes ShoppingCartSubmit, _003C_003Ec__DisplayClass15_0, _003C_003Ec__DisplayClass15_1, _003C_003Ec__DisplayClass15_2; methods _003CCheckAsync_003Eb__3, _003CCheckAsync_003Eb__0, _003CCheckAsync_003Eb__2, _003CCheckAsync_003Eb__4, MoveNext, SetStateMachine; references AccProduct, Person, PersonWantsOrg, ShoppingCartItem, ShoppingCartOrder; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-compositionapi-server-plugin-qer-compositionapi-itshop-requestunsubscribeapi.cs | decompiled C# reference | classes RequestUnsubscribeApi; methods Build; references AccProduct, ITShopOrg, Person, PersonWantsOrg, ShoppingCartItem, ShoppingCartOrder; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-qer-customizer-qer-customizer-shoppingcartorder.cs | decompiled C# reference | classes ShoppingCartOrder; methods MoveNext, SetStateMachine, OnSavingAsync, FillDocumentNumber, GetNewDocumentNumber, _StartCheck; references ShoppingCartOrder; markers reads entity values, references DB/Dialog objects, IT Shop related markers |