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