Tables [dbo].[ICBarcodeTypeDetails]
PropertyValue
Row Count (~)0
Created12:57:23 AM Thursday, March 21, 2019
Last Modified1:11:14 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ICBarcodeTypeDetails: BarcodeTypeID\DetailIDForeign Keys FK_ICBarCodeTypeDetails_BarcodeTypeID_ICBarcodeTypes: [dbo].[ICBarcodeTypes].BarcodeTypeIDBarcodeTypeIDint4
False
Cluster Primary Key PK_ICBarcodeTypeDetails: BarcodeTypeID\DetailIDDetailIDint4
False
Foreign Keys FK_ICBarCodeTypeDetails_BarcodeSegmentID_ICBarcodeSegments: [dbo].[ICBarcodeSegments].BarcodeSegmentIDBarcodeSegmentIDint4
False
CharStartint4
False
CharEndint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICBarcodeTypeDetails: BarcodeTypeID\DetailIDPK_ICBarcodeTypeDetailsBarcodeTypeID, DetailID
True
80
NameColumns
FK_ICBarCodeTypeDetails_BarcodeSegmentID_ICBarcodeSegmentsBarcodeSegmentID->[dbo].[ICBarcodeSegments].[BarcodeSegmentID]
FK_ICBarCodeTypeDetails_BarcodeTypeID_ICBarcodeTypesBarcodeTypeID->[dbo].[ICBarcodeTypes].[BarcodeTypeID]
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