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)