GO
CREATE TABLE [dbo].[ZL_Orderinfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[OrderNo] [varchar](50) NULL,
[Reuser] [varchar](255) NULL,
[Receiver] [varchar](50) NULL,
[Rename] [varchar](255) NULL,
[Guojia] [varchar](255) NULL,
[Shengfen] [varchar](255) NULL,
[Chengshi] [varchar](255) NULL,
[Diqu] [varchar](255) NULL,
[Jiedao] [varchar](255) NULL,
[ZipCode] [varchar](50) NULL,
[Phone] [varchar](50) NULL,
[Email] [varchar](50) NULL,
[Mobile] [int] NULL,
[Delivery] [int] NULL,
[Outstock] [int] NULL,
[Deliverytime] [int] NULL,
[Payment] [int] NULL,
[Invoice] [varchar](2000) NULL,
[Ordermessage] [text] NULL,
[Merchandiser] [varchar](50) NULL,
[Internalrecords] [text] NULL,
[Ordersamount] [money] NULL,
[Receivablesamount] [money] NULL,
[Specifiedprice] [money] NULL,
[Freight] [money] NULL,
[Invoiceneeds] [int] NULL,
[Developedvotes] [int] NULL,
[OrderStatus] [int] NULL,
[Paymentstatus] [int] NULL,
[StateLogistics] [int] NULL,
[Signed] [int] NULL CONSTRAINT [DF_ZL_Orderinfo_Signed]  DEFAULT (0),
[Settle] [int] NULL CONSTRAINT [DF_ZL_Orderinfo_Settle]  DEFAULT (0),
[Aside] [int] NULL CONSTRAINT [DF_ZL_Orderinfo_aside]  DEFAULT (0),
[Suspended] [int] NULL CONSTRAINT [DF_ZL_Orderinfo_Suspended]  DEFAULT (0),
[Ordertype] [int] NULL CONSTRAINT [DF_ZL_Orderinfo_Ordertype]  DEFAULT (0),
[AddTime] [datetime] NULL CONSTRAINT [DF_ZL_Orderinfo_AddTime]  DEFAULT (getdate()),
[AddUser] [varchar](255) NULL,
[Userid] [int] NULL,
[city] [nvarchar](50) NULL,
[IsCount] [bit] NULL CONSTRAINT [DF_ZL_Orderinfo_IsCount]  DEFAULT (0),
[Integral] [int] NULL DEFAULT (0),
[parentID] [int] NULL DEFAULT (0),
[service_charge] [float] NULL ,
[Balance_price] [float] NULL ,
[Freight_remark] [nvarchar](1000) null,
[Balance_remark][nvarchar](1000) null,
[Money_rate] [money] null DEFAULT (1),
[Money_code] [varchar] (4) null,
[MobileNum] [nvarchar] (20) NULL ,
[ExpressDelivery] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[InvoType] [int] NULL,
[Promoter] [int] NULL,
[ExpressNum] [varchar](400) null,
[Company] [nvarchar] (400) null,
[SendPointStatus] [int] NULL DEFAULT (0),
[Province] [nvarchar]  NULL,
[Extend] [ntext]  NULL,
[StoreID] [int] NULL DEFAULT (0),
[AllMoney_Json] [nvarchar](500) NULL,
[PaymentNo] [nvarchar](500) NULL,
[ExpTime] [nvarchar](500) NULL,
[IsSure] [int] NULL,
[BackID] [int] NULL,
CONSTRAINT [PK_ZL_Orderinfo] PRIMARY KEY CLUSTERED
([ID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]