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