joGetter/db.sql at main · blakelinkd/joGetter · GitHub

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
-- jobs definition

CREATE TABLE jobs (
	id INTEGER,
	postTitle TEXT,
	location TEXT,
	salary TEXT,
	compatibilityRating TEXT,
	hasApplied INTEGER DEFAULT (0),
	link TEXT,
	generateLink TEXT,
	skills TEXT,
	jobDescription TEXT,
	benefits TEXT,
	Resume BLOB,
	createdAt TEXT,
	companyName TEXT,
	jk TEXT,
	homepage TEXT,
	"source" TEXT,
	emails TEXT,
	websiteUrl TEXT,
	HREmail TEXT,
	PhoneNumber TEXT,
	hasBeenSearched INTEGER,
	experience INTEGER,
	HRName TEXT,
	emailSent INTEGER,
	easyApply INTEGER,
	interviewing INTEGER,
	compatibility_score INTEGER,
	missingSkills TEXT,
	thirdParty INTEGER,
	recruiterName TEXT,
	locality TEXT,
	country TEXT,
	logo TEXT,
	datePosted TEXT,
	validThrough TEXT,
	employmentType TEXT,
	jobLocationType TEXT,
	applicantLocationRequirements TEXT, salaryMax REAL, salaryMin REAL,
	CONSTRAINT JOBS_PK PRIMARY KEY (id)
);