ktkyj

Tables (26)

CATEGORY_POLICY

  • policy_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → MEMBER.member_id
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • category_id — INT — Foreign key → MERCHANT_CATEGORY.category_id
  • policy — VARCHAR(50) — ALLOW/WATCH/BLOCK
  • trust_score_threshold — INT

FINANCIAL_PRODUCT

  • product_id — BIGINT — Primary key — NOT NULL
  • product_type — VARCHAR(50) — SAVINGS/DEPOSIT/LOAN/INVEST
  • product_name — VARCHAR(100)
  • base_rate — DECIMAL(5, 2)
  • required_trust_score — INT
  • term_months — INT

LOAN_ACCOUNT

  • account_id — BIGINT — Primary key — NOT NULL
  • application_id — BIGINT — Foreign key → PRODUCT_APPLICATION.application_id
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • product_id — BIGINT — Foreign key → FINANCIAL_PRODUCT.product_id
  • principal — BIGINT
  • interest_rate — DECIMAL(5, 2)
  • limit_amount — BIGINT
  • start_date — DATE
  • end_date — DATE
  • is_overdue — BOOLEAN

MEMBER

  • member_id — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(50) — PARENT / CHILD
  • name — VARCHAR(100)
  • birth_date — DATE
  • phone — VARCHAR(50)
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • created_at — DATETIME
  • deleted_at — DATETIME

MERCHANT

  • merchant_id — BIGINT — Primary key — NOT NULL
  • merchant_name — VARCHAR(100)
  • category_id — INT — Foreign key → MERCHANT_CATEGORY.category_id

MERCHANT_CATEGORY

  • category_id — INT — Primary key — NOT NULL
  • category_name — VARCHAR(100)

NOTIFICATION

  • notification_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id
  • noti_type — VARCHAR(50) — QUEST/PAYMENT/PRODUCT/ALLOWANCE
  • content — VARCHAR(255)
  • link_url — VARCHAR(255)
  • is_read — BOOLEAN
  • created_at — DATETIME

PARENT_CHILD_LINK

  • link_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → MEMBER.member_id
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • link_code — VARCHAR(50)
  • status — VARCHAR(50) — REQUESTED/LINKED/UNLINKED
  • linked_at — DATETIME

PAYMENT

  • payment_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • merchant_id — BIGINT — Foreign key → MERCHANT.merchant_id
  • amount — BIGINT
  • status — VARCHAR(50) — SUCCESS/FAILED/BLOCKED
  • trust_score_at_payment — INT
  • created_at — DATETIME

PAYMENT_METHOD

  • method_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id
  • method_type — VARCHAR(50) — ACCOUNT/CARD
  • account_no — VARCHAR(100)
  • is_primary — BOOLEAN
  • created_at — DATETIME

PRODUCT_APPLICATION

  • application_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • product_id — BIGINT — Foreign key → FINANCIAL_PRODUCT.product_id
  • status — VARCHAR(50) — PENDING/APPROVED/REJECTED
  • applied_at — DATETIME
  • processed_at — DATETIME

QUEST

  • quest_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → MEMBER.member_id
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • title — VARCHAR(255)
  • content — VARCHAR(255)
  • deadline — DATE
  • reward — BIGINT
  • status — VARCHAR(50) — OPEN/IN_PROGRESS/DONE
  • max_retry — INT
  • created_at — DATETIME

QUEST_SUBMISSION

  • submission_id — BIGINT — Primary key — NOT NULL
  • quest_id — BIGINT — Foreign key → QUEST.quest_id
  • photo_url — VARCHAR(255)
  • memo — VARCHAR(255)
  • status — VARCHAR(50) — PENDING/APPROVED/REJECTED
  • retry_count — INT
  • submitted_at — DATETIME
  • processed_at — DATETIME

RECURRING_ALLOWANCE

  • allowance_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → MEMBER.member_id
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • amount — BIGINT
  • cycle — VARCHAR(50) — WEEKLY/MONTHLY
  • next_payment_date — DATE
  • status — VARCHAR(50) — ACTIVE/PAUSED/CANCELLED

SAVINGS_ACCOUNT

  • account_id — BIGINT — Primary key — NOT NULL
  • application_id — BIGINT — Foreign key → PRODUCT_APPLICATION.application_id
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • product_id — BIGINT — Foreign key → FINANCIAL_PRODUCT.product_id
  • principal — BIGINT
  • monthly_payment — BIGINT
  • applied_rate — DECIMAL(5, 2)
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(50) — ACTIVE/COMPLETED/TERMINATED

TEMP_ALLOW_REQUEST

  • request_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • category_id — INT — Foreign key → MERCHANT_CATEGORY.category_id
  • merchant_id — BIGINT — Foreign key → MERCHANT.merchant_id
  • status — VARCHAR(50) — PENDING/APPROVED/REJECTED
  • requested_at — DATETIME
  • processed_at — DATETIME

TRANSACTION

  • tx_id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → WALLET.wallet_id
  • tx_type — VARCHAR(50) — CHARGE/ALLOWANCE/QUEST_REWARD/PAYMENT/INTEREST/DONATION
  • amount — BIGINT
  • balance_after — BIGINT
  • related_id — BIGINT — 연관 퀘스트/결제/펀딩 id
  • created_at — DATETIME

TRUST_GRADE

  • grade_id — INT — Primary key — NOT NULL
  • grade_name — VARCHAR(50)
  • min_score — INT
  • max_score — INT
  • color — VARCHAR(50)
  • savings_bonus_rate — DECIMAL(5, 2)
  • daily_allow_request_limit — INT

TRUST_SCORE_HISTORY

  • history_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • score_after — INT
  • change_amount — INT
  • reason — VARCHAR(100) — QUEST/PAYMENT/LOAN_OVERDUE/...
  • created_at — DATETIME

Untitled (User)

  • id — Long — Primary key — NOT NULL
  • name — String
  • profileImage — String
  • Field (email) — String

Untitled (RefreshToken)

  • Key (id) — Long — Primary key — NOT NULL
  • id (userId) — Long — Foreign key → Untitled.id — NOT NULL
  • Field (token) — String
  • Field (expiryDate) — Instant

Untitled2 (UserPlnaList)

  • Key — Primary key — NOT NULL
  • id (userId) — Long — Foreign key → Untitled.id — NOT NULL
  • Key (planId) — Long — Foreign key → Untitled3.Key — NOT NULL

Untitled3 (Plan)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (uuid) — String
  • Field2 (title) — String
  • Field (startDate) — LocalTime
  • Field (endDate) — LocalTime
  • Field (authorEmail) — String

WALLET

  • wallet_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id
  • wallet_type — VARCHAR(50) — PARENT/SAVING/DONATION/SPEND
  • balance — BIGINT
  • updated_at — DATETIME

WISH_FUNDING

  • wish_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → MEMBER.member_id
  • title — VARCHAR(255)
  • photo_url — VARCHAR(255)
  • target_amount — BIGINT
  • current_amount — BIGINT
  • deadline — DATE
  • status — VARCHAR(50) — IN_PROGRESS/ACHIEVED/CLOSED

WISH_FUNDING_DONATION

  • donation_id — BIGINT — Primary key — NOT NULL
  • wish_id — BIGINT — Foreign key → WISH_FUNDING.wish_id
  • parent_id — BIGINT — Foreign key → MEMBER.member_id
  • amount — BIGINT
  • donated_at — DATETIME