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