USE [FSLibrary]
GO

/****** Object:  Table [dbo].[tbl_GS1_BatchMessages]    Script Date: 4/24/2020 11:01:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_GS1_BatchMessages](
	[messageId] [int] IDENTITY(1,1) NOT NULL,
	[createDate] [datetime] NOT NULL,
	[ownerType] [varchar](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[clientName] [varchar](200) NOT NULL,
	[batchid] [int] NOT NULL,
	[GLN] [nchar](20) NULL,
	[publishedGTIN] [varchar](14) NULL,
	[GTIN] [varchar](14) NULL,
	[messageCode] [varchar](50) NULL,
	[message] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbl_GS1_BatchMessages] ADD  CONSTRAINT [DF_tbl_GS1_BatchMessages_createDate]  DEFAULT (getdate()) FOR [createDate]
GO