Tables [dbo].[SADeviceItemSupplies]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:00 AM Thursday, March 21, 2019
Last Modified1:14:17 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SADeviceItemSupplies: DeviceItemID\DetailIDDeviceItemIDint4
False
Cluster Primary Key PK_SADeviceItemSupplies: DeviceItemID\DetailIDDetailIDint4
False
1 - 1
Foreign Keys FK_SADeviceItemSupplies_SupplyVendorID_SASupplyVendors: [dbo].[SASupplyVendors].SupplyVendorIDSupplyVendorIDint4
False
Foreign Keys FK_SADeviceItemSupplies_SupplySourceID_SASupplySource: [dbo].[SASupplySource].SupplySourceIDSupplySourceIDint4
False
SupplyTypeIDint4
False
Costmoney8
False
((0))
Yieldint4
False
((0))
MinVolumeint4
False
((0))
VendorItemvarchar(32)32
True
Itemvarchar(32)32
True
Descriptionvarchar(255)255
True
Activebit1
False
((1))
MfgNumbervarchar(30)30
True
UpdateSupplyVendorIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SADeviceItemSupplies: DeviceItemID\DetailIDPK_SADeviceItemSuppliesDeviceItemID, DetailID
True
80
NameColumns
FK_SADeviceItemSupplies_SupplySourceID_SASupplySourceSupplySourceID->[dbo].[SASupplySource].[SupplySourceID]
FK_SADeviceItemSupplies_SupplyVendorID_SASupplyVendorsSupplyVendorID->[dbo].[SASupplyVendors].[SupplyVendorID]
CREATE TABLE [dbo].[SADeviceItemSupplies]
(
[DeviceItemID] [int] NOT NULL,
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[SupplyVendorID] [int] NOT NULL,
[SupplySourceID] [int] NOT NULL,
[SupplyTypeID] [int] NOT NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_SADeviceItemSupplies_Cost] DEFAULT ((0)),
[Yield] [int] NOT NULL CONSTRAINT [DF_SADeviceItemSupplies_Yield] DEFAULT ((0)),
[MinVolume] [int] NOT NULL CONSTRAINT [DF_SADeviceItemSupplies_MinVolume] DEFAULT ((0)),
[VendorItem] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Item] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_SADeviceItemSupplies_Active] DEFAULT ((1)),
[MfgNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdateSupplyVendorID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SADeviceItemSupplies] ADD CONSTRAINT [PK_SADeviceItemSupplies] PRIMARY KEY CLUSTERED  ([DeviceItemID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SADeviceItemSupplies] ADD CONSTRAINT [FK_SADeviceItemSupplies_SupplySourceID_SASupplySource] FOREIGN KEY ([SupplySourceID]) REFERENCES [dbo].[SASupplySource] ([SupplySourceID])
GO
ALTER TABLE [dbo].[SADeviceItemSupplies] ADD CONSTRAINT [FK_SADeviceItemSupplies_SupplyVendorID_SASupplyVendors] FOREIGN KEY ([SupplyVendorID]) REFERENCES [dbo].[SASupplyVendors] ([SupplyVendorID])
GO