ㅂㅈ
Tables (21)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — BIGINT — Primary key — NOT NULL
- VERSION — BIGINT
- JOB_INSTANCE_ID — BIGINT — 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 — Primary key — NOT NULL
- SHORT_CONTEXT — VARCHAR(2500) — NOT NULL
- SERIALIZED_CONTEXT — TEXT
BATCH_JOB_EXECUTION_PARAMS
- JOB_EXECUTION_ID — BIGINT — 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
- 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_INSTANCE_SEQ
- 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 — 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 — Primary key — NOT NULL
- SHORT_CONTEXT — VARCHAR(2500) — NOT NULL
- SERIALIZED_CONTEXT — TEXT
BATCH_STEP_EXECUTION_SEQ
- ID — BIGINT — NOT NULL
- UNIQUE_KEY — CHAR(1) — NOT NULL
ETF
- etf_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → kb_product.product_id — NOT NULL
- cagr_10y — DOUBLE — NOT NULL
- annual_volatility — DOUBLE — NOT NULL
FAQ
- faq_id — BIGINT — Primary key — NOT NULL
- faq_content — TEXT — NOT NULL
- faq_answer — TEXT — NOT NULL
deposit
- deposit_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → kb_product.product_id — NOT NULL
- interest_rate — DOUBLE — NOT NULL
- term_month — INT — NOT NULL
- payment_type — ENUM('LUMP_SUM', 'INSTALLMENT') — NOT NULL
- monthly_limit — BIGINT
family
- family_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- family_name — VARCHAR(100) — NOT NULL
- relation — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deduction_type — ENUM('SPOUSE', 'LINEAL_DESCENDANT', 'OTHER') — NOT NULL
gift
- gift_id — BIGINT — Primary key — NOT NULL
- family_id — BIGINT — Foreign key → family.family_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- amount — BIGINT — NOT NULL
- status — ENUM('DRAFT', 'CONFIRMED', 'CANCELLED') — NOT NULL
- memo — TEXT
- gift_date — DATE — NOT NULL
kb_product
- product_id — BIGINT — Primary key — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- product_type — ENUM('DEPOSIT', 'ETF', 'SAVINGS_INSURANCE') — NOT NULL
- description — TEXT — NOT NULL
law_article
- law_id — BIGINT — Primary key — NOT NULL
- law_name — VARCHAR(200) — NOT NULL
- article_no — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- title — VARCHAR(200) — NOT NULL
reminder
- reminder_id — BIGINT — Primary key — NOT NULL
- gift_id — BIGINT — Foreign key → gift.gift_id — NOT NULL
- reminder_type — ENUM('DEDUCTION_RENEWAL', 'FILING_DEADLINE') — NOT NULL
- target_date — DATE — NOT NULL
- status — ENUM('PENDING', 'SENT', 'FAILED') — NOT NULL
- sent_at — DATETIME
- created_at — DATETIME — NOT NULL
saving_insurance
- saving_insurance_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → kb_product.product_id — NOT NULL
- disclosed_rate — DOUBLE — NOT NULL
- guaranteed_rate — DOUBLE — NOT NULL
- term_month — INT — NOT NULL
- payment_type — ENUM('LUMP_SUM', 'INSTALLMENT') — NOT NULL
- monthly_limit — BIGINT
simulation
- simulation_id — BIGINT — Primary key — NOT NULL
- gift_id — BIGINT — Foreign key → gift.gift_id — NOT NULL
- product_id — BIGINT — Foreign key → kb_product.product_id — NOT NULL
- amount — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- expired_at — DATETIME — NOT NULL
- simulation_name — VARCHAR(200) — NOT NULL
simulation_result
- result_id — BIGINT — Primary key — NOT NULL
- simulation_id — BIGINT — Foreign key → simulation.simulation_id — NOT NULL
- gift_tax — BIGINT — NOT NULL
- expected_amount — BIGINT — NOT NULL
user
- user_id — BIGINT — Primary key — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — ENUM('ADMIN', 'USER') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- email — VARCHAR(255) — NOT NULL