ZB-MyFin
테이블 (3)
거래 (TRANSACTION)
- id — BIGINT — 기본 키 — NOT NULL
- senderAccountId (sender_act_id) — BIGINT — 외래 키 → 계좌.id — NOT NULL
- number (txn_no) — VARCHAR(30) — NOT NULL
- amount — BIGINT — NOT NULL
- type (txn_type) — VARCHAR(30)
- tradedAt (traded_at) — DATETIME — NOT NULL
- receiverAccountId (receiver_act_id) — BIGINT — NOT NULL
계좌 (ACCOUNT)
- id — BIGINT — 기본 키 — NOT NULL
- userId (user_id) — VARCHAR(50) — 외래 키 → 유저.id — NOT NULL
- number (act_no) — VARCHAR(255) — NOT NULL
- password (act_pw) — VARCHAR(255) — NOT NULL
- balance — BIGINT
- createdAt (created_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME
- deletedAt (deleted_at) — DATETIME
유저 (USERS)
- id — VARCHAR(50) — 기본 키 — NOT NULL
- userId (user_id) — VARCHAR(100) — NOT NULL
- password (user_pw) — VARCHAR(255) — NOT NULL
- name (user_name) — VARCHAR(100) — NOT NULL
- birthDate (birth_date) — DATE — NOT NULL
- sex (sex_flag) — TINYINT(1) — NOT NULL
- zipCode (zip_code) — VARCHAR(10) — NOT NULL
- address1 (address_1) — VARCHAR(255) — NOT NULL
- address2 (address_2) — VARCHAR(255) — NOT NULL
- phoneNum (phone_num) — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- type (user_type) — VARCHAR(20)
- lastLoggedInAt (last_logged_in_at) — DATETIME
- createdAt (created_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME
- deletedAt (deleted_at) — DATETIME