数据库设计-对公

业务模块1

机构表 ORGNIZATIONS

IDORGCODEORGNODEORGNAMEAREACODEPROVINCECITYDISTRICTLATLNGSUBCOUNTPARENTCODEORGADDRESSPHONENOLEVELREMARKDEPTNO

存续尽职调查表BUS_DURATION_DILIGENCING_INFO

IDCUSTNAMECUSTNOISCOMPINFOTRULYCOMPEXCEPTIONINFOISADDRESSTRULYADDRESSEXCEPTIONINFOISLEGALPHONETRULYLEGALPHONEEXCEPTIONINFOISFINANCEPHONETRULYFINANCEPHONEEXCEPTIONINFOISBENEFICIARYINFOTRULYBENEFICIARYEXCEPTIONINFOISINVALIDINVALIDEXCEPTIONINFOISBREAKLAWISSWINDLEISLAUNDERISHAVEOTHEREXCEPTIONOTHEREXCEPTIONINFOISNEEDCHECKACCOUNTCHECKTYPEACCOUNTNUMBERACCOUNTCUSTOMCONFIRMRESULT

单位涉案账户排查表excelaccount

idexclnumberexclunit1exclunit2exclunit3exclunit4exclunit5exclunit6exclunit7exclunit8exclunit9exclunit10

双录处理表BUS_RECORD_LOG

IDRECORD_DATEFILE_URLFILE_NAMEDEPTNOORGCODEORGNODERECORD_CODEABNORMAL_TYPECOMPANY_NAMEACCOUNT_NAMECERTIFICATE_TYPECERTIFICATE_CODELEADERIDENTIFY_TYPEIDENTIFYNOCUSTOMERCODECOMPANYCODEOPENDATEOPDATEOPUSERCHECKDATECHECKUSERFILESIZERECORD_STARTRECORD_END

权限表SYS_FHBUTTON

FHBUTTON_IDNAMEQX_NAMEBZ

营销获客表BUS_IM_TASK

IDCOMPANYIDDEPTNOORGCODEORGNODEASSIGN_USERIDASSIGN_DATEASSIGN_EXPIREDATESTATUSRESULTISCONTACTCUSTOMISCONFIRMOPEN

开户尽职调查表BUS_DILIGENCING_INFO

IDCUSTNAMEACCOUNTNAMEACCOUNTTYPEPLACEFLAGCUST_ORG_FLAGCUST_ORG_CLASSIFYCUST_TYPEENTCODEIS_EXCASEIS_LONG_SUSPENSIONOPDATEDEPTNOORGCODEORGNODECHECKERCHECKDATEIS_DOUBLE_OTHER

业务模块4

批量企业信息核查表BATCH_MASTER

IDENTNAMECREDITCODEUSER_NAMEYEAS_STATUSBREAK_STATUSEXCE_STATUSINFO_STATUSCREATE_TIMEVERSIONNUMBER

尽调任务手工创建表BUS_DEPT_SUB_TASK

IDORGCODEORGNODEORGNAMEAREACODEPROVINCECITYDISTRICTLATLNGSUBCOUNT

业务模块5

业务模块3

填单信息预处理表FILL_DISPOSE

IDFILL_ODD_IDPROVE_FILEPROVE_FILE2PROVE_FILE3PROVE_FILE4PROVE_FILE5PROVE_FILE6PROVE_FILE7PROVE_FILE8PROVE_FILE9PROVE_FILE10PROVE_FILE11PROVE_FILE12PROVE_FILE13PROVE_FILE14PROVE_FILE15PROVEADRRE

业务风险查询日志表risk_query_log

idinquirer_nameorg_codeorg_namequery_labelfirm_namecreation_datequety_fruitdept_no

用户操作日志表SYS_FHLOG

FHLOG_IDUSERNAMECZTIMECONTENT 

存续尽调任务下发表BUS_DURATION_DILIGENCING_TASK

IDENTCODEENTNAMEDEPTNODEPTNAMEORGCODEORGNODEASSIGNUSERIDASSIGNUSERNAMEASSIGNDATEASSIGNEXPIREDATESTATUSRESULTIDEXPIRESTATUSCOMPLETEDATEOPDATESERIALNUMBERDESKINFOIDTASKTYPE

对公智能账户管理平台

用户角色表 SYS_ROLE

ROLE_IDROLE_NAMERIGHTSPARENT_IDADD_QXDEL_QXEDIT_QXCHA_QX

用户菜单表ROLE

NAMEMENUSSUPPER

开户预约台账查询表ACC_OPEN_LOG

IDBANKCODEDEPTCODEDEPTNODEDEPTNAMEENTTYPEENTNAMEENTCODEACC_TYPELINKPERSONLINKPHONESUBSCRIBE_DATE

业务模块2

开户预约任务表BUS_SUBSCRIBE_OPEN_INFO

IDBANKCODEDEPTCODEDEPTNAMEENTNAMEENTCODELINKPERSONLINKPHONESUBSCRIBE_DATEOPEN_DATEOPEN_STATUSORDER_TYPEGET_TYPEGET_TIMEDEPTNODEstatus

业务模块

三要素核验表MOBILE_CHECK_LOG

IDMOBILEIDNOREALNAMEOPERATORRANGESTARTRANGEENDRESULTUNMATCHEDDATE

用户表基本表 SYS_USER