ERD

Tables (15)

CALC_GROUP (Untitled11)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

CALC_HISTORY (Untitled13)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

CALC_RESULT_DETAIL (Untitled12)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

CALC_TYPE (계산 방식 코드)

  • 계산 방식 코드 (CALC_TYPE_CD) — VARCHAR2 — Primary key — NOT NULL
  • 계산 방식 설명 (DESCRIPTION) — VARCHAR2

DED_CONDITION (Untitled4)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

DED_GROUP_MAP (Untitled10)

  • Key — Primary key — NOT NULL
  • Field

DED_MASTER (공제 마스터)

  • 공제 고유 ID (DED_ID) — NUMBER — Primary key — NOT NULL
  • Key — Primary key — NOT NULL — 123
  • 계산 방식 코드 (CALC_TYPE_CD2) — VARCHAR2 — Foreign key → CALC_TYPE.계산 방식 코드 — NOT NULL
  • 공제명 (DED_NAME) — VARCHAR2
  • 적용 연도 (APPLY_YEAR) — NUMBER
  • 화면 노출 순서 (DISPLAY_ORDER) — NUMBER
  • 공제 설명 (DESCRIPTION) — VARCHAR2
  • 공제 활성화 여부 (ACTIVE_YN) — CHAR
  • 생성일 (CRATED_AT) — DATE
  • 수정일 (UPDATED_AT) — DATE
  • 계산 방식 코드 (CALC_TYPE_CD) — VARCHAR2

DED_RULE (공제 규칙)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

DED_RULE_PARAM (Untitled5)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

HELP_CONTENT (Untitled6)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

INPUT_FIELD_MASTER (Untitled7)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

SIMPLE_ANALYSIS_LOG (Untitled9)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

USER (Untitled14)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

USER_BEHAVIOR_LOG (Untitled15)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

USER_INPUT_CTX (Untitled8)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3