ㅇㄴㅁ

Tables (3)

Account

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • account_number — VARCHAR(20) — NOT NULL
  • balance — DECIMAL(15,2)

Member

  • id — BIGINT
  • username — VARCHAR(20) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • name — VARCHAR(20) — NOT NULL

Transaction

  • id — BIGINT
  • from_account_id — BIGINT
  • to_account_id — BIGINT
  • amount — DECIMAL(15,2) — NOT NULL
  • type — ENUM('입금', '출금', '송금') — NOT NULL
  • timestamp — DATETIME