scheduled-transfer

Tables (4)

accounts (계좌)

  • id (계좌 ID) — BIGINT — Primary key — NOT NULL
  • user_id (사용자 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • bank_id (은행 ID) — BIGINT — Foreign key → banks.id — NOT NULL
  • account_number (계좌번호) — VARCHAR(20) — NOT NULL — UNIQUE
  • created_at (생성일시) — TIMESTAMP — NOT NULL
  • updated_at (수정일시) — TIMESTAMP — NOT NULL

banks (은행)

  • id (은행 ID) — BIGINT — Primary key — NOT NULL
  • code (은행 코드) — VARCHAR(10) — NOT NULL
  • name (이름) — VARCHAR(100) — NOT NULL
  • maintenance_start_time (점검 시작 시간) — TIME — NOT NULL
  • maintenance_end_time (점검 종료 시간) — TIME — NOT NULL
  • created_at (생성일시) — TIMESTAMP — NOT NULL
  • updated_at (수정일시) — TIMESTAMP — NOT NULL

scheduled_transfers (지연이체 예약)

  • id (지연이체 예약 ID) — BIGINT — Primary key — NOT NULL
  • from_account_number (출금 계좌번호) — VARCHAR(20) — NOT NULL
  • to_account_number (입금 계좌번호) — VARCHAR(20) — NOT NULL
  • to_bank_code (입금 은행 코드) — VARCHAR(10) — NOT NULL
  • amount (이체 금액) — DECIMAL(15, 2) — NOT NULL
  • status (이체 상태) — ENUM — NOT NULL
  • scheduled_at (예약일시) — TIMESTAMP — NOT NULL
  • created_at (생성일시) — TIMESTAMP — NOT NULL
  • updated_at (수정일시) — TIMESTAMP — NOT NULL

users (사용자)

  • id (사용자 ID) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(50) — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • created_at (생성일시) — TIMESTAMP — NOT NULL
  • updated_at (수정일시) — TIMESTAMP — NOT NULL