Skip to content
Snippets Groups Projects
Select Git revision
  • master
1 result

StudentJobs

    • Name Last commit Last update
    .settings
    _notes
    images
    .buildpath
    .project
    README
    app.php
    application.css
    config.inc.sample.php
    download.php
    functions.inc.php
    index.php
    main.php
    manage.php
    resume.php
    style.css
    submit.php
    supplemental.php
    test.php
    view.php
    README
    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