finanace_mall
Tables (7)
Account (계좌)
- id (Key2) — Primary key — NOT NULL
- userId (Key) — Foreign key → User.id — NOT NULL
- accountNum (Field)
- accountType (Field2) — 기본계좌, 상품계좌
- balance (Field3) — 잔액
- createdAt (Field5)
- updatedAt (Field6)
Interest (이자)
- id (Key) — Primary key — NOT NULL
- subscriptionId (Key3) — Foreign key → Subscription.id — NOT NULL
- interestType (Field) — current, maturity
- amount (Field2)
- createdAt (Field3)
- updatedAt (Field4)
Product (상품)
- id (Key) — Primary key — NOT NULL
- name (Field)
- productType (Field2) — 예금, 적금
- max (Field3) — 최대 납입금액
- paymentCycle (Field4) — 납입주기 ( 월, 주 )
- period (Field5) — 가입기간
- maturityYield (Field6) — 만기수익률
- cancelYield (Field7) — 해지수익률
- description (Field8) — 상품설명
- isDeleted (Field9) — 삭제여부
- createdAt (Field10)
- updatedAt (Field11)
ProductImage (상품사진)
- id (Key2) — Primary key — NOT NULL
- productId (Key) — Foreign key → Product.id — NOT NULL
- orgName (Field)
- saveName (Field2)
- saveDir (Field3)
- order (Field4)
- remark (Field5)
- createdAt (Field6)
- updatedAt (Field7)
Subscription (가입)
- id (Key3) — Primary key — NOT NULL
- productId (Key) — Foreign key → Product.id — NOT NULL
- accountId (Key2) — Foreign key → Account.id — NOT NULL
- memberId (Key4) — Foreign key → User.id — NOT NULL
- paymentAmount (Field) — 납입금액
- paymentCycle (Field2) — 납입주기
- joinDate (Field3) — 가입일
- endDate (Field4) — 만기일
- status (Field5) — active, matured, calcelled
- maturedAt (Field6) — 만기처리시각
- cancelledAt (Field7) — 해지처리시각
- createdAt (Field8)
- updatedAt (Field9)
User (유저)
- id (Key) — Primary key — NOT NULL
- email (Field6)
- passwd (Field)
- name (Field5)
- role (Field2) — USER,ADMIN
- createdAt (Field3)
- updatedAt (Field4)