USE [P21]
GO

/****** Object:  Table [dbo].[nutech_kit_item_report_input]    Script Date: 12/19/2024 7:46:01 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[nutech_kit_item_report_input](
	[customer_id] [int] NOT NULL,
	[location_id] [int] NOT NULL,
	[item_id] [varchar](50) NOT NULL,
	[qty] [int] NOT NULL,
	[last_modified] [datetime] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[nutech_kit_item_report_input] ADD  CONSTRAINT [DF_msbs_kit_item_report_input_last_modified]  DEFAULT (getdate()) FOR [last_modified]
GO