javascript_w4_database

Tables (4)

bank (Untitled4)

  • id — Primary key — NOT NULL
  • name

category (Untitled3)

  • id — Primary key — NOT NULL
  • name

transactionHistory (Untitled2)

  • id — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • category_id — Foreign key → category.id — NOT NULL
  • bank_id — Foreign key → bank.id — NOT NULL
  • usage
  • amount
  • created_at

user (Untitled)

  • id — integer — Primary key — NOT NULL
  • email (emial)
  • password
  • name
  • salt