/
Dimitriy_Z
/
finserver
Обзор
Документация
Войти
/
Dimitriy_Z
/
finserver
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
future
src/main/resources/schema.sql
34 строки
1 KB
Dmitrii-Z
feat: добавлены ограничения для полей юзера
22 мар 2024, 19:43
22 мар 2024, 19:43
b328601
Код
Авторство
О чём код?
DROP TABLE IF EXISTS users, categories, spending, trend_of_spending CASCADE; CREATE TABLE IF NOT EXISTS users ( id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, name VARCHAR (50) NOT NULL, email VARCHAR (100) NOT NULL, password VARCHAR (100) NOT NULL, role VARCHAR NOT NULL ); CREATE TABLE IF NOT EXISTS categories ( id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, name VARCHAR (50) NOT NULL, is_spending BOOLEAN NOT NULL, user_id BIGINT NOT NULL REFERENCES users (id) ON DELETE CASCADE, UNIQUE (name, is_spending, user_id) ); CREATE TABLE IF NOT EXISTS trend_of_spending ( id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, name VARCHAR (50) NOT NULL, user_id BIGINT NOT NULL REFERENCES users (id) ON DELETE CASCADE, UNIQUE (name, user_id) ); CREATE TABLE IF NOT EXISTS spending ( id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, created TIMESTAMP NOT NULL, category_id BIGINT REFERENCES categories (id) ON DELETE CASCADE, trend_id BIGINT REFERENCES trend_of_spending (id) ON DELETE CASCADE, note VARCHAR (200), quantity DOUBLE NOT NULL, user_id BIGINT REFERENCES users (id) ON DELETE CASCADE );