01-db.rst.txt 1.28 KB
数据库设计
=======================

合同表
++++++++++++

   表名: tb_contract

   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   |  字段名称             |  是否必填   |  类型     |  限制     |  唯一   |  说明                    |
   +=======================+=============+===========+===========+=========+==========================+
   | contract_code         | *是*        | string    |   <=50    |  是     | 合同编号(合同表主键      |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | salesperson_unid      | *是*        | string    |   <=32    |  是     | 销售员,通过code服       |
   |                       |             |           |           |         | 务进行选择               |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+
   | customer_unid         | *是*        | string    |   <=50    |  是     | 客户名称,通过code服务   |
   |                       |             |           |           |         | 进行选择                 |
   +-----------------------+-------------+-----------+-----------+---------+--------------------------+