· 5 years ago · Apr 07, 2020, 08:34 PM
1DROP TABLE IF EXISTS `employment_application`;
2CREATE TABLE IF NOT EXISTS `employment_application` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `position_applying` varchar(125) NOT NULL,
5 `work_in_canada` varchar(125) NOT NULL,
6 `date_to_start` varchar(125) NOT NULL,
7 `desired_pay` varchar(125) NOT NULL,
8 `first_name` varchar(125) NOT NULL,
9 `last_name` varchar(125) NOT NULL,
10 `phone` varchar(12) NOT NULL,
11 `email` varchar(256) NOT NULL,
12 `address` varchar(512) NOT NULL,
13 `street_address` varchar(512) NOT NULL,
14 `province` varchar(125) NOT NULL,
15 `city` varchar(125) NOT NULL,
16 `postal_code` varchar(16) NOT NULL,
17 `education_type_1` varchar(512) NOT NULL,
18 `school_name_1` varchar(512) NOT NULL,
19 `school_city_1` varchar(512) NOT NULL,
20 `school_state_1` varchar(512) NOT NULL,
21 `areas_studied_1` varchar(512) NOT NULL,
22 `primary_earned_1` varchar(512) NOT NULL,
23 `secondary_earned_1` varchar(512) NOT NULL,
24 `date_started_1` varchar(16) NOT NULL,
25 `date_ended_1` varchar(16) NOT NULL,
26 `education_type_2` varchar(512) NOT NULL,
27 `school_name_2` varchar(512) NOT NULL,
28 `school_city_2` varchar(512) NOT NULL,
29 `school_state_2` varchar(512) NOT NULL,
30 `areas_studied_2` varchar(512) NOT NULL,
31 `primary_earned_2` varchar(512) NOT NULL,
32 `secondary_earned_2` varchar(512) NOT NULL,
33 `date_started_2` varchar(16) NOT NULL,
34 `date_ended_2` varchar(16) NOT NULL,
35 `employer_name_1` varchar(512) NOT NULL,
36 `job_city_1` varchar(512) NOT NULL,
37 `job_state_1` varchar(512) NOT NULL,
38 `supervisor_1` varchar(512) NOT NULL,
39 `supervisor_phone_1` varchar(512) NOT NULL,
40 `job_title_1` varchar(512) NOT NULL,
41 `job_description_1` varchar(512) NOT NULL,
42 `start_date_1` varchar(16) NOT NULL,
43 `end_date_1` varchar(16) NOT NULL,
44 `employer_name_2` varchar(512) NOT NULL,
45 `job_city_2` varchar(512) NOT NULL,
46 `job_state_2` varchar(512) NOT NULL,
47 `supervisor_2` varchar(512) NOT NULL,
48 `supervisor_phone_2` varchar(512) NOT NULL,
49 `job_title_2` varchar(512) NOT NULL,
50 `job_description_2` varchar(512) NOT NULL,
51 `start_date_2` varchar(16) NOT NULL,
52 `end_date_2` varchar(16) NOT NULL,
53 `aditional_information` varchar(512) NOT NULL,
54 `resume` varchar(512) NOT NULL,
55 `_form` text NOT NULL,
56 `session` varchar(256) NOT NULL,
57 `submitted` varchar(126) NOT NULL,
58 PRIMARY KEY (`id`)
59)