
/****** Object:  Table [dbo].[asr_bas_err_log]    Script Date: 2020/12/21 14:43:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[asr_bas_err_log](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[uuid] [varchar](255) NULL,
	[wrk_no] [int] NULL,
	[start_time] [datetime] NULL,
	[end_time] [datetime] NULL,
	[wrk_sts] [bigint] NULL,
	[io_type] [int] NULL,
	[crn_no] [int] NULL,
	[plc_no] [int] NULL,
	[loc_no] [varchar](7) NULL,
	[sta_no] [int] NULL,
	[source_sta_no] [int] NULL,
	[source_loc_no] [varchar](7) NULL,
	[barcode] [varchar](255) NULL,
	[err_code] [int] NULL,
	[error] [varchar](255) NULL,
	[status] [int] NULL,
	[create_time] [datetime] NULL,
	[create_by] [bigint] NULL,
	[update_time] [datetime] NULL,
	[update_by] [bigint] NULL,
	[memo] [varchar](255) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'uuid'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'wrk_no'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发生时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'start_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'end_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作状态[asr_bas_wrk_status]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'wrk_sts'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入出库类型[asr_bas_wrk_iotype]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'io_type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'堆垛机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'crn_no'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'plc' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'plc_no'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目标库位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'loc_no'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目标站' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'sta_no'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'源站' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'source_sta_no'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'源库位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'source_loc_no'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'条码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'barcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'err_code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'error'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常情况{1:待处理,2:已修复}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'create_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加人员[sys_user]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'create_by'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'update_time'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人员[sys_user]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'update_by'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_bas_err_log', @level2type=N'COLUMN',@level2name=N'memo'
GO