数据库设计
=======================

销售合同表
++++++++++++

   表名： tb_contract

   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | contract_unid         | *是*        | PK        |   <=32    |  是     | 合同id                   |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | salesperson_unid      | *是*        | string    |   <=255   |  否     |销售员id，通过auth服务获取|
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | project_unid          | *是*        | FK        |           |  否     | 项目id(int类型)          |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | customer_unid         | *是*        | FK        |           |  否     | 客户id(int类型)          |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | province              | *否*        | string    |   <=32    |  否     | 项目所在地的省份，通过   |
   |                       |             |           |           |         | code服务行选择           |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | city                  | *否*        | string    |   <=32    |  否     | 项目所在地的市，通过     |
   |                       |             |           |           |         | code服务行选择行选择     |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | county                | *否*        | string    |   <=32    |  否     | 项目所在地的县（区），通 |
   |                       |             |           |           |         | 过code服务进行选择       |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | guarantee_period      | *否*        | int       |           |  否     | 质保周期，单位是月       |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | sign_date             | *否*        | date      |           |  否     | 签订时间                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | product_line_type     | *否*        | string    |   <=32    |  否     | 产品线类型，通过code服务 |
   |                       |             |           |           |         | 进行选择                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_state        | *否*        | string    |   <=32    |  否     | 合同状态，通过code服务进 |
   |                       |             |           |           |         | 行选择                   |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_type         | *否*        | string    |   <=32    |  否     | 合同类型，通过code服务进 |
   |                       |             |           |           |         | 行选择                   |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_amount       | *否*        | float     |           |  否     | 合同金额                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | deduct_amount         | *否*        | float     |           |  否     | 抵扣金额                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_amount_note  | *否*        | text      |           |  否     | 合同金额备注             |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | stop_amount           | *否*        | float     |           |  否     | 暂停金额                 |              
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | reback_note           | *否*        | text      |           |  否     | 累计回款额备注           |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | exemptions_amount     | *否*        | float     |           |  否     | 豁免金额                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_remain_note  | *否*        | text      |           |  否     | 合同余额备注             |          
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | is_archive            | *否*        | bool      |           |  否     | 是否归档                 |            
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | bad_amount            | *否*        | float     |           |  否     | 坏账金额                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | bad_amount_note       | *否*        | text      |           |  否     | 坏账金额备注             |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | confirm_income_amount | *否*        | float     |           |  否     | 确定收入金额             |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | amount_state_unid     | *否*        | string    |   <=32    |  否     | 账款状态,通过code服务进行|
   |                       |             |           |           |         | 选择                     |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | start_guarantee_date  | *否*        | date      |           |  否     | 维保服务期开始时间       |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | end_guarantee_date    | *否*        | date      |           |  否     | 维保服务期结束时间       |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | mainten_start_point   | *否*        | string    |   <=32    |  否     | 质保期开始节点           |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_note         | *否*        | text      |           |  否     | 合同备注                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | is_delete             | *否*        | bool      |           |  否     | 合同删除标识             |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+

   
付款约定表
++++++++++++

   表名：tb_payment_agree
   
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | payment_unid          | *是*        | PK        |           |  是     | 主键(自增长的int类型)    |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+ 
   | contract_unid         | *是*        | FK        |   <=32    |  否     | 合同编号                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | payment_type          | *是*        | string    |   <=32    |  否     | 付款类型，通过code服务进 |
   |                       |             |           |           |         | 行选择                   |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | payment_progress      | *是*        | int       |           |  否     | 付款进度                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | days                  | *是*        | int       |           |  否     | 天数                     |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | payment_propority     | *是*        | float     |           |  否     | 付款比例                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | payment_requirement   | *否*        | text      |           |  否     | 付款条件                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+

   
   
合同回款信息表
++++++++++++++++++

   表名：tb_return_info
   
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | reback_unid           | *是*        | PK        |           |  是     | 主键(自增长的int类型)    |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+ 
   | contract_unid         | *是*        | FK        |   <=32    |  否     | 合同编号                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | reback_progress       | *是*        | int       |           |  否     | 回款进度                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | reback_date           | *是*        | date      |           |  否     | 回款时间                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | actual_reback_amount  | *是*        | float     |           |  否     | 实际回款数额             |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | reback_note           | *否*        | text      |           |  否     | 回款备注                 |          
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   
   
合同开票信息表
+++++++++++++++++++++

   表名：tb_receipt
   
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | receipt_unid          | *是*        | PK        |           |  是     |主键(自增长的int类型)     |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_unid         | *是*        | FK        |   <=32    |  否     | 合同编号                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | receipt_progress      | *是*        | int       |           |  否     | 开票进度                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | receipt_amount        | *是*        | float     |           |  否     | 开票金额                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | oa_flow_id            | *是*        | string    |   <=32    |  否     | oa流水号                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | receipt_note          | *否*        | text      |           |  否     | 发票备注                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | create_date           | *是*        | date      |           |  否     | 开票日期                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   
   
发货信息表
++++++++++++++++

   表名：tb_deliver_goods
   
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | deliver_unid          | *是*        | PK        |           |  是     | 主键(自增长的int类型)    |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_unid         | *是*        | FK        |   <=32    |  否     | 合同编号                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | deliver_goods_date    | *是*        | date      |           |  否     | 发货日期                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | goods_acceptanc_date  | *是*        | date      |           |  否     | 到货验收日期             |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   
   
工程验收信息表
+++++++++++++++++++

   表名：tb_project_acceptanc
   
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | acceptanc_unid        | *是*        | PK        |           |  是     | 主键(自增长的int类型)    |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | contract_unid         | *是*        | FK        |   <=32    |  否     | 合同编号                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | acceptanc_type        | *是*        | string    |   <=32    |  否     | 验收类型(1为初验、2为终验|
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | acceptanc_date        | *是*        | date      |           |  否     | 验收时间                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | acceptanc_note        | *否*        | text      |           |  否     | 验收备注                 |              
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   
   
附件表
++++++++++++

   表名：tb_appendix
   
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | appendix_unid         | *是*        | PK        |           |  是     | 附件主键(自增长的int类型)|
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | business_table        | *是*        | string    |   <=32    |  否     | 业务表名                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | business_unid         | *是*        | string    |   <=32    |  否     | 业务表主键               |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | appendix_name         | *是*        | string    |   <=255   |  否     | 附件文件名               |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | appendix_type         | *是*        | string    |   <=32    |  否     | 附件类型                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | appendix_url          | *是*        | string    |   <=255   |  否     | 附件下载地址             |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   
   

   
   
   
项目表
++++++++++++

   表名：tb_project

   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | project_unid          | *是*        | PK        |           |  是     | 项目id(自增长的int类型)  |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | project_name          | *是*        | string    |   <=255   |  是     | 项目名称                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   
   
客户表
++++++++++++

   表名：tb_customer

   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | customer_unid         | *是*        | PK        |           |  是     | 客户id(自增长的int类型)  |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | customer_name         | *是*        | string    |   <=255   |  是     | 客户名称                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+