lbs
2020-07-23 15:05:07 11 举报
登录查看完整内容
数据库详细说明
作者其他创作
大纲/内容
合同图片表(jz_contract_img)
--------------------------------------------id (合同图片ID)--------------------------------------------contractId (合同编号 )--------------------------------------------ordersId ( 订单编号 )--------------------------------------------imgPath ( 图片路径 ) --------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间) --------------------------------------------activity(是否有效)--------------------------------------------
申请待办表(sy_app_todo)
--------------------------------------------id (待办ID)PK ------------------------------------------- appId (申请业务主表ID) --------------------------------------------flowId (流程ID) --------------------------------------------nodeId (环节ID) --------------------------------------------interFlow (是否内部流转,0-否 1-是)--------------------------------------------status(状态 0-未处理 1-已处理) --------------------------------------------opinion(处理意见) --------------------------------------------createId (处理人ID)--------------------------------------------createTime (创建时间) --------------------------------------------handleTime (处理时间) --------------------------------------------upperNodeId (上一个处理环节ID) --------------------------------------------upperUserId (上一个处理人ID)--------------------------------------------upperTodoId (上一个处理待办事件ID)--------------------------------------------app_type (待办类型)--------------------------------------------appTitle (申请标题 特殊待办事件专用)--------------------------------------------flowName (流程名称 特殊待办件专用) --------------------------------------------userName (申请人 特殊待办件专用)--------------------------------------------nodeName (当前节点 特殊待办件专用)--------------------------------------------doUrl (处理链接地址 特殊待办件专用)--------------------------------------------flowLibId (流程节点ID 特殊待办件专用)--------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间) --------------------------------------------activity(是否有效)--------------------------------------------
系统交互关系表(sy_business_property)
--------------------------------------------id--------------------------------------------companyId (类型编号)--------------------------------------------companyName (类型名称) --------------------------------------------userIp--------------------------------------------userKey(用户秘钥) --------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间) --------------------------------------------activity(是否有效)--------------------------------------------
合同打印表(jz_contract_printinfo)
--------------------------------------------id (合同打印ID) PK--------------------------------------------contractId 合同id --------------------------------------------ordersId 订单id --------------------------------------------create_date 打印时间 --------------------------------------------created_by 打印人 --------------------------------------------
合同表(jz_contract)
--------------------------------------------id (合同ID)PK --------------------------------------------ordersId (订单ID)--------------------------------------------companyId (家政公司 ID)--------------------------------------------nannyId (保姆 ID)--------------------------------------------ordersType (订单类型)--------------------------------------------contractContent (合同内容)--------------------------------------------create_date (创建时间)--------------------------------------------created_by (创建人)--------------------------------------------activity (是否有效)--------------------------------------------isRelation --------------------------------------------relationTime --------------------------------------------relationBy --------------------------------------------printIs --------------------------------------------update_date (最新修改时间) --------------------------------------------updated_by (最新修改人)--------------------------------------------managerId (申领人员ID)--------------------------------------------
权限组( sy_login_screen)
--------------------------------------------screen_grant_no(权限编号)PK --------------------------------------------screen_grant_name (权限名称) --------------------------------------------screen_grant_id(权限id) --------------------------------------------screen_grant_en_name (权限英文名) --------------------------------------------screen_grant_kor_name--------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间)--------------------------------------------orderno(排序号)--------------------------------------------activity(是否有效)--------------------------------------------
系统交互日志(sy_business_log )
--------------------------------------------id (日志ID)--------------------------------------------userId (用户ID)--------------------------------------------ip (服务器IP)--------------------------------------------businessName(请求内容描述) --------------------------------------------requestTime (请求时间)--------------------------------------------requestParameter (请求参数)--------------------------------------------status (请求状态)--------------------------------------------responseCode (响应状态码)--------------------------------------------responseDesc (响应描述)--------------------------------------------responseParameter (响应JSON) --------------------------------------------requestUrl (请求路径) --------------------------------------------companyId --------------------------------------------companyName--------------------------------------------
公司以及所属团队表(jz_company)
--------------------------------------------cpny_id(公司id) PK--------------------------------------------cpny_name(公司名称)--------------------------------------------cpny_shortname(公司名称简写)--------------------------------------------cpny_addr(公司地址)--------------------------------------------cpny_location(地点)--------------------------------------------cpny_postlcode(邮政编码)--------------------------------------------cpny_intro(简介)--------------------------------------------cpny_history(历史)--------------------------------------------cpny_web_addr(公司网址)--------------------------------------------cpny_tel_no(电话号码)--------------------------------------------cpny_logo(公司Logo)--------------------------------------------cpny_fax_no(传真号)--------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间)--------------------------------------------orderno(排序号)--------------------------------------------activity(状态)--------------------------------------------com_cd(法人)--------------------------------------------division(公司id)--------------------------------------------cpny_license(许可证号)--------------------------------------------parentid(上级公司id)--------------------------------------------wxaccount(微信账号)--------------------------------------------permit(许可证呢个图片URL,图片服器)--------------------------------------------prefix--------------------------------------------codePath--------------------------------------------webTitle--------------------------------------------companyIdea--------------------------------------------webDesc--------------------------------------------keyWord--------------------------------------------color--------------------------------------------endTime--------------------------------------------qq--------------------------------------------level--------------------------------------------alongShow--------------------------------------------isShow--------------------------------------------photoImg--------------------------------------------isopenselfbrand--------------------------------------------areaid--------------------------------------------areaname--------------------------------------------areaxqid--------------------------------------------areaxqname--------------------------------------------addr--------------------------------------------star--------------------------------------------type--------------------------------------------latitude(经度)--------------------------------------------longtitude(纬度)--------------------------------------------cityId--------------------------------------------contacts(公司联系人)--------------------------------------------contactsMobile(公司联系人手机号)--------------------------------------------cpny_createDate--------------------------------------------businessType--------------------------------------------groupCompanyId--------------------------------------------managerId--------------------------------------------spreadCode(推广码)--------------------------------------------openId--------------------------------------------idCard(身份证号码)--------------------------------------------licenseImg(有那个业执照图片URL)--------------------------------------------idCardImgZm(身份证正面图片URL)--------------------------------------------idCardImgFm(身份证反面图片URL)--------------------------------------------bondMoney(保证金)--------------------------------------------signFlag--------------------------------------------jiesuanType--------------------------------------------
用户表(sy_admin)
------------------------------------------adminno (用户编号) ------------------------------------------adminid (用户ID) PK------------------------------------------realname (真实姓名)------------------------------------------adminlevel------------------------------------------username (用户名)------------------------------------------paassword(密码)------------------------------------------login_deptid (所属部门id) PK------------------------------------------screen_grant_no (权限编号)------------------------------------------create_date(创建时间)------------------------------------------create_by(创建人)------------------------------------------update_date(最后修改时间)------------------------------------------update_by(最后修改时间)------------------------------------------orderno(排序号)------------------------------------------activity(是否有效)------------------------------------------password1(初始密码)------------------------------------------password2(第二次修改密码)------------------------------------------password3(第三次修改密码)------------------------------------------num------------------------------------------companyPermissions------------------------------------------adminType------------------------------------------changePasswordDate(修改密码时间)------------------------------------------mobile(手机号)------------------------------------------groupCompanyInfos(管理的门店ID合)------------------------------------------personId------------------------------------------
系统提醒(sy_admin_remind )
--------------------------------------------id (系统提醒ID)PK --------------------------------------------adminId (用户ID) ------------------------------------------- companyid(用户所在公司或团队ID)--------------------------------------------message(消息)--------------------------------------------menuId (菜单ID)--------------------------------------------param (参数)--------------------------------------------ywid (业务ID)--------------------------------------------ywsm (业务说明)--------------------------------------------msgStatus (1-sendMsg 0-notice) ------------------------------------------- msgType (sendMsg-1 notice-0)------------------------------------------- msgTitle (消息标题)------------------------------------------- url --------------------------------------------deptId ------------------------------------------- appId --------------------------------------------todoId --------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间) --------------------------------------------activity(是否有效)--------------------------------------------
地区表(sy_area)
--------------------------------------------areaid (地区id)PK--------------------------------------------areaname (地区名称) --------------------------------------------areaLongitude (经度)--------------------------------------------areaLatitude (纬度)--------------------------------------------level (层级)--------------------------------------------parentid (父级地区id) --------------------------------------------jzCompanyId (家政公司ID)--------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间) --------------------------------------------orderno (排序号)--------------------------------------------activity(是否有效)--------------------------------------------
菜单(sy_menu)
--------------------------------------------menu_code(菜单编号)PK--------------------------------------------menu_no --------------------------------------------menu_intro (菜单名称)--------------------------------------------menu_en_intro(菜单英文名称) --------------------------------------------menu_tw_intro --------------------------------------------menu_kor_intro--------------------------------------------menu_parent_code (菜单父级编号) --------------------------------------------key_no --------------------------------------------table_name --------------------------------------------is_can_be_build --------------------------------------------menu_url (菜单请求路径) --------------------------------------------depth (菜单层级数) --------------------------------------------menu_image(菜单图片URL)--------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间)--------------------------------------------orderno(排序号)--------------------------------------------activity(是否有效)--------------------------------------------
jz_company_account_ybm_config
--------------------------------------------id --------------------------------------------minDay(最小天数)--------------------------------------------maxDay(最大天数)--------------------------------------------ratio (结算比例)--------------------------------------------activity (是否有效)--------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间)--------------------------------------------
权限组-菜单(sy_screen_grant)
--------------------------------------------screen_code (菜单编号)PK--------------------------------------------screen_grant_no (权限组编号)PK--------------------------------------------selectr(查询权限)--------------------------------------------insertr (添加权限) --------------------------------------------updater (修改权限) --------------------------------------------deleter (删除权限) --------------------------------------------create_date(创建时间)--------------------------------------------create_by(创建人)--------------------------------------------update_date(最后修改时间)--------------------------------------------update_by(最后修改时间)--------------------------------------------orderno(排序号)--------------------------------------------activity(是否有效)--------------------------------------------
申请表(sy_app)
---------------------------------------------------------id (申请ID)PK ---------------------------------------------------------appTitle (申请标题) --------------------------------------------------------- appDeptId (申请部门ID) -------------------------------------------------------- appUserId (申请用户ID) ---------------------------------------------------------appTime (申请时间) ---------------------------------------------------------flowId (流程ID) ---------------------------------------------------------currentNodeId (当前环节ID) ---------------------------------------------------------status (状态 0未办理,1办理中,2完结,3退回 )---------------------------------------------------------context ---------------------------------------------------------formId ---------------------------------------------------------create_date(创建时间)---------------------------------------------------------create_by(创建人)---------------------------------------------------------update_date(最后修改时间)---------------------------------------------------------update_by(最后修改时间) ---------------------------------------------------------activity(是否有效)---------------------------------------------------------
城市表(sy_city)
--------------------------------------------id (城市id)PK--------------------------------------------name (城市名称)--------------------------------------------areaId(地区ID)--------------------------------------------
0 条评论
回复 删除
下一页