EcWkUMVZ

1--
2-- Структура таблицы `assignment`
3--
4
5CREATE TABLE IF NOT EXISTS `assignment` (
6  `assignment_id` int(11) NOT NULL AUTO_INCREMENT,
7  `assignment_create` datetime NOT NULL,
8  `assignment_deadline` datetime NOT NULL,
9  `assignment_type` int(11) NOT NULL,
10  `assignment_name` varchar(255) NOT NULL,
11  `assignment_process` int(11) NOT NULL,
12  `assignment_author` int(11) NOT NULL,
13  `assignment_actionee` int(11) NOT NULL,
14  `assignment_department` int(11) DEFAULT NULL,
15  `assignment_process_group` int(11) DEFAULT NULL,
16  `assignment_process_stage` int(11) DEFAULT NULL,
17  `assignment_process_performer` int(11) NOT NULL,
18  `assignment_grade` int(11) NOT NULL,
19  `assignment_status` int(11) NOT NULL DEFAULT '1',
20  `assignment_from` varchar(255) DEFAULT NULL,
21  `descriptions` text,
22  `send_message` int(11) DEFAULT NULL,
23  `execution_time` datetime DEFAULT NULL,
24  `contragent_id` int(11) DEFAULT NULL,
25  `contractor_id` int(11) DEFAULT [...]
26	
27`assignment_id` int(11) NOT NULL AUTO_INCREMENT