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)

Payment (Untitled5)

    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)