프로젝트1
테이블 (13)
asset_store(워드클라우드 저장) (asset_store)
- asset_id — BIGINT — 기본 키 — NOT NULL
- created_by_user_id — BIGINT
- asset_type — VARCHAR(30) — NOT NULL
- keyword — VARCHAR(200)
- period_start — DATE
- period_end — DATE
- file_path — VARCHAR(500) — NOT NULL
- meta — TEXT
- created_at — DATETIME — NOT NULL
batch_error_log(에러로그) (batch_error_log)
- error_id — BIGINT — 기본 키 — NOT NULL
- run_id — BIGINT — NOT NULL
- step_run_id — BIGINT
- step_id — BIGINT
- category — VARCHAR(30)
- news_id — VARCHAR(80)
- missing_field — VARCHAR(40)
- fail_reason — VARCHAR(120)
- error_code — VARCHAR(60)
- message — TEXT
- payload — TEXT
- occurred_at — DATETIME — NOT NULL
- resolved_at — DATETIME
- resolved_by_user_id — BIGINT
batch_job(배치작업) (batch_job)
- job_id — BIGINT — 기본 키 — NOT NULL
- job_code — VARCHAR(40) — NOT NULL
- job_name — VARCHAR(120)
- target_id — BIGINT
- schedule_rule — VARCHAR(80)
- status — VARCHAR(20) — NOT NULL
- updated_at — DATETIME — NOT NULL
batch_run(배치실행) (batch_run)
- run_id — BIGINT — 기본 키 — NOT NULL
- job_id — BIGINT — NOT NULL
- requested_by_user_id — BIGINT
- trigger_type — VARCHAR(20) — NOT NULL
- target_start_at — DATETIME
- target_end_at — DATETIME
- started_at — DATETIME
- ended_at — DATETIME
- status — VARCHAR(20) — NOT NULL
- total_count — INT — NOT NULL
- success_count — INT — NOT NULL
- fail_count — INT — NOT NULL
- fail_rate — DECIMAL(6,4)
- params — TEXT
- created_at — DATETIME — NOT NULL
batch_step_def(배치사항 1:1매핑) (batch_step_def)
- step_id — BIGINT — 기본 키 — NOT NULL
- job_id — BIGINT — NOT NULL
- step_code — VARCHAR(20) — NOT NULL
- step_order — INT — NOT NULL
- step_name — VARCHAR(120)
- input_ref — VARCHAR(80)
- output_ref — VARCHAR(80)
- status — VARCHAR(20) — NOT NULL
batch_step_run(배치실행단계별기록) (batch_step_run)
- step_run_id — BIGINT — 기본 키 — NOT NULL
- run_id — BIGINT — NOT NULL
- step_id — BIGINT — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
- status — VARCHAR(20) — NOT NULL
- total_count — INT — NOT NULL
- success_count — INT — NOT NULL
- fail_count — INT — NOT NULL
- error_code — VARCHAR(60)
- message — TEXT
crawl_target(크롤링대상) (crawl_target)
- target_id — BIGINT — 기본 키 — NOT NULL
- target_name — VARCHAR(80) — NOT NULL
- base_url — VARCHAR(500) — NOT NULL
- query_template — VARCHAR(500)
- timezone — VARCHAR(40) — NOT NULL
- min_article_count — INT — NOT NULL
- window_start — TIME
- window_end — TIME
- required_fields — TEXT
- dedupe_rule — TEXT
- parse_rule — TEXT
- status — VARCHAR(20) — NOT NULL
- updated_at — DATETIME — NOT NULL
econ_knowledge(경제지식 /용어 컨텐츠) (econ_knowledge)
- knowledge_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_by_user_id — BIGINT
- updated_by_user_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
news_ref(뉴스참조테이블) (news_ref)
- news_id — VARCHAR(80) — 기본 키 — NOT NULL
- published_date — DATE
- url — VARCHAR(600)
- press — VARCHAR(120)
- title — VARCHAR(500)
- created_at — DATETIME — NOT NULL
rerun_item(재실행 목록) (rerun_item)
- item_id — BIGINT — 기본 키 — NOT NULL
- request_id — BIGINT — NOT NULL
- news_id — VARCHAR(80) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- message — TEXT
- updated_at — DATETIME — NOT NULL
rerun_request(재실행 요청메인) (rerun_request)
- request_id — BIGINT — 기본 키 — NOT NULL
- requested_by_user_id — BIGINT
- category — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- params — TEXT
- executed_run_id — BIGINT
- created_at — DATETIME — NOT NULL
user_action_log(회원관리로그페이지) (user_action_log)
- action_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT
- action_type — VARCHAR(30) — NOT NULL
- session_id — VARCHAR(100)
- keyword — VARCHAR(200)
- keyword_date — DATE
- period_type — VARCHAR(20)
- news_id — VARCHAR(80)
- payload — TEXT
- occurred_at — DATETIME — NOT NULL
users(회원기본정보) (users)
- user_id — BIGINT — 기본 키 — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL