init

luxiaotao1123

2021-11-17 85d878b12d6988ca2275d60e7da0ec31814f8fc8

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
ÿþ 
GO 
/****** Object:  Table [dbo].[man_pakin]    Script Date: 2021/4/26 11:15:17 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
SET ANSI_PADDING ON 
GO 
CREATE TABLE [dbo].[man_pakin]( 
    [wrk_no] [varchar](255) NOT NULL, 
    [wrk_sts] [bigint] NULL, 
    [zpallet] [varchar](255) NULL, 
    [anfme] [decimal](24, 9) NULL, 
    [node_id] [bigint] NOT NULL, 
    [loc_no] [varchar](255) NOT NULL, 
    [matnr] [varchar](255) NOT 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, 
    [doc_id] [bigint] NULL, 
    [doc_num] [varchar](255) NULL, 
    [cust_name] [varchar](50) NULL, 
    [item_num] [int] NULL, 
    [count] [int] 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, 
 CONSTRAINT [PK_man_pakin_1] PRIMARY KEY CLUSTERED  
( 
    [wrk_no] ASC, 
    [node_id] ASC, 
    [matnr] 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 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'wrk_no' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'å]\O¶r
`[man_wrk_sts]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'wrk_sts' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'zpallet' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'anfme' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'sQT€'MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'node_id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'loc_no' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'FUÁT
x' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @level2type=N'COLUMN',@level2name=N'unit' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SKC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'barcode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'doc_id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'doc_num' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢[7b Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'man_pakin', @level2type=N'COLUMN',@level2name=N'cust_name' 
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_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @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_pakin', @level2type=N'COLUMN',@level2name=N'memo' 
GO