dul
Tables (6)
Account (계좌)
- 계좌ID (accountID) — INT(100000) — Primary key — NOT NULL
- 은행 (bank) — VARCHAR
- 계좌번호 (account) — INT(23)
- 지점명 (branch) — VARCHAR
- 지점주소 (branchAdd) — VARCHAR
- 국가 (country) — VARCHAR — Foreign key → Country.국가
- 계정ID (joinID) — CHAR(321) — Foreign key → Join.계정ID — NOT NULL
Country (국가)
- 국가 (country) — VARCHAR — Primary key
- 통화 (currency) — CHAR(3)
- 환율 (rate) — DECIMAL(9,3)
Deal (거래)
- 거래ID (dealID) — INT(1000000000) — Primary key — NOT NULL
- 계정ID (joinID2) — CHAR(321) — Foreign key → Join.계정ID — NOT NULL
- 수취인ID (receiverID2) — CHAR(32) — Foreign key → Receiver.수취인ID — NOT NULL
- 송금계좌ID (sendAccountID) — INT(100000)
- 수취계좌Id (receiverAccountID) — INT(100000)
- 시작날짜 (dateStart) — DATE
- 종료날짜 (dateEnd) — DATE
- 금액 (money) — DECIMAL(16,6)
- 수수료 (charge) — DECIMAL(9,3)
Join (계정)
- 계정ID (joinID) — CHAR(321) — Primary key — NOT NULL
- 비밀번호 (password) — CHAR(16)
- 이름 (name) — CHAR(5)
- 영문이름 (nameEng) — VARCHAR
- 주소 (address) — VARCHAR
- 생년월일 (birth) — DATE
- 전화번호 (phoneNum) — INT(15)
Rate (거래 당시 환율)
- 거래ID (dealID) — INT(1000000000) — Foreign key → Deal.거래ID — NOT NULL
- 국가 (country) — VARCHAR — Foreign key → Country.국가
- 수취인ID (receiverID2) — CHAR(32) — Foreign key → Deal.수취인ID — NOT NULL
- 계정ID (joinID2) — CHAR(321) — Foreign key → Deal.계정ID — NOT NULL
- 환율 (rate) — DECIMAL(9,3)
Receiver (수취인)
- 수취인ID (receiverID) — CHAR(32) — Primary key — NOT NULL
- 영문이름 (nameEng) — VARCHAR
- 주소 (address) — VARCHAR
- 전화번호 (phoneNum) — INT(15)
- 계좌ID (accountID) — INT(100000) — Foreign key → Account.계좌ID — NOT NULL