CREATE TABLE [dbo].[DHU_inplane](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[in_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[in_khid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[in_khname] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[in_ware] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[In_idate] [datetime] NULL,
	[In_fee] [decimal](9, 3) NULL,
	[In_date] [datetime] NULL,
	[in_TEL] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[to_name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[To_tel] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[to_address] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[IN_man] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[in_person] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[in_volume] [decimal](9, 3) NULL,
	[in_weight] [decimal](9, 3) NULL,
	[in_allnum] [decimal](9, 3) NULL,
	[in_fp] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[in_bz] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[In_jdate] [datetime] NULL,
	[to_addrtess] [nvarchar](502) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_DHU_inplane] PRIMARY KEY CLUSTERED 
(
	[in_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


CREATE TABLE [dbo].[DHU_ingoods](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[in_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[goo_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[goo_name] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[goo_XH] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[goo_inum] [decimal](9, 3) NULL,
	[goo_dan] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[Goo_weight] [decimal](9, 3) NULL,
	[Goo_volume] [decimal](9, 3) NULL,
	[Goo_dj] [decimal](9, 3) NULL,
	[GOO_BZ] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[goo_jnum] [numeric](10, 2) NULL,
 CONSTRAINT [PK_DHU_ingoods_1] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


CREATE TABLE [dbo].[Dhu_WARE](
	[id] [int] NULL,
	[ware_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ware_name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ware_address] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[ware_type] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ware_man] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ware_addrtess] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

CREATE TABLE [dbo].[DHU_customer](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[cu_id] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[cu_name] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[cu_address] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[cu_type] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[CU_TEL] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[CU_EMAIL] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[CU_man] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[CU_JC] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_DHU_customer1] PRIMARY KEY CLUSTERED 
(
	[cu_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF