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'))