Karma
Tables (6)
Categories (Untitled5)
- category_id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- created_at (Field3)
FinAcoount (Untitled6)
- finaccount_id (Key) — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → Users.user_id — NOT NULL
- fin_acno (Field)
- acno (Field2)
- bncd (Field3)
Goals (Untitled3)
- goal_id (Key) — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → Users.user_id — NOT NULL
- name (Field)
- amount (Field2)
- deadline (Field3) — DATE
- created_at (Field4)
- updated_at (Field5)
Subscriptions (Untitled4)
- subscription_id (Key) — Primary key — NOT NULL
- user_id (Key2) — UUID — Foreign key → Users.user_id — NOT NULL
- name (Field)
- amount (Field2)
- interval_days (Field3)
- start_date (Field4)
- end_date (Field5)
- is_active (Field6)
- created_at (Field7)
Transactions (Untitled2)
- transaction_id (Key) — UUID — Primary key — NOT NULL
- amount (Field2)
- name (Field6)
- type (Field3)
- date (Field4)
- created_at (Field5)
- category_id (Key3) — Foreign key → Categories.category_id — NOT NULL
Users (Untitled)
- user_id (Key) — UUID — Primary key — NOT NULL
- name (Field)
- phone (Field2)
- password (Field5)
- minimumBalance (Field6)
- created_at (Field3)
- updated_at (Field4)