01-db.rst.txt
21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
数据库设计
=======================
销售合同表
++++++++++++
表名： tb_contract
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| contract_code | *是* | string | <=32 | 是 | 合同编号（主键），通过 |
| | | | | | code服务进行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| salesperson_unid | *是* | string | <=32 | 否 | 销售员，通过code服 |
| | | | | | 务进行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| project_unid | *是* | string | <=32 | 否 | 项目名称，通过code服务 |
| | | | | | 进行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| customer_unid | *是* | string | <=32 | 否 | 客户名称，通过code服务 |
| | | | | | 进行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| location_province | *是* | string | <=32 | 否 | 项目所在地的省份 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| location_city | *是* | string | <=32 | 否 | 项目所在地的市 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| location_area | *是* | string | <=32 | 否 | 项目所在地的县（区） |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| quality_cycle | *是* | int | <=16 | 否 | 质保周期，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| sign_date | *是* | date | <=16 | 否 | 签订时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| year | *是* | string | <=4 | 否 | 所属年份 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| month | *是* | string | <=2 | 否 | 所属月份 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| product_line_type | *是* | string | <=32 | 否 | 产品线类型，通过code服务 |
| | | | | | 进行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_state | *是* | string | <=32 | 否 | 合同状态，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_nature | *是* | string | <=32 | 否 | 合同性质，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_amount | *是* | float | <=24 | 否 | 合同金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| deduct_amount | *是* | float | <=24 | 否 | 抵扣金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_amount_note | *否* | text | | 否 | 合同金额备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| total_reback_amount | *是* | float | <=24 | 否 | 累计回款额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| stop_amount | *是* | float | <=24 | 否 | 暂停金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| reback_note | *否* | text | | 否 | 累计回款额备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_remaining | *是* | float | <=24 | 否 | 合同余额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| exemptions_amount | *是* | float | <=24 | 否 | 豁免金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_remain_note | *否* | text | | 否 | 合同余额备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| is_file | *是* | bool | | 否 | 是否归档，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| bad_amount | *是* | float | <=24 | 否 | 坏账金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| bad_amount_note | *否* | text | | 否 | 坏账金额备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| total_receive_amount | *是* | float | <=24 | 否 | 累计应收款 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| total_leave_amount | *是* | float | <=24 | 否 | 应收账款余额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| over_days_unid | *是* | int | <=16 | 否 | 逾期天数 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| confirm_income_amount | *是* | float | <=24 | 否 | 确定收入金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| amount_state_unid | *是* | string | <=32 | 否 | 账款状态,通过code服务进行|
| | | | | | 选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| start_guarantee_date | *是* | date | | 否 | 维保服务期开始时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| end_guarantee_date | *是* | date | | 否 | 维保服务期结束时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| quality_start_point | *是* | string | <=32 | 否 | 质保期开始节点 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| start_quality_date | *是* | date | | 否 | 质保期开始时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| end_quality_date | *是* | date | | 否 | 质保期结束时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_note | *否* | text | | 否 | 合同备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_identify | *否* | bool | | 否 | 合同标识 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
付款约定表
++++++++++++
表名：tb_payment_agree
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| payment_id | *是* | string | <=32 | 是 | 主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_code | *是* | String | <=32 | 否 | 合同编号，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| payment_period_state | *是* | string | <=10 | 否 | 合同状态，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| total_days | *是* | int | <=32 | 否 | 天数 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| payment_agree_date | *是* | date | | 否 | 应付款日期 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| payment_amount | *是* | float | <=16 | 否 | 应付金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| payment_propority | *是* | float | <=16 | 否 | 付款比例，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| payment_requirement | *是* | text | | 否 | 付款条件 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
合同回款信息表
++++++++++++++++++
表名：tb_return_info
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| return_id | *是* | string | <=32 | 是 | 主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_code | *是* | string | <=32 | 否 | 合同编号，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| payment_period_number | *是* | int | <=16 | 否 | 付款期数 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| actual_reback_amount | *是* | float | <=24 | 否 | 实际回款数额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| reback_propority | *是* | float | <=24 | 否 | 回款比例 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| reback_note | *否* | text | | 否 | 回款备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
合同开票信息表
+++++++++++++++++++++
表名：tb_receipt
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| receipt_id | *是* | string | <=32 | 是 | 合同开票信息主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_code | *是* | string | <=32 | 否 | 合同编号，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| receipt_progress | *是* | int | <=16 | 否 | 开票进度 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| receipt_amount | *是* | float | <=24 | 否 | 开票金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| oa_flow_id | *是* | int | <=32 | 否 | oa流水号 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| receipt_propority | *是* | float | <=24 | 否 | 开票比例 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| total_receipt_amount | *是* | float | <=24 | 否 | 累计开票金额 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| is_reback | *否* | bool | | 否 | 是否回款 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| receipt_note | *是* | text | | 否 | 发票备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
发货信息表
++++++++++++++++
表名：tb_deliver_goods
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| deliver_id | *是* | string | <=32 | 是 | 发货信息主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_code | *是* | string | <=32 | 否 | 合同编号，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| deliver_goods_date | *是* | date | | 否 | 发货时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| goods_check_date | *是* | date | | 否 | 到货验收时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
工程验收信息表
+++++++++++++++++++
表名：tb_project_check
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| project_id | *是* | string | <=32 | 是 | 工程验收信息主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| contract_code | *是* | string | <=32 | 否 | 合同编号，通过code服务进 |
| | | | | | 行选择 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| is_first_check | *是* | bool | | 否 | 是否是初验 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| first_check_date | *是* | date | | 否 | 初验时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| is_end_check | *是* | bool | | 否 | 是否是终验 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| end_check_date | *否* | date | | 否 | 终验时间 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| check_note | *否* | text | | 否 | 验收备注 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
附件表
++++++++++++
表名：tb_appendix
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| 字段名称 | 是否必填 | 类型 | 限制 | 唯一 | 说明 |
+=======================+=============+===========+===========+=========+==========================+
| appendix_id | *是* | string | <=32 | 是 | 附件主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| foreign_key | *是* | string | | 是 | 合同及子表的主键 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| appendix_type | *是* | string | | 是 | 附件类型 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+
| appendix_url | *是* | string | | 否 | 附件下载地址 |
+-----------------------+-------------+-----------+-----------+---------+--------------------------+