FINANCEHUB설계

테이블 (4)

계좌 (ACCOUNTS)

  • ACCOUNT_ID (Key) — INTEGER — 기본 키 — NOT NULL
  • USER_ID (Key2) — INTEGER — 외래 키 → 고객.USER_ID — NOT NULL
  • ACCOUNT_NUM (Field) — TEXTUNIQUE NOT NULL
  • BALANCE (Field2) — INTEGERDEFAULT 0 CHECK (BALANCE>=0)
  • IS_ACTIVE (Field3) — TEXT DEFAULT "Y" CHECK (IS ACTIVE IN('Y','N')
  • OPEND_AT (Field4) — TEXT DEFAULT (datetime('now', 'localtime'))

계좌알림매핑테이블 (ACCOUNT_NOTIFICATIONS)

  • NOTI_ID (Key) — INTEGER — 기본 키 — NOT NULL
  • NOTI_TYPE (Field) — TEXT NOT NULL CHECK (NOTI_TYPE IN ('SMS','PUSH','EMAIL'))
  • IS_SUBSCRIBED (Field2) — TEXT DEFAULT 'N' CHECK (IS _SUBSCRIBED IN ('Y' , 'N')
  • SET_AT (Field3) — TEXT DEFAULT (datetime('now', 'localtime'))
  • USER_ID (Key2) — INTEGER — 외래 키 → 고객.USER_ID — NOT NULL
  • ACCOUNT_ID (Key3) — INTEGER — 외래 키 → 고객.USER_ID — NOT NULL

고객 (BANK_USERS)

  • USER_ID (Key) — INTEGER — 기본 키 — NOT NULL
  • EMAIL (Field) — TEXT UNIQUE
  • NICKNAME (Field2) — TEXT NOT NULL
  • PASSWORD (Field3) — TEXTNOT NULL
  • CREATED_AT (Field4) — TEXT DEFAULT (datetime('now', 'localtime'))

이체이력 (TRANSFER_LOG)

  • TRANSFER_ID (Key) — INTEGER — 기본 키 — NOT NULL
  • FROM_ACCOUNT_ID (Key2) — INTEGER — 외래 키 → 계좌.ACCOUNT_ID — NOT NULL
  • TO_ACCOUNT_ID (Key3) — INTEGER — 외래 키 → 계좌.ACCOUNT_ID — NOT NULL
  • AMOUNT (Field3) — INTEGER NOT NULL CHECK (AMOUNT>0)
  • TRANSFERRED_AT (Field4) — TEXT DEFAULT (datetime('now', 'localtime'))