Account

Tables (3)

account

  • id — int — Primary key — NOT NULL
  • 계좌번호 (number) — varchar
  • 계좌상태 (status) — varchar
  • 잔액 (balance) — long
  • id_user — int — Foreign key → accountuser.id — NOT NULL

accountuser

  • id — int — Primary key — NOT NULL
  • 이름 (name) — varchar

transaction

  • id — int — Primary key — NOT NULL
  • 거래타입 (type_transaction) — varchar
  • 거래결과타입 (type_result) — varchar
  • 금액 (amount) — int
  • 거래후잔액 (balance_snapshot) — int
  • 거래ID (transaction_id) — varchar
  • id_account — int — Foreign key → account.id — NOT NULL