README 3.95 KB
Newer Older
Eric Rasmussen's avatar
Eric Rasmussen committed
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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
database: studentjobs

####application
####a new row is created for each edit so that previous submissions display the application as it looked at the time of submission
  	id  	int(10)  	 	  	No  	 	auto_increment
	username 	varchar(255) 	utf8_general_ci 		No 			
	firstname 	varchar(255) 	utf8_general_ci 		No 			
	mi 	varchar(5) 	utf8_general_ci 		Yes 	NULL 		
	lastname 	varchar(255) 	utf8_general_ci 		No 			
	address 	varchar(255) 	utf8_general_ci 		No 			
	city 	varchar(255) 	utf8_general_ci 		No 			
	state 	varchar(255) 	utf8_general_ci 		No 			
	zip 	varchar(10) 	utf8_general_ci 		No 			
	phone 	varchar(255) 	utf8_general_ci 		No 			
	email 	varchar(255) 	utf8_general_ci 		No 			
	misdemeanor 	varchar(5) 	utf8_general_ci 		No 			
	misdetails 	longtext 	utf8_general_ci 		Yes 	NULL 		
	felony 	varchar(5) 	utf8_general_ci 		No 			
	feldetails 	longtext 	utf8_general_ci 		Yes 	NULL 		
	courtorder 	varchar(5) 	utf8_general_ci 		No 			
	codetails 	longtext 	utf8_general_ci 		Yes 	NULL 			 

####contacts
####users granted permission to view submissions for the appropriate dept
  	id  	int(10)  	 	  	No  	 	auto_increment
	department_id 	int(10) 			No 			
	username 	varchar(255) 	utf8_general_ci 		No 			
	name 	varchar(255) 	utf8_general_ci 		No 			
	email 	varchar(255) 	utf8_general_ci 		No 			
	phone 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		

####department
####departments that are part of the system, these are the depts that submissions can be made to
  	id  	int(10)  	 	  	No  	 	auto_increment
	name 	varchar(255) 	utf8_general_ci 		No 			
	address 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	sup_app_url 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		

####education
####0 or more education records are made for each application
  	id  	int(10)  	 	  	No  	 	auto_increment
	application_id 	int(10) 			No 			
	name 	varchar(255) 	utf8_general_ci 		No 			
	frommonth 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	fromyear 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	tomonth 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	toyear 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	major 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	graduate 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	degree 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		

####employer
####0 or more previous employer records are made for each application
  	id  	int(10)  	 	  	No  	 	auto_increment
	application_id 	int(10) 			No 			
	name 	varchar(255) 	utf8_general_ci 		No 			
	address 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	city 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	state 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	zip 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	supervisor 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	phone 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	frommonth 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	fromyear 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	tomonth 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	toyear 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		
	hoursweek 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	title 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	duties 	longtext 	utf8_general_ci 		Yes 	NULL 		
	salary 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		

####submissions
####these are the actual submissions for consideration made to the departments
  	id  	int(10)  	 	  	No  	 	auto_increment
	username 	varchar(255) 	utf8_general_ci 		No 			
	application_id 	int(10) 			No 			
	department_id 	int(10) 			No 			
	positionappliedfor 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		
	timestamp 	timestamp 			No 	CURRENT_TIMESTAMP 		
	resume_id 	int(10) 			No 			
	cover_id 	int(10) 			No 			
	
####uploads
####file uploads: resumes and cover letters
  	id  	int(10)  	 	  	No  	 	auto_increment
	username 	varchar(255) 	utf8_general_ci 		No 			
	showflag 	tinyint(4) 			No 			
	kind 	varchar(20) 	utf8_general_ci 		No 			
	name 	varchar(255) 	utf8_general_ci 		No 			
	type 	varchar(255) 	utf8_general_ci 		No 			
	size 	int(10) 			No 			
	content 	longblob 		BINARY 	No