/
sofnuk2004
/
web-server
Обзор
Документация
Войти
/
sofnuk2004
/
web-server
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
database/init.sql
33 строки
981 B
sofya365
начало
16 сен 2025, 16:55
16 сен 2025, 16:55
c29a2d1
Код
Авторство
О чём код?
CREATE TABLE IF NOT EXISTS users ( id SERIAL PRIMARY KEY, email VARCHAR(255) UNIQUE NOT NULL, hashed_password VARCHAR(255) NOT NULL, full_name VARCHAR(255), role VARCHAR(50) NOT NULL CHECK (role IN ('admin', 'doctor', 'patient')), is_active BOOLEAN DEFAULT TRUE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS predictions ( id SERIAL PRIMARY KEY, user_id INTEGER REFERENCES users(id), original_image_path VARCHAR(500), processed_image_path VARCHAR(500), diagnosis VARCHAR(255), confidence FLOAT, model_used VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS models ( id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL, version VARCHAR(50), model_type VARCHAR(100), accuracy FLOAT, precision FLOAT, recall FLOAT, f1_score FLOAT, is_active BOOLEAN DEFAULT FALSE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );