This repository has been archived by the owner on Oct 28, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
create tables.sql
67 lines (67 loc) · 2.49 KB
/
create tables.sql
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
CREATE TABLE "Vacancies"(
"IdVacancy" INTEGER NOT NULL,
"Name" TEXT NOT NULL,
"IdArea" INTEGER NOT NULL,
"SalaryFrom" DECIMAL(8, 2),
"SalaryTo" DECIMAL(8, 2),
"SalaryCurrency" TEXT,
"PublishedAt" TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL,
"SnippetRequirement" TEXT,
"SnippetResponsibility" TEXT,
"Description" TEXT NOT NULL,
"IdExperience" TEXT NOT NULL
);
ALTER TABLE
"Vacancies" ADD PRIMARY KEY("IdVacancy");
CREATE TABLE "VacanciesSpecializations"(
"IdVacancy" INTEGER NOT NULL,
"IdSpecialization" TEXT NOT NULL
);
CREATE INDEX "vacanciesspecializations_idvacancy_index" ON
"VacanciesSpecializations"("IdVacancy");
CREATE INDEX "vacanciesspecializations_idspecialization_index" ON
"VacanciesSpecializations"("IdSpecialization");
CREATE TABLE "Specializations"(
"IdSpecialization" TEXT NOT NULL,
"Name" TEXT NOT NULL
);
ALTER TABLE
"Specializations" ADD PRIMARY KEY("IdSpecialization");
CREATE TABLE "Area"(
"IdArea" INTEGER NOT NULL,
"Name" TEXT NOT NULL
);
ALTER TABLE
"Area" ADD PRIMARY KEY("IdArea");
CREATE TABLE "Experience"(
"IdExperience" TEXT NOT NULL,
"Name" TEXT NOT NULL
);
ALTER TABLE
"Experience" ADD PRIMARY KEY("IdExperience");
CREATE TABLE "Skills"(
"IdSkill" SERIAL NOT NULL,
"Name" TEXT NOT NULL
);
ALTER TABLE
"Skills" ADD PRIMARY KEY("IdSkill");
CREATE TABLE "VacanciesSkills"(
"IdVacancy" INTEGER NOT NULL,
"IdSkill" INTEGER NOT NULL
);
CREATE INDEX "vacanciesskills_idvacancy_index" ON
"VacanciesSkills"("IdVacancy");
CREATE INDEX "vacanciesskills_idskill_index" ON
"VacanciesSkills"("IdSkill");
ALTER TABLE
"Vacancies" ADD CONSTRAINT "vacancies_idarea_foreign" FOREIGN KEY("IdArea") REFERENCES "Area"("IdArea");
ALTER TABLE
"Vacancies" ADD CONSTRAINT "vacancies_idexperience_foreign" FOREIGN KEY("IdExperience") REFERENCES "Experience"("IdExperience");
ALTER TABLE
"VacanciesSpecializations" ADD CONSTRAINT "vacanciesspecializations_idvacancy_foreign" FOREIGN KEY("IdVacancy") REFERENCES "Vacancies"("IdVacancy");
ALTER TABLE
"VacanciesSpecializations" ADD CONSTRAINT "vacanciesspecializations_idspecialization_foreign" FOREIGN KEY("IdSpecialization") REFERENCES "Specializations"("IdSpecialization");
ALTER TABLE
"VacanciesSkills" ADD CONSTRAINT "vacanciesskills_idvacancy_foreign" FOREIGN KEY("IdVacancy") REFERENCES "Vacancies"("IdVacancy");
ALTER TABLE
"VacanciesSkills" ADD CONSTRAINT "vacanciesskills_idskill_foreign" FOREIGN KEY("IdSkill") REFERENCES "Skills"("IdSkill");