
CREATE TABLE table_100 (
  keys  binary(2) PRIMARY KEY,
  data  binary(60) NOT NULL
)
GO
CREATE TABLE table_101 (
  keys  binary(2) PRIMARY KEY,
  data  binary(32) NOT NULL
)
GO
CREATE TABLE table_102 (
  keys  binary(4) PRIMARY KEY,
  data  binary(2800) NOT NULL
)
GO
CREATE TABLE table_103 (
  keys  binary(2) PRIMARY KEY,
  data  binary(32) NOT NULL
)
GO
CREATE TABLE table_104 (
  keys  binary(4) PRIMARY KEY,
  data  binary(100) NOT NULL
)
GO
CREATE TABLE table_105 (
  keys  binary(2) PRIMARY KEY,
  data  binary(32) NOT NULL
)
GO
CREATE TABLE table_106 (
  keys  binary(2) PRIMARY KEY,
  data  binary(4) NOT NULL
)
GO
CREATE TABLE table_107 (
  keys  binary(6) PRIMARY KEY,
  data  binary(4) NOT NULL
)
GO
CREATE TABLE table_108 (
  keys  binary(4) PRIMARY KEY,
  data  binary(2836) NOT NULL
)
GO
CREATE TABLE table_109 (
  keys  binary(2) PRIMARY KEY,
  data  binary(32) NOT NULL
)
GO
CREATE TABLE table_110 (
  keys  binary(2) PRIMARY KEY,
  data  binary(12) NOT NULL
)
GO




CREATE TABLE [dbo].[table_1000] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[hykh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hyxm] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Xb] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ccrq] [datetime] NULL ,
	[Dwzy] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yddh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dzyj] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zjhm] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Lxdz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Qtxx] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Jrrq] [datetime] NULL ,
	[Klxid] [int] NULL ,
	[Hyjbid] [int] NULL ,
	[Xfze] [real] NULL ,
	[Xfye] [real] NULL ,
	[Hyjf] [real] NULL ,
	[Dqjf] [real] NULL ,
	[Hykzt] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[czy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[table_1001] (
	[klxid] [int] NOT NULL ,
	[klxmc] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[kbz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[table_1002] (
	[yhjbid] [int] NOT NULL ,
	[klxid] [int] NOT NULL ,
	[yhmc] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Yhl] [real] NOT NULL ,
	[Dzsj] [real] NOT NULL ,
	[Yhbz] [char] (200) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[table_1003] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Ykh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[xkh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[hksj] [datetime] NULL ,
	[hkyy] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[czy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[hkbz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TABLE_1004] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[klxid] [int] NULL ,
	[hykh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[xfje] [real] NULL ,
	[hdjf] [real] NULL ,
	[xfsj] [datetime] NULL ,
	[czy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[xfbz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[xffs] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TABLE_1005] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[hykh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[czje] [real] NULL ,
	[yje] [real] NULL ,
	[xje] [real] NULL ,
	[yhjs] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[czsj] [datetime] NULL ,
	[czy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[czbz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[table_1006] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[hykh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[dhjf] [real] NULL ,
	[dhsj] [datetime] NULL ,
	[czy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[dhbz] [char] (300) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[table_1007] (
	[id] [int] NOT NULL ,
	[czy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[czyxm] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[czymm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[czyzt] [int] NULL ,
	[czybz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TABLE_1008] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[czmc] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[czrs] [int] NULL ,
	[czbz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TABLE_1009] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[czid] [int] NULL ,
	[yyrq] [datetime] NULL ,
	[yysjd] [int] NULL ,
	[yyr] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[yyrdh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[yyrs] [int] NULL ,
	[yybz] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[table_1000] WITH NOCHECK ADD 
	CONSTRAINT [PK_table_1000] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[table_1001] WITH NOCHECK ADD 
	CONSTRAINT [PK_table_1001] PRIMARY KEY  CLUSTERED 
	(
		[klxid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[table_1002] WITH NOCHECK ADD 
	CONSTRAINT [PK_table_1002] PRIMARY KEY  CLUSTERED 
	(
		[yhjbid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[table_1003] WITH NOCHECK ADD 
	CONSTRAINT [PK_table_1003] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TABLE_1004] WITH NOCHECK ADD 
	CONSTRAINT [PK_TABLE_1004] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TABLE_1005] WITH NOCHECK ADD 
	CONSTRAINT [PK_TABLE_1005] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[table_1006] WITH NOCHECK ADD 
	CONSTRAINT [PK_table_1006] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[table_1007] WITH NOCHECK ADD 
	CONSTRAINT [PK_table_1007] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TABLE_1008] WITH NOCHECK ADD 
	CONSTRAINT [PK_TABLE_1008] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TABLE_1009] WITH NOCHECK ADD 
	CONSTRAINT [PK_TABLE_1009] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

