У меня тут есть промежуточные таблицы? Просто напиши да или нет. Также напиши нужны они…
- User
У меня тут есть промежуточные таблицы? Просто напиши да или нет. Также напиши нужны они или нет.
CREATE TABLE Users (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
username VARCHAR(50) NOT NULL,
password_hash VARCHAR(255) NOT NULL );
CREATE TABLE IncomeCategories (
id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users(id) ON DELETE CASCADE,
name VARCHAR(50) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE ExpenseCategories (
id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users(id) ON DELETE CASCADE,
name VARCHAR(50) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP )
CREATE TABLE IncomeTransactions (
id SERIAL PRIMARY KEY,
transaction_id INTEGER REFERENCES Transactions(id) ON DELETE CASCADE,
category_id INTEGER REFERENCES IncomeCategories(id) ON DELETE SET NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE ExpenseTransactions (
id SERIAL PRIMARY KEY,
transaction_id INTEGER REFERENCES Transactions(id) ON DELETE CASCADE,
category_id INTEGER REFERENCES ExpenseCategories(id) ON DELETE SET NULL, -- категория расхода
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE Transactions (
id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users(id) ON DELETE CASCADE,
amount DECIMAL(10, 2) NOT NULL,
transaction_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
description TEXT,
is_recurring BOOLEAN DEFAULT FALSE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE Budgets (
id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users(id) ON DELETE CASCADE,
name VARCHAR(50) NOT NULL,
total_amount DECIMAL(10, 2) NOT NULL,
start_date DATE NOT NULL,
end_date DATE NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE Loans (
id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users(id) ON DELETE CASCADE,
bank_name VARCHAR(100) NOT NULL,
loan_amount DECIMAL(10, 2) NOT NULL,
total_amount DECIMAL(10, 2) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE Payments (
id SERIAL PRIMARY KEY,
loan_id INT REFERENCES Loans(id) ON DELETE CASCADE,
payment_number INT NOT NULL,
payment_date DATE NOT NULL,
amount DECIMAL(10, 2) NOT NULL,
status VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
CREATE TABLE Reminders (
id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users(id) ON DELETE CASCADE,
transaction_id INTEGER REFERENCES Transactions(id) ON DELETE CASCADE,
reminder_date TIMESTAMP NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
- Assistant
Да, у вас есть промежуточные таблицы IncomeTransactions и ExpenseTransactions. Они не обязательны и можно обойтись без них.