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)