TeenyFinny
Tables (21)
account_info
- account_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- type — ENUM('ALLOWANCE', 'GOAL', 'INVEST') — NOT NULL
- number — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
allowance_request
- request_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- reason — TEXT
- status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
api_request_log
- request_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- category — VARCHAR(50) — NOT NULL — ENUM으로 묶을 수 있으면 묶으면 좋을듯
- request_content — TEXT — NOT NULL — JSON 페이로드
- response_code — INT — HTTP 응답 코드(200, 400 등)
- success — BOOLEAN
- created_at — DATETIME — NOT NULL
auto_transfer
- auto_transfer_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- account_id — BIGINT — Foreign key → account_info.account_id — NOT NULL
- transfer_amount — DECIMAL(12, 2) — NOT NULL
- ratio — INT — 투자 비율(%)
- type — ENUM('ALLOWANCE', 'GOAL', 'INVEST') — NOT NULL
- frequency — ENUM('DAILY', 'WEEKLY', 'MONTHLY')
- transfer_date — TINYINT — 매월 n일
- bass_transfer_id — BIGINT — 은행측 자동이체 식별자
- status — ENUM('PENDING', 'SUCCESS', 'FAIL') — NOT NULL
- last_sync_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
baas_account
- account_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → baas_users.user_id — NOT NULL — 은행 내부 고객 식별자
- number — VARCHAR(20) — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- balance — DECIMAL(18, 2) — NOT NULL — 원 단위소수 자리수 2개를 포함해서 총 18자리 표현ex. 12343.10원
- interest_rate — DECIMAL(5, 3) — 소수 자릿수 3개를 포함해서 총 5자리 표현예 : 1.250
- status — ENUM('ACTIVE', 'CLOSED', 'SUSPENDED') — NOT NULL — 정상/해지/휴먼
- type — ENUM('DEPOSIT', 'SAVING', 'INVESTMENT') — NOT NULL — 입출금, 적금, 예금 등 구분
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- expired_at — DATE
baas_auto_transfer
- auto_transfer_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → baas_users.user_id — NOT NULL — 은행 내부 고객 식별자
- from_account_id — BIGINT — Foreign key → baas_account.account_id — NOT NULL
- to_account_id — BIGINT — Foreign key → baas_account.account_id — NOT NULL
- amount — DECIMAL(15, 2) — NOT NULL — 매달 얼마씩 이체할건지
- memo — VARCHAR(50) — 예 : "용돈", "보너스"
- transfer_day — TINYINT — NOT NULL — 매월 n 일
- next_transfer_day — DATE — 언제 자동이체를 실행해야 하는지를 판단하기 위한 필드
- status — ENUM('PROCESSING', 'SUCCESS', 'FAIL') — NOT NULL — 처리중, 성공, 실패
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
baas_investment_account
- cano — CHAR(8) — Primary key — NOT NULL — 한국투자증권API 필드와 일치
- user_id — BIGINT — Foreign key → baas_users.user_id — NOT NULL — 은행 내부 고객 식별자
- tot_evlu_amt — BIGINT — NOT NULL — 예수금 + 유가증권 평가금액
- dnca_tot_amt — BIGINT — NOT NULL — 투자 가능한 현금
- scts_evlu_amt — BIGINT — NOT NULL — 투자한 종목의 총 평가금액
- created_at — DATETIME — NOT NULL
baas_portfolio
- portfolio_id — BIGINT — Primary key — NOT NULL
- cano — CHAR(8) — Foreign key → baas_investment_account.cano — NOT NULL
- user_id — BIGINT — Foreign key → baas_users.user_id — NOT NULL — 은행 내부 고객 식별자
- pdno — VARCHAR(12) — NOT NULL — 종목 식별 코드
- prdt_name — VARCHAR(60) — NOT NULL — 종목 한글 이름
- hldg_qty — BIGINT — NOT NULL — 보유중인 수량
- pchs_avg_pric — BIGINT — NOT NULL — 평균 매입 단가
- created_at — DATETIME — NOT NULL
baas_trade_orders
- order_id — BIGINT — Primary key — NOT NULL
- cano — CHAR(8) — Foreign key → baas_investment_account.cano — NOT NULL
- user_id — BIGINT — Foreign key → baas_users.user_id — NOT NULL — 은행 내부 고객 식별자
- gt_uid — CHAR(32) — 글로벌 주문 I
- 법인 — 전용"
- ord_tmd — DATETIME — NOT NULL
- tr_id — VARCHAR(255) — NOT NULL — 거래 종류 식별 ID (메모 참고)/임의로 VARCHAR 타입으로 선언함
- pdno — VARCHAR(12) — NOT NULL — 종목 식별 코드
- prdt_name — VARCHAR(60) — NOT NULL — 종목 한글 이름
- ord_qty — INT — NOT NULL — 주문한 수량
- ord_unpr — BIGINT — NOT NULL — 주문 단가
- excg_id_dvsn_cd — CHAR(3) — NOT NULL — 거래소 코드, KRX 고정
- status — ENUM('REQUESTED', 'EXECUTED', 'CANCELLED') — NOT NULL
- created_at — DATETIME — NOT NULL
baas_transaction
- transaction_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → baas_users.user_id — NOT NULL — 은행 내부 고객 식별자
- account_id — BIGINT — Foreign key → baas_account.account_id
- code — VARCHAR(10) — NOT NULL — 100 : 입금200 : 출금300 : 자동이체 이런 식으로
- type — VARCHAR(20) — NOT NULL — 예 : 일시불, 할부 / ENUM이 나을듯
- balance_after — DECIMAL(15, 3) — NOT NULL — 거래 완료 후 잔액 표시
- merchant_name — VARCHAR(50) — 예 : CU 편의점, 스타벅스, CGV 등
- category — VARCHAR(30) — NOT NULL — 예 : 쇼핑, 교통, 식비, 여가 등
- status — ENUM('SUCCESS', 'FAIL', 'PENDING') — NOT NULL
- created_at — DATETIME — NOT NULL
baas_users
- user_id — BIGINT — Primary key — NOT NULL — 은행 내부 고객 식별자
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- birth_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
card_info
- card_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → account_info.account_id — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL — 남겨둘지 여부는 담당자가 정해주세요
- name — VARCHAR(100) — NOT NULL
- number — VARCHAR(20) — NOT NULL
- cvc — CHAR(3) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
chatbot_option
- option_id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(50) — NOT NULL
- topic — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
feedback
- feedback_id — BIGINT — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → summary_report.report_id — NOT NULL
- writer_id — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
goal_savings
- goal_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- target_amount — DECIMAL(12,2) — NOT NULL
- monthly_amount — DECIMAL(12,2) — NOT NULL
- pay_day — DATE — NOT NULL
- status — ENUM('PENDING','REJECTED','ONGOING','COMPLETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- notification_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- type — ENUM('ALLOWANCE','GOAL','QUIZ','SYSTEM') — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
quiz_info
- quiz_id — BIGINT — Primary key — NOT NULL
- info — TEXT — NOT NULL
- question — TEXT — NOT NULL
- answer — VARCHAR(100) — NOT NULL
- explanation — TEXT — NOT NULL
- course — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
quiz_progress
- progress_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- quiz_date — DATE
- streak_days — INT
- monthly_reward — BOOLEAN — NOT NULL
- course_completed — BOOLEAN
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
summary_report
- report_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- month — INT — NOT NULL — 생성일자가 곧 발급 월 아닌지?
- total_expense — DECIMAL(12, 2) — NOT NULL
- created_at — DATETIME — NOT NULL
user_relationship
- relationship_id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → user_service.user_id — NOT NULL — 부모 기준으로 매핑 진행
- child_id — BIGINT — Foreign key → user_service.user_id — NOT NULL
- family_otp — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
user_service
- user_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- simple_password — VARCHAR(255) — NOT NULL
- salt — VARCHAR(255) — NOT NULL — 패스워드 보안용
- birth_date — DATE — NOT NULL
- gender — TINYINT — NOT NULL — 성별(1:남, 2: 여)
- role — ENUM('PARENT', 'CHILD') — NOT NULL
- push_enabled — BOOLEAN — NOT NULL
- night_push_enabled — BOOLEAN — NOT NULL
- provider_id — VARCHAR(10) — NOT NULL — Oauth 식별
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL