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)