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