01-db.rst.txt
1.28 KB
数据库设计
=======================
合同表
++++++++++++
表名: tb_contract
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| contract_code | *是* | string | <=50 | 是 | 合同编号(合同表主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| salesperson_unid | *是* | string | <=32 | 是 | 销售员,通过code服 |
| | | | | | 务进行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| customer_unid | *是* | string | <=50 | 是 | 客户名称,通过code服务 |
| | | | | | 进行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+