📄 sql-db.txt
字号:
[pay_byrate] [real] NULL ,
[pay_bmrate] [real] NULL ,
[pay_inyrate] [real] NULL ,
[pay_inmrate] [real] NULL ,
[pay_way] [char] (1) NULL ,
[pay_precision] [char] (1) NULL ,
[pay_memo1] [char] (10) NULL ,
[pay_memo2] [char] (30) NULL ,
[mo_id] [smallint] NOT NULL ,
[ba_id] [smallint] NULL ,
[rate_id] [smallint] NULL
)
GO
CREATE TABLE [dbo].[pbcatcol] (
[pbc_tnam] [char] (30) NULL ,
[pbc_tid] [int] NULL ,
[pbc_ownr] [char] (30) NULL ,
[pbc_cnam] [char] (30) NULL ,
[pbc_cid] [smallint] NULL ,
[pbc_labl] [varchar] (254) NULL ,
[pbc_lpos] [smallint] NULL ,
[pbc_hdr] [varchar] (254) NULL ,
[pbc_hpos] [smallint] NULL ,
[pbc_jtfy] [smallint] NULL ,
[pbc_mask] [varchar] (31) NULL ,
[pbc_case] [smallint] NULL ,
[pbc_hght] [smallint] NULL ,
[pbc_wdth] [smallint] NULL ,
[pbc_ptrn] [varchar] (31) NULL ,
[pbc_bmap] [char] (1) NULL ,
[pbc_init] [varchar] (254) NULL ,
[pbc_cmnt] [varchar] (254) NULL ,
[pbc_edit] [varchar] (31) NULL ,
[pbc_tag] [varchar] (254) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[pbcatedt] (
[pbe_name] [varchar] (30) NOT NULL ,
[pbe_edit] [varchar] (254) NULL ,
[pbe_type] [smallint] NOT NULL ,
[pbe_cntr] [int] NULL ,
[pbe_seqn] [smallint] NOT NULL ,
[pbe_flag] [int] NULL ,
[pbe_work] [char] (32) NULL
)
GO
CREATE TABLE [dbo].[pbcatfmt] (
[pbf_name] [varchar] (30) NOT NULL ,
[pbf_frmt] [varchar] (254) NOT NULL ,
[pbf_type] [smallint] NOT NULL ,
[pbf_cntr] [int] NULL
)
GO
CREATE TABLE [dbo].[pbcattbl] (
[pbt_tnam] [char] (30) NULL ,
[pbt_tid] [int] NULL ,
[pbt_ownr] [char] (30) NULL ,
[pbd_fhgt] [smallint] NULL ,
[pbd_fwgt] [smallint] NULL ,
[pbd_fitl] [char] (1) NULL ,
[pbd_funl] [char] (1) NULL ,
[pbd_fchr] [smallint] NULL ,
[pbd_fptc] [smallint] NULL ,
[pbd_ffce] [char] (32) NULL ,
[pbh_fhgt] [smallint] NULL ,
[pbh_fwgt] [smallint] NULL ,
[pbh_fitl] [char] (1) NULL ,
[pbh_funl] [char] (1) NULL ,
[pbh_fchr] [smallint] NULL ,
[pbh_fptc] [smallint] NULL ,
[pbh_ffce] [char] (32) NULL ,
[pbl_fhgt] [smallint] NULL ,
[pbl_fwgt] [smallint] NULL ,
[pbl_fitl] [char] (1) NULL ,
[pbl_funl] [char] (1) NULL ,
[pbl_fchr] [smallint] NULL ,
[pbl_fptc] [smallint] NULL ,
[pbl_ffce] [char] (32) NULL ,
[pbt_cmnt] [varchar] (254) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[pbcatvld] (
[pbv_name] [varchar] (30) NOT NULL ,
[pbv_vald] [varchar] (254) NOT NULL ,
[pbv_type] [smallint] NOT NULL ,
[pbv_cntr] [int] NULL ,
[pbv_msg] [varchar] (254) NULL
)
GO
CREATE TABLE [dbo].[press_button] (
[pr_code] [smallint] NOT NULL ,
[pr_button] [smallint] NOT NULL
)
GO
CREATE TABLE [dbo].[probation] (
[pro_id] [int] NOT NULL ,
[pro_first] [smalldatetime] NOT NULL ,
[pro_last] [smalldatetime] NOT NULL ,
[pro_times] [smallint] NOT NULL ,
[pro_count] [int] NOT NULL ,
[pro_true] [char] (1) NOT NULL
)
GO
CREATE TABLE [dbo].[purvey_list] (
[pur_id] [int] NOT NULL ,
[pur_signid] [int] NULL ,
[pur_code] [smallint] NULL ,
[pur_paydate] [smalldatetime] NULL ,
[pur_itemname] [char] (16) NULL ,
[pur_scale] [real] NULL ,
[pur_sum] [numeric](10, 3) NULL ,
[pur_currency] [char] (1) NULL ,
[pur_memo] [char] (10) NULL ,
[sign_id] [int] NOT NULL ,
[fund_id] [smallint] NOT NULL
)
GO
CREATE TABLE [dbo].[rate_bank] (
[rate_id] [smallint] NOT NULL ,
[rate_baid] [smallint] NULL ,
[rate_term] [int] NULL ,
[rate_mrate] [real] NULL ,
[rate_yrate] [real] NULL ,
[rate_way] [char] (1) NULL ,
[rate_memo] [char] (20) NULL ,
[ba_id] [smallint] NOT NULL
)
GO
CREATE TABLE [dbo].[rate_project] (
[ra_id] [int] NOT NULL ,
[ra_project] [char] (20) NOT NULL ,
[ra_doid] [int] NULL ,
[ra_date] [smalldatetime] NULL ,
[ra_area] [real] NULL ,
[ra_base] [real] NULL ,
[ra_average] [real] NULL ,
[ra_total] [numeric](12, 5) NULL ,
[ra_way] [char] (1) NULL ,
[ra_memo] [char] (20) NULL ,
[do_id] [int] NOT NULL
)
GO
CREATE TABLE [dbo].[real_number] (
[real_id] [int] NOT NULL ,
[real_roid] [int] NULL ,
[real_signid] [int] NULL ,
[real_code] [int] NULL ,
[real_paydate] [smalldatetime] NULL ,
[real_itemname] [char] (16) NULL ,
[real_paytype] [char] (10) NULL ,
[real_money] [numeric](12, 3) NULL ,
[real_currency] [char] (1) NULL ,
[real_rate] [real] NULL ,
[real_convert] [numeric](12, 3) NULL ,
[real_billtype] [char] (1) NULL ,
[real_billcode] [char] (16) NULL ,
[real_payman] [char] (10) NULL ,
[real_receiveman] [char] (10) NULL ,
[real_histroy] [char] (1) NULL ,
[real_memo] [char] (20) NULL ,
[sign_id] [int] NOT NULL ,
[fund_id] [smallint] NOT NULL ,
[em_id] [int] NOT NULL
)
GO
CREATE TABLE [dbo].[receive] (
[rec_id] [int] NOT NULL ,
[rec_roid] [int] NULL ,
[rec_signid] [int] NULL ,
[rec_code] [int] NULL ,
[rec_paydate] [smalldatetime] NULL ,
[rec_itemname] [char] (16) NULL ,
[rec_money] [numeric](13, 3) NULL ,
[rec_currency] [char] (1) NULL ,
[rec_balance] [numeric](13, 3) NULL ,
[rec_latefee] [numeric](10, 3) NULL ,
[rec_tag] [char] (4) NULL ,
[rec_memo] [char] (10) NULL ,
[sign_id] [int] NOT NULL ,
[fund_id] [smallint] NOT NULL
)
GO
CREATE TABLE [dbo].[right_regist] (
[right_id] [int] NOT NULL ,
[right_paname] [char] (30) NULL ,
[right_rocode] [char] (14) NULL ,
[right_signname] [char] (32) NULL ,
[right_unitprice] [real] NULL ,
[right_totalprice] [numeric](12, 3) NULL ,
[right_currency] [char] (1) NULL ,
[right_uniform] [char] (16) NULL ,
[right_general] [real] NULL ,
[right_manage] [real] NULL ,
[right_stamptax] [real] NULL ,
[right_other] [real] NULL ,
[right_give] [smalldatetime] NULL ,
[right_pass] [smalldatetime] NULL ,
[right_realtycode] [char] (16) NULL ,
[right_incommon] [char] (16) NULL ,
[right_drawdate] [smalldatetime] NULL ,
[right_drawman] [char] (10) NULL ,
[right_idcard] [char] (18) NULL ,
[right_memo1] [char] (20) NULL ,
[right_memo2] [char] (10) NULL ,
[right_memo3] [char] (10) NULL ,
[sign_id] [int] NULL
)
GO
CREATE TABLE [dbo].[right_scale] (
[ri_id] [int] NOT NULL ,
[ri_itemname] [char] (14) NULL ,
[ri_way] [char] (6) NULL ,
[ri_parameter] [real] NULL ,
[ri_memo] [char] (10) NULL
)
GO
CREATE TABLE [dbo].[room] (
[ro_id] [int] NOT NULL ,
[ro_temp] [real] NULL ,
[ro_code] [char] (14) NULL ,
[ro_floor] [smallint] NULL ,
[ro_card] [char] (4) NULL ,
[ro_tablet] [char] (10) NULL ,
[ro_form] [smallint] NULL ,
[ro_type] [smallint] NULL ,
[ro_use] [smallint] NULL ,
[ro_way] [smallint] NULL ,
[ro_buildarea] [real] NULL ,
[ro_measure] [real] NULL ,
[ro_usearea] [real] NULL ,
[ro_fitment] [smallint] NULL ,
[ro_fitprice] [real] NULL ,
[ro_fittotal] [real] NULL ,
[ro_prepare] [char] (40) NULL ,
[ro_price] [real] NULL ,
[ro_total] [numeric](12, 3) NULL ,
[ro_currency] [char] (1) NULL ,
[ro_salestate] [char] (1) NOT NULL ,
[ro_right] [char] (1) NOT NULL ,
[ro_map] [char] (40) NULL ,
[ro_memo1] [char] (40) NULL ,
[ro_memo2] [char] (40) NULL ,
[do_id] [int] NOT NULL ,
[form_id] [smallint] NOT NULL ,
[type_id] [smallint] NULL ,
[use_id] [smallint] NULL ,
[way_id] [smallint] NOT NULL ,
[fit_id] [smallint] NULL ,
[ro_clientname] [char] (32) NULL
)
GO
CREATE TABLE [dbo].[room_form] (
[form_id] [smallint] NOT NULL ,
[form_name] [char] (10) NOT NULL ,
[form_memo] [char] (10) NULL
)
GO
CREATE TABLE [dbo].[room_histroy] (
[his_id] [int] NOT NULL ,
[his_roid] [int] NULL ,
[his_date] [smalldatetime] NULL ,
[his_price] [real] NULL ,
[his_total] [numeric](10, 3) NULL ,
[his_bargain] [numeric](10, 3) NULL ,
[his_memo] [char] (10) NULL ,
[ro_id] [int] NOT NULL ,
[do_id] [int] NOT NULL
)
GO
CREATE TABLE [dbo].[room_temp] (
[temp_id] [int] NOT NULL ,
[temp_code] [smallint] NULL ,
[temp_lsl] [smallint] NULL ,
[temp_lel] [smallint] NULL ,
[temp_rs] [char] (4) NULL ,
[temp_re] [char] (4) NULL ,
[temp_tag] [char] (1) NULL ,
[temp_barea] [real] NULL ,
[temp_uarea] [real] NULL ,
[temp_memo] [char] (20) NULL ,
[do_id] [int] NOT NULL ,
[way_id] [smallint] NULL ,
[form_id] [smallint] NULL ,
[type_id] [smallint] NULL
)
GO
CREATE TABLE [dbo].[room_type] (
[type_id] [smallint] NOT NULL ,
[type_name] [char] (10) NOT NULL ,
[type_memo] [char] (10) NULL
)
GO
CREATE TABLE [dbo].[room_use] (
[use_id] [smallint] NOT NULL ,
[use_name] [char] (10) NOT NULL ,
[use_memo] [char] (10) NULL
)
GO
CREATE TABLE [dbo].[room_way] (
[way_id] [smallint] NOT NULL ,
[way_name] [char] (10) NOT NULL ,
[way_memo] [char] (10) NULL
)
GO
CREATE TABLE [dbo].[roomtemp] (
[ro_id] [int] NOT NULL ,
[ro_code] [char] (14) NULL ,
[ro_floor] [smallint] NULL ,
[ro_card] [char] (4) NULL ,
[ro_tablet] [char] (10) NULL ,
[ro_buildarea] [real] NULL ,
[ro_usearea] [real] NULL ,
[ro_salestate] [char] (1) NOT NULL ,
[ro_right] [char] (1) NOT NULL ,
[do_id] [int] NOT NULL ,
[form_id] [smallint] NOT NULL ,
[type_id] [smallint] NULL ,
[use_id] [smallint] NULL ,
[way_id] [smallint] NOT NULL
)
GO
CREATE TABLE [dbo].[sign_client] (
[sign_id] [int] NOT NULL ,
[sign_roid] [int] NULL ,
[sign_infoid] [smallint] NULL ,
[sign_name] [char] (32) NULL ,
[sign_metier] [char] (10) NULL ,
[sign_type] [char] (1) NULL ,
[sign_lawmen] [char] (12) NULL ,
[sign_sex] [char] (1) NULL ,
[sign_birthday] [smalldatetime] NULL ,
[sign_certif] [char] (10) NULL ,
[sign_card] [char] (20) NULL ,
[sign_native] [char] (20) NULL ,
[sign_telephone] [char] (18) NULL ,
[sign_mobile] [char] (18) NULL ,
[sign_bp] [char] (18) NULL ,
[sign_address] [char] (40) NULL ,
[sign_code] [char] (6) NULL ,
[sign_workunit] [char] (30) NULL ,
[sign_unittele] [char] (18) NULL ,
[sign_memo1] [char] (30) NULL ,
[sign_memo2] [char] (30) NULL ,
[inf_id] [smallint] NULL ,
[ro_id] [int] NOT NULL
)
GO
CREATE TABLE [dbo].[simbank_list] (
[siml_id] [int] NOT NULL ,
[siml_date] [smalldatetime] NULL ,
[siml_balance] [numeric](12, 5) NULL ,
[siml_principal] [real] NULL ,
[siml_rate] [real] NULL ,
[siml_sum] [real] NULL ,
[siml_memo] [char] (10) NULL
)
GO
CREATE TABLE [dbo].[simpurery_list] (
[sim_id] [int] NOT NULL ,
[sim_data] [smalldatetime] NULL ,
[sim_scale] [real] NULL ,
[sim_sum] [numeric](10, 3) NULL ,
[sim_currency] [char] (1) NULL ,
[sim_memo] [char] (10) NULL ,
[fund_id] [smallint] NOT NULL
)
GO
CREATE TABLE [dbo].[subscribe] (
[sub_id] [int] NOT NULL ,
[sub_singid] [int] NULL ,
[sub_target] [smalldatetime] NULL ,
[sub_targetcode] [char] (10) NULL ,
[sub_useful] [smalldatetime] NULL ,
[sub_earnest] [real] NULL ,
[sub_subscribe] [smalldatetime] NULL ,
[sub_subcard] [char] (10) NULL ,
[sub_subearnest] [real] NULL ,
[sub_currency] [char] (1) NULL ,
[sub_rate] [real] NULL ,
[sub_convert] [real] NULL ,
[sub_receipt] [char] (10) NULL ,
[sub_saleman] [char] (12) NULL ,
[sub_payment] [int] NULL ,
[sub_favour] [real] NULL ,
[sub_rebate] [real] NULL ,
[sub_price] [real] NULL ,
[sub_total] [numeric](12, 3) NULL ,
[sub_memo1] [char] (20) NULL ,
[sub_agio] [real] NULL ,
[sub_contotal] [numeric](12, 3) NULL ,
[sub_inkdate] [smalldatetime] NULL ,
[sub_concode] [char] (10) NULL ,
[sub_consort] [char] (1) NULL ,
[sub_handle] [char] (12) NULL ,
[sub_credit] [numeric](12, 3) NULL ,
[sub_bank] [char] (30) NULL ,
[sub_creditbank] [numeric](12, 3) NULL ,
[sub_fund] [numeric](12, 3) NULL ,
[sub_month] [int] NULL ,
[sub_mrate] [real] NULL ,
[sub_notariz] [char] (1) NULL ,
[sub_creditif] [char] (1) NULL ,
[sub_bankfund] [char] (1) NULL ,
[sub_term] [smalldatetime] NULL ,
[sub_creditdate] [smalldatetime] NULL ,
[sub_bankdate] [smalldatetime] NULL ,
[sub_memo2] [char] (30) NULL ,
[sign_id] [int] NOT NULL ,
[pay_id] [int] NULL
)
GO
CREATE TABLE [dbo].[sys_log] (
[sys_id] [int] NOT NULL ,
[sys_opmen] [char] (12) NULL ,
[sys_start] [datetime] NULL ,
[sys_winname] [char] (40) NULL ,
[sys_end] [datetime] NULL ,
[sys_memo] [char] (30) NULL
)
GO
CREATE TABLE [dbo].[sys_parameter] (
[sys_id] [int] NOT NULL ,
[sys_name] [char] (16) NULL ,
[sys_value] [char] (10) NULL ,
[sys_single] [char] (1) NULL ,
[sys_much] [char] (1) NULL ,
[sys_bake] [char] (1) NULL ,
[sys_memo1] [char] (6) NULL ,
[sys_memo2] [char] (6) NULL ,
[sys_memo3] [char] (6) NULL
)
GO
CREATE TABLE [dbo].[temp_price] (
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -