ledger

Tables (3)

accounts (Acounts)

  • Key (type) — Primary key — NOT NULL
  • id (int) — Primary key
  • bank_code (varchar(10))
  • account_number (varchar(32))
  • account_perpose (varchar(30))
  • balance (int 2)
  • balance_after (int 3)
  • created_at (Field)
  • id (int4) — Foreign key → user.id

transaction (Transaction)

  • key (type) — Primary key — NOT NULL
  • id (int) — Primary key
  • created_at (datetime)
  • usage_time (datetime2)
  • content (varchar(255))
  • value (int2)
  • Is_income (boolean)
  • id (int4) — Foreign key → accounts.id

user (User)

  • key (type) — Primary key — NOT NULL
  • id (int) — Primary key
  • useremail (varchar(255))
  • username (varchar(255)2)
  • hashed_password (varchar(255)3)
  • created_at (datetime)