1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
| /****** 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
|
|
