contract

#	Имя	Тип	Null
1	id	bigint(20)	UNSIGNED
2	created_at	timestamp	NULL
3	updated_at	timestamp	NULL
4	active	bigint(20)	NOT NULL,
5	status_id	bigint(20)	NOT NULL,
6	number	varchar(255)	COLLATE
7	type	bigint(20)	NOT NULL,
8	payment	bigint(20)	DEFAULT
9	additional	bigint(20)	DEFAULT
10	stocks_id	bigint(20)	DEFAULT
11	client_id	bigint(20)	NOT NULL,
12	date_closed	datetime	DEFAULT
13	comments	longtext	COLLATE
14	assigned_by_id	bigint(20)	DEFAULT
15	created_by_id	bigint(20)	DEFAULT
16	modify_by_id	bigint(20)	DEFAULT
17	closed_by_id	bigint(20)	DEFAULT
18	developer_id	bigint(20)	NOT NULL,
19	deal_id	bigint(20)	NOT NULL,
20	item_id	bigint(20)	NOT NULL,
21	price	bigint(20)	NOT NULL,
22	opportunity	bigint(20)	DEFAULT
23	history_changes	longtext	COLLATE
24	date_contract	varchar(255)	COLLATE
25	deferred	tinyint(1)	DEFAULT
26	period	bigint(20)	DEFAULT
27	first_payment	datetime	DEFAULT
28	deferred_list	longtext	CHARACTER
29	date_send_reg	datetime	DEFAULT
30	date_reg	datetime	DEFAULT
31	description	longtext	COLLATE
32	name_bank	varchar(255)	COLLATE
33	number_mortgage	varchar(255)	COLLATE
34	date_mortgage	varchar(255)	COLLATE
35	term_mortgage	varchar(255)	COLLATE
36	initial_payment	varchar(255)	COLLATE
37	amount_mortgage	varchar(255)	COLLATE
38	deleted_at	timestamp	NULL
39	complex_id	tinyint(4)	DEFAULT
40	house_id	tinyint(4)	DEFAULT