CRM数据库表结构

1、产品信息表product序列名数据类型长度允许空1prod_idbigintn2prod_namenvarchar200n3prod_typenvarchar100n4prod_batchnvarchar100y5prod_unitnvarchr10y6prod_pricemoneyy7prod_memonvarchar200y库存表storage序列名数据类型长度允许空1stk_idbigintn2stk_prod_idbigintn3stk_warehousenvarchar50n4stk_warenvarchar50n5stk_countintn6stk_memonvarchar200y

2、历史订单表orders序列名数据类型长度允许空1odr_idbigintn2odr_customernvarchar100n3odr_datedatetimen4odr_addrnvarchar200y5odr_statuschar1n订单明细表orders_line序列名数据类型长度允许空1odd_idbigintn2odd_order_idbigintn3odd_prod_idbigintn4odd_countintn5odd_unitvarchar10y6odd_pricemoneyy说明产品编号 主键产品名称产品型号产品批次单位产品价格备注说明主键，标识列，库存编号产品名称，对应pro

3、duct表（prod_id）仓库名称货位库存数量备注说明主键，标识列 订单编号下单公司下单时间公司地址订单状态说明主键，标识列 订单编号对应orders表(odr_id)产品编号，对应product表（prod_id）数量单位订单价格productstorageordersorders_line系统用户表sys_user序列名数据类型长度允许空1usr_idbigintn2usr_namenvarchar50n3usr_passwordnvarchar50n4usr_role_idbiginty5usr_flagintn系统角色表sys_role序列名数据类型长度允许空1role_idbigi

4、ntn2role_namenvarchar50n3role_descnvarchar50y4role_flaginty权限表sys_right序列名数据类型长度允许空1right_codevarchar50n2right_parent_codevarchar50y3right_typevarchar20y4right_textvarchar50y5right_urlvarchar50y6right_tipvarchar50y角色权限表sys_role_right序列名数据类型长度允许空1rf_idbigintn2rf_role_idbigintn3rf_right_codevarcharn说明

5、主键，标识列，用户id用户名称用户密码外键，引用sys_role表主键1.管理员，2.营销经理3.客户经理用户等级说明主键，标识列，管理名称编号管理名称权限用户状态说明说明sys_usersys_rolesys_rightsys_role_right数据字典表bas_dict序列名数据类型长度允许空1dict_idbigintn2dict_typenvarchar50n3dict_itemnvarchar50n4dict_valuenvarchar50n5dict_is_editablebitn说明主键，标识列类别条目值是否可编辑0.不可编辑1.可以编辑bas_dict营销机会表sal_cha

6、nce序列名数据类型长度允许空1chc_idbigintn2chc_sourcenvarchar50y3chc_cust_namenvarchar100n4chc_titlenvarchar200n5chc_rateintn6chc_linkmannvarchar50y7chc_telnvarchar50n8chc_descnvarchar2000n9chc_create_idbigintn10chc_create_bynvarchar50n11chc_create_datedatetimen12chc_due_idbiginty13chc_due_tonvarchar50y14chc_due

7、_datedatetimey15chc_statuschar10n营销计划表sal_plan序列名数据类型长度允许空1pla_idbigintn2pla_chc_idbigintn3pla_datedatetimen4pla_todonvarchar500n5pla_resultnvarchar500y说明主键，标识列，机会编号机会来源机会名称机会概要成功几率联系人联系电话机会描述创建人编号创建人名字创建日期被指派人编号被指派人名字指派时间0.未指派 1已指派 3,开发成功 4，开发失败说明计划结果sal_chancesal_plan客户信息表cst_customer序列名数据类型长度允许空1

8、cust_nochar17n2cust_namenvarchar100n3cust_regionnvarchar50y4cust_manager_idbigint50y5cust_manager_namenvarchar50y6cust_levelinty7cust_level_labelnvarchar50y8cust_satisfyinty9cust_creditinty10cust_addrnvarchar300y11cust_zipchar10y12cust_telnvarchar50y13cust_faxnvarchar50y14cust_websitenvarchar50y15cu

9、st_licence_nonvarchar50y16cust_chieftainnvarchar50y17cust_bankrollbiginty18cust_turnoverbiginty19cust_banknvarchar200y20cust_bank_accountnvarchar50y21cust_local_tax_nonvarchar50y22cust_national_tax_nonvarchar50y23cust_statuschar1y联系人表cst_linkman序列名数据类型长度允许空1lkm_idbigintn2lkm_cust_nochar17n3lkm_cust_

10、namenvarchar100y4lkm_namenvarchar50n5lkm_sexnvarchar5y6lkm_postionnvarchar50y7lkm_telnvarchar50n8lkm_mobilenvarchar50y9lkm_memonvarchar300y交往记录表cst_activity序列名数据类型长度允许空1atv_idbigintn2atv_cust_nochar17y3atv_cust_namenvarchar100y4atv_datedatetimen5atv_placenvarchar200n6atv_titlenvarchar500n7atv_remark

11、nvarchar200y8atv_descnvarchar2000y客户流失表cst_lost序列名数据类型长度允许空1lst_idbigintn2lst_cust_nochar17n3lst_cust_namenvarchar100y4lst_cust_manager_idbigintn5lst_cust_manager_namenvarchar50n6lst_last_order_datedatetimey7lst_lost_datedatetimey8lst_delaynvarchar4000y9lst_reasonnvarchar2000y10lst_statusnvarchar10n

12、说明客户编号名称客户地区客户经理编号客户经理客户等级客户满意度客户信用度地址邮政编码电话传真网址营业执照注册号法人注册资金年营业额开户银行银行账号地税登记号国税登记号客户状态说明联系人编号外键，引用cst_customer主键姓名性别职位办公电话手机备注说明主键标识列，cst_customercst_linkmancst_activity客户编号客户名称时间地点概要详细信息备注说明主键，标识列 流失编号外键，引用cst_customer主键客户名字客户经理编号客户经理上次下单时间确认流失时间状态cst_lost客户服务表cst_service序列名数据类型长度允许空1svr_idbigintn

13、2svr_typenvarchar20n3svr_titlenvarchar500n4svr_cust_nochar17y5svr_cust_namenvarchar100n6svr_statusnvarchar10n7svr_requestnvarchar3000n8svr_create_idbigintn9svr_create_bynvarchar50n10svr_create_datedatetimen11svr_due_idbiginty12svr_due_tonvarchar50y13svr_due_datedatetimey14svr_dealnvarchar3000y15svr_deal_idbiginty16svr_deal_bynvarchar50y17svr_deal_datedatetimey18svr_resultnv