ÿþ 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ÁTx' , @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'ĉ