account

Tables (7)

account (Untitled3)

  • 계좌번호 (account) — INT — Primary key — NOT NULL
  • id — INT — Foreign key → user.id — NOT NULL
  • 비밀번호 (pwd) — VARCHAR(100)
  • 개설날짜 (created_at) — TIMESTAMP
  • 해지여부 (a_status) — INT

account (Untitled5)

  • id — INT — Primary key — NOT NULL
  • 계좌번호 (account_no) — VARCHAR — Primary key
  • 계좌비번 (account_pwd) — VARCHAR
  • 해지여부 (closed) — VARCHAR
  • 개설날짜 (open_date) — DATE

history (Untitled2)

  • hid — INT — Primary key — NOT NULL
  • 계좌번호 (account) — INT — Foreign key → account.계좌번호 — NOT NULL
  • 입금 (ds) — INT
  • 출금 (wd) — INT
  • 잔액 (bal) — INT

history (Untitled6)

  • id — INT — Primary key — NOT NULL
  • 계좌번호 (account_no) — VARCHAR — Primary key
  • history_id — INT — Primary key
  • 거래날짜 (trand_date) — DATETIME
  • 구분번호 (code) — INT
  • 거래액 (amount) — DECIMAL(15,2)
  • 잔액 (balance) — DECIMAL(15,2)

trans_type_code (Untitled7)

  • 구분번호 (code) — INT — Primary key — NOT NULL
  • 코드설명 (description) — VARCHAR

user (Untitled)

  • id — INT — Primary key — NOT NULL
  • 이름 (name) — VACHAR(30)
  • 전화번호 (tel) — VARCHAR(50)
  • 주민번호 (rnn) — VARCHAR(14)
  • 탈퇴여부 (u_status) — INT

user (Untitled4)

  • id — INT — Primary key — NOT NULL
  • 비밀번호 (pwd) — INT
  • 이름 (name) — VARCHAR
  • 전화번호 (tel) — VARCHAR
  • 주민번호 (rrn) — VARCHAR
  • 탈퇴여부 (withdrawn) — VARCHAR