t

 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
CREATE TABLE `participant_nis` (
`citizen_id` int(11) DEFAULT NULL,
`military_units_id` int(11) DEFAULT NULL,
`registration_number` varchar(20) DEFAULT NULL,
`registration_number_2` varchar(20) DEFAULT NULL,
`document_number` varchar(20) DEFAULT NULL,
`document_date` date DEFAULT NULL,
`person_approved_document` varchar(256) DEFAULT NULL,
`military_control` varchar(256) DEFAULT NULL,
`entry_register_date` date DEFAULT NULL,
`report_date` date DEFAULT NULL,
`saving_sum` varchar(9) DEFAULT NULL,
`personal_account` varchar(20) DEFAULT NULL,
`inn_kpp` varchar(22) DEFAULT NULL,
`credit_organization_name` varchar(256) DEFAULT NULL,
`bik` varchar(9) DEFAULT NULL,
`k_s` varchar(20) DEFAULT NULL,
`postal_address` varchar(200) DEFAULT NULL,
`contact_phone` varchar(16) DEFAULT NULL,
`chief_phone` varchar(16) DEFAULT NULL,
`telephone_trustees` varchar(16) DEFAULT NULL,
`participating_type` int(11) DEFAULT NULL,
`participating_type2` int(11) DEFAULT NULL,
`year1` int(11) DEFAULT NULL,
`year2` int(11) DEFAULT NULL,
`year3` int(11) DEFAULT NULL,
`year4` int(11) DEFAULT NULL,
`month1` int(11) DEFAULT NULL,
`month2` int(11) DEFAULT NULL,
`day` int(11) DEFAULT NULL,
`inclusion_type` int(11) DEFAULT NULL,
`inclusion_reason` varchar(256) DEFAULT NULL,
`inclusion_date` date DEFAULT NULL,
`exclusion_reason` varchar(256) DEFAULT NULL,
`exclusion_date` date DEFAULT NULL,
`date2` date DEFAULT NULL,
`accumulation_right` int(11) DEFAULT NULL,
`right_date` date DEFAULT NULL,
`military_address` text,
`date_notification` date DEFAULT NULL,
`notification_number` text,
`notification_delivery_date` date DEFAULT NULL,
`covering_letter` text,
`quantity_of_transition` int(11) DEFAULT NULL,
`note` text,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8