stockmoa

Tables (26)

api_call_usage

  • api_name — VARCHAR(20) — Primary key — NOT NULL
  • usage_date — DATE — Primary key — NOT NULL
  • used_count — INT — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

batch_job_execution

  • JOB_EXECUTION_ID — bigint — Primary key — NOT NULL
  • VERSION — bigint
  • JOB_INSTANCE_ID — bigint — Foreign key → batch_job_instance.JOB_INSTANCE_ID — NOT NULL
  • CREATE_TIME — datetime(6) — NOT NULL
  • START_TIME — datetime(6)
  • END_TIME — datetime(6)
  • STATUS — varchar(10)
  • EXIT_CODE — varchar(2500)
  • EXIT_MESSAGE — varchar(2500)
  • LAST_UPDATED — datetime(6)

batch_job_execution_context

  • JOB_EXECUTION_ID — bigint — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
  • SHORT_CONTEXT — varchar(2500) — NOT NULL
  • SERIALIZED_CONTEXT — text

batch_job_execution_params

  • my_row_id — bigint — Primary key — NOT NULL
  • JOB_EXECUTION_ID — bigint — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
  • PARAMETER_NAME — varchar(100) — NOT NULL
  • PARAMETER_TYPE — varchar(100) — NOT NULL
  • PARAMETER_VALUE — varchar(2500)
  • IDENTIFYING — char(1) — NOT NULL

batch_job_execution_seq

  • my_row_id — bigint — Primary key — NOT NULL
  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

batch_job_instance

  • JOB_INSTANCE_ID — bigint — Primary key — NOT NULL
  • VERSION — bigint
  • JOB_NAME — varchar(100) — NOT NULL
  • JOB_KEY — varchar(32) — NOT NULL

batch_job_seq

  • my_row_id — bigint — Primary key — NOT NULL
  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

batch_step_execution

  • STEP_EXECUTION_ID — bigint — Primary key — NOT NULL
  • VERSION — bigint — NOT NULL
  • STEP_NAME — varchar(100) — NOT NULL
  • JOB_EXECUTION_ID — bigint — Foreign key → batch_job_execution.JOB_EXECUTION_ID — NOT NULL
  • CREATE_TIME — datetime(6) — NOT NULL
  • START_TIME — datetime(6)
  • END_TIME — datetime(6)
  • STATUS — varchar(10)
  • COMMIT_COUNT — bigint
  • READ_COUNT — bigint
  • FILTER_COUNT — bigint
  • WRITE_COUNT — bigint
  • READ_SKIP_COUNT — bigint
  • WRITE_SKIP_COUNT — bigint
  • PROCESS_SKIP_COUNT — bigint
  • ROLLBACK_COUNT — bigint
  • EXIT_CODE — varchar(2500)
  • EXIT_MESSAGE — varchar(2500)
  • LAST_UPDATED — datetime(6)

batch_step_execution_context

  • STEP_EXECUTION_ID — bigint — Foreign key → batch_step_execution.STEP_EXECUTION_ID — NOT NULL
  • SHORT_CONTEXT — varchar(2500) — NOT NULL
  • SERIALIZED_CONTEXT — text

batch_step_execution_seq

  • my_row_id — bigint — Primary key — NOT NULL
  • ID — bigint — NOT NULL
  • UNIQUE_KEY — char(1) — NOT NULL

batch_sync_state

  • sync_key — VARCHAR(100) — Primary key — NOT NULL
  • scope_key — VARCHAR(100) — Primary key — NOT NULL
  • synced_from — DATE
  • synced_to — DATE
  • last_run_at — DATETIME(6)
  • last_status — VARCHAR(20)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

company

  • company_id — BIGINT — Primary key — NOT NULL
  • corp_name — VARCHAR(120) — NOT NULL

flyway_schema_history

  • installed_rank — int — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int — NOT NULL
  • success — tinyint(1) — NOT NULL

mock_account

  • mock_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • seed_amount — DECIMAL(18, 2) — NOT NULL — 가입 지급 가상머니
  • cash_balance — DECIMAL(18, 2) — NOT NULL — 현재 예수금(가상머니)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

mock_holding

  • mock_holding_id — BIGINT — Primary key — NOT NULL
  • mock_account_id — BIGINT — Foreign key → mock_account.mock_account_id — NOT NULL
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL
  • quantity — BIGINT — NOT NULL
  • avg_price — DECIMAL(18, 4) — NOT NULL — 평균 매입 단가
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

mock_ranking_snapshot

  • mock_ranking_snapshot_id — BIGINT — Primary key — NOT NULL
  • mock_account_id — BIGINT — NOT NULL
  • period_type — VARCHAR(10) — NOT NULL — DAILY / WEEKLY / MONTHLY
  • snapshot_date — DATE — NOT NULL — 집계 기준일
  • return_rate — DECIMAL(10, 4) — NOT NULL — 수익률(%)
  • eval_amount — DECIMAL(18, 2) — NOT NULL — 평가금액
  • win_rate — DECIMAL(5, 2) — 승률(%)
  • rank_no — INT — NOT NULL — 순위
  • created_at — DATETIME(6) — NOT NULL

mock_trade

  • mock_trade_id — BIGINT — Primary key — NOT NULL
  • mock_account_id — BIGINT — Foreign key → mock_account.mock_account_id — NOT NULL
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL
  • side — VARCHAR(4) — NOT NULL — BUY / SELL
  • quantity — BIGINT — NOT NULL
  • price — DECIMAL(18, 4) — NOT NULL — 체결 단가
  • amount — DECIMAL(18, 2) — NOT NULL — 체결 금액(수량*단가)
  • traded_at — DATETIME(6) — NOT NULL

social_account

  • social_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — KAKAO / NAVER / GOOGLE
  • provider_user_id — VARCHAR(191) — NOT NULL — 소셜 제공자의 사용자 고유 ID
  • created_at — DATETIME(6) — NOT NULL

stock

  • stock_id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id
  • stock_code — VARCHAR(6) — NOT NULL
  • stock_name — VARCHAR(60) — NOT NULL

stock_event

  • stock_event_id — BIGINT — Primary key — NOT NULL
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL
  • event_type — VARCHAR(20) — NOT NULL — MEETING(주총) / DIVIDEND(배당) / RIGHTS(권리) 등
  • event_date — DATE — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

stock_price_adjustment

  • effective_date — DATE — Primary key — NOT NULL
  • stock_id — BIGINT — Foreign key — NOT NULL
  • factor — DECIMAL(20,10) — NOT NULL
  • event_type — VARCHAR(20) — NOT NULL
  • shares_before — BIGINT — NOT NULL
  • shares_after — BIGINT — NOT NULL
  • close_before — DECIMAL(18,4) — NOT NULL
  • close_after — DECIMAL(18,4) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

stock_price_daily

  • trade_date — DATE — Primary key — NOT NULL
  • stock_id — BIGINT — Foreign key — NOT NULL
  • open_price — DECIMAL(15,2)
  • high_price — DECIMAL(15,2)
  • low_price — DECIMAL(15,2)
  • close_price — DECIMAL(15,2) — NOT NULL
  • change_price — DECIMAL(15,2) — NOT NULL
  • change_rate — DECIMAL(9,2) — NOT NULL
  • volume — BIGINT — NOT NULL
  • trading_value — BIGINT — NOT NULL
  • market_cap — BIGINT — NOT NULL
  • listed_shares — BIGINT — NOT NULL
  • is_traded — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

stock_price_monthly

  • month_start — DATE — Primary key — NOT NULL
  • stock_id — BIGINT — Foreign key — NOT NULL
  • open_price — DECIMAL(15,2)
  • high_price — DECIMAL(15,2)
  • low_price — DECIMAL(15,2)
  • close_price — DECIMAL(15,2) — NOT NULL
  • volume — BIGINT — NOT NULL
  • trading_value — BIGINT — NOT NULL
  • is_complete — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

stock_price_weekly

  • week_start — DATE — Primary key — NOT NULL
  • stock_id — BIGINT — Foreign key — NOT NULL
  • open_price — DECIMAL(15,2)
  • high_price — DECIMAL(15,2)
  • low_price — DECIMAL(15,2)
  • close_price — DECIMAL(15,2) — NOT NULL
  • volume — BIGINT — NOT NULL
  • trading_value — BIGINT — NOT NULL
  • is_complete — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 로그인 아이디 / 소셜 이메일
  • password_hash — VARCHAR(255) — 로컬 계정만 존재. OAuth 전용 계정은 NULL
  • nickname — VARCHAR(30) — NOT NULL — 커뮤니티 표시 이름
  • email_verified — TINYINT(1) — NOT NULL — 로컬 가입=이메일 인증 후 1, OAuth=0(미인증)
  • marketing_email_agreed — TINYINT(1) — NOT NULL — 이메일 수신 동의(선택 약관)
  • role — VARCHAR(20) — NOT NULL — USER / ADMIN
  • status — VARCHAR(20) — NOT NULL — ACTIVE / WITHDRAWN
  • last_login_at — DATETIME(6)
  • withdrawn_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

watchlist_item

  • watchlist_item_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL