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