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