ÿþ

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'Ä<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'ÁType' , @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

