FIND

Tables (4)

expense

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR — Foreign key → user.EMAIL
  • date — DATE — NOT NULL
  • expense_type — VARCHAR
  • amount — INT
  • image_url — VARCHAR
  • INDEX — `FK1_expense_email`

transaction_history

  • id — INT
  • date — DATE — NOT NULL
  • store — VARCHAR — NOT NULL
  • type — VARCHAR — NOT NULL
  • category — VARCHAR
  • amount — INT — NOT NULL

user

  • EMAIL — VARCHAR — Primary key — NOT NULL
  • NAME — VARCHAR — NOT NULL
  • PASSWORD — VARCHAR — NOT NULL
  • USERACCESSTOKEN — VARCHAR — NOT NULL
  • USERREFRESHTOKEN — VARCHAR — NOT NULL
  • USERSEQNO — INT — NOT NULL
  • ADDRESS — VARCHAR — NOT NULL
  • BIRTH — VARCHAR — NOT NULL
  • PHONE — VARCHAR — NOT NULL

useraccount

  • fintech_use_num — VARCHAR — Primary key — NOT NULL
  • money — DECIMAL(15,2) — NOT NULL
  • bank_name — VARCHAR — NOT NULL
  • userseqno — INT — Foreign key → user.USERSEQNO — NOT NULL
  • account_num_masked — VARCHAR — NOT NULL
  • INDEX — `fk_userseqno`