V99i62Tj

1CREATE TABLE IF NOT EXISTS `worksheet` (
2  `id` int(11) NOT NULL,
3  `change_control_number` varchar(255) DEFAULT NULL,
4  `project_title` varchar(255) DEFAULT NULL,
5  `project_owner` varchar(100) DEFAULT NULL,
6  `initiator` varchar(50) DEFAULT NULL,
7  `submit_date` date DEFAULT NULL,
8  `expected_implementation_date` date DEFAULT NULL,
9  `site` varchar(50) DEFAULT NULL,
10  `project_type` int(11) NOT NULL,
11  `status` int(11) DEFAULT NULL,
12  `approval_step` int(11) NOT NULL,
13  `approval_status` int(11) DEFAULT '0',
14  `openway_project_status` int(11) NOT NULL,
15  `emergency_request_status` int(11) DEFAULT NULL,
16  `current_operation` mediumtext,
17  `current_operation_file` varchar(255) DEFAULT NULL,
18  `proposed_operation_impact` mediumtext,
19  `proposed_operation_impact_file` varchar(255) DEFAULT NULL,
20  `rationale_justification` mediumtext,
21  `rationale_justification_file` varchar(255) DEFAULT NULL,
22  `change_control_category` varchar(255) DEFAULT '[]',
23  `area_affected` mediumtext,
24  `product_material_affected` mediumtext,
25  `number_affected` mediumtext,
26  `nrc_number` varchar(50) DEFAULT NULL,
27  `supplier_site_affected` mediumtext,
28  `cost_center` varchar(50) DEFAULT NULL,
29  `countries_markets_affected` mediumtext,
30  `safety_environment` varchar(255) DEFAULT '[]',
31  `safety_environment_impact` mediumtext,
32  `food_safety_quality` varchar(255) DEFAULT '[]',
33  `food_safety_quality_impact` mediumtext,
34  `cost` varchar(255) DEFAULT '[]',
35  `cost_impact` mediumtext,
36  `delivery` varchar(255) DEFAULT '[]',
37  `delivery_impact` mediumtext,
38  `motivation` varchar(255) DEFAULT '[]',
39  `motivation_impact` mediumtext,
40  `traceability` varchar(255) DEFAULT '[]',
41  `traceability_impact` mediumtext,
42  `production_maintenance` varchar(255) DEFAULT '[]',
43  `production_maintenance_impact` mediumtext,
44  `trial_date` date DEFAULT NULL,
45  `trial_purpose` mediumtext,
46  `trial_scope` mediumtext,
47  `qfs_status_score` varchar(20) DEFAULT NULL,
48  `trial_result` mediumtext,
49  `recommendation` mediumtext,
50  `ex_trial_quantity` varchar(20) DEFAULT NULL,
51  `ex_trial_usage` mediumtext,
52  `production_date` date DEFAULT NULL,
53  `production_scope` mediumtext,
54  `post_implementation_result` mediumtext,
55  `summary` mediumtext,
56  `ccm1_status` varchar(20) DEFAULT NULL,
57  `ccm1_date` date DEFAULT NULL,
58  `ccm1_notes` mediumtext,
59  `safety_risk_assessment_status` varchar(20) DEFAULT NULL,
60  `safety_risk_assessment_notes` varchar(100) DEFAULT NULL,
61  `quality_risk_assessment_status` varchar(20) DEFAULT NULL,
62  `quality_risk_assessment_notes` varchar(100) DEFAULT NULL,
63  `trial_technical_meeting_status` varchar(100) DEFAULT NULL,
64  `trial_technical_meeting_date` date DEFAULT NULL,
65  `trial_technical_meeting_notes` varchar(100) DEFAULT NULL,
66  `trial_review_status` varchar(20) DEFAULT NULL,
67  `trial_review_date` date DEFAULT NULL,
68  `trial_review_notes` varchar(100) DEFAULT NULL,
69  `handover_doc_status` varchar(20) DEFAULT NULL,
70  `handover_doc_notes` varchar(100) DEFAULT NULL,
71  `ccm2_status` varchar(20) DEFAULT NULL,
72  `ccm2_date` date DEFAULT NULL,
73  `ccm2_notes` mediumtext,
74  `actual_implementation_status` varchar(20) DEFAULT NULL,
75  `actual_implementation_date` date DEFAULT NULL,
76  `post_implementation_review1_status` varchar(20) DEFAULT NULL,
77  `post_implementation_review1_date` date DEFAULT NULL,
78  `post_implementation_review2_status` varchar(20) DEFAULT NULL,
79  `post_implementation_review2_date` date DEFAULT NULL,
80  `post_implementation_review3_status` varchar(20) DEFAULT NULL,
81  `post_implementation_review3_date` date DEFAULT NULL,
82  `post_launch_doc_completion_status` varchar(20) DEFAULT NULL,
83  `post_launch_doc_completion_notes` varchar(100) DEFAULT NULL,
84  `ccm3_status` varchar(20) DEFAULT NULL,
85  `ccm3_date` date DEFAULT NULL,
86  `ccm3_notes` mediumtext,
87  `status_delete` int(11) NOT NULL DEFAULT '1',
88  `_created_by` varchar(255) DEFAULT NULL,
89  `_updated_by` varchar(255) DEFAULT NULL,
90  `_created_time` datetime DEFAULT NULL,
91  `_updated_time` datetime DEFAULT NULL
92) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;