JussDB
Tables (5)
Account (tb_account)
- account_id (Key) — Primary key — NOT NULL
- account_type (Field)
- bank_name (Field2)
- account_name (Field3)
- account_number (Field4)
- balance (Field5)
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- is_show (Field6)
- is_favorite (Field7)
- card_id (Key3) — Foreign key → Card.card_id — NOT NULL
Card (tb_card)
- card_id (Key) — Primary key — NOT NULL
- card_name (Field)
- min_usage (Field2)
- account_id (Key2) — Foreign key → Account.account_id — NOT NULL
Recent (tb_recent)
- recent_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- accounts (Field)
Transaction (tb_transaction)
- tr_id (Key) — Primary key — NOT NULL
- receiver_id (Key2) — Foreign key → Account.account_id — NOT NULL
- sender_id (Key3) — Foreign key → Account.account_id — NOT NULL
- amount (Field2)
- memo (Field3)
- is_fill (Field4)
- card_id (Key4) — Foreign key → Card.card_id — NOT NULL
- created_at (Field)
User (tb_user)
- user_id (Key) — Primary key — NOT NULL