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