sql-db.txt

某 房 产 公 司 售 楼 管 理 系 统

CREATE TABLE [dbo].[employee] (
	[em_id] [int] NOT NULL ,
	[em_code] [char] (10) NULL ,
	[em_name] [char] (12) NULL ,
	[em_pass] [char] (8) NULL ,
	[em_sex] [char] (1) NULL ,
	[em_birthday] [smalldatetime] NULL ,
	[em_department] [char] (10) NULL ,
	[em_duty] [char] (1) NULL ,
	[em_telephone] [char] (40) NULL ,
	[em_memo] [char] (30) NULL 
)
GO

CREATE TABLE [dbo].[adjust_price] (
	[ad_id] [int] NOT NULL ,
	[ad_name] [char] (20) NULL ,
	[ad_date] [smalldatetime] NULL ,
	[ad_scale] [real] NULL ,
	[ad_fixunit] [real] NULL ,
	[ad_fixtotal] [real] NULL ,
	[ad_fixdprice] [real] NULL ,
	[ad_mode] [char] (16) NULL ,
	[ad_range] [real] NULL 
)
GO

CREATE TABLE [dbo].[adjust_range] (
	[range_id] [int] NOT NULL ,
	[range_adid] [int] NULL ,
	[range_code] [smallint] NULL ,
	[range_doid] [int] NULL ,
	[range_lstart] [smallint] NULL ,
	[range_lend] [smallint] NULL ,
	[range_rstart] [char] (4) NULL ,
	[range_rend] [char] (4) NULL ,
	[range_memo] [char] (10) NULL ,
	[ad_id] [int] NOT NULL ,
	[do_id] [int] NOT NULL 
)
GO

CREATE TABLE [dbo].[advertisement] (
	[adver_id] [int] NOT NULL ,
	[adver_sort] [char] (20) NULL ,
	[adver_name] [char] (20) NULL ,
	[adver_address] [char] (16) NULL ,
	[adver_print] [char] (10) NULL ,
	[adver_time] [char] (10) NULL ,
	[adver_aim] [char] (30) NULL ,
	[adver_start] [smalldatetime] NULL ,
	[adver_end] [smalldatetime] NULL ,
	[adver_number] [int] NULL ,
	[adver_paadd] [char] (30) NULL ,
	[adver_memo1] [char] (30) NULL ,
	[adver_memo2] [char] (30) NULL ,
	[adver_memo3] [char] (30) NULL 
)
GO

CREATE TABLE [dbo].[area_agio] (
	[ar_id] [int] NOT NULL ,
	[ar_quotiety] [real] NULL ,
	[ar_area] [real] NULL ,
	[ar_agio] [real] NULL ,
	[ar_memo] [char] (10) NULL ,
	[ra_id] [int] NULL ,
	[do_id] [int] NULL 
)
GO

CREATE TABLE [dbo].[bank] (
	[ba_id] [smallint] NOT NULL ,
	[ba_name] [char] (30) NOT NULL ,
	[ba_sum] [numeric](13, 3) NULL ,
	[ba_memo] [char] (10) NULL 
)
GO

CREATE TABLE [dbo].[bank_list] (
	[list_id] [int] NOT NULL ,
	[list_signid] [int] NULL ,
	[list_purid] [int] NULL ,
	[list_code] [int] NULL ,
	[list_paydate] [smalldatetime] NULL ,
	[list_balance] [numeric](12, 5) NULL ,
	[list_principal] [real] NULL ,
	[list_rate] [real] NULL ,
	[list_sum] [real] NULL ,
	[list_memo] [int] NULL ,
	[sign_id] [int] NOT NULL 
)
GO

CREATE TABLE [dbo].[base_point] (
	[base_id] [int] NOT NULL ,
	[base_raid] [int] NULL ,
	[base_layer] [smallint] NULL ,
	[base_rotype] [smallint] NULL ,
	[base_roform] [smallint] NULL ,
	[base_way] [smallint] NULL ,
	[base_area] [real] NULL ,
	[base_memo] [char] (10) NULL ,
	[ra_id] [int] NOT NULL 
)
GO

CREATE TABLE [dbo].[budget_list] (
	[budget_id] [int] NOT NULL ,
	[budget_signid] [int] NULL ,
	[budget_purid] [int] NULL ,
	[budget_code] [int] NULL ,
	[budget_paydate] [smalldatetime] NULL ,
	[budget_money] [numeric](12, 3) NULL ,
	[budget_memo1] [char] (10) NULL ,
	[budget_memo2] [char] (10) NULL ,
	[sign_id] [int] NULL 
)
GO

CREATE TABLE [dbo].[building_item] (
	[item_id] [smallint] NOT NULL ,
	[item_code] [char] (6) NULL ,
	[item_name] [char] (20) NULL ,
	[item_mark] [char] (10) NULL ,
	[item_address] [char] (40) NULL ,
	[item_area] [numeric](10, 3) NULL ,
	[item_contract] [char] (30) NULL ,
	[item_use] [char] (1) NULL ,
	[item_start] [smalldatetime] NULL ,
	[item_end] [smalldatetime] NULL ,
	[item_allyear] [smallint] NULL ,
	[item_kind] [char] (10) NULL ,
	[item_frame] [char] (16) NULL ,
	[item_layer] [smallint] NULL ,
	[item_card] [char] (40) NULL ,
	[item_salein] [char] (40) NULL ,
	[item_saleout] [char] (40) NULL ,
	[item_watch] [char] (40) NULL ,
	[item_manage] [char] (40) NULL ,
	[item_demo1] [char] (40) NULL ,
	[item_demo2] [char] (40) NULL 
)
GO

CREATE TABLE [dbo].[door] (
	[do_id] [int] NOT NULL ,
	[do_paid] [int] NULL ,
	[do_code] [char] (6) NULL ,
	[do_name] [char] (10) NULL ,
	[do_totalprice] [numeric](13, 3) NULL ,
	[do_factprice] [numeric](13, 3) NULL ,
	[do_area] [real] NULL ,
	[do_roomnum] [int] NULL ,
	[do_average] [real] NULL ,
	[do_ceiling] [real] NULL ,
	[do_minimum] [real] NULL ,
	[do_tag] [char] (1) NULL ,
	[do_memo1] [char] (20) NULL ,
	[do_memo2] [char] (20) NULL ,
	[pa_id] [int] NOT NULL 
)
GO

CREATE TABLE [dbo].[exchange_histroy] (
	[ex_id] [int] NOT NULL ,
	[ex_roid] [int] NULL ,
	[ex_signid] [int] NULL ,
	[ex_state] [char] (1) NULL ,
	[ex_total] [numeric](12, 3) NULL ,
	[ex_paysort] [char] (30) NULL ,
	[ex_saleman] [char] (12) NULL ,
	[ex_reason] [char] (100) NULL ,
	[ro_id] [int] NOT NULL ,
	[sign_id] [int] NOT NULL ,
	[ex_paytotal] [numeric](10, 2) NULL ,
	[ex_charge] [real] NULL ,
	[ex_chargedate] [smalldatetime] NULL ,
	[ex_date] [smalldatetime] NULL ,
	[ex_currency] [char] (1) NULL ,
	[ex_man] [int] NULL ,
	[ex_billtype] [char] (1) NULL ,
	[ex_billcode] [char] (12) NULL ,
	[ex_tag] [char] (1) NULL ,
	[ex_fine] [real] NULL ,
	[ex_payback] [numeric](10, 2) NULL 
)
GO

CREATE TABLE [dbo].[fit_item] (
	[fititem_id] [int] NOT NULL ,
	[fititem_roid] [int] NULL ,
	[fititem_outwall] [char] (30) NULL ,
	[fititem_inwall] [char] (30) NULL ,
	[fititem_ceiling] [char] (30) NULL ,
	[fititem_ground] [char] (30) NULL ,
	[fititem_window] [char] (30) NULL ,
	[fititem_kitchen] [char] (30) NULL ,
	[fititem_toilet] [char] (30) NULL ,
	[fititem_balcony] [char] (30) NULL ,
	[fititem_elevator] [char] (30) NULL ,
	[fititem_other] [char] (30) NULL ,
	[fititem_memo] [char] (30) NULL ,
	[ro_id] [int] NULL ,
	[do_id] [int] NULL ,
	[pa_id] [int] NULL 
)
GO

CREATE TABLE [dbo].[fit_stand] (
	[fit_id] [smallint] NOT NULL ,
	[fit_name] [char] (20) NOT NULL ,
	[fit_price] [real] NULL ,
	[fit_memo] [char] (20) NULL 
)
GO

CREATE TABLE [dbo].[form_agio] (
	[fo_id] [int] NOT NULL ,
	[fo_quotiety] [real] NULL ,
	[fo_form] [smallint] NULL ,
	[fo_agio] [real] NULL ,
	[fo_memo] [char] (10) NULL ,
	[ra_id] [int] NULL ,
	[do_id] [int] NULL 
)
GO

CREATE TABLE [dbo].[fund] (
	[fund_id] [smallint] NOT NULL ,
	[fund_name] [char] (16) NULL ,
	[fund_memo] [char] (10) NULL 
)
GO

CREATE TABLE [dbo].[info] (
	[inf_id] [smallint] NOT NULL ,
	[inf_name] [char] (20) NULL ,
	[inf_memo] [char] (10) NULL 
)
GO

CREATE TABLE [dbo].[intent_client] (
	[int_id] [int] NOT NULL ,
	[int_paname] [char] (12) NULL ,
	[int_infoname] [smallint] NULL ,
	[int_date] [smalldatetime] NULL ,
	[int_name] [char] (32) NULL ,
	[int_metier] [char] (10) NULL ,
	[int_type] [char] (1) NULL ,
	[int_lawmen] [char] (12) NULL ,
	[int_sex] [char] (1) NULL ,
	[int_birthday] [smalldatetime] NULL ,
	[int_certif] [char] (10) NULL ,
	[int_card] [char] (20) NULL ,
	[int_native] [char] (20) NULL ,
	[int_telephone] [char] (18) NULL ,
	[int_mobile] [char] (18) NULL ,
	[int_bp] [char] (18) NULL ,
	[int_address] [char] (40) NULL ,
	[int_code] [char] (6) NULL ,
	[int_workunit] [char] (30) NULL ,
	[int_unittele] [char] (18) NULL ,
	[int_memo1] [char] (30) NULL ,
	[int_memo2] [char] (30) NULL ,
	[inf_id] [smallint] NULL 
)
GO

CREATE TABLE [dbo].[jkcolumn] (
	[db_id] [int] NOT NULL ,
	[col_id] [int] NOT NULL ,
	[col_ename] [char] (30) NOT NULL ,
	[col_cname] [char] (30) NOT NULL ,
	[col_type] [char] (6) NOT NULL ,
	[col_width] [smallint] NULL ,
	[col_dec] [smallint] NULL ,
	[col_list] [char] (10) NULL ,
	[col_mask] [char] (20) NULL ,
	[is_null] [numeric](1, 0) NOT NULL ,
	[is_primary] [numeric](1, 0) NOT NULL ,
	[is_view] [numeric](1, 0) NOT NULL ,
	[is_modify] [numeric](1, 0) NOT NULL ,
	[is_sys] [numeric](1, 0) NOT NULL ,
	[vol_colid] [smallint] NULL ,
	[col_multi] [smallint] NULL ,
	[is_dup] [smallint] NULL ,
	[is_add] [smallint] NULL ,
	[is_single] [numeric](1, 0) NOT NULL 
)
GO

CREATE TABLE [dbo].[jkreport] (
	[rep_id] [int] NOT NULL ,
	[db_id] [int] NOT NULL ,
	[rep_name] [char] (40) NOT NULL ,
	[rep_sql] [text] NOT NULL ,
	[rep_style] [char] (8) NOT NULL ,
	[is_sys] [numeric](1, 0) NOT NULL ,
	[rep_rows] [smallint] NULL 
)
GO

CREATE TABLE [dbo].[jktable] (
	[db_id] [int] NOT NULL ,
	[dbeng] [char] (20) NOT NULL ,
	[dbchin] [char] (40) NOT NULL ,
	[dbtype] [smallint] NOT NULL ,
	[dblock] [smallint] NOT NULL ,
	[dbvol] [smallint] NOT NULL ,
	[dbok] [smallint] NOT NULL ,
	[vol_dbid] [int] NULL 
)
GO

CREATE TABLE [dbo].[layer_agio] (
	[la_id] [int] NOT NULL ,
	[la_quotiety] [real] NULL ,
	[la_layer] [smallint] NULL ,
	[la_agio] [real] NULL ,
	[la_memo] [char] (10) NULL ,
	[ra_id] [int] NULL ,
	[do_id] [int] NULL 
)
GO

CREATE TABLE [dbo].[market] (
	[mar_id] [int] NOT NULL ,
	[mar_project] [char] (20) NULL ,
	[mar_type] [char] (20) NULL ,
	[mar_address] [char] (30) NULL ,
	[mar_area] [real] NULL ,
	[mar_builarea] [real] NULL ,
	[mar_finish] [smalldatetime] NULL ,
	[mar_pa] [smallint] NULL ,
	[mar_layer] [smallint] NULL ,
	[mar_form] [char] (30) NULL ,
	[mar_small] [real] NULL ,
	[mar_large] [real] NULL ,
	[mar_allunit] [int] NULL ,
	[mar_saleunit] [int] NULL ,
	[mar_saleway] [char] (30) NULL ,
	[mar_startprice] [real] NULL ,
	[mar_largeprice] [real] NULL ,
	[mar_avprice] [real] NULL ,
	[mar_develop] [char] (30) NULL ,
	[mar_saleman] [char] (30) NULL ,
	[mar_memo] [char] (30) NULL 
)
GO

CREATE TABLE [dbo].[other_data] (
	[data_id] [smallint] NOT NULL ,
	[data_itemid] [smallint] NULL ,
	[data_source] [char] (10) NULL ,
	[data_area] [numeric](10, 3) NULL ,
	[data_buildarea] [numeric](10, 3) NULL ,
	[data_virescence] [numeric](10, 3) NULL ,
	[data_fundus] [numeric](10, 3) NULL ,
	[data_fundusscale] [real] NULL ,
	[data_public] [numeric](10, 3) NULL ,
	[data_publicscale] [real] NULL ,
	[data_cubage] [real] NULL ,
	[data_utility] [real] NULL ,
	[data_carport] [int] NULL ,
	[data_start] [smalldatetime] NULL ,
	[data_attend] [smalldatetime] NULL ,
	[data_house] [int] NULL ,
	[data_invest] [char] (30) NULL ,
	[data_total] [numeric](10, 3) NULL ,
	[data_continue] [char] (30) NULL ,
	[data_memo1] [char] (10) NULL ,
	[data_memo2] [char] (10) NULL ,
	[item_id] [smallint] NOT NULL 
)
GO

CREATE TABLE [dbo].[parameter] (
	[pa_id] [int] NOT NULL ,
	[pa_mantissa] [char] (1) NOT NULL 
)
GO

CREATE TABLE [dbo].[pavilion] (
	[pa_id] [int] NOT NULL ,
	[pa_itemid] [smallint] NULL ,
	[pa_code] [char] (6) NULL ,
	[pa_name] [char] (12) NULL ,
	[pa_level] [char] (6) NULL ,
	[pa_mark] [char] (10) NULL ,
	[pa_area] [real] NULL ,
	[pa_totalprice] [numeric](13, 3) NULL ,
	[pa_factprice] [numeric](13, 3) NULL ,
	[pa_salearea] [numeric](10, 3) NULL ,
	[pa_roomnum] [int] NULL ,
	[pa_average] [real] NULL ,
	[pa_ceiling] [real] NULL ,
	[pa_minimum] [real] NULL ,
	[pa_card] [char] (20) NULL ,
	[pa_contract] [char] (30) NULL ,
	[pa_use] [char] (1) NULL ,
	[pa_start] [smalldatetime] NULL ,
	[pa_end] [smalldatetime] NULL ,
	[pa_allyear] [int] NULL ,
	[pa_kind] [char] (10) NULL ,
	[pa_frame] [char] (16) NULL ,
	[pa_layer] [smallint] NULL ,
	[pa_work] [smalldatetime] NULL ,
	[pa_finish] [smalldatetime] NULL ,
	[pa_attend] [smalldatetime] NULL ,
	[pa_watch] [char] (40) NULL ,
	[pa_memo1] [char] (40) NULL ,
	[pa_memo2] [char] (20) NULL ,
	[item_id] [smallint] NOT NULL 
)
GO

CREATE TABLE [dbo].[pay_event] (
	[ev_id] [smallint] NOT NULL ,
	[ev_name] [char] (12) NULL ,
	[ev_memo] [char] (10) NULL 
)
GO

CREATE TABLE [dbo].[pay_list] (
	[list_id] [int] NOT NULL ,
	[list_serial] [smallint] NULL ,
	[list_payid] [int] NULL ,
	[list_voiddate] [smallint] NULL ,
	[list_day] [smallint] NULL ,
	[list_specify] [smalldatetime] NULL ,
	[list_month] [smallint] NULL ,
	[list_affair] [char] (1) NOT NULL ,
	[list_fund] [smallint] NULL ,
	[list_scale] [real] NULL ,
	[list_sum] [numeric](12, 3) NULL ,
	[list_currenty] [char] (1) NULL ,
	[list_stage] [int] NULL ,
	[list_mday] [smallint] NULL ,
	[list_space] [smallint] NULL ,
	[list_tag] [char] (1) NULL ,
	[list_memo] [char] (20) NULL ,
	[fund_id] [smallint] NOT NULL ,
	[ev_id] [smallint] NOT NULL ,
	[pay_id] [int] NOT NULL 
)
GO

CREATE TABLE [dbo].[pay_mode] (
	[mo_id] [smallint] NOT NULL ,
	[mo_name] [char] (26) NULL ,
	[mo_memo] [char] (10) NULL 
)
GO

CREATE TABLE [dbo].[pay_project] (
	[pay_id] [int] NOT NULL ,
	[pay_moid] [smallint] NULL ,
	[pay_agio] [real] NULL ,
	[pay_start] [smalldatetime] NULL ,
	[pay_bound] [char] (30) NULL ,
	[pay_baid] [smallint] NULL ,