BankAccount(get,post,put,delete)
Tables (3)
BankAccount_accounts (Untitled2)
- Account ID (account_id) — INT(10) — Primary key — NOT NULL
- User_id — INT(10) — Foreign key → BankAccount_users.User ID — NOT NULL
- 계좌번호 (account_number) — VARCHAR(20)
- 비밀번호 (password) — VARCHAR(100)
- 계좌잔고 (balance) — DECIMAL(15.2)
BankAccount_transactions (Untitled3)
- Transactions ID (transactions_id) — INT(10) — Primary key — NOT NULL
- Account ID (account_id) — INT(10) — Foreign key → BankAccount_accounts.Account ID — NOT NULL
- 입출금 (amount) — DECIMAL(15,2)
- 입출금 기록 (Transactions_date) — VARCHAR(100)
- 입금거래설명 (description) — TEXT
- 거래시간 (datatime) — DATETIME
BankAccount_users (Untitled)
- User ID (User_id) — INT(10) — Primary key — NOT NULL
- 이름 (fullname) — VARCHAR(255)
- 핸드폰 (phone) — VARCHAR(20)
- 이메일 (emali) — VARCHAR(100)
- 주소 (address) — VARCHAR(300)
- 아이디 (id) — VARCHAR(300)
- 비밀번호 (password) — VARCHAR(300)