/****** Object:  Table [dbo].[tbl_Entities]    Script Date: 7/30/2021 10:28:44 AM ******/
IF  EXISTS (SELECT *
FROM sys.indexes
WHERE name='tbl_InventoryReference_entity_partnum_warehouse_index' AND object_id = OBJECT_ID('[dbo].[tbl_InventoryReference]'))
    DROP INDEX [tbl_InventoryReference_entity_partnum_warehouse_index] ON [dbo].[tbl_InventoryReference]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_InventoryReference]') AND type in (N'U'))
    DROP TABLE [dbo].[tbl_InventoryReference]
GO

/****** Object:  Table [dbo].[tbl_Entities]    Script Date: 7/30/2021 10:28:44 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_InventoryReference](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [col_partnum]  [nvarchar] (50) NULL,
    [col_class]  [nvarchar] (3) NULL,
    [col_mfr]  [nvarchar](3) NULL,
    [col_parentMfr]  [nvarchar] (3) NULL,
    [col_warehouse]  [nvarchar] (3) NULL,
    [col_parentwarehouse]  [nvarchar] (3) NULL,
    [col_Entity]  [nvarchar](3) NULL,
    [col_pnet_ats]   [int] NULL,
    [col_inet_ats]   [int] NULL,
    [col_Eccn]  [nvarchar] (100) NULL,
    [col_Hts]  [nvarchar] (100) NULL,
    [col_CountryOfOrigin]  [nvarchar] (400) NULL,
    [col_AllocProductInd]  [nvarchar] (2) NULL

 CONSTRAINT [PK_InventoryID] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [tbl_InventoryReference_entity_partnum_warehouse_index] ON [dbo].[tbl_InventoryReference]
(
    [col_Entity] ASC,
    [col_partnum] ASC,
    [col_warehouse] ASC
)
INCLUDE([id],
    [col_class],
    [col_mfr],
    [col_parentMfr],
    [col_parentwarehouse],
    [col_pnet_ats],
    [col_inet_ats],
    [col_Eccn],
    [col_Hts],
    [col_CountryOfOrigin],
    [col_AllocProductInd]) WITH (STATISTICS_NORECOMPUTE = OFF, DROP_EXISTING = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF)
GO