money
Tables (8)
Account (계좌)
- account_number (pk) — Long — Primary key — NOT NULL
- user_id (유저ID) — Long — Primary key
- bank_id (은행ID) — Long — Primary key
- balance (금액) — double
- transaction_count (송금횟수) — Long
- name (계좌별명) — varchar
- account_number_raw (계좌번호문자열) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
AuthToken (토큰)
- ID (pk) — Long — Primary key — NOT NULL
- user_id (uk) — Long — Primary key
- token (토큰) — varchar
- expire_date (만료시간) — timestamp
Bank (은행)
- ID (pk) — Long — Primary key — NOT NULL
- name (은행명) — varchar
- created_at (생성일) — timestamp
EmailAuthLog (이메일 인증 로그)
- ID (pk) — Long — Primary key — NOT NULL
- user_id (유저ID) — Long
- user_email (유저이메일) — Long
- status (인증 성공) — varchar
- created_at (인증 시간) — timestamp
LoginLog (로그인 로그)
- ID (pk) — Long — Primary key — NOT NULL
- user_id (유저ID) — Long
- user_email (유저이메일) — Long
- status (로그인 성공) — varchar
- created_at (인증 시간) — timestamp
Transaction (계좌이체)
- ID (pk) — Long — Primary key — NOT NULL
- from_account_id (출금계좌ID) — Long
- to_account_id (입금계좌ID) — Long
- from_account_name (출금계좌주명) — varchar
- to_account_name (입금계좌주명) — varchar
- amount (이체금액) — double
- memo (메모) — varchar
- created_at (거래일시) — timestamp
TransactionLog (계좌이체로그)
- ID (pk) — Long — Primary key — NOT NULL
- transaction_id (이체ID) — Long
- from_account_number (출금계좌) — Long
- from_account_id (출금계좌ID) — Long
- to_account_number (입금계좌) — Long
- to_account_id (입금계좌ID) — Long — NOT NULL
- from_account_name (출금계좌주명) — varchar
- to_account_name (입금계좌주명) — varchar
- amount (금액) — double
- status (입/출금상태) — varchar
- created_at (거래일시) — timestamp
User (사용자)
- ID (pk) — Long — Primary key — NOT NULL
- email (uk) — varchar — Primary key
- password (비밀번호) — varchar
- name (이름) — varchar
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- transaction_password (송금비밀번호) — varchar