test

Tables (4)

categories

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id
  • name — varchar(255) — NOT NULL

recurring_transaction

  • id — bigint — Primary key — NOT NULL
  • amount — bigint
  • day_of_month — int
  • end_date — date
  • is_done — bit(1) — NOT NULL
  • memo — varchar(255)
  • start_date — date
  • category_id — bigint — Foreign key → categories.id
  • user_id — bigint — Foreign key → users.id

transactions

  • id — bigint — Primary key — NOT NULL
  • date — date — NOT NULL
  • amount — bigint — NOT NULL
  • category_id — bigint — Foreign key → categories.id
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • memo — varchar(255)
  • type — enum('EXPENSE','INCOME') — NOT NULL
  • recurring_transaction_id — bigint — Foreign key → recurring_transaction.id
  • expense_type — enum('FIXED','VARIABLE')

users

  • id — bigint — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • username — varchar(255) — NOT NULL