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