Tables [dbo].[SADeviceService]
PropertyValue
Row Count (~)0
Created12:59:00 AM Thursday, March 21, 2019
Last Modified1:06:25 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SADeviceService: DeviceServiceID\SupplyVendorIDDeviceServiceIDint4
False
1 - 1
Cluster Primary Key PK_SADeviceService: DeviceServiceID\SupplyVendorIDSupplyVendorIDint4
False
((1))
MinVolumeint4
True
((0))
MaxVolumeint4
True
((0))
BlkServicemoney8
True
((0))
ClrServicemoney8
True
((0))
Activebit1
False
((0))
KeyNameKey ColumnsUnique
Cluster Primary Key PK_SADeviceService: DeviceServiceID\SupplyVendorIDPK_SADeviceServiceDeviceServiceID, SupplyVendorID
True
CREATE TABLE [dbo].[SADeviceService]
(
[DeviceServiceID] [int] NOT NULL IDENTITY(1, 1),
[SupplyVendorID] [int] NOT NULL CONSTRAINT [DF_SADeviceService_SupplyVendorID] DEFAULT ((1)),
[MinVolume] [int] NULL CONSTRAINT [DF_SADeviceService_MinVolume] DEFAULT ((0)),
[MaxVolume] [int] NULL CONSTRAINT [DF_SADeviceService_MaxVolume] DEFAULT ((0)),
[BlkService] [money] NULL CONSTRAINT [DF_SADeviceService_BlkService] DEFAULT ((0)),
[ClrService] [money] NULL CONSTRAINT [DF_SADeviceService_ClrService] DEFAULT ((0)),
[Active] [bit] NOT NULL CONSTRAINT [DF_SADeviceService_Active] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SADeviceService] ADD CONSTRAINT [PK_SADeviceService] PRIMARY KEY CLUSTERED  ([DeviceServiceID], [SupplyVendorID]) ON [PRIMARY]
GO