test2

Tables (25)

category_default_policy

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL — 편의점 / 교통 / PC방 등
  • is_harmful — TINYINT(1) — NOT NULL — 유해업종 여부 (설정 UI 필터용)
  • default_policy — VARCHAR(10)

deposit

  • enroll_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • product_id — BIGINT — Foreign key → deposit_product.product_id — NOT NULL
  • principal — BIGINT — NOT NULL — 예치금
  • applied_rate — DECIMAL(5, 2) — NOT NULL — 가입시점 고정금리
  • start_date — DATE — NOT NULL
  • maturity_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL — REQUESTED / APPROVED / ACTIVE / MATURED / TERMINATED
  • approved_by — BIGINT — Foreign key → user.user_id
  • created_at — TIMESTAMP — NOT NULL

deposit_product

  • product_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • base_rate — DECIMAL(5, 2) — NOT NULL — 기본금리 (%)
  • required_trust_score — INT — NOT NULL
  • description — TEXT

link_status

  • link_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • relationship — VARCHAR(10) — 엄마 / 아빠 등
  • status — VARCHAR(10) — NOT NULL — LINKED / UNLINKED
  • linked_at — TIMESTAMP — NOT NULL

loan

  • enroll_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • product_id — BIGINT — Foreign key → loan_product.product_id — NOT NULL
  • principal — BIGINT — NOT NULL — 대출금
  • applied_rate — DECIMAL(5, 2) — NOT NULL — 가입시점 고정금리
  • credit_limit — BIGINT — NOT NULL — 신뢰도 기반 대출한도
  • auto_transfer — TINYINT(1) — NOT NULL — 이자 자동이체 여부
  • payment_day — TINYINT — NOT NULL — 상환일 (1~28)
  • start_date — DATE — NOT NULL
  • maturity_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL — REQUESTED / APPROVED / ACTIVE / MATURED / TERMINATED
  • approved_by — BIGINT — Foreign key → user.user_id
  • created_at — TIMESTAMP — NOT NULL
  • remaining_principal — BIGINT

loan_product

  • product_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • base_rate — DECIMAL(5, 2) — NOT NULL — 기본금리 (%)
  • required_trust_score — INT — NOT NULL
  • description — TEXT

loan_schedule

  • schedule_id — BIGINT — Primary key — NOT NULL
  • enroll_id — BIGINT — Foreign key → loan.enroll_id — NOT NULL
  • due_date — DATE — NOT NULL — 상환 예정일
  • principal_amount — BIGINT — NOT NULL — 상환 원금
  • interest_amount — BIGINT — NOT NULL — 상환 이자
  • paid — TINYINT(1) — NOT NULL
  • paid_at — TIMESTAMP
  • is_overdue — TINYINT(1) — NOT NULL — 연체 여부
  • overdue_interest — BIGINT — NOT NULL — 누적 연체이자

mcc

  • mcc_id — BIGINT — Primary key — NOT NULL
  • mcc_code — VARCHAR(4) — NOT NULL — 표준 MCC 4자리
  • category_id — BIGINT — Foreign key → category_default_policy.category_id — NOT NULL

notification

  • noti_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • type — VARCHAR(20) — NOT NULL — QUEST / PAYMENT / PRODUCT / ALLOWANCE / APPROVE
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(500)
  • deeplink — VARCHAR(200) — 클릭시 이동 경로
  • is_read — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notification_setting

  • setting_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • noti_type — VARCHAR(20) — NOT NULL — QUEST / PAYMENT / PRODUCT / ALLOWANCE
  • enabled — TINYINT(1) — NOT NULL

payment_method

  • method_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL — 부모만
  • type — VARCHAR(10) — NOT NULL — ACCOUNT / CARD
  • account_info — VARCHAR(100) — NOT NULL — 마스킹 저장
  • is_primary — TINYINT(1) — NOT NULL — 주거래 수단
  • created_at — TIMESTAMP — NOT NULL

please_approve

  • request_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • parent_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • category_id — BIGINT — Foreign key → category_default_policy.category_id — NOT NULL — 차단된 업종
  • reason — VARCHAR(200)
  • status — VARCHAR(10) — NOT NULL — PENDING / APPROVED / REJECTED / EXPIRED
  • requested_at — TIMESTAMP — NOT NULL
  • processed_at — TIMESTAMP
  • expires_at — TIMESTAMP — 당일 자정 자동만료

quest

  • quest_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → user.user_id — NOT NULL — 생성한 부모
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL — 수행할 자녀
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT
  • deadline — TIMESTAMP — NOT NULL
  • reward_amount — BIGINT — NOT NULL — 보상금 (원)
  • status — VARCHAR(20) — NOT NULL — AVAILABLE / IN_PROGRESS / REVIEW / DONE / FAILED
  • retry_count — TINYINT — NOT NULL — 반려 횟수 (3이면 실패)
  • photo_url — VARCHAR(500) — 실시간 촬영 인증사진 URL (재제출시 덮어쓰기)
  • text_content — TEXT — 인증 텍스트 (재제출시 덮어쓰기)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • reward_score — INT

recurring_deposit

  • enroll_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • product_id — BIGINT — Foreign key → recurring_deposit_product.product_id — NOT NULL
  • monthly_amount — BIGINT — NOT NULL — 월 납입액
  • applied_rate — DECIMAL(5, 2) — NOT NULL — 가입시점 고정금리
  • payment_day — TINYINT — NOT NULL — 납입일 (1~28)
  • start_date — DATE — NOT NULL
  • maturity_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL — REQUESTED / APPROVED / ACTIVE / MATURED / TERMINATED
  • approved_by — BIGINT — Foreign key → user.user_id
  • created_at — TIMESTAMP — NOT NULL
  • auto_transfer — TINYINT(1)
  • current_amount — BIGINT

recurring_deposit_product

  • product_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • savings_type — VARCHAR(10) — NOT NULL — FREE(자유적립) / FIXED(정액적립)
  • base_rate — DECIMAL(5, 2) — NOT NULL — 기본금리 (%)
  • required_trust_score — INT — NOT NULL
  • description — TEXT

reserve_allowance

  • allowance_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • cycle — VARCHAR(10) — NOT NULL — WEEKLY / MONTHLY
  • amount — BIGINT — NOT NULL
  • payment_day — TINYINT — NOT NULL — WEEKLY: 1~7 / MONTHLY: 1~28
  • is_active — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

savings_schedule

  • schedule_id — BIGINT — Primary key — NOT NULL
  • enroll_id — BIGINT — Foreign key → recurring_deposit.enroll_id — NOT NULL
  • due_date — DATE — NOT NULL — 납입 예정일
  • amount — BIGINT — NOT NULL — 납입액
  • paid — TINYINT(1) — NOT NULL
  • paid_at — TIMESTAMP

teeny_grade

  • grade_id — BIGINT — Primary key — NOT NULL
  • grade_name — VARCHAR(20) — NOT NULL — 회복필요 / 주의 / 보통 / 우수 / 양호
  • min_score — INT — NOT NULL
  • max_score — INT — NOT NULL
  • bonus_rate — DECIMAL(5, 2) — NOT NULL — 우대금리 (+%)
  • today_allow_limit — TINYINT — NOT NULL — 오늘만 허용 요청 가능 횟수
  • color — VARCHAR(7) — 등급 색상 HEX

teeny_score

  • log_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • delta — INT — NOT NULL — 변동량 (+/- 가능, signed)
  • reason — VARCHAR(100) — NOT NULL — 퀘스트성공 / 연체 / 중도해지 등
  • score_after — INT — NOT NULL — 변동 후 점수
  • created_at — TIMESTAMP — NOT NULL

transactions

  • tx_id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.wallet_id — NOT NULL
  • type — VARCHAR(20) — NOT NULL — 충전 / 용돈 / 결제 / 퀘스트보상 / 이자 / 후원
  • amount — BIGINT — NOT NULL — 항상 양수, 방향은 type으로 판단
  • category_id — BIGINT — Foreign key → category_default_policy.category_id — 결제시 업종 (소비리포트 집계용)
  • merchant_name — VARCHAR(100) — 가맹점명 텍스트
  • status — VARCHAR(10) — NOT NULL — 성공 거래만 기록
  • created_at — TIMESTAMP — NOT NULL

transactions_attempts

  • attempt_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category_default_policy.category_id — NOT NULL — 판정 근거 업종
  • amount — BIGINT — NOT NULL
  • applied_policy — VARCHAR(10) — NOT NULL — ALLOW / WATCH / BLOCK
  • result — VARCHAR(10) — NOT NULL — SUCCESS / REJECTED
  • trust_snapshot — INT — NOT NULL — 결제 시점 신뢰도
  • created_at — TIMESTAMP — NOT NULL
  • Field
  • 주체ID — BIGINT — Foreign key → wallet.wallet_id — NOT NULL
  • 대상ID — BIGINT — Foreign key → wallet.wallet_id — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(10) — NOT NULL — PARENT / CHILD
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone — VARCHAR(15) — NOT NULL — 연락처당 1계정
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL — BCrypt 등 암호화
  • profile_image_url — VARCHAR(500)
  • trust_score — INT — NOT NULL — 자녀만, 0~1000, 초기 600
  • status — VARCHAR(20) — NOT NULL — ACTIVE / WITHDRAW_PENDING / DELETED
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_policy

  • member_policy_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL — 자녀 ID
  • category_id — BIGINT — Foreign key → category_default_policy.category_id — NOT NULL — 대상 업종
  • threshold_score — INT — WATCH일 때 기준 신뢰점수

wallet

  • wallet_id — BIGINT — Primary key — NOT NULL
  • balance — BIGINT — NOT NULL — 원 단위, 음수 불가
  • created_at — TIMESTAMP — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL

wish_funding

  • funding_id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL — 목표 이름
  • image_url — VARCHAR(500)
  • target_amount — BIGINT — NOT NULL — 목표 금액
  • current_amount — BIGINT — NOT NULL — 현재 모은 금액
  • deadline — DATE
  • share_token — VARCHAR(64) — 외부 공유 URL 토큰
  • status — VARCHAR(10) — NOT NULL — ACTIVE / ACHIEVED / CLOSED
  • created_at — TIMESTAMP — NOT NULL