index.html

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  
  <title>Hexo</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta property="og:type" content="website">
<meta property="og:title" content="Hexo">
<meta property="og:url" content="http://yoursite.com/index.html">
<meta property="og:site_name" content="Hexo">
<meta name="twitter:card" content="summary">
<meta name="twitter:title" content="Hexo">
  
    <link rel="alternate" href="/atom.xml" title="Hexo" type="application/atom+xml">
  
  
    <link rel="icon" href="/favicon.png">
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  <link rel="stylesheet" href="/css/style.css">
  

</head>

<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/" id="logo">Hexo</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/">Home</a>
        
          <a class="main-nav-link" href="/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
          <a id="nav-rss-link" class="nav-icon" href="/atom.xml" title="RSS Feed"></a>
        
        <a id="nav-search-btn" class="nav-icon" title="Search"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" results="0" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="http://yoursite.com"></form>
      </div>
    </div>
  </div>
</header>
      <div class="outer">
        <section id="main">
  
    <article id="post-hello-world" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/2016/11/29/hello-world/" class="article-date">
  <time datetime="2016-11-29T11:05:27.176Z" itemprop="datePublished">2016-11-29</time>
</a>
    
  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/2016/11/29/hello-world/">Hello World</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>Welcome to <a href="https://hexo.io/" target="_blank" rel="external">Hexo</a>! This is your very first post. Check <a href="https://hexo.io/docs/" target="_blank" rel="external">documentation</a> for more info. If you get any problems when using Hexo, you can find the answer in <a href="https://hexo.io/docs/troubleshooting.html" target="_blank" rel="external">troubleshooting</a> or you can ask me on <a href="https://github.com/hexojs/hexo/issues" target="_blank" rel="external">GitHub</a>.</p>
<h2 id="Quick-Start"><a href="#Quick-Start" class="headerlink" title="Quick Start"></a>Quick Start</h2><h3 id="Create-a-new-post"><a href="#Create-a-new-post" class="headerlink" title="Create a new post"></a>Create a new post</h3><figure class="highlight bash"><table><tr><td class="gutter"><pre><div class="line">1</div></pre></td><td class="code"><pre><div class="line">$ hexo new <span class="string">"My New Post"</span></div></pre></td></tr></table></figure>
<p>More info: <a href="https://hexo.io/docs/writing.html" target="_blank" rel="external">Writing</a></p>
<h3 id="Run-server"><a href="#Run-server" class="headerlink" title="Run server"></a>Run server</h3><figure class="highlight bash"><table><tr><td class="gutter"><pre><div class="line">1</div></pre></td><td class="code"><pre><div class="line">$ hexo server</div></pre></td></tr></table></figure>
<p>More info: <a href="https://hexo.io/docs/server.html" target="_blank" rel="external">Server</a></p>
<h3 id="Generate-static-files"><a href="#Generate-static-files" class="headerlink" title="Generate static files"></a>Generate static files</h3><figure class="highlight bash"><table><tr><td class="gutter"><pre><div class="line">1</div></pre></td><td class="code"><pre><div class="line">$ hexo generate</div></pre></td></tr></table></figure>
<p>More info: <a href="https://hexo.io/docs/generating.html" target="_blank" rel="external">Generating</a></p>
<h3 id="Deploy-to-remote-sites"><a href="#Deploy-to-remote-sites" class="headerlink" title="Deploy to remote sites"></a>Deploy to remote sites</h3><figure class="highlight bash"><table><tr><td class="gutter"><pre><div class="line">1</div></pre></td><td class="code"><pre><div class="line">$ hexo deploy</div></pre></td></tr></table></figure>
<p>More info: <a href="https://hexo.io/docs/deployment.html" target="_blank" rel="external">Deployment</a></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="http://yoursite.com/2016/11/29/hello-world/" data-id="ciw3i5tab0000wwm9msoy5fsj" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


    <article id="post-数据库表结构" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/2016/09/13/数据库表结构/" class="article-date">
  <time datetime="2016-09-13T07:43:20.000Z" itemprop="datePublished">2016-09-13</time>
</a>
    
  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/2016/09/13/数据库表结构/">数据库表结构</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>[TOC]</p>
<h1 id="用户账户表"><a href="#用户账户表" class="headerlink" title="用户账户表"></a>用户账户表</h1><h2 id="用户表"><a href="#用户表" class="headerlink" title="用户表"></a>用户表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_INFO</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_NAME</td>
<td>用户账号</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td>用于非微博用户</td>
</tr>
<tr>
<td>USER_PWD</td>
<td>用户密码</td>
<td>VARCHAR(10)</td>
<td>否</td>
<td>用于非微博用户</td>
</tr>
<tr>
<td>EMAIL</td>
<td>邮箱</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>SEX</td>
<td>性别</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001004</td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td>VARCHAR(15)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MOBILE_HOME</td>
<td>手机号归属地</td>
<td>VARCHAR(30)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>BIRTHDAY</td>
<td>出生日期</td>
<td>VARCHAR(10)</td>
<td>否</td>
<td>格式：yyyy-MM-dd</td>
</tr>
<tr>
<td>WB_TOKEN</td>
<td>微博Token</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>WB_ID</td>
<td>微博账号ID</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>WB_USERNAME</td>
<td>微博账号</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>WB_NICKNAME</td>
<td>微博账号昵称</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>WB_REG_TIME</td>
<td>微博注册时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>USER_SOURCE</td>
<td>用户来源</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001027</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="微博数据表"><a href="#微博数据表" class="headerlink" title="微博数据表"></a>微博数据表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>WB_DATA</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>REAL_NAME</td>
<td>真实姓名</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ID_CARD</td>
<td>身份证号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="登录日志表"><a href="#登录日志表" class="headerlink" title="登录日志表"></a>登录日志表</h2><h2 id="用户银行卡表"><a href="#用户银行卡表" class="headerlink" title="用户银行卡表"></a>用户银行卡表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_BANK</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td>USER_ID</td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REAL_NAME</td>
<td>真实姓名</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ID_CARD</td>
<td>身份证号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>BANK</td>
<td>开户行</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CARD_TYPE</td>
<td>银行卡类型</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001007001借记卡</td>
</tr>
<tr>
<td>CARD_NO</td>
<td>银行卡号</td>
<td>VARCHAR(30)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>RESERVE_MOBILE</td>
<td>预留手机号</td>
<td>VARCHAR(11)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>BIND_NO</td>
<td>绑卡流水</td>
<td>VARCHAR(32)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>删除标识</td>
<td>INT</td>
<td>否</td>
<td>0正常1删除</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="用户运营商表"><a href="#用户运营商表" class="headerlink" title="用户运营商表"></a>用户运营商表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_CARRIER</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td>USER_ID</td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CARRIER_TYPE</td>
<td>运营商类型</td>
<td>CHAR(9)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CARRIER_PWD</td>
<td>手机号服务密码</td>
<td>VARCHAR(10)</td>
<td>否</td>
<td>密文存储</td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>删除标识</td>
<td>INT</td>
<td>否</td>
<td>0正常1删除</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="用户账户表-1"><a href="#用户账户表-1" class="headerlink" title="用户账户表"></a>用户账户表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_ACCOUNT</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td>USER_ID</td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REAL_NAME</td>
<td>真实姓名</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>ID_CARD</td>
<td>身份证号</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>ID_HOME</td>
<td>身份证归属地</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td>VARCHAR(15)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>PAY_PWD</td>
<td>支付密码</td>
<td>VARCHAR(10)</td>
<td>否</td>
<td>密文存储</td>
</tr>
<tr>
<td>CREDIT_AMOUNT</td>
<td>授信金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>CREDIT_DATE</td>
<td>授信日期</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREDIT_ID</td>
<td>授信ID</td>
<td>BIGINT</td>
<td>否</td>
<td>最新授信ID</td>
</tr>
<tr>
<td>USED_AMOUNT</td>
<td>已使用金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>BALANCE</td>
<td>余额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>CREDIT_STATUS</td>
<td>授信状态</td>
<td>CHAR(9)</td>
<td></td>
<td>001001</td>
</tr>
<tr>
<td>FILL_FLAG</td>
<td>填写标识</td>
<td>VARCHAR(10)</td>
<td>是</td>
<td>默认0，既所有信息均未填写<br>每一位代表一个填写项，0：未填写、1：已填写<br>第一位：手机号绑定<br>第二位：银行卡绑定<br>第三位：手机运营商<br>第四位：紧急联系人<br>第五位：身份证<br>第六位：芝麻认证</td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>删除标识</td>
<td>INT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="用户日志表"><a href="#用户日志表" class="headerlink" title="用户日志表"></a>用户日志表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_LOG</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td>USER_ID</td>
</tr>
<tr>
<td>备注</td>
<td>记录用户非借款相关的日志信息</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOG_TYPE</td>
<td>日志类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001005001系统<br>001005002用户<br>001005003客服</td>
</tr>
<tr>
<td>OPERATE_ID</td>
<td>操作人ID</td>
<td>BIGINT</td>
<td>是</td>
<td>0表示系统自动</td>
</tr>
<tr>
<td>OPERATOR</td>
<td>操作人</td>
<td>VARCHAR(30)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>OPT_CONTENT</td>
<td>操作内容</td>
<td>VARCHAR(100)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>OPERATE_TIME</td>
<td>操作时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="用户照片"><a href="#用户照片" class="headerlink" title="用户照片"></a>用户照片</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_IMAGES</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CARD_FRONT</td>
<td>证件正面照片</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CARD_BACK</td>
<td>证件背面照片</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>HOLD_CARD</td>
<td>手持证件照片</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>删除标识</td>
<td>INT</td>
<td>是</td>
<td>0正常、1删除</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>默认同创建时间</td>
</tr>
</tbody>
</table>
<h2 id="紧急联系人"><a href="#紧急联系人" class="headerlink" title="紧急联系人"></a>紧急联系人</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_URGENT</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>RELATION</td>
<td>关系类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001014</td>
</tr>
<tr>
<td>REAL_NAME</td>
<td>真实姓名</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ID_CARD</td>
<td>身份证号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td>VARCHAR(15)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MOBILE_HOME</td>
<td>手机号归属地</td>
<td>VARCHAR(30)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CALL_COUNT</td>
<td>主叫次数</td>
<td>INT</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>CALLED_COUNT</td>
<td>被叫次数</td>
<td>INT</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>TALK_TIME</td>
<td>通话时长</td>
<td>INT</td>
<td>是</td>
<td>默认0，单位秒</td>
</tr>
<tr>
<td>LAST_TALK</td>
<td>最近通话时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>删除标识</td>
<td>INT</td>
<td>是</td>
<td>0正常、1删除</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>默认同创建时间</td>
</tr>
</tbody>
</table>
<h2 id="用户通话详单"><a href="#用户通话详单" class="headerlink" title="用户通话详单"></a>用户通话详单</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_CALL_DETAIL</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>默认同创建时间</td>
</tr>
</tbody>
</table>
<h2 id="用户通话统计"><a href="#用户通话统计" class="headerlink" title="用户通话统计"></a>用户通话统计</h2><table>
<thead>
<tr>
<th>表名</th>
<th>USER_CALL_CENSUS</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>默认同创建时间</td>
</tr>
</tbody>
</table>
<h2 id="授信申请表"><a href="#授信申请表" class="headerlink" title="授信申请表"></a>授信申请表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>CREDIT_APPLY</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>CREDIT_NO</td>
<td>授信流程编号</td>
<td>VARCHAR(32)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REAL_NAME</td>
<td>申请人姓名</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td>默认空字符</td>
</tr>
<tr>
<td>ID_CARD</td>
<td>身份证号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td>默认空字符</td>
</tr>
<tr>
<td>ID_HOME</td>
<td>身份证归属地</td>
<td>VARCHAR(50)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>SEX</td>
<td>性别</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001004</td>
</tr>
<tr>
<td>EMAIL</td>
<td>邮箱</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>BIRTHDAY</td>
<td>出生日期</td>
<td>VARCHAR(10)</td>
<td>否</td>
<td>格式：yyyy-MM-dd</td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>BANK_ID</td>
<td>银行卡ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>URGENT_ID</td>
<td>紧急联系人ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CARRIER_ID</td>
<td>运营商ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREDIT_AMOUNT</td>
<td>授信金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>CREDIT_STATUS</td>
<td>授信状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001001</td>
</tr>
<tr>
<td>AUDIT_STATUS</td>
<td>授信审核状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001015</td>
</tr>
<tr>
<td>AUDITOR_ID</td>
<td>最近审批人ID</td>
<td>BIGINT</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>AUDITOR_NAME</td>
<td>最近审批人姓名</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="授信申请风控表"><a href="#授信申请风控表" class="headerlink" title="授信申请风控表"></a>授信申请风控表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>CREDIT_RISK</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>CREDIT_ID</td>
<td>授信申请ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>RISK_TYPE</td>
<td>风控类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001016</td>
</tr>
<tr>
<td>RISK_ID</td>
<td>风控ID</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>RISK_DECISION</td>
<td>风控评估结果</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001029</td>
</tr>
<tr>
<td>RISK_SCORE</td>
<td>风控评分</td>
<td>INT</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>RISK_TIME</td>
<td>风控结果时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>删除标识</td>
<td>INT</td>
<td>是</td>
<td>0正常1删除</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="授信审核操作表"><a href="#授信审核操作表" class="headerlink" title="授信审核操作表"></a>授信审核操作表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>CREDIT_AUDIT_OPT</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>授信签收处理表，签收之后才能处理，处理完成之后删除记录</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>STEP_NO</td>
<td>流程步骤</td>
<td>INT</td>
<td>是</td>
<td>默认1</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>EMP_ID</td>
<td>后台用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREDIT_ID</td>
<td>授信ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>OPT_TYPE</td>
<td>操作类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001034最后的操作类型</td>
</tr>
<tr>
<td>CHEKIN_TIME</td>
<td>检入时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CHEKOUT_TIME</td>
<td>检出时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEAL_TIME</td>
<td>处理时间</td>
<td>DATETIME</td>
<td>否</td>
<td>指审批完成时间</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="授信审核结果表"><a href="#授信审核结果表" class="headerlink" title="授信审核结果表"></a>授信审核结果表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>CREDIT_AUDIT_RESULT</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>STEP_NO</td>
<td>审批步骤</td>
<td>INT</td>
<td>是</td>
<td>默认1</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>EMP_ID</td>
<td>后台用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREDIT_ID</td>
<td>授信ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREDIT_STATUS</td>
<td>授信状态</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001001</td>
</tr>
<tr>
<td>CREDIT_AMOUNT</td>
<td>授信金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>MEMO</td>
<td>审批意见</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="授信日志表"><a href="#授信日志表" class="headerlink" title="授信日志表"></a>授信日志表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>CREDIT_LOG</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>CREDIT_ID</td>
<td>授信ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOG_TYPE</td>
<td>日志类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001005001系统<br>001005002客户<br>001005003客服</td>
</tr>
<tr>
<td>OPERATE_ID</td>
<td>操作人ID</td>
<td>BIGINT</td>
<td>是</td>
<td>0表示系统自动</td>
</tr>
<tr>
<td>OPERATOR</td>
<td>操作人</td>
<td>VARCHAR(30)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>OPT_CONTENT</td>
<td>操作内容</td>
<td>VARCHAR(100)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DISPLAY</td>
<td>显示字段</td>
<td>INT</td>
<td>是</td>
<td>1前端显示、0前端不显示</td>
</tr>
<tr>
<td>OPERATE_TIME</td>
<td>操作时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="授信策略表-暂不添加"><a href="#授信策略表-暂不添加" class="headerlink" title="授信策略表(暂不添加)"></a>授信策略表(暂不添加)</h2><table>
<thead>
<tr>
<th>表名</th>
<th>CREDIT_POLICY</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>授信策略命中情况</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREDIT_ID</td>
<td>授信ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h1 id="风控服务"><a href="#风控服务" class="headerlink" title="风控服务"></a>风控服务</h1><h2 id="黑名单"><a href="#黑名单" class="headerlink" title="黑名单"></a>黑名单</h2><table>
<thead>
<tr>
<th>表名</th>
<th>BLACK_USER</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>否</td>
<td>0非内部用户，1内部用户</td>
</tr>
<tr>
<td>REAL_NAME</td>
<td>姓名</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ID_CARD</td>
<td>身份证号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MEMO</td>
<td>备注</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>删除标识</td>
<td>INT</td>
<td>是</td>
<td>0正常1删除</td>
</tr>
<tr>
<td>CREATOR</td>
<td>创建人</td>
<td>INT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h1 id="借款服务"><a href="#借款服务" class="headerlink" title="借款服务"></a>借款服务</h1><h2 id="借款记录表"><a href="#借款记录表" class="headerlink" title="借款记录表"></a>借款记录表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>LOAN_INFO</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>LOAN_ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>LOAN_ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>LOAN_NO</td>
<td>借款编号</td>
<td>VARCHAR(32)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_ID</td>
<td>申请人ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REAL_NAME</td>
<td>申请人姓名</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td>默认空字符</td>
</tr>
<tr>
<td>ID_CARD</td>
<td>身份证号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td>默认空字符</td>
</tr>
<tr>
<td>LOAN_DAY</td>
<td>借款期限</td>
<td>INT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOAN_UNIT</td>
<td>期限单位</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001026</td>
</tr>
<tr>
<td>INTEREST_RATE</td>
<td>利率</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td>默认空字符，0.3表示正常利息0.3%，</td>
</tr>
<tr>
<td>APPLY_AMOUNT</td>
<td>借款金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOAN_AMOUNT</td>
<td>放款金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DATA_FROM</td>
<td>数据来源</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001027</td>
</tr>
<tr>
<td>DUE_INTEREST</td>
<td>应还利息</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ACT_INTEREST</td>
<td>实还利息</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DUE_AMOUNT</td>
<td>应还金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ACT_AMOUNT</td>
<td>实还金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>STAGE_SUM</td>
<td>分期数</td>
<td>INT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REPAY_TYPE</td>
<td>还款方式</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001020</td>
</tr>
<tr>
<td>BEGIN_DATE</td>
<td>开始日期</td>
<td>DATE</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>END_DATE</td>
<td>结束日期</td>
<td>DATE</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>LOAN_STATUS</td>
<td>借款状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001002</td>
</tr>
<tr>
<td>AUDIT_STATUS</td>
<td>审批状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001003</td>
</tr>
<tr>
<td>APPLY_TIME</td>
<td>申请时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOAN_TIME</td>
<td>放款时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>SETTLE_TIME</td>
<td>结清时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREDIT_ID</td>
<td>授信ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ANTI_FRAUD</td>
<td>反欺诈ID</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td>反欺诈日志ID</td>
</tr>
<tr>
<td>ANTI_DECISION</td>
<td>反欺诈评估结果</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001029</td>
</tr>
<tr>
<td>ANTI_SCORE</td>
<td>反欺诈评分</td>
<td>INT</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td>提交时间</td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="借款设备表"><a href="#借款设备表" class="headerlink" title="借款设备表"></a>借款设备表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>LOAN_DEVICE</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>LOAN_ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>USER_ID</td>
<td>申请人ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_IP</td>
<td>用户IP</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>TOKEN_ID</td>
<td>同盾设备标识</td>
<td>VARCHAR(64)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEVICE_ID</td>
<td>设备ID</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MOBILE_MODEL</td>
<td>手机型号</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MOBILE_OS</td>
<td>手机操作系统</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001030</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="放款记录表"><a href="#放款记录表" class="headerlink" title="放款记录表"></a>放款记录表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>LOAN_RECORD</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>放款成功时插入</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>LOAN_ID</td>
<td>借款ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>BANK_ID</td>
<td>银行卡ID</td>
<td>BIGINT</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>LOAN_AMOUNT</td>
<td>放款金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>TRADE_ID</td>
<td>代付流水</td>
<td>VARCHAR(32)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOAN_TIME</td>
<td>放款时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LENDERS_ID</td>
<td>放款人ID</td>
<td>INT</td>
<td>否</td>
<td>0表示系统自动放款</td>
</tr>
<tr>
<td>LENDERS_NAME</td>
<td>放款人</td>
<td>VARCHAR(30)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>TRADE_STATUS</td>
<td>交易状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001035</td>
</tr>
<tr>
<td>TRADE_MEMO</td>
<td>交易备注</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>默认同创建时间</td>
</tr>
</tbody>
</table>
<h2 id="还款计划表"><a href="#还款计划表" class="headerlink" title="还款计划表"></a>还款计划表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>REPAY_PLAN</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>LOAN_ID</td>
<td>借款ID</td>
<td>BIGINT</td>
<td>是</td>
<td>是</td>
</tr>
<tr>
<td>USER_ID</td>
<td>申请人ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>STEP_NO</td>
<td>序号</td>
<td>INT</td>
<td>是</td>
<td>当前期数</td>
</tr>
<tr>
<td>DUE_AMOUNT</td>
<td>应还金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DUE_DAY</td>
<td>应还款日期</td>
<td>DATE</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REPAY_AMOUNT</td>
<td>实还金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>实际还款金额=应还金额+逾期利息</td>
</tr>
<tr>
<td>ACT_DAY</td>
<td>实际还款日期</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DUE_INTEREST</td>
<td>应还利息</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ACT_INTEREST</td>
<td>实还利息</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REDUCE_AMOUNT</td>
<td>减免罚息</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>默认0</td>
</tr>
<tr>
<td>OVERDUE_DAY</td>
<td>逾期天数</td>
<td>INT</td>
<td>是</td>
<td>默认0，结清时计算</td>
</tr>
<tr>
<td>OVERDUE_AMOUNT</td>
<td>逾期利息</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td>默认为0，结清时计算</td>
</tr>
<tr>
<td>REPAY_STATUS</td>
<td>还款状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001021</td>
</tr>
<tr>
<td>EARLY_FLAG</td>
<td>提前还款状态</td>
<td>TINYINT</td>
<td>是</td>
<td>1是0否</td>
</tr>
<tr>
<td>MEMO</td>
<td>备注</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEL_FLAG</td>
<td>逻辑删除</td>
<td>INT</td>
<td>是</td>
<td>0正常1删除</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="还款记录表"><a href="#还款记录表" class="headerlink" title="还款记录表"></a>还款记录表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>REPAY_RECORD</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>还款成功时插入</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>LOAN_ID</td>
<td>借款ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>PLAN_ID</td>
<td>还款计划ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>BANK_ID</td>
<td>银行卡ID</td>
<td>BIGINT</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>REPAY_AMOUNT</td>
<td>还款金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REPAY_TYPE</td>
<td>还款方式</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001023</td>
</tr>
<tr>
<td>REPAY_TIME</td>
<td>还款时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>TRADE_ID</td>
<td>代收流水</td>
<td>VARCHAR(32)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>TRADE_STATUS</td>
<td>交易状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001035</td>
</tr>
<tr>
<td>TRADE_MEMO</td>
<td>交易备注</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>默认同创建时间</td>
</tr>
</tbody>
</table>
<h2 id="借款日志表"><a href="#借款日志表" class="headerlink" title="借款日志表"></a>借款日志表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>LOAN_LOG</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>LOAN_ID</td>
<td>借款ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOG_TYPE</td>
<td>日志类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001005001系统<br>001005002客户<br>001005003客服</td>
</tr>
<tr>
<td>FLOW_STATUS</td>
<td>流程状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001019</td>
</tr>
<tr>
<td>OPERATE_ID</td>
<td>操作人ID</td>
<td>BIGINT</td>
<td>是</td>
<td>0表示系统自动</td>
</tr>
<tr>
<td>OPERATOR</td>
<td>操作人</td>
<td>VARCHAR(30)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>OPT_CONTENT</td>
<td>操作内容</td>
<td>VARCHAR(100)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DISPLAY</td>
<td>显示字段</td>
<td>INT</td>
<td>是</td>
<td>1前端显示、0前端不显示</td>
</tr>
<tr>
<td>OPERATE_TIME</td>
<td>操作时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="借款审核操作表"><a href="#借款审核操作表" class="headerlink" title="借款审核操作表"></a>借款审核操作表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>LOAN_AUDIT_OPT</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>借款签收处理表，签收之后才能处理，处理完成之后删除记录</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>STEP_NO</td>
<td>审批步骤</td>
<td>INT</td>
<td>是</td>
<td>默认1</td>
</tr>
<tr>
<td>EMP_ID</td>
<td>后台用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOAN_ID</td>
<td>借款ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>OPT_TYPE</td>
<td>操作类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001034最后的操作类型</td>
</tr>
<tr>
<td>CHEKIN_TIME</td>
<td>检入时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CHEKOUT_TIME</td>
<td>检出时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DEAL_TIME</td>
<td>处理时间</td>
<td>DATETIME</td>
<td>否</td>
<td>指审批完成时间</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="借款审核结果表"><a href="#借款审核结果表" class="headerlink" title="借款审核结果表"></a>借款审核结果表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>LOAN_AUDIT_RESULT</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>STEP_NO</td>
<td>审批步骤</td>
<td>INT</td>
<td>是</td>
<td>默认1</td>
</tr>
<tr>
<td>EMP_ID</td>
<td>后台用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOAN_ID</td>
<td>借款ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>SIGN_TIME</td>
<td>签收时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DEAL_TIME</td>
<td>处理时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>AUDIT_STATUS</td>
<td>审批结果</td>
<td>CHAR(9)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MEMO</td>
<td>审批意见</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h2 id="交易异常处理表？？"><a href="#交易异常处理表？？" class="headerlink" title="交易异常处理表？？"></a>交易异常处理表？？</h2><table>
<thead>
<tr>
<th>表名</th>
<th>TRADE_EXCEPTION</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>TRADE_TYPE</td>
<td>交易类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001022</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>LOAN_ID</td>
<td>贷款ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>TRADE_AMOUNT</td>
<td>还款金额</td>
<td>DECIMAL(10,2)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h1 id="交易服务"><a href="#交易服务" class="headerlink" title="交易服务"></a>交易服务</h1><h2 id="绑卡记录表"><a href="#绑卡记录表" class="headerlink" title="绑卡记录表"></a>绑卡记录表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>PAY_BIND_CARD</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>BANK_CODE</td>
<td>银行代码</td>
<td>CHAR(5)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CARD_NO</td>
<td>银行卡号</td>
<td>VARCHAR(20)</td>
<td></td>
<td></td>
</tr>
<tr>
<td>ID_CARD</td>
<td>持卡人身份证号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MOBILE</td>
<td>持卡人手机号</td>
<td>VARCHAR(15)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2 id="交易流水表"><a href="#交易流水表" class="headerlink" title="交易流水表"></a>交易流水表</h2><p>待添加</p>
<h1 id="消息服务"><a href="#消息服务" class="headerlink" title="消息服务"></a>消息服务</h1><h2 id="短信表"><a href="#短信表" class="headerlink" title="短信表"></a>短信表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>SMS_INFO</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>WB_USERNAME</td>
<td>微博账号</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MSG</td>
<td>短信内容</td>
<td>VARCHAR(100)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>BIZ_ID</td>
<td>业务单号</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>MSG_TYPE</td>
<td>消息类型</td>
<td>CHAR(9)</td>
<td>否</td>
<td>001032</td>
</tr>
<tr>
<td>SMS_TYPE</td>
<td>短信类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001033</td>
</tr>
<tr>
<td>DATA_SOURCE</td>
<td>数据来源</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001027</td>
</tr>
<tr>
<td>SMS_ID</td>
<td>消息ID</td>
<td>VARCHAR(64)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>TASK_ID</td>
<td>第三方返回ID</td>
<td>VARCHAR(64)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>SEND_STATUS</td>
<td>发送状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001017</td>
</tr>
<tr>
<td>RES_CODE</td>
<td>响应代码</td>
<td>VARCHAR(10)</td>
<td>否</td>
<td>第三方响应代码</td>
</tr>
<tr>
<td>REPORT_STATUS</td>
<td>短信状态报告</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001012</td>
</tr>
<tr>
<td>SEND_TIME</td>
<td>发送时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>REPORT_TIME</td>
<td>状态报告时间</td>
<td>DATETIME</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>SEND_EXCEPTION</td>
<td>发送异常</td>
<td>VARCHAR(50)</td>
<td>否</td>
<td>调用第三方接口出现的异常信息</td>
</tr>
</tbody>
</table>
<h2 id="短信验证码表"><a href="#短信验证码表" class="headerlink" title="短信验证码表"></a>短信验证码表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>SMS_VERIFY</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>BIGINT</td>
<td>是</td>
<td>PK，自增</td>
</tr>
<tr>
<td>USER_ID</td>
<td>用户ID</td>
<td>BIGINT</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>WB_USERNAME</td>
<td>微博账号</td>
<td>VARCHAR(32)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>BIZ_TYPE</td>
<td>业务类型</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001013</td>
</tr>
<tr>
<td>MOBILE</td>
<td>手机号</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>SMS_SN</td>
<td>短信序号</td>
<td>INT</td>
<td>否</td>
<td>后续可能短信自动读取</td>
</tr>
<tr>
<td>VERIFY_CODE</td>
<td>短信验证码</td>
<td>VARCHAR(10)</td>
<td></td>
<td></td>
</tr>
<tr>
<td>VERIFY_STATUS</td>
<td>状态</td>
<td>CHAR(9)</td>
<td>是</td>
<td>001011</td>
</tr>
<tr>
<td>SMI_ID</td>
<td>短信表主键</td>
<td>BIGINT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>TTL</td>
<td>存活时间</td>
<td>INT</td>
<td>是</td>
<td>单位秒</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>UPDATE_TIME</td>
<td>更新时间</td>
<td>DATETIME</td>
<td>是</td>
<td>首次创建时等于创建时间</td>
</tr>
</tbody>
</table>
<h1 id="基础数据表"><a href="#基础数据表" class="headerlink" title="基础数据表"></a>基础数据表</h1><h2 id="接口日志表"><a href="#接口日志表" class="headerlink" title="接口日志表"></a>接口日志表</h2><table>
<thead>
<tr>
<th>表名</th>
<th></th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td></td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2 id="数据字典表"><a href="#数据字典表" class="headerlink" title="数据字典表"></a>数据字典表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>DATA_DICT</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>-</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>INT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>DICT_CODE</td>
<td>字典代码</td>
<td>VARCHAR(6)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DICT_NAME</td>
<td>字典名称</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MEMO</td>
<td>备注</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="数据字典项表"><a href="#数据字典项表" class="headerlink" title="数据字典项表"></a>数据字典项表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>DATA_DICT_ITEM</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>字典代码最多9位，最多3级，1级字典父代码和ID均为0</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>INT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>ITEM_CODE</td>
<td>字典项代码</td>
<td>VARCHAR(9)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ITEM_NAME</td>
<td>字典项名称</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>DICT_CODE</td>
<td>字典代码</td>
<td>VARCHAR(6)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>ORDER_BY</td>
<td>排序</td>
<td>INT</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>MEMO</td>
<td>备注</td>
<td>VARCHAR(20)</td>
<td>否</td>
<td></td>
</tr>
<tr>
<td>DICT_STATUS</td>
<td>字典状态</td>
<td>INT</td>
<td>是</td>
<td>1启用、0停用</td>
</tr>
<tr>
<td>CREATE_TIME</td>
<td>创建时间</td>
<td>DATETIME</td>
<td>是</td>
</tr>
</tbody>
</table>
<h2 id="身份证号归属地表"><a href="#身份证号归属地表" class="headerlink" title="身份证号归属地表"></a>身份证号归属地表</h2><table>
<thead>
<tr>
<th>表名</th>
<th>ID_CARD_INFO</th>
</tr>
</thead>
<tbody>
<tr>
<td>主键</td>
<td>ID</td>
</tr>
<tr>
<td>外键</td>
<td></td>
</tr>
<tr>
<td>备注</td>
<td>记录身份证号对应归属地信息</td>
</tr>
</tbody>
</table>
<table>
<thead>
<tr>
<th>字段名称</th>
<th>中文描述</th>
<th>字段类型</th>
<th>必填项</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>ID</td>
<td>主键</td>
<td>INT</td>
<td>是</td>
<td>PK</td>
</tr>
<tr>
<td>CARD_PROVICE</td>
<td>身份证号省代码</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CARD_CITY</td>
<td>身份证号市代码</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CARD_ZONE</td>
<td>身份证号区域代码</td>
<td>VARCHAR(20)</td>
<td>是</td>
<td></td>
</tr>
<tr>
<td>CARD_DESC</td>
<td>身份证号归属地信息</td>
<td>VARCHAR(100)</td>
<td>是</td>
</tr>
</tbody>
</table>
<h1 id="第三方原始数据"><a href="#第三方原始数据" class="headerlink" title="第三方原始数据"></a>第三方原始数据</h1><h2 id="同盾反欺诈日志"><a href="#同盾反欺诈日志" class="headerlink" title="同盾反欺诈日志"></a>同盾反欺诈日志</h2><h2 id="用户通话记录"><a href="#用户通话记录" class="headerlink" title="用户通话记录"></a>用户通话记录</h2><h1 id="附录"><a href="#附录" class="headerlink" title="附录"></a>附录</h1><h2 id="数据字典"><a href="#数据字典" class="headerlink" title="数据字典"></a>数据字典</h2><table>
<thead>
<tr>
<th>字典代码</th>
<th>中文名称</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>001001</td>
<td>用户状态</td>
<td></td>
</tr>
<tr>
<td>001001001</td>
<td>未授信</td>
<td></td>
</tr>
<tr>
<td>001001002</td>
<td>已授信</td>
<td></td>
</tr>
<tr>
<td>001001003</td>
<td>拒绝授信-可立即重申</td>
<td></td>
</tr>
<tr>
<td>001001004</td>
<td>拒绝授信-可30天后重申</td>
<td></td>
</tr>
<tr>
<td>001001005</td>
<td>永久拒绝</td>
<td></td>
</tr>
<tr>
<td>001001006</td>
<td>授信失效</td>
<td></td>
</tr>
<tr>
<td>001002</td>
<td>借款状态</td>
<td></td>
</tr>
<tr>
<td>001002001</td>
<td>审核中</td>
<td></td>
</tr>
<tr>
<td>001002002</td>
<td>审核拒绝</td>
<td></td>
</tr>
<tr>
<td>001002003</td>
<td>待放款</td>
<td></td>
</tr>
<tr>
<td>001002004</td>
<td>放款失败</td>
<td></td>
</tr>
<tr>
<td>001002005</td>
<td>待还款</td>
<td></td>
</tr>
<tr>
<td>001002006</td>
<td>逾期</td>
<td></td>
</tr>
<tr>
<td>001002007</td>
<td>已还清</td>
<td></td>
</tr>
<tr>
<td>001003</td>
<td>审核状态</td>
<td></td>
</tr>
<tr>
<td>001003001</td>
<td>审核中</td>
<td>用于自动审核场景，自动审核出结果之前的状态</td>
</tr>
<tr>
<td>001003002</td>
<td>自动审核通过</td>
<td></td>
</tr>
<tr>
<td>001003003</td>
<td>自动审核驳回</td>
<td></td>
</tr>
<tr>
<td>001003004</td>
<td>待签收</td>
<td></td>
</tr>
<tr>
<td>001003005</td>
<td>已签收</td>
<td></td>
</tr>
<tr>
<td>001003006</td>
<td>审核通过</td>
<td></td>
</tr>
<tr>
<td>001003007</td>
<td>审核驳回</td>
<td></td>
</tr>
<tr>
<td>001004</td>
<td>性别</td>
<td></td>
</tr>
<tr>
<td>001004001</td>
<td>男</td>
<td></td>
</tr>
<tr>
<td>001004002</td>
<td>女</td>
<td></td>
</tr>
<tr>
<td>001005</td>
<td>日志类型</td>
<td></td>
</tr>
<tr>
<td>001005001</td>
<td>系统</td>
<td></td>
</tr>
<tr>
<td>001005002</td>
<td>客户</td>
<td></td>
</tr>
<tr>
<td>001005003</td>
<td>客服</td>
<td></td>
</tr>
<tr>
<td>001006</td>
<td>流水类型</td>
<td></td>
</tr>
<tr>
<td>001006001</td>
<td>放款</td>
<td></td>
</tr>
<tr>
<td>001006002</td>
<td>还款</td>
<td></td>
</tr>
<tr>
<td>001007</td>
<td>银行卡类型</td>
<td></td>
</tr>
<tr>
<td>001007001</td>
<td>储蓄卡</td>
<td></td>
</tr>
<tr>
<td>001009</td>
<td>后台用户状态</td>
<td></td>
</tr>
<tr>
<td>001009001</td>
<td>正常</td>
<td></td>
</tr>
<tr>
<td>001009002</td>
<td>停用</td>
<td></td>
</tr>
<tr>
<td>001009003</td>
<td>删除</td>
<td></td>
</tr>
<tr>
<td>001010</td>
<td>后台用户角色</td>
<td></td>
</tr>
<tr>
<td>001010001</td>
<td>系统管理员</td>
<td></td>
</tr>
<tr>
<td>001010002</td>
<td>业务人员</td>
<td></td>
</tr>
<tr>
<td>001011</td>
<td>短信验证码状态</td>
<td></td>
</tr>
<tr>
<td>001011001</td>
<td>正常</td>
<td></td>
</tr>
<tr>
<td>001011002</td>
<td>过期</td>
<td></td>
</tr>
<tr>
<td>001011003</td>
<td>已使用</td>
<td></td>
</tr>
<tr>
<td>001012</td>
<td>短信状态报告</td>
<td></td>
</tr>
<tr>
<td>001012001</td>
<td>未接收</td>
<td></td>
</tr>
<tr>
<td>001012002</td>
<td>已接收</td>
<td></td>
</tr>
<tr>
<td>001013</td>
<td>短信验证类型</td>
<td></td>
</tr>
<tr>
<td>001013001</td>
<td>手机号绑定</td>
<td></td>
</tr>
<tr>
<td>001013002</td>
<td>银行卡绑定</td>
<td></td>
</tr>
<tr>
<td>001014</td>
<td>关系类型</td>
<td></td>
</tr>
<tr>
<td>001014001</td>
<td>父母</td>
<td></td>
</tr>
<tr>
<td>001014002</td>
<td>配偶</td>
<td></td>
</tr>
<tr>
<td>001014003</td>
<td>兄弟姐妹</td>
<td></td>
</tr>
<tr>
<td>001015</td>
<td>审核状态</td>
<td></td>
</tr>
<tr>
<td>001015001</td>
<td>未提交</td>
<td></td>
</tr>
<tr>
<td>001015002</td>
<td>审核中</td>
<td>用于自动审核场景，自动审核出结果之前的状态</td>
</tr>
<tr>
<td>001015003</td>
<td>自动审核通过</td>
<td></td>
</tr>
<tr>
<td>001015004</td>
<td>自动审核驳回</td>
<td></td>
</tr>
<tr>
<td>001015005</td>
<td>待签收</td>
<td></td>
</tr>
<tr>
<td>001015006</td>
<td>已签收</td>
<td></td>
</tr>
<tr>
<td>001015007</td>
<td>审核通过</td>
<td></td>
</tr>
<tr>
<td>001015008</td>
<td>审核驳回</td>
<td></td>
</tr>
<tr>
<td>001016</td>
<td>风控验证类型</td>
<td></td>
</tr>
<tr>
<td>001016001</td>
<td>同盾反欺诈</td>
<td></td>
</tr>
<tr>
<td>001016002</td>
<td></td>
<td></td>
</tr>
<tr>
<td>001016003</td>
<td></td>
<td></td>
</tr>
<tr>
<td>001017</td>
<td>短信发送状态</td>
<td></td>
</tr>
<tr>
<td>001017001</td>
<td>发送成功</td>
<td></td>
</tr>
<tr>
<td>001017002</td>
<td>发送失败</td>
<td></td>
</tr>
<tr>
<td>001018</td>
<td>接口调用状态</td>
<td>借款记录推送状态</td>
</tr>
<tr>
<td>001018001</td>
<td>调用成功</td>
<td></td>
</tr>
<tr>
<td>001018002</td>
<td>调用失败</td>
<td></td>
</tr>
<tr>
<td>001019</td>
<td>流程步骤</td>
<td>借款日志流程步骤</td>
</tr>
<tr>
<td>001019001</td>
<td>借款申请</td>
<td></td>
</tr>
<tr>
<td>001019002</td>
<td>借款审核</td>
<td></td>
</tr>
<tr>
<td>001019003</td>
<td>放款成功</td>
<td></td>
</tr>
<tr>
<td>001019004</td>
<td>审核失败</td>
<td></td>
</tr>
<tr>
<td>001020</td>
<td>还款方式</td>
<td></td>
</tr>
<tr>
<td>001020001</td>
<td>一次还清</td>
<td></td>
</tr>
<tr>
<td>001020002</td>
<td>等额本金</td>
<td></td>
</tr>
<tr>
<td>001021</td>
<td>还款状态</td>
<td></td>
</tr>
<tr>
<td>001021001</td>
<td>待还款</td>
<td></td>
</tr>
<tr>
<td>001021002</td>
<td>部分还款</td>
<td></td>
</tr>
<tr>
<td>001021003</td>
<td>逾期</td>
<td></td>
</tr>
<tr>
<td>001021004</td>
<td>已还清</td>
<td></td>
</tr>
<tr>
<td>001022</td>
<td>交易异常类型</td>
<td></td>
</tr>
<tr>
<td>001022001</td>
<td>还款失败</td>
<td></td>
</tr>
<tr>
<td>001023</td>
<td>还款方式</td>
<td></td>
</tr>
<tr>
<td>001023001</td>
<td>银行卡还款</td>
<td></td>
</tr>
<tr>
<td>001024</td>
<td>提前还款状态</td>
<td></td>
</tr>
<tr>
<td>001024001</td>
<td>未提前还款</td>
<td></td>
</tr>
<tr>
<td>001024002</td>
<td>部分提前还款</td>
<td></td>
</tr>
<tr>
<td>001024003</td>
<td>全额提前还款</td>
<td></td>
</tr>
<tr>
<td>001025</td>
<td>逾期状态</td>
<td></td>
</tr>
<tr>
<td>001025001</td>
<td>未逾期</td>
<td></td>
</tr>
<tr>
<td>001025002</td>
<td>已逾期</td>
<td></td>
</tr>
<tr>
<td>001026</td>
<td>借款期限单位</td>
<td></td>
</tr>
<tr>
<td>001026001</td>
<td>周</td>
<td></td>
</tr>
<tr>
<td>001026002</td>
<td>月</td>
<td></td>
</tr>
<tr>
<td>001027</td>
<td>数据来源</td>
<td></td>
</tr>
<tr>
<td>001027001</td>
<td>微博</td>
<td></td>
</tr>
<tr>
<td>001027002</td>
<td>微信</td>
<td></td>
</tr>
<tr>
<td>001028</td>
<td>授信金额</td>
<td></td>
</tr>
<tr>
<td>001028001</td>
<td>500</td>
<td></td>
</tr>
<tr>
<td>001028002</td>
<td>800</td>
<td></td>
</tr>
<tr>
<td>001028003</td>
<td>1000</td>
<td></td>
</tr>
<tr>
<td>001029</td>
<td>反欺诈评估结果</td>
<td></td>
</tr>
<tr>
<td>001029001</td>
<td>Accept</td>
<td>无风险</td>
</tr>
<tr>
<td>001029002</td>
<td>Review</td>
<td>低风险</td>
</tr>
<tr>
<td>001029003</td>
<td>Reject</td>
<td>高风险</td>
</tr>
<tr>
<td>001030</td>
<td>手机操作系统</td>
<td></td>
</tr>
<tr>
<td>001030001</td>
<td>Android</td>
<td></td>
</tr>
<tr>
<td>001030002</td>
<td>IOS</td>
<td></td>
</tr>
<tr>
<td>001031</td>
<td>短信通道</td>
<td></td>
</tr>
<tr>
<td>001031001</td>
<td>微博短信</td>
<td></td>
</tr>
<tr>
<td>001031002</td>
<td>筑望短信</td>
<td></td>
</tr>
<tr>
<td>001032</td>
<td>消息类型</td>
<td></td>
</tr>
<tr>
<td>001032001</td>
<td>验证码</td>
<td></td>
</tr>
<tr>
<td>001033</td>
<td>短信类型</td>
<td></td>
</tr>
<tr>
<td>001033001</td>
<td>下行短信</td>
<td></td>
</tr>
<tr>
<td>001033002</td>
<td>上行短信</td>
<td></td>
</tr>
<tr>
<td>001034</td>
<td>操作类型</td>
<td></td>
</tr>
<tr>
<td>001034001</td>
<td>检入</td>
<td></td>
</tr>
<tr>
<td>001034002</td>
<td>检出</td>
<td></td>
</tr>
<tr>
<td>001034003</td>
<td>审批</td>
<td></td>
</tr>
<tr>
<td>001035</td>
<td>借款交易状态</td>
<td></td>
</tr>
<tr>
<td>001035001</td>
<td>成功</td>
<td></td>
</tr>
<tr>
<td>001035002</td>
<td>失败</td>
</tr>
</tbody>
</table>
<h2 id="字典SQL"><a href="#字典SQL" class="headerlink" title="字典SQL"></a>字典SQL</h2><p>INSERT INTO DICT_INFO(‘ID’,’DICT_CODE’,’DICT_NAME’,’PARENT_CODE’,’PARENT_ID’,’DICT_LEVEL’,’MEMO’,’DICT_STATUS’,’CREATE_TIME’)VALUES(1,’001’,’微贷’,’0’,0,1,NULL,1,’2016-09-30 16:06:00’);</p>
<p>INSERT INTO DICT_INFO(‘ID’,’DICT_CODE’,’DICT_NAME’,’PARENT_CODE’,’PARENT_ID’,’DICT_LEVEL’,’MEMO’,’DICT_STATUS’,’CREATE_TIME’)VALUES(2,’001001’,’用户状态’,’001’,1,2,NULL,1,’2016-09-30 16:06:00’);</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="http://yoursite.com/2016/09/13/数据库表结构/" data-id="ciw3i5tal0001wwm9nxxrit14" class="article-share-link">Share</a>
      
      
  <ul class="article-tag-list"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/tags/command/">command</a></li><li class="article-tag-list-item"><a class="article-tag-list-link" href="/tags/git/">git</a></li></ul>

    </footer>
  </div>
  
</article>


</section>
        
          <aside id="sidebar">
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Tags</h3>
    <div class="widget">
      <ul class="tag-list"><li class="tag-list-item"><a class="tag-list-link" href="/tags/command/">command</a></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/git/">git</a></li></ul>
    </div>
  </div>


  <div class="widget-wrap">
    <h3 class="widget-title">Tag Cloud</h3>
    <div class="widget tagcloud">
      <a href="/tags/command/" style="font-size: 10px;">command</a> <a href="/tags/git/" style="font-size: 10px;">git</a>
    </div>
  </div>

  
  <div class="widget-wrap">
    <h3 class="widget-title">Archives</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/archives/2016/11/">November 2016</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2016/09/">September 2016</a></li></ul>
    </div>
  </div>


  <div class="widget-wrap">
    <h3 class="widget-title">Recent Posts</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/2016/11/29/hello-world/">Hello World</a>
          </li>
        
          <li>
            <a href="/2016/09/13/数据库表结构/">数据库表结构</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      &copy; 2016 John Doe<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>
    </div>
    <nav id="mobile-nav">
  
    <a href="/" class="mobile-nav-link">Home</a>
  
    <a href="/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    

<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>


  <link rel="stylesheet" href="/fancybox/jquery.fancybox.css">
  <script src="/fancybox/jquery.fancybox.pack.js"></script>


<script src="/js/script.js"></script>

  </div>
</body>
</html>