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)
); |
Partager