USE [GalaxyTrack_Malarkey] GO /****** Object: Table [dbo].[AntennaMaster] Script Date: 3/17/2022 12:35:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AntennaMaster]( [_id] [int] IDENTITY(1,1) NOT NULL, [StationName] [varchar](18) NOT NULL, [PortalName] [varchar](18) NOT NULL, [AntennaID] [int] NOT NULL, [RFIDAntenna] [int] NOT NULL, [TxPower] [float] NULL, [RxSensitivity] [int] NULL, [Enabled] [tinyint] NULL, [TimeStamp] [datetime] NULL, CONSTRAINT [PK_AntennaMaster] PRIMARY KEY NONCLUSTERED ( [_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Bundles] Script Date: 3/17/2022 12:35:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Bundles]( [RecordId] [bigint] IDENTITY(1,1) NOT NULL, [PalletId] [bigint] NULL, [CreationTime] [datetime] NOT NULL, [Type] [nvarchar](50) NULL, [Status] [nvarchar](50) NULL, [RFIDEPC] [varchar](37) NOT NULL, [RFIDTID] [varchar](50) NULL, [TagFilterValue] [tinyint] NULL, [CompanyPrefix] [int] NULL, [ItemReference] [int] NULL, [GS1SerialNumber] [bigint] NULL, [Plant] [smallint] NULL, [Line] [smallint] NULL, [Year] [smallint] NULL, [DOY] [smallint] NULL, [ReferenceNbr] [int] NULL, [LastUpdate] [datetime] NULL, [PalletEPC] [nvarchar](37) NULL, CONSTRAINT [PK_Bundles] PRIMARY KEY CLUSTERED ( [RecordId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ObservationLog] Script Date: 3/17/2022 12:35:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ObservationLog]( [RecordId] [bigint] IDENTITY(1,1) NOT NULL, [ObservationTime] [datetime] NOT NULL, [RFIDEPC] [varchar](37) NOT NULL, [RFIDTID] [varchar](50) NULL, [TagFilterValue] [tinyint] NULL, [CompanyPrefix] [bigint] NULL, [ItemReference] [bigint] NULL, [GS1SerialNumber] [bigint] NULL, [Plant] [smallint] NULL, [Line] [smallint] NULL, [Year] [smallint] NULL, [DOY] [smallint] NULL, [ReferenceNbr] [int] NULL, [Portal] [nvarchar](18) NULL, [StationName] [varchar](18) NOT NULL, [Antenna] [tinyint] NOT NULL, [ObsType] [varchar](5) NOT NULL, [ErrorCode] [int] NULL, [Code1] [varchar](50) NULL, [PalletEPC] [varchar](37) NULL, CONSTRAINT [PK_ObservationLog] PRIMARY KEY CLUSTERED ( [RecordId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Pallets] Script Date: 3/17/2022 12:35:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Pallets]( [RecordId] [bigint] IDENTITY(1,1) NOT NULL, [CreationTime] [datetime] NOT NULL, [Type] [nvarchar](50) NULL, [Status] [nvarchar](50) NULL, [RFIDEPC] [varchar](37) NOT NULL, [RFIDTID] [varchar](50) NULL, [TagFilterValue] [tinyint] NULL, [CompanyPrefix] [int] NULL, [ItemReference] [int] NULL, [GS1SerialNumber] [bigint] NULL, [Plant] [smallint] NULL, [Line] [smallint] NULL, [Year] [smallint] NULL, [DOY] [smallint] NULL, [ReferenceNbr] [int] NULL, [LastUpdate] [datetime] NULL, CONSTRAINT [PK_Pallets] PRIMARY KEY CLUSTERED ( [RecordId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Products] Script Date: 3/17/2022 12:35:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Products]( [RecordId] [int] IDENTITY(1,1) NOT NULL, [CompanyPrefix] [int] NOT NULL, [GTIN] [bigint] NOT NULL, [GTIN12] [bigint] NOT NULL, [GTIN13] [bigint] NOT NULL, [BrandName] [nvarchar](50) NULL, [Brand1Language] [nvarchar](10) NULL, [ProductDescription] [nvarchar](100) NULL, [Desc1Language] [nvarchar](10) NULL, [ProductIndustry] [nvarchar](50) NULL, [PackagingLevel] [nvarchar](50) NULL, [IsVariable] [char](1) NULL, [IsPurchasable] [char](1) NULL, [StatusLabel] [nvarchar](50) NULL, [DateAvailableforReuse] [datetime] NULL, [Height] [decimal](15, 3) NULL, [Width] [decimal](15, 3) NULL, [Depth] [decimal](15, 3) NULL, [DimensionMeasure] [varchar](50) NULL, [GrossWeight] [decimal](15, 3) NULL, [NetWeight] [decimal](15, 3) NULL, [WeightMeasure] [nvarchar](50) NULL, [SKU] [nvarchar](50) NULL, [Comments] [nvarchar](500) NULL, [HasImage] [char](1) NULL, [CCPEnhanced] [char](1) NULL, [SubBrandName] [nvarchar](50) NULL, [ProductDescriptionShort] [nvarchar](100) NULL, [LabelDescription] [nvarchar](50) NULL, [NetContent1Count] [decimal](15, 0) NULL, [NetContent1UnitOfMeasure] [nvarchar](50) NULL, [NetContent2Count] [decimal](15, 0) NULL, [NetContent2UnitOfMeasure] [nvarchar](50) NULL, [NetContent3Count] [decimal](15, 0) NULL, [NetContent3UnitOfMeasure] [nvarchar](50) NULL, [BrandName2] [nvarchar](50) NULL, [Brand2Language] [nvarchar](10) NULL, [Description2] [nvarchar](100) NULL, [GlobalProductClassification] [nvarchar](50) NULL, [ImageURL] [nvarchar](100) NULL, [ImageURLValidation] [nvarchar](100) NULL, [TargetMarket] [nvarchar](50) NULL, [LastModifiedDate] [datetime] NULL, [ProductFamily] [nvarchar](20) NULL, CONSTRAINT [PK_Products] PRIMARY KEY NONCLUSTERED ( [RecordId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[StationMaster] Script Date: 3/17/2022 12:35:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[StationMaster]( [Name] [varchar](18) NOT NULL, [StationType] [varchar](20) NULL, [Description] [varchar](50) NULL, [CreationDate] [datetime] NOT NULL, [ActivationKey] [varchar](100) NOT NULL, [IPAddress] [varchar](15) NULL, [AuthToken] [varchar](50) NULL, [AuthTimestamp] [datetime] NULL, [LicenseKey] [varchar](1250) NULL, [TampDelay] [int] NULL, [TagMgrTimeOut] [int] NULL, [TagMgrDupTime] [int] NULL, CONSTRAINT [PK_StationMaster] PRIMARY KEY CLUSTERED ( [Name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[TableMaster] Script Date: 3/17/2022 12:35:03 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TableMaster]( [RecordId] [int] IDENTITY(1,1) NOT NULL, [TableName] [nvarchar](50) NOT NULL, [TableEntry] [nvarchar](50) NOT NULL, [Description] [nvarchar](150) NULL, [Status] [nvarchar](10) NULL, [TimeStamp] [datetime] NULL, CONSTRAINT [PK_TableMaster] PRIMARY KEY NONCLUSTERED ( [RecordId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [Bundles_PalletEPC] Script Date: 3/17/2022 12:35:03 PM ******/ CREATE NONCLUSTERED INDEX [Bundles_PalletEPC] ON [dbo].[Bundles] ( [PalletEPC] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [Bundles_RFIDEPC] Script Date: 3/17/2022 12:35:03 PM ******/ CREATE NONCLUSTERED INDEX [Bundles_RFIDEPC] ON [dbo].[Bundles] ( [RFIDEPC] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [Bundles_RFIDTID] Script Date: 3/17/2022 12:35:03 PM ******/ CREATE NONCLUSTERED INDEX [Bundles_RFIDTID] ON [dbo].[Bundles] ( [RFIDTID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ObservationLog_PalletEPC] Script Date: 3/17/2022 12:35:03 PM ******/ CREATE NONCLUSTERED INDEX [ObservationLog_PalletEPC] ON [dbo].[ObservationLog] ( [PalletEPC] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [ObservationLog_RFIDEPC] Script Date: 3/17/2022 12:35:03 PM ******/ CREATE NONCLUSTERED INDEX [ObservationLog_RFIDEPC] ON [dbo].[ObservationLog] ( [RFIDEPC] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [Pallets_RFIDEPC] Script Date: 3/17/2022 12:35:03 PM ******/ CREATE NONCLUSTERED INDEX [Pallets_RFIDEPC] ON [dbo].[Pallets] ( [RFIDEPC] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [Pallets_RFIIDTID] Script Date: 3/17/2022 12:35:03 PM ******/ CREATE NONCLUSTERED INDEX [Pallets_RFIIDTID] ON [dbo].[Pallets] ( [RFIDTID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO