---

PRAGMA foreign_keys = ON;

DROP TABLE IF EXISTS fine;
DROP TABLE IF EXISTS rental;
DROP TABLE IF EXISTS car;
DROP TABLE IF EXISTS user_account;

-- Пользователи
CREATE TABLE user_account (
  user_id   INTEGER PRIMARY KEY,
  full_name TEXT,
  email     TEXT,
  phone     TEXT
);

-- Автомобили
CREATE TABLE car (
  car_id       INTEGER PRIMARY KEY,
  plate_no     TEXT,
  brand        TEXT,
  model        TEXT,
  year         INTEGER,
  odometer_km  INTEGER
);

-- Аренды
CREATE TABLE rental (
  rental_id    INTEGER PRIMARY KEY,
  user_id      INTEGER,
  car_id       INTEGER,
  start_at     TEXT,
  end_at       TEXT,
  status       TEXT,
  cost_amount  NUMERIC
);

-- Штрафы
CREATE TABLE fine (
  fine_id   INTEGER PRIMARY KEY,
  rental_id INTEGER,
  amount    NUMERIC,
  reason    TEXT
);