TiMoTae

Tables (19)

account

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL
  • account_no (계좌번호) — VARCHAR(30) — NOT NULL
  • account_type (계좌종류) — VARCHAR(20) — NOT NULL
  • created_in_service (서비스 내에서 가입되었는지 여부) — BIT(1) — NOT NULL
  • selected (자산분석 선택 여부) — BIT(1) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

analysis_summary

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL
  • analysis_scope (분석 범위) — VARCHAR(20) — NOT NULL
  • account_no (계좌번호) — VARCHAR(30)
  • average_salary (평균 월급) — BIGINT — NOT NULL
  • fixed_cost_total (월 고정비) — BIGINT — NOT NULL
  • variable_cost_total (월 변동비) — BIGINT — NOT NULL
  • reducible_total (절약 가능 금액) — BIGINT — NOT NULL
  • seed_money — BIGINT — NOT NULL
  • analyzed_at (분석 일자) — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

asset_risk

  • id — BIGINT — Primary key — NOT NULL
  • asset_type (상품종류) — VARCHAR(20) — NOT NULL
  • asset_code (상품코드) — VARCHAR(30) — NOT NULL
  • asset_name (상품명) — VARCHAR(100) — NOT NULL
  • volatility (변동성) — DECIMAL(10,4) — NOT NULL
  • risk_level (위험도 레벨) — VARCHAR(20) — NOT NULL
  • calculated_date (산출일자) — DATE — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

crypto_daily_candle

  • id — BIGINT — Primary key — NOT NULL
  • market (마켓명) — VARCHAR(20) — NOT NULL
  • candle_date_time_utc (캔들 기준 시각(UTC 기준)) — DATETIME — NOT NULL
  • candle_date_time_kst (캔들 기준 시각(KST 기준)) — DATETIME — NOT NULL
  • opening_price (시가) — DECIMAL(20,8)
  • high_price (고가) — DECIMAL(20,8)
  • low_price (저가) — DECIMAL(20,8)
  • trade_price (종가) — DECIMAL(20,8)
  • timestamp (캔들 종료 시각(KST 기준)) — BIGINT
  • candle_acc_trade_price (누적 거래 금액) — DECIMAL(30,8)
  • candle_acc_trade_volume (누적 거래량) — DECIMAL(30,8)
  • prev_closing_price (전일 종가(UTC 0시 기준)) — DECIMAL(20,8)
  • change_price (전일 종가 대비 변화 금액) — DECIMAL(20,8)
  • change_rate (전일 종가 대비 변화량) — DECIMAL(20,8)
  • converted_trade_price (종가 환산 화폐 단위로 환산된 가격) — DECIMAL(20,8)
  • created_at — DATETIME
  • updated_at — DATETIME
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

deposit

  • recommended_product_id — BIGINT — Foreign key → recommended_financial_product.id — NOT NULL
  • account_type_unique_no — VARCHAR(255) — NOT NULL
  • bank_code — VARCHAR(255)
  • bank_name — VARCHAR(255) — NOT NULL
  • account_name — VARCHAR(255) — NOT NULL
  • account_no — VARCHAR(30)
  • account_create_date — DATE
  • account_description — TEXT
  • subscription_period — INT — NOT NULL
  • interest_rate — DECIMAL(10,4) — NOT NULL
  • rate_description — TEXT
  • final_score — DECIMAL(10,2) — NOT NULL
  • compare_score — DECIMAL(10,2) — NOT NULL
  • expected_maturity_amount — BIGINT — NOT NULL
  • expected_interest_amount — BIGINT — NOT NULL
  • expected_return — DECIMAL(10,4) — NOT NULL
  • risk_value — DECIMAL(10,4) — NOT NULL
  • recommendation_reason — TEXT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)

etf_detail

  • recommended_product_id — BIGINT — NOT NULL
  • etf_id — BIGINT
  • isu_cd — VARCHAR(255) — NOT NULL
  • isu_nm — VARCHAR(255) — NOT NULL
  • volatility — DOUBLE — NOT NULL
  • current_price — DECIMAL(38,2) — NOT NULL
  • dividend_yield — DOUBLE — NOT NULL
  • expected_return — DOUBLE — NOT NULL
  • quantity — DECIMAL(38,2)
  • avg_price — DECIMAL(38,2)
  • first_purchase_date — DATE
  • last_purchase_date — DATE
  • total_dividends_received — DECIMAL(38,2)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • Key — Foreign key → recommended_financial_product.id — NOT NULL

etf_master

  • id — BIGINT — Primary key — NOT NULL
  • isu_cd — VARCHAR(255) — NOT NULL
  • isu_nm — VARCHAR(255) — NOT NULL
  • idx_ind_nm — VARCHAR(255)
  • tdd_clsprc — BIGINT
  • nav — DOUBLE
  • dividend_rate — DOUBLE
  • avg_growth_rate — DOUBLE
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

etf_price_history

  • id — BIGINT — Primary key — NOT NULL
  • etf_id — BIGINT — Foreign key → etf_master.id — NOT NULL
  • base_date — VARCHAR(255) — NOT NULL
  • closing_price — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

etf_statistics

  • id — BIGINT — Primary key — NOT NULL
  • etf_id — BIGINT — Foreign key → etf_master.id — NOT NULL
  • volatility — DOUBLE — NOT NULL
  • expected_return — DOUBLE — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

etf_trade_history

  • id — BIGINT — NOT NULL
  • recommended_etf_id — BIGINT — Foreign key → etf_detail.recommended_product_id
  • trade_price — DECIMAL(38,2)
  • quantity — DECIMAL(38,2)
  • total_price — DECIMAL(38,2)
  • remaining_cash — DECIMAL(38,2)
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL
  • etf_master_id — BIGINT — Foreign key → etf_master.id — NOT NULL
  • Key — Foreign key → etf_detail.Key — NOT NULL

installment_savings

  • recommended_product_id — BIGINT — Foreign key → recommended_financial_product.id — NOT NULL
  • account_type_unique_no — VARCHAR(255) — NOT NULL
  • bank_code — VARCHAR(255)
  • bank_name — VARCHAR(255) — NOT NULL
  • account_name — VARCHAR(255) — NOT NULL
  • account_no — VARCHAR(30)
  • account_create_date — DATE
  • account_description — TEXT
  • subscription_period — INT — NOT NULL
  • interest_rate — DECIMAL(10,4) — NOT NULL
  • rate_description — TEXT
  • final_score — DECIMAL(10,2) — NOT NULL
  • compare_score — DECIMAL(10,2) — NOT NULL
  • expected_maturity_amount — BIGINT — NOT NULL
  • expected_interest_amount — BIGINT — NOT NULL
  • expected_return — DECIMAL(10,4) — NOT NULL
  • risk_value — DECIMAL(10,4) — NOT NULL
  • recommendation_reason — TEXT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)

product

  • product_id — VARCHAR(255) — Primary key — NOT NULL
  • title (상품명) — VARCHAR(255) — NOT NULL
  • link (구매 주소) — VARCHAR(255)
  • image_url (이미지 URL) — VARCHAR(255)
  • lowest_price (최저가) — DECIMAL(38,2) — NOT NULL
  • highest_price (최고가) — DECIMAL(38,2)
  • mall_name (판매처명) — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

recommended_financial_product

  • id — BIGINT — Primary key — NOT NULL
  • wishlist_id — BIGINT — NOT NULL
  • product_type — VARCHAR(255)
  • recommend_ratio — DOUBLE
  • recommend_first_amount — DECIMAL(38,2)
  • recommend_monthly_amount — DECIMAL(38,2)
  • recommend_amount — DECIMAL(38,2)
  • recommended_time — DATETIME(6) — NOT NULL
  • final_score — DOUBLE
  • risk_value — DOUBLE
  • recommend_reason — TEXT
  • is_selected — BIT(1)
  • recommend_order — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

stock_asset

  • isu_srt_cd (단축코드) — VARCHAR(20) — Primary key — NOT NULL
  • isu_cd (표준코드) — VARCHAR(20) — NOT NULL
  • isu_nm (한글 종목명) — VARCHAR(100) — NOT NULL
  • isu_abbrv (한글 종목약명) — VARCHAR(100)
  • isu_eng_nm (영문 종목명) — VARCHAR(200)
  • list_dd (상장일) — VARCHAR(20)
  • mkt_tp_nm (시장구분) — VARCHAR(50)
  • secugrp_nm (증권구분) — VARCHAR(50)
  • sect_tp_nm (소속부) — VARCHAR(50)
  • kind_stkcert_tp_nm (주식종류) — VARCHAR(50)
  • parval (액면가) — VARCHAR(30)
  • list_shrs (상장주식수) — VARCHAR(30)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

stock_daily_trade

  • id — BIGINT — Primary key — NOT NULL
  • bas_dd (기준일자) — VARCHAR(8) — NOT NULL
  • isu_cd (종목코드) — VARCHAR(20) — Foreign key → stock_asset.isu_cd — NOT NULL
  • isu_nm (종목명) — VARCHAR(255) — NOT NULL
  • mkt_nm (시장구분) — VARCHAR(255)
  • mkt_id — VARCHAR(255)
  • tdd_clsprc (종가) — BIGINT
  • fluc_tp_cd (등락 방향 코드) — VARCHAR(10)
  • cmpprevdd_prc (대비) — BIGINT
  • fluc_rt (등락률) — DOUBLE
  • tdd_opnprc (시가) — BIGINT
  • tdd_hgprc (고가) — BIGINT
  • tdd_lwprc (저가) — BIGINT
  • acc_trdvol (거래량) — BIGINT
  • acc_trdval (거래대금) — BIGINT
  • list_shrs (상장주식수) — BIGINT
  • mktcap (시가총액) — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

users

  • id — BINARY(16) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • age — INT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • ssafy_user_key — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

wishlist

  • wishlist_id — BIGINT — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL
  • total_amount (합계 금액) — DECIMAL(38,2) — NOT NULL
  • start_date (가입 시작일) — DATE — NOT NULL
  • end_date (목표 달성일) — DATE — NOT NULL
  • target_end_date (희망 목표 달성일) — DATE — NOT NULL
  • wish_list_status (위시리스트 상태) — VARCHAR(20) — NOT NULL
  • wish_list_image_url (이미지 URL) — VARCHAR(255)
  • current_amount (현재까지 모은 금액) — DECIMAL(38,2) — NOT NULL
  • seed_money (사용자 지정 시드머니) — BIGINT
  • monthly_payment (사용자 지정 월납입금) — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

wishlist_item

  • id — BIGINT — Primary key — NOT NULL
  • wishlist_id — BIGINT — Foreign key → wishlist.wishlist_id — NOT NULL
  • product_id — VARCHAR(255) — Foreign key → product.product_id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

wishlist_monthly_asset_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • wishlist_id — BIGINT — Foreign key → wishlist.wishlist_id — NOT NULL
  • base_month — VARCHAR(6) — NOT NULL
  • invested_amount — BIGINT — NOT NULL
  • evaluation_amount — BIGINT — NOT NULL
  • achievement_rate — DOUBLE — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)