dbo.HardwareType
Device models
TableType TUsage USERDATARows 7SizeMB 0.072
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_HardwareType | varchar(38) | no | Device model | PKUID |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
UID_PersonPurchase | varchar(38) | yes | Identity | FKUID |
Ident_HardwareType | nvarchar(128) | no | Device model | |
Ident_HardwareBasicType | nvarchar(64) | no | Device type | limited |
Description | nvarchar(-1) | yes | Description | |
IsLocalPeripher | bit(1) | yes | Local peripheral | |
ManufacturerURL | nvarchar(-1) | yes | Web page | |
UID_FirmPartner | varchar(38) | yes | Company | FKUID |
UID_FirmPartnerDefaultVendor | varchar(38) | yes | Default supplier | FKUID |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
IsPC | bit(1) | yes | PC | |
IsServer | bit(1) | yes | Server | |
GuarantyMonths | int(4) | yes | Warranty [months] | |
GuarantyMonthsAdditional | int(4) | yes | Additional warranty [months] | |
UsageMonths | int(4) | yes | Usage [months] | |
StockMin | int(4) | yes | Min. stock | |
StockLimit | int(4) | yes | Max. stock | |
UID_HardwareTypeAlternate | varchar(38) | yes | Alternative device model | FKUID |
ArticleCode | nvarchar(128) | yes | Item number | |
OrderUnit | nvarchar(64) | yes | Request units | |
OrderQuantityMin | int(4) | yes | Minimum request quantity | |
LastOfferDate | datetime(8) | yes | Last quote date | |
LastOfferPrice | int(4) | yes | Price of last offer | |
LastDeliverDate | datetime(8) | yes | Last delivery date | |
LastDeliverPrice | int(4) | yes | Price of last delivery | |
AdditionalInformation | nvarchar(-1) | yes | Additional information | |
XTouched | nchar(2) | yes | Processing status | |
IsInActive | bit(1) | yes | Disabled | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1285 | HardwareType.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL3346 | Hardware.UID_HardwareType | HardwareType.UID_HardwareType |
| QER_RFRL3352 | HardwareType.UID_FirmPartnerDefaultVendor | FirmPartner.UID_FirmPartner |
| QER_RFRL845 | HardwareType.UID_PersonPurchase | Person.UID_Person |
| QER_RFRL848 | HardwareType.UID_FirmPartner | FirmPartner.UID_FirmPartner |
Triggers
GEN_T10643EDFCBBC2FB1CA3054AB0 SQL_TRIGGER
GEN_T26BC3BFCC55F871E481A982FE SQL_TRIGGER
GEN_T3A985E6DE46E923CDF5D5181A SQL_TRIGGER
GEN_T47162D448118DBBD8B6C44001 SQL_TRIGGER
GEN_T5BCA54F6F1FD6DAA0C0C0ECB0 SQL_TRIGGER
GEN_T696B81F6EB5287C7E0A59EA0C SQL_TRIGGER
QER_TDHardwareType SQL_TRIGGER
QER_TIHardwareType SQL_TRIGGER
QER_TUHardwareType 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.GEN_T10643EDFCBBC2FB1CA3054AB0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T26BC3BFCC55F871E481A982FE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3A985E6DE46E923CDF5D5181A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5BCA54F6F1FD6DAA0C0C0ECB0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIHardwareType | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHardwareType | SQL expression dependency | OBJECT_OR_COLUMN |
| AccProduct | referenced by foreign key from table | QER_RFRL1285: HardwareType.UID_AccProduct -> AccProduct.UID_AccProduct |
| Hardware | foreign key references table | QER_RFRL3346: Hardware.UID_HardwareType -> HardwareType.UID_HardwareType |
| FirmPartner | referenced by foreign key from table | QER_RFRL3352: HardwareType.UID_FirmPartnerDefaultVendor -> FirmPartner.UID_FirmPartner |
| Person | referenced by foreign key from table | QER_RFRL845: HardwareType.UID_PersonPurchase -> Person.UID_Person |
| FirmPartner | referenced by foreign key from table | QER_RFRL848: HardwareType.UID_FirmPartner -> FirmPartner.UID_FirmPartner |
| dbo.QER_TIHardware | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIHardwareType | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUHardware | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUHardwareType | source text reference | uses session context values, has TRY/CATCH error handling |