<!DOCTYPE html> <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]--> <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]--> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>1. 数据库设计 — finance_serv 1.0 documentation</title> <link rel="stylesheet" href="_static/css/theme.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> <link rel="index" title="Index" href="genindex.html" /> <link rel="search" title="Search" href="search.html" /> <link rel="next" title="2. 财务进度服务http接口" href="02-finance-http.html" /> <link rel="prev" title="财务进度服务设计" href="index.html" /> <script src="_static/js/modernizr.min.js"></script> </head> <body class="wy-body-for-nav"> <div class="wy-grid-for-nav"> <nav data-toggle="wy-nav-shift" class="wy-nav-side"> <div class="wy-side-scroll"> <div class="wy-side-nav-search"> <a href="index.html" class="icon icon-home"> finance_serv </a> <div class="version"> 1.0 </div> <div role="search"> <form id="rtd-search-form" class="wy-form" action="search.html" method="get"> <input type="text" name="q" placeholder="Search docs" /> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> </div> </div> <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation"> <p class="caption"><span class="caption-text">目录:</span></p> <ul class="current"> <li class="toctree-l1 current"><a class="current reference internal" href="#">1. 数据库设计</a><ul> <li class="toctree-l2"><a class="reference internal" href="#id2">1.1. 销售合同表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id3">1.2. 付款约定表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id4">1.3. 合同回款信息表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id5">1.4. 合同开票信息表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id6">1.5. 发货信息表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id7">1.6. 工程验收信息表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id8">1.7. 附件表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id9">1.8. 项目表</a></li> <li class="toctree-l2"><a class="reference internal" href="#id10">1.9. 客户表</a></li> </ul> </li> <li class="toctree-l1"><a class="reference internal" href="02-finance-http.html">2. 财务进度服务http接口</a></li> <li class="toctree-l1"><a class="reference internal" href="99-history.html">3. 修订历史</a></li> </ul> </div> </div> </nav> <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap"> <nav class="wy-nav-top" aria-label="top navigation"> <i data-toggle="wy-nav-top" class="fa fa-bars"></i> <a href="index.html">finance_serv</a> </nav> <div class="wy-nav-content"> <div class="rst-content"> <div role="navigation" aria-label="breadcrumbs navigation"> <ul class="wy-breadcrumbs"> <li><a href="index.html">Docs</a> »</li> <li>1. 数据库设计</li> <li class="wy-breadcrumbs-aside"> <a href="_sources/01-db.rst.txt" rel="nofollow"> View page source</a> </li> </ul> <hr/> </div> <div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article"> <div itemprop="articleBody"> <div class="section" id="id1"> <h1>1. 数据库设计<a class="headerlink" href="#id1" title="Permalink to this headline">¶</a></h1> <div class="section" id="id2"> <h2>1.1. 销售合同表<a class="headerlink" href="#id2" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名: tb_contract</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>contract_unid</td> <td><em>是</em></td> <td>PK</td> <td><=32</td> <td>是</td> <td>合同id</td> </tr> <tr class="row-odd"><td>salesperson_unid</td> <td><em>是</em></td> <td>string</td> <td><=255</td> <td>否</td> <td>销售员id,通过auth服务获取</td> </tr> <tr class="row-even"><td>project_unid</td> <td><em>是</em></td> <td>FK</td> <td> </td> <td>否</td> <td>项目id(int类型)</td> </tr> <tr class="row-odd"><td>customer_unid</td> <td><em>是</em></td> <td>FK</td> <td> </td> <td>否</td> <td>客户id(int类型)</td> </tr> <tr class="row-even"><td>province</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>项目所在地的省份,通过 code服务行选择</td> </tr> <tr class="row-odd"><td>city</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>项目所在地的市,通过 code服务行选择行选择</td> </tr> <tr class="row-even"><td>county</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>项目所在地的县(区),通 过code服务进行选择</td> </tr> <tr class="row-odd"><td>guarantee_period</td> <td><em>否</em></td> <td>int</td> <td> </td> <td>否</td> <td>质保周期,单位是月</td> </tr> <tr class="row-even"><td>sign_date</td> <td><em>否</em></td> <td>date</td> <td> </td> <td>否</td> <td>签订时间</td> </tr> <tr class="row-odd"><td>product_line_type</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>产品线类型,通过code服务 进行选择</td> </tr> <tr class="row-even"><td>contract_state</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>合同状态,通过code服务进 行选择</td> </tr> <tr class="row-odd"><td>contract_type</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>合同类型,通过code服务进 行选择</td> </tr> <tr class="row-even"><td>contract_amount</td> <td><em>否</em></td> <td>float</td> <td> </td> <td>否</td> <td>合同金额</td> </tr> <tr class="row-odd"><td>deduct_amount</td> <td><em>否</em></td> <td>float</td> <td> </td> <td>否</td> <td>抵扣金额</td> </tr> <tr class="row-even"><td>contract_amount_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>合同金额备注</td> </tr> <tr class="row-odd"><td>stop_amount</td> <td><em>否</em></td> <td>float</td> <td> </td> <td>否</td> <td>暂停金额</td> </tr> <tr class="row-even"><td>reback_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>累计回款额备注</td> </tr> <tr class="row-odd"><td>exemptions_amount</td> <td><em>否</em></td> <td>float</td> <td> </td> <td>否</td> <td>豁免金额</td> </tr> <tr class="row-even"><td>contract_remain_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>合同余额备注</td> </tr> <tr class="row-odd"><td>is_archive</td> <td><em>否</em></td> <td>bool</td> <td> </td> <td>否</td> <td>是否归档</td> </tr> <tr class="row-even"><td>bad_amount</td> <td><em>否</em></td> <td>float</td> <td> </td> <td>否</td> <td>坏账金额</td> </tr> <tr class="row-odd"><td>bad_amount_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>坏账金额备注</td> </tr> <tr class="row-even"><td>confirm_income_amount</td> <td><em>否</em></td> <td>float</td> <td> </td> <td>否</td> <td>确定收入金额</td> </tr> <tr class="row-odd"><td>amount_state_unid</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>账款状态,通过code服务进行 选择</td> </tr> <tr class="row-even"><td>start_guarantee_date</td> <td><em>否</em></td> <td>date</td> <td> </td> <td>否</td> <td>维保服务期开始时间</td> </tr> <tr class="row-odd"><td>end_guarantee_date</td> <td><em>否</em></td> <td>date</td> <td> </td> <td>否</td> <td>维保服务期结束时间</td> </tr> <tr class="row-even"><td>mainten_start_point</td> <td><em>否</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>质保期开始节点</td> </tr> <tr class="row-odd"><td>contract_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>合同备注</td> </tr> <tr class="row-even"><td>is_delete</td> <td><em>否</em></td> <td>bool</td> <td> </td> <td>否</td> <td>合同删除标识</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id3"> <h2>1.2. 付款约定表<a class="headerlink" href="#id3" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_payment_agree</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>payment_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>主键(自增长的int类型)</td> </tr> <tr class="row-odd"><td>contract_unid</td> <td><em>是</em></td> <td>FK</td> <td><=32</td> <td>否</td> <td>合同编号</td> </tr> <tr class="row-even"><td>payment_type</td> <td><em>是</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>付款类型,通过code服务进 行选择</td> </tr> <tr class="row-odd"><td>payment_progress</td> <td><em>是</em></td> <td>int</td> <td> </td> <td>否</td> <td>付款进度</td> </tr> <tr class="row-even"><td>days</td> <td><em>是</em></td> <td>int</td> <td> </td> <td>否</td> <td>天数</td> </tr> <tr class="row-odd"><td>payment_propority</td> <td><em>是</em></td> <td>float</td> <td> </td> <td>否</td> <td>付款比例</td> </tr> <tr class="row-even"><td>payment_requirement</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>付款条件</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id4"> <h2>1.3. 合同回款信息表<a class="headerlink" href="#id4" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_return_info</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>reback_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>主键(自增长的int类型)</td> </tr> <tr class="row-odd"><td>contract_unid</td> <td><em>是</em></td> <td>FK</td> <td><=32</td> <td>否</td> <td>合同编号</td> </tr> <tr class="row-even"><td>reback_progress</td> <td><em>是</em></td> <td>int</td> <td> </td> <td>否</td> <td>回款进度</td> </tr> <tr class="row-odd"><td>reback_date</td> <td><em>是</em></td> <td>date</td> <td> </td> <td>否</td> <td>回款时间</td> </tr> <tr class="row-even"><td>actual_reback_amount</td> <td><em>是</em></td> <td>float</td> <td> </td> <td>否</td> <td>实际回款数额</td> </tr> <tr class="row-odd"><td>reback_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>回款备注</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id5"> <h2>1.4. 合同开票信息表<a class="headerlink" href="#id5" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_receipt</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>receipt_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>主键(自增长的int类型)</td> </tr> <tr class="row-odd"><td>contract_unid</td> <td><em>是</em></td> <td>FK</td> <td><=32</td> <td>否</td> <td>合同编号</td> </tr> <tr class="row-even"><td>receipt_progress</td> <td><em>是</em></td> <td>int</td> <td> </td> <td>否</td> <td>开票进度</td> </tr> <tr class="row-odd"><td>receipt_amount</td> <td><em>是</em></td> <td>float</td> <td> </td> <td>否</td> <td>开票金额</td> </tr> <tr class="row-even"><td>oa_flow_id</td> <td><em>是</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>oa流水号</td> </tr> <tr class="row-odd"><td>receipt_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>发票备注</td> </tr> <tr class="row-even"><td>create_date</td> <td><em>是</em></td> <td>date</td> <td> </td> <td>否</td> <td>开票日期</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id6"> <h2>1.5. 发货信息表<a class="headerlink" href="#id6" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_deliver_goods</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>deliver_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>主键(自增长的int类型)</td> </tr> <tr class="row-odd"><td>contract_unid</td> <td><em>是</em></td> <td>FK</td> <td><=32</td> <td>否</td> <td>合同编号</td> </tr> <tr class="row-even"><td>deliver_goods_date</td> <td><em>是</em></td> <td>date</td> <td> </td> <td>否</td> <td>发货日期</td> </tr> <tr class="row-odd"><td>goods_acceptanc_date</td> <td><em>是</em></td> <td>date</td> <td> </td> <td>否</td> <td>到货验收日期</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id7"> <h2>1.6. 工程验收信息表<a class="headerlink" href="#id7" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_project_acceptanc</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>acceptanc_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>主键(自增长的int类型)</td> </tr> <tr class="row-odd"><td>contract_unid</td> <td><em>是</em></td> <td>FK</td> <td><=32</td> <td>否</td> <td>合同编号</td> </tr> <tr class="row-even"><td>acceptanc_type</td> <td><em>是</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>验收类型(1为初验、2为终验</td> </tr> <tr class="row-odd"><td>acceptanc_date</td> <td><em>是</em></td> <td>date</td> <td> </td> <td>否</td> <td>验收时间</td> </tr> <tr class="row-even"><td>acceptanc_note</td> <td><em>否</em></td> <td>text</td> <td> </td> <td>否</td> <td>验收备注</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id8"> <h2>1.7. 附件表<a class="headerlink" href="#id8" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_appendix</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>appendix_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>附件主键(自增长的int类型)</td> </tr> <tr class="row-odd"><td>business_table</td> <td><em>是</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>业务表名</td> </tr> <tr class="row-even"><td>business_unid</td> <td><em>是</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>业务表主键</td> </tr> <tr class="row-odd"><td>appendix_name</td> <td><em>是</em></td> <td>string</td> <td><=255</td> <td>否</td> <td>附件文件名</td> </tr> <tr class="row-even"><td>appendix_type</td> <td><em>是</em></td> <td>string</td> <td><=32</td> <td>否</td> <td>附件类型</td> </tr> <tr class="row-odd"><td>appendix_url</td> <td><em>是</em></td> <td>string</td> <td><=255</td> <td>否</td> <td>附件下载地址</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id9"> <h2>1.8. 项目表<a class="headerlink" href="#id9" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_project</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>project_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>项目id(自增长的int类型)</td> </tr> <tr class="row-odd"><td>project_name</td> <td><em>是</em></td> <td>string</td> <td><=255</td> <td>是</td> <td>项目名称</td> </tr> </tbody> </table> </div></blockquote> </div> <div class="section" id="id10"> <h2>1.9. 客户表<a class="headerlink" href="#id10" title="Permalink to this headline">¶</a></h2> <blockquote> <div><p>表名:tb_customer</p> <table border="1" class="docutils"> <colgroup> <col width="25%" /> <col width="14%" /> <col width="12%" /> <col width="12%" /> <col width="10%" /> <col width="28%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">字段名称</th> <th class="head">是否必填</th> <th class="head">类型</th> <th class="head">限制</th> <th class="head">唯一</th> <th class="head">说明</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>customer_unid</td> <td><em>是</em></td> <td>PK</td> <td> </td> <td>是</td> <td>客户id(自增长的int类型)</td> </tr> <tr class="row-odd"><td>customer_name</td> <td><em>是</em></td> <td>string</td> <td><=255</td> <td>是</td> <td>客户名称</td> </tr> </tbody> </table> </div></blockquote> </div> </div> </div> </div> <footer> <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation"> <a href="02-finance-http.html" class="btn btn-neutral float-right" title="2. 财务进度服务http接口" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a> <a href="index.html" class="btn btn-neutral" title="财务进度服务设计" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a> </div> <hr/> <div role="contentinfo"> <p> © Copyright 2017, xf. </p> </div> Built with <a href="http://sphinx-doc.org/">Sphinx</a> using a <a href="https://github.com/rtfd/sphinx_rtd_theme">theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>. </footer> </div> </div> </section> </div> <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT:'./', VERSION:'1.0', LANGUAGE:'None', COLLAPSE_INDEX:false, FILE_SUFFIX:'.html', HAS_SOURCE: true, SOURCELINK_SUFFIX: '.txt' }; </script> <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> <script type="text/javascript" src="_static/js/theme.js"></script> <script type="text/javascript"> jQuery(function () { SphinxRtdTheme.Navigation.enable(true); }); </script> </body> </html>