ÿþ 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'ĉ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