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