/
ZufarFaiz
/
SberProject
Обзор
Документация
Войти
/
ZufarFaiz
/
SberProject
Код
Запросы
1
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
develop
src/main/resources/db/db.sql
56 строк
1 KB
Семейный
Внес изменения в сущность compnay
01 июн 2025, 23:33
01 июн 2025, 23:33
53a2cc9
Код
Авторство
О чём код?
CREATE TABLE users ( user_id BIGSERIAL PRIMARY KEY, user_name VARCHAR(100) NOT NULL UNIQUE, email VARCHAR(100) NOT NULL UNIQUE, password VARCHAR(100) NOT NULL, role VARCHAR(20) NOT NULL ); CREATE TABLE companies ( company_id BIGSERIAL PRIMARY KEY, name VARCHAR(100) NOT NULL UNIQUE, location VARCHAR(255) NOT NULL ); CREATE TABLE applicants ( applicant_id BIGSERIAL PRIMARY KEY, user_id BIGINT NOT NULL, education VARCHAR(255), resume text, FOREIGN KEY (user_id) REFERENCES users(user_id) ); CREATE TABLE jobs ( job_id BIGSERIAL PRIMARY KEY, title VARCHAR(100) NOT NULL, description TEXT NOT NULL, salary NUMERIC NOT NULL, company_id BIGINT NOT NULL, FOREIGN KEY (company_id) REFERENCES companies(company_id) ); CREATE TABLE job_responses ( job_response_id BIGSERIAL PRIMARY KEY, status VARCHAR(20) NOT NULL, job_id BIGINT NOT NULL, applicant_id BIGINT NOT NULL, FOREIGN KEY (job_id) REFERENCES jobs(job_id), FOREIGN KEY (applicant_id) REFERENCES applicants(applicant_id) ); CREATE TABLE recruiters( recruiter_id BIGSERIAL PRIMARY KEY, user_id BIGINT NOT NULL, FOREIGN KEY (user_id) REFERENCES users(user_id) ); ALTER TABLE jobs ADD COLUMN recruiter_id BIGINT, ADD CONSTRAINT fk FOREIGN KEY (recruiter_id) REFERENCES recruiters(recruiter_id); ALTER TABLE recruiters ADD COLUMN company_id BIGINT NOT NULL DEFAULT 1, ADD CONSTRAINT fk FOREIGN KEY (company_id) REFERENCES companies(company_id);