ㅂㅈ

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