은행계좌조회

테이블 (3)

은행계좌상세 (BankAccounts)

  • AccountNumber (Key) — INT — 외래 키 → 은행계좌정보.AccountNumber — NOT NULL
  • BankCode — INT — 외래 키 → 은행코드.BankCode — NOT NULL
  • UseYn — Boolean
  • AccountType — Boolean
  • AccountHolderName — NVARCHAR(30)
  • AccountPassword — NVARCHAR(30)
  • CorporateRegistrationNumber — NVARCHAR(30)
  • ResidentRegistrationNumber — NVARCHAR(30)
  • CheckType — Boolean
  • CertificateName — NVARCHAR(50)
  • CertificatePath — NVARCHAR(200)
  • CertificatePassword — NVARCHAR(50)
  • InternetbankId — NVARCHAR(20)
  • InternetbankPassword — NVARCHAR(50)
  • CreatedDate — Datetime
  • ModifiedDate — Datetime
  • UserName (Field) — NVARCHAR(20)

은행계좌정보 (Untitled)

  • AccountNumber (Key) — INT — 기본 키 — NOT NULL
  • BankCode (Field) — INT
  • AccountName (Field2) — NVARCHAR(50)
  • UserId (Field3) — NVARCHAR(20)
  • CreatedDate (Field4) — Datetime
  • ModifiedDate (Field5) — Datetime
  • GroupId (Field6) — VARCHAR(4)

은행코드 (BankCode)

  • BankCode — INT — 기본 키 — NOT NULL
  • BankName — NVARCHAR(20)
  • CreatedDate — Datetime
  • ModifiedDate — Datetime