payments
| # | Имя | Тип | Null | Описание |
|---|---|---|---|---|
| 1 | id | bigint(20) | UNSIGNED | |
| 2 | created_at | timestamp | NULL | |
| 3 | updated_at | timestamp | NULL | |
| 4 | active | bigint(20) | COLLATE | |
| 5 | status_id | bigint(20) | COLLATE | |
| 6 | number | varchar(255) | NOT NULL, | |
| 7 | payment_date | datetime | DEFAULT | |
| 8 | deposit_date | datetime | ||
| 9 | date_closed | datetime | ||
| 10 | comments | varchar(255) | ||
| 11 | assigned_by_id | bigint(20) | ||
| 12 | created_by_id | bigint(20) | ||
| 13 | modify_by_id | bigint(20) | ||
| 14 | closed_by_id | bigint(20) | ||
| 15 | client_id | bigint(20) | ||
| 16 | developer_id | bigint(20) | ||
| 17 | contract_id | bigint(20) | ||
| 18 | deal_id | bigint(20) | ||
| 19 | item_id | bigint(20) | ||
| 20 | price | bigint(20) | ||
| 21 | history_changes | longtext |