blame | 历史 | 原始文档
#
luxiaotao1123
2021-04-23 4d76ec2cc1cbbf9f192d532922c2d0a05900f510 
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198

ÿþ 


GO 


/****** Object:  Table [dbo].[man_order_detl_log]    Script Date: 2021/4/23 11:39:47 ******/ 


SET ANSI_NULLS ON 


GO 


SET QUOTED_IDENTIFIER ON 


GO 


SET ANSI_PADDING ON 


GO 


CREATE TABLE [dbo].[man_order_detl_log]( 


    [id] [bigint] NOT NULL, 


    [order_id] [bigint] NULL, 


    [anfme] [decimal](24, 9) NULL, 


    [matnr] [varchar](255) NULL, 


    [maktx] [varchar](255) NULL, 


    [name] [varchar](255) NULL, 


    [specs] [varchar](255) NULL, 


    [model] [varchar](255) NULL, 


    [batch] [varchar](50) NULL, 


    [unit] [varchar](50) NULL, 


    [barcode] [varchar](255) NULL, 


    [supplier] [varchar](255) NULL, 


    [unit_price] [decimal](24, 9) NULL, 


    [item_num] [int] NULL, 


    [count] [decimal](24, 9) NULL, 


    [weight] [decimal](24, 9) NULL, 


    [status] [int] NULL, 


    [create_by] [bigint] NULL, 


    [create_time] [datetime] NULL, 


    [update_by] [bigint] NULL, 


    [update_time] [datetime] NULL, 


    [memo] [varchar](255) NULL 


) ON [PRIMARY] 


 


GO 


SET ANSI_PADDING OFF 


GO 


/****** Object:  Table [dbo].[man_order_log]    Script Date: 2021/4/23 11:39:47 ******/ 


SET ANSI_NULLS ON 


GO 


SET QUOTED_IDENTIFIER ON 


GO 


SET ANSI_PADDING ON 


GO 


CREATE TABLE [dbo].[man_order_log]( 


    [id] [bigint] NOT NULL, 


    [uuid] [varchar](255) NOT NULL, 


    [order_no] [varchar](255) NULL, 


    [order_time] [varchar](255) NULL, 


    [doc_type] [bigint] NULL, 


    [item_id] [bigint] NULL, 


    [item_name] [varchar](255) NULL, 


    [allot_item_id] [bigint] NULL, 


    [def_number] [varchar](255) NULL, 


    [number] [varchar](255) NULL, 


    [cstmr] [bigint] NULL, 


    [cstmr_name] [varchar](255) NULL, 


    [tel] [varchar](255) NULL, 


    [oper_memb] [varchar](50) NULL, 


    [total_fee] [decimal](24, 9) NULL, 


    [discount] [decimal](24, 9) NULL, 


    [discount_fee] [decimal](24, 9) NULL, 


    [other_fee] [decimal](24, 9) NULL, 


    [act_fee] [decimal](24, 9) NULL, 


    [pay_type] [int] NULL, 


    [salesman] [varchar](255) NULL, 


    [account_day] [int] NULL, 


    [post_fee_type] [int] NULL, 


    [post_fee] [decimal](24, 9) NULL, 


    [pay_time] [datetime] NULL, 


    [send_time] [datetime] NULL, 


    [ship_name] [varchar](255) NULL, 


    [ship_code] [varchar](255) NULL, 


    [settle] [bigint] NULL, 


    [status] [int] NULL, 


    [create_by] [bigint] NULL, 


    [create_time] [datetime] NULL, 


    [update_by] [bigint] NULL, 


    [update_time] [datetime] 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'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'id' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢‹US…Qx[man_order]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'order_id' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'anfme' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'FUÁTx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'matnr' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'FUÁT Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'maktx' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N' Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'name' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ĉ<h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'specs' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'‹W÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'model' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'batch' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'unit' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'FUÁTagx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'barcode' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'›O”^FU' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'supplier' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'US÷N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'unit_price' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÁTy˜pe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'item_num' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'count' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'͑ϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'weight' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶r`{1:ck8^,0:y(u}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'status' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûm RºNXT[sys_user]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'create_by' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûm Röeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'create_time' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºNXT[sys_user]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'update_by' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eöeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'update_time' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_detl_log', @level2type=N'COLUMN',@level2name=N'memo' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'id' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'uuid' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢‹US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'order_no' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USncåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'order_time' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|‹W[man_doc_type]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'doc_type' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'y˜îv÷S[man_item]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'item_id' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Œèby˜îv÷S[man_item]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'allot_item_id' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'RËYhync÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'def_number' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'hync÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'number' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢[7b÷S[man_cstmr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'cstmr' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢[7b' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'cstmr_name' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'T€û|¹e_' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'tel' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Íd\OºNXT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'oper_memb' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'T¡‹Ñ‘˜' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'total_fee' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Oà`‡s' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'discount' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Oà`ё˜' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'discount_fee' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'•.UbǑ-9(uT¡‹' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'other_fee' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ž[ØNё˜' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'act_fee' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ØN>k{|‹W{1:°sё,2:°‹&}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'pay_type' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'N¡RXT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'salesman' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~—{)Ype' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'account_day' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'®9/eØN{|‹W{1:(W¿~/eØN,2:'0RØN>k}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'post_fee_type' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'®9' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'post_fee' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ØN>köeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'pay_time' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÑS'öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'send_time' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'irAm Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'ship_name' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'irAmUS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'ship_code' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢‹US¶r`[man_order_log_settle]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'settle' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶r`{1:ck8^,0:y(u}' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'status' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûm RºNXT[sys_user]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'create_by' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûm Röeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'create_time' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºNXT[sys_user]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'update_by' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eöeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'update_time' 


GO 


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_order_log', @level2type=N'COLUMN',@level2name=N'memo' 


GO