aaaa
Tables (8)
Account
- id — VARCHAR(36)
- product_code — VARCHAR(50)
- account_number — VARCHAR(50) — NOT NULL
- bank_code — VARCHAR(10)
- student_union_id — VARCHAR(36) — NOT NULL
- created_at — DATETIME
Deposit
- id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- student_union_id — VARCHAR(36) — NOT NULL
- account_id — VARCHAR(36) — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- deposit_date — DATETIME — NOT NULL
- memo — TEXT
- created_at — DATETIME
Ledger
- id — VARCHAR(36)
- student_union_id — VARCHAR(36) — NOT NULL
- month — VARCHAR(7) — NOT NULL
- total_income — DECIMAL(15,2)
- total_expense — DECIMAL(15,2)
- created_at — DATETIME
LedgerDetail
- id — VARCHAR(36)
- ledger_id — VARCHAR(36) — NOT NULL
- transaction_type — ENUM('DEPOSIT', 'WITHDRAWAL') — NOT NULL
- transaction_id — VARCHAR(36) — NOT NULL
- description — VARCHAR(500)
- amount — DECIMAL(15,2) — NOT NULL
StudentUnion
- id — VARCHAR(36)
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- president_id — VARCHAR(36)
- created_at — DATETIME
TransactionMemo
- id — VARCHAR(36)
- transaction_type — ENUM('DEPOSIT', 'WITHDRAWAL') — NOT NULL
- transaction_id — VARCHAR(36) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- INDEX — idx_transaction
User
- id — VARCHAR(36)
- name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- created_at — DATETIME
Withdrawal
- id — VARCHAR(36)
- student_union_id — VARCHAR(36) — NOT NULL
- account_id — VARCHAR(36) — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- purpose — VARCHAR(500)
- receipt_url — VARCHAR(1000)
- withdrawal_date — DATETIME — NOT NULL
- memo — TEXT
- created_at — DATETIME