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