USE [SSMES]
GO
/****** Object:  Table [dbo].[Tb_MatrlLog]    Script Date: 2021/3/31 16:15:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tb_MatrlLog](
	[c_Id] [varchar](20) NOT NULL,
	[c_ProductSN] [varchar](40) NULL,
	[c_MatrlID] [varchar](40) NULL,
	[c_MatrlName] [varchar](40) NULL,
	[c_MatrlValue] [varchar](40) NULL,
	[c_Check] [varchar](2) NULL,
	[c_UpDateTime] [datetime2](7) NULL,
	[C_TimeStamp] [datetime2](7) NULL,
	[c_Sw01] [varchar](40) NULL,
	[c_Sw02] [varchar](40) NULL,
	[c_Sw03] [varchar](40) NULL,
 CONSTRAINT [PK_Tb_MatrlLog_c_Id] PRIMARY KEY CLUSTERED 
(
	[c_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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'2020111722031774ee18', N'1118310XELT20/LYKH/201108A0339', N'1118310XELT20', N'OP21中间壳体组件', N'1118310XELT20/LYKH/201108A0339', N'1', CAST(N'2020-11-17 22:03:17.1104801' AS DateTime2), CAST(N'2020-11-17 22:03:17.0000000' AS DateTime2), N'1', N'08194576', N'OP21')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'2020111722051459637f', N'1118310XELT20/LYKH/201108A0339', N'1118310XELT20', N'OP22中间壳体组件', N'1118310XELT20/LYKH/201108A0339', N'1', CAST(N'2020-11-17 22:05:14.3412214' AS DateTime2), CAST(N'2020-11-17 22:05:14.0000000' AS DateTime2), N'1', N'08194576', N'OP22')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'2020111722051464f06a', N'1118310XELT20/LYKH/201108A0339', N'1118303XELT17', N'OP22背板', N'303T17/LY/200819B1639', N'1', CAST(N'2020-11-17 22:05:14.3422572' AS DateTime2), CAST(N'2020-11-17 22:05:14.0000000' AS DateTime2), N'1', N'08194576', N'OP22')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201117220514a333a5', N'1118310XELT20/LYKH/201108A0339', N'1118302XELT17', N'OP22压轮条码', N'T17/TZ/201114B7040', N'1', CAST(N'2020-11-17 22:05:14.3422572' AS DateTime2), CAST(N'2020-11-17 22:05:14.0000000' AS DateTime2), N'1', N'08194576', N'OP22')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201117220514ced665', N'1118310XELT20/LYKH/201108A0339', N'1118330XELT17', N'OP22涡轮轴', N'17R0J044201006Y0303', N'1', CAST(N'2020-11-17 22:05:14.3432093' AS DateTime2), CAST(N'2020-11-17 22:05:14.0000000' AS DateTime2), N'1', N'08194576', N'OP22')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201117220950875b44', N'1118310XELT20/LYKH/201108A0339', N'1118342XELT13', N'OP50止推轴承条码', N'1118342XELT13/BATEL200929Y0965', N'1', CAST(N'2020-11-17 22:09:50.4302761' AS DateTime2), CAST(N'2020-11-17 22:09:50.0000000' AS DateTime2), N'1', N'08194576', N'OP50')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118014649c2aac1', N'1118200XELT20/BADJP/201113A773', N'1118101XELT17', N'OP90压壳条码', N'1118101XELT17/BATHS/200927Y3045', N'1', CAST(N'2020-11-18 01:46:49.3176461' AS DateTime2), CAST(N'2020-11-18 01:46:49.0000000' AS DateTime2), N'1', N'09301818', N'OP90')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118014649de4527', N'1118200XELT20/BADJP/201113A773', N'1118300XELT20', N'OP90中间体条码', N'1118310XELT20/LYKH/201108A0339', N'1', CAST(N'2020-11-18 01:46:49.3176461' AS DateTime2), CAST(N'2020-11-18 01:46:49.0000000' AS DateTime2), N'1', N'09301818', N'OP90')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118014649e04ad3', N'1118200XELT20/BADJP/201113A773', N'1118200XELT20', N'OP90蜗壳条码', N'1118200XELT20/BADJP/201113A773', N'1', CAST(N'2020-11-18 01:46:49.3195939' AS DateTime2), CAST(N'2020-11-18 01:46:49.0000000' AS DateTime2), N'1', N'09301818', N'OP90')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118015607511727', N'1118200XELT20/BADJP/201113A773', N'1118433XELT17', N'OP102电控执行器条码', N'0010111328901747311020ELT17000', N'1', CAST(N'2020-11-18 01:56:07.1938617' AS DateTime2), CAST(N'2020-11-18 01:56:07.0000000' AS DateTime2), N'1', N'09301818', N'OP102')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118015905f57614', N'1118200XELT20/BADJP/201113A773', N'1118000XELT20', N'OP130增压器总成SN', N'1118000XELT20/CASUL/20201118Y1042', N'1', CAST(N'2020-11-18 01:59:05.1424965' AS DateTime2), CAST(N'2020-11-18 01:59:05.0000000' AS DateTime2), N'1', N'09301818', N'OP130')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'202011180200143f14a3', N'1118200XELT20/BADJP/201113A773', N'1118000XELT20', N'OP140增压器总成SN', N'1118000XELT20/CASUL/20201118Y1042', N'1', CAST(N'2020-11-18 02:00:14.7347589' AS DateTime2), CAST(N'2020-11-18 02:00:14.0000000' AS DateTime2), N'1', N'09301818', N'OP140')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118020014541e92', N'1118200XELT20/BADJP/201113A773', N'0', N'OP140测试报告路径', N'', N'1', CAST(N'2020-11-18 02:00:14.7357544' AS DateTime2), CAST(N'2020-11-18 02:00:14.0000000' AS DateTime2), N'1', N'09301818', N'OP140')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118020014b53ad8', N'1118200XELT20/BADJP/201113A773', N'1118200XELT20', N'OP140蜗壳条码', N'1118200XELT20/BADJP/201113A773', N'1', CAST(N'2020-11-18 02:00:14.7347589' AS DateTime2), CAST(N'2020-11-18 02:00:14.0000000' AS DateTime2), N'1', N'09301818', N'OP140')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'202011180203357f4102', N'1118200XELT20/BADJP/201113A773', N'1118200XELT20', N'OP153蜗壳条码', N'1118200XELT20/BADJP/201113A773', N'1', CAST(N'2020-11-18 02:03:35.6814793' AS DateTime2), CAST(N'2020-11-18 02:03:35.0000000' AS DateTime2), N'1', N'09301818', N'OP153')
INSERT [dbo].[Tb_MatrlLog] ([c_Id], [c_ProductSN], [c_MatrlID], [c_MatrlName], [c_MatrlValue], [c_Check], [c_UpDateTime], [C_TimeStamp], [c_Sw01], [c_Sw02], [c_Sw03]) VALUES (N'20201118020335dd0d11', N'1118200XELT20/BADJP/201113A773', N'1118000XELT20', N'OP153增压器总成SN', N'1118000XELT20/CASUL/20201118Y1042', N'1', CAST(N'2020-11-18 02:03:35.6814793' AS DateTime2), CAST(N'2020-11-18 02:03:35.0000000' AS DateTime2), N'1', N'09301818', N'OP153')
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品唯一码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_ProductSN'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_MatrlID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_MatrlName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料批次' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_MatrlValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'防错标记 确认该产品最终绑定的物料，默认值为1；如果该产品与该物料解绑，将其改为0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_Check'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_UpDateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间戳' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'C_TimeStamp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_Sw01'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_Sw02'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog', @level2type=N'COLUMN',@level2name=N'c_Sw03'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料追溯记录表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_MatrlLog'
GO