CREATE TABLE [dbo].[ICBarcodeTypeDetails]
(
[BarcodeTypeID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[BarcodeSegmentID] [int] NOT NULL,
[CharStart] [int] NOT NULL,
[CharEnd] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICBarcodeTypeDetails] ADD CONSTRAINT [PK_ICBarcodeTypeDetails] PRIMARY KEY CLUSTERED ([BarcodeTypeID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICBarcodeTypeDetails] ADD CONSTRAINT [FK_ICBarCodeTypeDetails_BarcodeSegmentID_ICBarcodeSegments] FOREIGN KEY ([BarcodeSegmentID]) REFERENCES [dbo].[ICBarcodeSegments] ([BarcodeSegmentID])
GO
ALTER TABLE [dbo].[ICBarcodeTypeDetails] ADD CONSTRAINT [FK_ICBarCodeTypeDetails_BarcodeTypeID_ICBarcodeTypes] FOREIGN KEY ([BarcodeTypeID]) REFERENCES [dbo].[ICBarcodeTypes] ([BarcodeTypeID])
GO