ÿþ

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'¢USQx[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'ÁType' , @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

