sql-db.txt

某 房 产 公 司 售 楼 管 理 系 统

	[ro_id] [int] NOT NULL ,
	[do_id] [int] NOT NULL ,
	[ro_floor] [smallint] NOT NULL ,
	[ro_card] [char] (4) NOT NULL ,
	[ro_price] [real] NOT NULL ,
	[ro_totalprice] [numeric](10, 2) NOT NULL 
)
GO

CREATE TABLE [dbo].[temp_trait] (
	[trait_id] [int] NOT NULL ,
	[trait_doid] [int] NOT NULL ,
	[trait_layer] [smallint] NULL ,
	[trait_rotype] [smallint] NULL ,
	[trait_roform] [smallint] NULL ,
	[trait_way] [smallint] NULL ,
	[trait_area] [real] NULL ,
	[trait_memo] [char] (20) NULL ,
	[type_id] [smallint] NULL ,
	[form_id] [smallint] NULL ,
	[way_id] [smallint] NULL 
)
GO

CREATE TABLE [dbo].[type_agio] (
	[ty_id] [int] NOT NULL ,
	[ty_quotiety] [real] NULL ,
	[ty_type] [smallint] NULL ,
	[ty_agio] [real] NULL ,
	[ty_memo] [char] (10) NULL ,
	[ra_id] [int] NULL ,
	[do_id] [int] NULL 
)
GO

CREATE TABLE [dbo].[way_agio] (
	[way_id] [int] NOT NULL ,
	[way_quotiety] [real] NULL ,
	[way_way] [smallint] NULL ,
	[way_agio] [real] NULL ,
	[way_memo] [char] (10) NULL ,
	[ra_id] [int] NULL ,
	[do_id] [int] NULL 
)
GO

CREATE TABLE [dbo].[word_ole] (
	[word_id] [int] NOT NULL ,
	[word_name] [char] (40) NULL ,
	[word_oleobject] [text] NULL 
)
GO

ALTER TABLE [dbo].[employee] WITH NOCHECK ADD 
	CONSTRAINT [emid] PRIMARY KEY  CLUSTERED 
	(
		[em_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[adjust_price] WITH NOCHECK ADD 
	CONSTRAINT [adid] PRIMARY KEY  CLUSTERED 
	(
		[ad_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[adjust_range] WITH NOCHECK ADD 
	CONSTRAINT [rangeid] PRIMARY KEY  CLUSTERED 
	(
		[range_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[advertisement] WITH NOCHECK ADD 
	CONSTRAINT [adverid] PRIMARY KEY  CLUSTERED 
	(
		[adver_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[area_agio] WITH NOCHECK ADD 
	CONSTRAINT [arid] PRIMARY KEY  CLUSTERED 
	(
		[ar_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[bank] WITH NOCHECK ADD 
	CONSTRAINT [baid] PRIMARY KEY  CLUSTERED 
	(
		[ba_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[bank_list] WITH NOCHECK ADD 
	CONSTRAINT [listid] PRIMARY KEY  CLUSTERED 
	(
		[list_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[base_point] WITH NOCHECK ADD 
	CONSTRAINT [baseid] PRIMARY KEY  CLUSTERED 
	(
		[base_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[budget_list] WITH NOCHECK ADD 
	CONSTRAINT [budgetid] PRIMARY KEY  CLUSTERED 
	(
		[budget_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[building_item] WITH NOCHECK ADD 
	CONSTRAINT [itemid] PRIMARY KEY  CLUSTERED 
	(
		[item_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[door] WITH NOCHECK ADD 
	CONSTRAINT [doid] PRIMARY KEY  CLUSTERED 
	(
		[do_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[exchange_histroy] WITH NOCHECK ADD 
	CONSTRAINT [exid] PRIMARY KEY  CLUSTERED 
	(
		[ex_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[fit_item] WITH NOCHECK ADD 
	CONSTRAINT [fititemid] PRIMARY KEY  CLUSTERED 
	(
		[fititem_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[fit_stand] WITH NOCHECK ADD 
	CONSTRAINT [fitid] PRIMARY KEY  CLUSTERED 
	(
		[fit_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[form_agio] WITH NOCHECK ADD 
	CONSTRAINT [foid] PRIMARY KEY  CLUSTERED 
	(
		[fo_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[fund] WITH NOCHECK ADD 
	CONSTRAINT [fundid] PRIMARY KEY  CLUSTERED 
	(
		[fund_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[info] WITH NOCHECK ADD 
	CONSTRAINT [infid] PRIMARY KEY  CLUSTERED 
	(
		[inf_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[intent_client] WITH NOCHECK ADD 
	CONSTRAINT [intid] PRIMARY KEY  CLUSTERED 
	(
		[int_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[jkcolumn] WITH NOCHECK ADD 
	CONSTRAINT [cdbid] PRIMARY KEY  CLUSTERED 
	(
		[db_id],
		[col_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[jkreport] WITH NOCHECK ADD 
	CONSTRAINT [repid] PRIMARY KEY  CLUSTERED 
	(
		[rep_id],
		[db_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[jktable] WITH NOCHECK ADD 
	CONSTRAINT [tdbid] PRIMARY KEY  CLUSTERED 
	(
		[db_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[layer_agio] WITH NOCHECK ADD 
	CONSTRAINT [laid] PRIMARY KEY  CLUSTERED 
	(
		[la_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[market] WITH NOCHECK ADD 
	CONSTRAINT [marid] PRIMARY KEY  CLUSTERED 
	(
		[mar_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[other_data] WITH NOCHECK ADD 
	CONSTRAINT [dataid] PRIMARY KEY  CLUSTERED 
	(
		[data_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[parameter] WITH NOCHECK ADD 
	CONSTRAINT [paid] PRIMARY KEY  CLUSTERED 
	(
		[pa_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[pavilion] WITH NOCHECK ADD 
	CONSTRAINT [ppaid] PRIMARY KEY  CLUSTERED 
	(
		[pa_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[pay_event] WITH NOCHECK ADD 
	CONSTRAINT [evid] PRIMARY KEY  CLUSTERED 
	(
		[ev_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[pay_list] WITH NOCHECK ADD 
	CONSTRAINT [plistid] PRIMARY KEY  CLUSTERED 
	(
		[list_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[pay_mode] WITH NOCHECK ADD 
	CONSTRAINT [moid] PRIMARY KEY  CLUSTERED 
	(
		[mo_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[pay_project] WITH NOCHECK ADD 
	CONSTRAINT [payid] PRIMARY KEY  CLUSTERED 
	(
		[pay_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[press_button] WITH NOCHECK ADD 
	CONSTRAINT [prcode] PRIMARY KEY  CLUSTERED 
	(
		[pr_code]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[probation] WITH NOCHECK ADD 
	CONSTRAINT [proid] PRIMARY KEY  CLUSTERED 
	(
		[pro_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[purvey_list] WITH NOCHECK ADD 
	CONSTRAINT [purid] PRIMARY KEY  CLUSTERED 
	(
		[pur_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[rate_bank] WITH NOCHECK ADD 
	CONSTRAINT [rateid] PRIMARY KEY  CLUSTERED 
	(
		[rate_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[rate_project] WITH NOCHECK ADD 
	CONSTRAINT [raid] PRIMARY KEY  CLUSTERED 
	(
		[ra_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[real_number] WITH NOCHECK ADD 
	CONSTRAINT [realid] PRIMARY KEY  CLUSTERED 
	(
		[real_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[receive] WITH NOCHECK ADD 
	CONSTRAINT [recid] PRIMARY KEY  CLUSTERED 
	(
		[rec_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[right_regist] WITH NOCHECK ADD 
	CONSTRAINT [rightid] PRIMARY KEY  CLUSTERED 
	(
		[right_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[right_scale] WITH NOCHECK ADD 
	CONSTRAINT [riid] PRIMARY KEY  CLUSTERED 
	(
		[ri_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[room] WITH NOCHECK ADD 
	CONSTRAINT [roid] PRIMARY KEY  CLUSTERED 
	(
		[ro_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[room_form] WITH NOCHECK ADD 
	CONSTRAINT [formid] PRIMARY KEY  CLUSTERED 
	(
		[form_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[room_histroy] WITH NOCHECK ADD 
	CONSTRAINT [hisid] PRIMARY KEY  CLUSTERED 
	(
		[his_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[room_temp] WITH NOCHECK ADD 
	CONSTRAINT [tempid] PRIMARY KEY  CLUSTERED 
	(
		[temp_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[room_type] WITH NOCHECK ADD 
	CONSTRAINT [typeid] PRIMARY KEY  CLUSTERED 
	(
		[type_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[room_use] WITH NOCHECK ADD 
	CONSTRAINT [useid] PRIMARY KEY  CLUSTERED 
	(
		[use_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[room_way] WITH NOCHECK ADD 
	CONSTRAINT [wayid] PRIMARY KEY  CLUSTERED 
	(
		[way_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[roomtemp] WITH NOCHECK ADD 
	CONSTRAINT [rotid] PRIMARY KEY  CLUSTERED 
	(
		[ro_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[sign_client] WITH NOCHECK ADD 
	CONSTRAINT [signid] PRIMARY KEY  CLUSTERED 
	(
		[sign_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[simbank_list] WITH NOCHECK ADD 
	CONSTRAINT [simlid] PRIMARY KEY  CLUSTERED 
	(
		[siml_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[simpurery_list] WITH NOCHECK ADD 
	CONSTRAINT [simid] PRIMARY KEY  CLUSTERED 
	(
		[sim_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[subscribe] WITH NOCHECK ADD 
	CONSTRAINT [subid] PRIMARY KEY  CLUSTERED 
	(
		[sub_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[sys_log] WITH NOCHECK ADD 
	CONSTRAINT [sysid] PRIMARY KEY  CLUSTERED 
	(
		[sys_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[sys_parameter] WITH NOCHECK ADD 
	CONSTRAINT [psysid] PRIMARY KEY  CLUSTERED 
	(
		[sys_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[temp_price] WITH NOCHECK ADD 
	CONSTRAINT [troid] PRIMARY KEY  CLUSTERED 
	(
		[ro_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[temp_trait] WITH NOCHECK ADD 
	CONSTRAINT [traitid] PRIMARY KEY  CLUSTERED 
	(
		[trait_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[type_agio] WITH NOCHECK ADD 
	CONSTRAINT [tyid] PRIMARY KEY  CLUSTERED 
	(
		[ty_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[way_agio] WITH NOCHECK ADD 
	CONSTRAINT [awayid] PRIMARY KEY  CLUSTERED 
	(
		[way_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[word_ole] WITH NOCHECK ADD 
	CONSTRAINT [wordid] PRIMARY KEY  CLUSTERED 
	(
		[word_id]
	)  ON [PRIMARY] 
GO