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