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`