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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
| CREATE TABLE Idiomas (
Langue VARCHAR(20) NOT NULL,
Level INTEGER NOT NULL,
PRIMARY KEY(Langue, Level)
);
CREATE TABLE CandidateWantedProfiles (
ID INTEGER NOT NULL IDENTITY(1,1),
Disponibility DATETIME NULL,
StudyLevel VARCHAR(10) NULL,
Mobility INTEGER NULL,
QualityKeywords VARCHAR(250) NULL,
PRIMARY KEY(ID)
);
CREATE TABLE Offers (
ID INTEGER NOT NULL IDENTITY(1,1),
Title VARCHAR(45) NULL,
DeptDescription VARCHAR(255) NULL,
Link VARCHAR(45) NULL,
NbApplications INTEGER NULL,
DurationAnswer INTEGER NULL,
PRIMARY KEY(ID)
);
CREATE TABLE Diplomas (
Diplomas VARCHAR(45) NOT NULL,
School VARCHAR(45) NOT NULL,
Specialization VARCHAR(45) NOT NULL,
PRIMARY KEY(Diplomas, School, Specialization)
);
CREATE TABLE Companies (
ID INTEGER NOT NULL IDENTITY(1,1),
Nom VARCHAR(45) NULL,
CType VARCHAR(20) NULL,
Description VARCHAR(250) NULL,
Adresse VARCHAR(50) NULL,
Email VARCHAR(45) NULL,
Size INTEGER NULL,
CA INTEGER NULL,
Login VARCHAR(20) NULL,
Mdp VARCHAR(10) NULL,
Telephone VARCHAR(10) NULL,
NbOffers INTEGER NULL,
PRIMARY KEY(ID)
);
CREATE TABLE Experiences (
Job VARCHAR(45) NOT NULL,
Duration INTEGER NOT NULL,
PRIMARY KEY(Job, Duration)
);
CREATE TABLE Candidates (
ID INTEGER NOT NULL IDENTITY(1,1),
Nom VARCHAR(20) NULL,
Prenom VARCHAR(20) NULL,
DNais DATETIME NULL,
Adresse VARCHAR(50) NULL,
Email VARCHAR(45) NULL,
Telephone VARCHAR(10) NULL,
Login VARCHAR(20) NULL,
Mdp VARCHAR(10) NULL,
PRIMARY KEY(ID)
);
CREATE TABLE Skills (
Skills VARCHAR(20) NOT NULL,
Level INTEGER NOT NULL,
PRIMARY KEY(Skills, Level)
);
CREATE TABLE Administrator (
Login VARCHAR(20) NOT NULL,
Mdp VARCHAR(10) NULL,
PRIMARY KEY(Login)
);
CREATE TABLE ActivityAreas (
Area VARCHAR(45) NOT NULL,
PRIMARY KEY(Area)
);
CREATE TABLE CoverLetter (
ID INTEGER NOT NULL IDENTITY(1,1),
Candidates_ID INTEGER NOT NULL,
Content VARCHAR(100) NULL,
PRIMARY KEY(ID),
FOREIGN KEY(Candidates_ID)
REFERENCES Candidates(ID)
);
CREATE TABLE JobProfiles (
ID INTEGER NOT NULL IDENTITY(1,1),
Offers_ID INTEGER NOT NULL,
ContractType VARCHAR(10) NULL,
Job VARCHAR(20) NULL,
KeywordDescription VARCHAR(255) NULL,
FullDescription INTEGER NULL,
Location VARCHAR(20) NULL,
SalaryLow INTEGER NULL,
SalaryHigh INTEGER NULL,
PRIMARY KEY(ID),
FOREIGN KEY(Offers_ID)
REFERENCES Offers(ID)
);
CREATE TABLE CandidateProfiles (
ID INTEGER NOT NULL IDENTITY(1,1),
Candidates_ID INTEGER NOT NULL,
Disponibility DATETIME NULL,
StudyLevel VARCHAR(10) NULL,
Mobility INTEGER NULL,
QualityKeywords VARCHAR(250) NULL,
PRIMARY KEY(ID),
FOREIGN KEY(Candidates_ID)
REFERENCES Candidates(ID)
);
CREATE TABLE JobWantedProfiles (
ID INTEGER NOT NULL IDENTITY(1,1),
Candidates_ID INTEGER NOT NULL,
ContractType INTEGER NULL,
Job VARCHAR(20) NULL,
KeywordDescriptions VARCHAR(255) NULL,
Location VARCHAR(20) NULL,
SalaryLow INTEGER NULL,
SalaryHigh INTEGER NULL,
PRIMARY KEY(ID),
FOREIGN KEY(Candidates_ID)
REFERENCES Candidates(ID)
); |
