금융 서비스 이탈 가능 고객 예측 현황 시스템

테이블 (91)

APPLICATION_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • APPLICATION_ID — NUMBER(18) — 외래 키 → INSURANCE_APPLICATION.APPLICATION_ID — NOT NULL
  • CHANGE_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • PREVIOUS_STATUS_CODE — VARCHAR2(20)
  • CURRENT_STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CHANGED_AT — TIMESTAMP — NOT NULL

ASSIGNMENT_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • ASSIGNMENT_ID — NUMBER(18) — 외래 키 → CONSULTATION_ASSIGNMENT.ASSIGNMENT_ID — NOT NULL
  • PREVIOUS_COUNSELOR_ID — VARCHAR2(30)
  • CURRENT_COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • CHANGED_AT — TIMESTAMP — NOT NULL
  • CHANGED_BY — VARCHAR2(30) — NOT NULL

AUDIT_LOG

  • AUDIT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • ACTION_CODE — VARCHAR2(20) — NOT NULL
  • TARGET_TABLE — VARCHAR2(30)
  • TARGET_KEY — VARCHAR2(50)
  • IP_ADDRESS — VARCHAR2(45) — NOT NULL
  • PROCESSED_AT — TIMESTAMP — NOT NULL
  • DETAIL — VARCHAR2(1000)

BACKUP_EXECUTION

  • BACKUP_ID — NUMBER(18) — 기본 키 — NOT NULL
  • POLICY_ID — VARCHAR2(20) — 외래 키 → BACKUP_POLICY.POLICY_ID — NOT NULL
  • STARTED_AT — TIMESTAMP — NOT NULL
  • ENDED_AT — TIMESTAMP
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • FILE_LOCATION — VARCHAR2(300)
  • FILE_SIZE — NUMBER(18)

BACKUP_POLICY

  • POLICY_ID — VARCHAR2(20) — 기본 키 — NOT NULL
  • POLICY_NAME — VARCHAR2(50) — NOT NULL
  • CYCLE — VARCHAR2(30) — NOT NULL
  • RETENTION_DAYS — NUMBER(4) — NOT NULL
  • TARGET_TABLES — VARCHAR2(1000)
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

BATCH_ERROR_LOG

  • ERROR_ID — NUMBER(18) — 기본 키 — NOT NULL
  • EXECUTION_ID — NUMBER(18) — 외래 키 → BATCH_EXECUTION.EXECUTION_ID — NOT NULL
  • OCCURRED_AT — TIMESTAMP — NOT NULL
  • STEP_NAME — VARCHAR2(50)
  • ERROR_MESSAGE — VARCHAR2(1000) — NOT NULL
  • STACK_SUMMARY — VARCHAR2(2000)

BATCH_EXECUTION

  • EXECUTION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • JOB_ID — NUMBER(18) — 외래 키 → BATCH_JOB.JOB_ID — NOT NULL
  • TARGET_BASE_DATE — DATE — NOT NULL
  • STARTED_AT — TIMESTAMP — NOT NULL
  • ENDED_AT — TIMESTAMP
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • PROCESSED_COUNT — NUMBER(12)
  • RETRY_COUNT — NUMBER(3) — NOT NULL

BATCH_JOB

  • JOB_ID — NUMBER(18) — 기본 키 — NOT NULL
  • JOB_NAME — VARCHAR2(50) — NOT NULL
  • SCHEDULE — VARCHAR2(50) — NOT NULL
  • JOB_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL

CAMPAIGN_SOURCE

  • SOURCE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CHANNEL_CODE — VARCHAR2(20) — 외래 키 → INFLOW_CHANNEL.CHANNEL_CODE — NOT NULL
  • PARTNER_CODE — VARCHAR2(20)
  • CAMPAIGN_NAME — VARCHAR2(100)
  • LANDING_PAGE — VARCHAR2(300)
  • REFERRER — VARCHAR2(50)
  • GENERAL_INFLOW_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CHURN_ACTION

  • ACTION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CHURN_CUSTOMER_ID — NUMBER(18) — 외래 키 → CHURN_CUSTOMER.CHURN_CUSTOMER_ID — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • ACTION_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • ACTION_AT — TIMESTAMP — NOT NULL
  • RESULT_CODE — VARCHAR2(20)
  • NEXT_ACTION_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CHURN_ACTION_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • ACTION_ID — NUMBER(18) — 외래 키 → CHURN_ACTION.ACTION_ID — NOT NULL
  • ACTION_AT — TIMESTAMP — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • CONTENT — VARCHAR2(1000)
  • RESULT — VARCHAR2(200)
  • NEXT_ACTION_AT — TIMESTAMP

CHURN_CANDIDATE

  • CANDIDATE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • CRITERIA_ID — NUMBER(18) — 외래 키 → CHURN_CRITERIA.CRITERIA_ID — NOT NULL
  • SOURCE_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • SOURCE_ID — NUMBER(18)
  • DETECTED_AT — TIMESTAMP — NOT NULL
  • REPRESENTATIVE_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CHURN_CRITERIA

  • CRITERIA_ID — NUMBER(18) — 기본 키 — NOT NULL
  • NO_SUBSCRIPTION_DAYS — NUMBER(4) — NOT NULL
  • ABANDONED_DAYS — NUMBER(4) — NOT NULL
  • INCOMPLETE_PAYMENT_DAYS — NUMBER(4) — NOT NULL
  • CONTACT_FAILURE_COUNT — NUMBER(3) — NOT NULL
  • ACTIVE_FROM — DATE — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CHURN_CRITERIA_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CRITERIA_ID — NUMBER(18) — 외래 키 → CHURN_CRITERIA.CRITERIA_ID — NOT NULL
  • CHANGED_AT — TIMESTAMP — NOT NULL
  • CHANGED_BY — VARCHAR2(30) — NOT NULL
  • PREVIOUS_VALUE — VARCHAR2(500)
  • CURRENT_VALUE — VARCHAR2(500)

CHURN_CUSTOMER

  • CHURN_CUSTOMER_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CANDIDATE_ID — NUMBER(18) — 외래 키 → CHURN_CANDIDATE.CANDIDATE_ID — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • OCCURRED_AT — TIMESTAMP — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • TYPE_CODE — VARCHAR2(20) — NOT NULL
  • TYPE_PRIORITY — NUMBER(3)
  • AUTO_CLASSIFIED_YN — CHAR(1) — NOT NULL
  • CHURN_SCORE — NUMBER(5,2)
  • GRADE_CODE — VARCHAR2(20)
  • SCORE_CALCULATED_AT — TIMESTAMP
  • MODEL_VERSION — VARCHAR2(20)
  • CONFIRMED_AT — TIMESTAMP
  • CONFIRM_REASON — VARCHAR2(300)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CHURN_GRADE_RULE

  • RULE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • MIN_SCORE — NUMBER(5,2) — NOT NULL
  • MAX_SCORE — NUMBER(5,2) — NOT NULL
  • GRADE_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CHURN_REASON

  • REASON_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CHURN_CUSTOMER_ID — NUMBER(18) — 외래 키 → CHURN_CUSTOMER.CHURN_CUSTOMER_ID — NOT NULL
  • REASON_CODE — VARCHAR2(20) — NOT NULL
  • SELECTED_AT — TIMESTAMP — NOT NULL
  • CUSTOMER_REACTION — VARCHAR2(500)
  • RECONSULTATION_POSSIBILITY — VARCHAR2(200)
  • REJECTION_REASON — VARCHAR2(500)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CHURN_TRAINING_DATASET

  • DATA_SET_ID — NUMBER(18) — 기본 키 — NOT NULL
  • GENERATED_AT — TIMESTAMP — NOT NULL
  • ROW_COUNT — NUMBER(12) — NOT NULL
  • ANONYMIZED_YN — CHAR(1) — NOT NULL
  • FILE_LOCATION — VARCHAR2(300)

CHURN_TYPE_RULE

  • RULE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • SOURCE_STATUS — VARCHAR2(50) — NOT NULL
  • TYPE_CODE — VARCHAR2(20) — NOT NULL
  • PRIORITY — NUMBER(3) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

COMMON_CODE

  • CODE_ID — VARCHAR2(30) — 기본 키 — NOT NULL
  • GROUP_CODE — VARCHAR2(30) — 외래 키 → COMMON_CODE_GROUP.GROUP_CODE — NOT NULL
  • CODE_NAME — VARCHAR2(50) — NOT NULL
  • SORT_ORDER — NUMBER(4) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL
  • ATTR1 — VARCHAR2(100)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

COMMON_CODE_GROUP

  • GROUP_CODE — VARCHAR2(30) — 기본 키 — NOT NULL
  • GROUP_NAME — VARCHAR2(50) — NOT NULL
  • DESCRIPTION — VARCHAR2(200)
  • USE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

COMPLETION_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • COMPLETION_ID — NUMBER(18) — 외래 키 — NOT NULL
  • CHANGED_AT — TIMESTAMP — NOT NULL
  • CHANGED_BY — VARCHAR2(30) — NOT NULL
  • PREVIOUS_VALUE — VARCHAR2(500)
  • CURRENT_VALUE — VARCHAR2(500)

CONSENT_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CONSENT_ID — NUMBER(18) — 외래 키 → PRIVACY_CONSENT.CONSENT_ID — NOT NULL
  • CHANGE_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • PREVIOUS_STATUS_CODE — VARCHAR2(20)
  • CURRENT_STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CHANGED_AT — TIMESTAMP — NOT NULL
  • CHANGED_BY — VARCHAR2(30) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL

CONSULTATION

  • CONSULTATION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REQUEST_ID — NUMBER(18) — 외래 키 → CONSULTATION_REQUEST.REQUEST_ID — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • STARTED_AT — TIMESTAMP — NOT NULL
  • ENDED_AT — TIMESTAMP
  • CONTACT_CHANNEL_CODE — VARCHAR2(20) — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CONSULTATION_ASSIGNMENT

  • ASSIGNMENT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REQUEST_ID — NUMBER(18) — 외래 키 → CONSULTATION_REQUEST.REQUEST_ID — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • ASSIGNED_AT — TIMESTAMP — NOT NULL
  • ASSIGNED_BY — VARCHAR2(30) — 외래 키 — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL

CONSULTATION_CANDIDATE

  • CANDIDATE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • INFLOW_ID — NUMBER(18) — 외래 키 → CUSTOMER_INFLOW.INFLOW_ID — NOT NULL
  • REASON — VARCHAR2(200)
  • PRIORITY — NUMBER(4)
  • CREATED_AT_DT — TIMESTAMP — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL

CONSULTATION_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CONSULTATION_ID — NUMBER(18) — 외래 키 → CONSULTATION.CONSULTATION_ID — NOT NULL
  • CONSULTED_AT — TIMESTAMP — NOT NULL
  • CONTENT — VARCHAR2(2000) — NOT NULL
  • CUSTOMER_REACTION — VARCHAR2(500)
  • FOLLOW_UP_ACTION — VARCHAR2(500)

CONSULTATION_MEMO

  • MEMO_ID — NUMBER(18) — 기본 키 — NOT NULL
  • HISTORY_ID — NUMBER(18) — 외래 키 → CONSULTATION_HISTORY.HISTORY_ID — NOT NULL
  • CONTENT — VARCHAR2(2000) — NOT NULL
  • CREATED_AT_DT — TIMESTAMP — NOT NULL

CONSULTATION_NOTIFICATION

  • NOTIFICATION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REQUEST_ID — NUMBER(18) — 외래 키 → CONSULTATION_REQUEST.REQUEST_ID — NOT NULL
  • NOTIFICATION_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • SCHEDULED_DATE — DATE — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL

CONSULTATION_PRIORITY

  • PRIORITY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REQUEST_ID — NUMBER(18) — 외래 키 → CONSULTATION_REQUEST.REQUEST_ID — NOT NULL
  • RULE_ID — NUMBER(18) — 외래 키 → PRIORITY_RULE.RULE_ID — NOT NULL
  • SCORE — NUMBER(6) — NOT NULL
  • LEVEL_CODE — VARCHAR2(20) — NOT NULL
  • CALCULATED_AT — TIMESTAMP — NOT NULL

CONSULTATION_PRODUCT

  • CONSULTATION_PRODUCT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • HISTORY_ID — NUMBER(18) — 외래 키 → CONSULTATION_HISTORY.HISTORY_ID — NOT NULL
  • PRODUCT_CODE — VARCHAR2(20) — 외래 키 → PRODUCT_MASTER.PRODUCT_CODE — NOT NULL
  • COVERAGE_CONDITION — VARCHAR2(500)
  • EXPECTED_PREMIUM — NUMBER(18,2)

CONSULTATION_REQUEST

  • REQUEST_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • REQUESTED_AT — TIMESTAMP — NOT NULL
  • PREFERRED_AT — TIMESTAMP
  • REQUEST_CHANNEL_CODE — VARCHAR2(20) — NOT NULL
  • INQUIRY — VARCHAR2(1000)
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • TARGET_CREATED_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CONSULTATION_REQUEST_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REQUEST_ID — NUMBER(18) — 외래 키 → CONSULTATION_REQUEST.REQUEST_ID — NOT NULL
  • CHANGE_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • PREVIOUS_VALUE — VARCHAR2(500)
  • CURRENT_VALUE — VARCHAR2(500)
  • CHANGE_REASON — VARCHAR2(300)
  • CHANGED_AT — TIMESTAMP — NOT NULL
  • CHANGED_BY — VARCHAR2(30) — NOT NULL

CONSULTATION_RESULT

  • RESULT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CONSULTATION_ID — NUMBER(18) — 외래 키 → CONSULTATION.CONSULTATION_ID — NOT NULL
  • RESULT_CODE — VARCHAR2(20) — NOT NULL
  • REGISTERED_AT — TIMESTAMP — NOT NULL
  • NEXT_PROCESS_CODE — VARCHAR2(20) — NOT NULL
  • CANDIDATE_CREATED_AT — TIMESTAMP
  • CANDIDATE_STATUS_CODE — VARCHAR2(20)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CONSULTATION_RESULT_RULE

  • RULE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • RESULT_CODE — VARCHAR2(20) — NOT NULL
  • NEXT_PROCESS_CODE — VARCHAR2(20) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CONSULTATION_SCHEDULE

  • CONSULTATION_SCHEDULE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REQUEST_ID — NUMBER(18) — 외래 키 → CONSULTATION_REQUEST.REQUEST_ID — NOT NULL
  • SCHEDULE_ID — NUMBER(18) — 외래 키 → COUNSELOR_SCHEDULE.SCHEDULE_ID — NOT NULL
  • SCHEDULED_AT — TIMESTAMP — NOT NULL
  • MANUALLY_ASSIGNED_YN — CHAR(1) — NOT NULL

CONTACT_ATTEMPT

  • ATTEMPT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CONSULTATION_ID — NUMBER(18) — 외래 키 → CONSULTATION.CONSULTATION_ID — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • ATTEMPTED_AT — TIMESTAMP — NOT NULL
  • CONTACT_CHANNEL_CODE — VARCHAR2(20) — NOT NULL
  • ATTEMPT_NO — NUMBER(3) — NOT NULL
  • SUCCESS_YN — CHAR(1) — NOT NULL
  • RESPONDED_YN — CHAR(1) — NOT NULL

CONTACT_FAILURE

  • FAILURE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • ATTEMPT_ID — NUMBER(18) — 외래 키 → CONTACT_ATTEMPT.ATTEMPT_ID — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • REASON_CODE — VARCHAR2(20) — NOT NULL
  • FAILURE_COUNT — NUMBER(3) — NOT NULL
  • LAST_FAILED_AT — TIMESTAMP — NOT NULL
  • RETRY_AT — TIMESTAMP

COUNSELOR_PERFORMANCE

  • PERFORMANCE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • BASE_DATE — DATE — NOT NULL
  • PERIOD_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • COMPLETED_COUNT — NUMBER(12) — NOT NULL
  • CONTACT_ATTEMPT_COUNT — NUMBER(12) — NOT NULL
  • CONTACT_SUCCESS_COUNT — NUMBER(12) — NOT NULL
  • COMPLETION_NUMERATOR — NUMBER(12) — NOT NULL
  • COMPLETION_DENOMINATOR — NUMBER(12) — NOT NULL
  • PREVENTION_NUMERATOR — NUMBER(12) — NOT NULL
  • PREVENTION_DENOMINATOR — NUMBER(12) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL

COUNSELOR_SCHEDULE

  • SCHEDULE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • AVAILABLE_DATE — DATE — NOT NULL
  • TIME_SLOT — VARCHAR2(20) — NOT NULL
  • CONSULTATION_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • CAPACITY — NUMBER(3) — NOT NULL

CUSTOMER

  • CUSTOMER_ID — VARCHAR2(30) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(30) — 외래 키
  • CUSTOMER_NAME — VARCHAR2(50) — NOT NULL
  • AGE_GROUP_CODE — VARCHAR2(20)
  • GENDER_CODE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(300)
  • PHONE — VARCHAR2(20) — NOT NULL
  • EMAIL — VARCHAR2(100)
  • ALTERNATE_CONTACT — VARCHAR2(20)
  • CONTACTABLE_TIME — VARCHAR2(50)
  • CONTACT_VALIDATED_YN — CHAR(1) — NOT NULL
  • INFLOW_AT — TIMESTAMP — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CUSTOMER_INFLOW

  • INFLOW_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • CHANNEL_CODE — VARCHAR2(20) — 외래 키 → INFLOW_CHANNEL.CHANNEL_CODE — NOT NULL
  • SOURCE_ID — NUMBER(18) — 외래 키 → CAMPAIGN_SOURCE.SOURCE_ID
  • INFLOW_AT — TIMESTAMP — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • INTEGRATED_YN — CHAR(1) — NOT NULL
  • DUPLICATE_STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

CUSTOMER_INTEREST

  • INTEREST_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • PRODUCT_CODE — VARCHAR2(20) — 외래 키 → PRODUCT_MASTER.PRODUCT_CODE — NOT NULL
  • INTEREST_LEVEL_CODE — VARCHAR2(20)
  • SELECTED_AT — TIMESTAMP — NOT NULL
  • INFLOW_SOURCE — VARCHAR2(50)
  • LATEST_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

DASHBOARD_CHART

  • CHART_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REPORT_ID — NUMBER(18) — 외래 키 → MANAGEMENT_REPORT.REPORT_ID
  • CHART_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • CHART_TITLE — VARCHAR2(100) — NOT NULL
  • CHART_DATA — CLOB
  • SORT_ORDER — NUMBER(4) — NOT NULL

DATA_CONSISTENCY_ERROR

  • ERROR_ID — NUMBER(18) — 기본 키 — NOT NULL
  • PROCESS_ID — NUMBER(18) — 외래 키 — NOT NULL
  • ERROR_TYPE — VARCHAR2(50) — NOT NULL
  • MESSAGE — VARCHAR2(500) — NOT NULL
  • DETECTED_AT — TIMESTAMP — NOT NULL
  • RESOLVED_YN — CHAR(1) — NOT NULL

DESIRED_PRODUCT

  • DESIRED_PRODUCT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REQUEST_ID — NUMBER(18) — 외래 키 → CONSULTATION_REQUEST.REQUEST_ID — NOT NULL
  • PRODUCT_CODE — VARCHAR2(20) — 외래 키 → PRODUCT_MASTER.PRODUCT_CODE — NOT NULL
  • PURPOSE — VARCHAR2(200)
  • SELECTED_AT — TIMESTAMP — NOT NULL

DESIRED_PRODUCT_HISTORY

  • HISTORY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • DESIRED_PRODUCT_ID — NUMBER(18) — 외래 키 → DESIRED_PRODUCT.DESIRED_PRODUCT_ID — NOT NULL
  • PREVIOUS_PRODUCT_CODE — VARCHAR2(20)
  • CURRENT_PRODUCT_CODE — VARCHAR2(20) — NOT NULL
  • CHANGE_REASON — VARCHAR2(200)
  • CHANGED_AT — TIMESTAMP — NOT NULL

DUPLICATE_CUSTOMER_MATCH

  • MATCH_ID — NUMBER(18) — 기본 키 — NOT NULL
  • INFLOW_ID — NUMBER(18) — 외래 키 → CUSTOMER_INFLOW.INFLOW_ID — NOT NULL
  • SOURCE_CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • MATCHED_CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • MATCH_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • MATCHED_FIELD — VARCHAR2(30) — NOT NULL
  • MATCH_SCORE — NUMBER(5,2)
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • LINKED_AT — TIMESTAMP

ERROR_MESSAGE

  • ERROR_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
  • USER_MESSAGE — VARCHAR2(300) — NOT NULL
  • INTERNAL_MESSAGE — VARCHAR2(500)
  • ERROR_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

FOLLOW_UP_NOTIFICATION

  • NOTIFICATION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • FOLLOW_UP_ID — NUMBER(18) — 외래 키 → FOLLOW_UP_SCHEDULE.FOLLOW_UP_ID — NOT NULL
  • NOTIFY_AT — TIMESTAMP — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL

FOLLOW_UP_SCHEDULE

  • FOLLOW_UP_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CONSULTATION_ID — NUMBER(18) — 외래 키 → CONSULTATION.CONSULTATION_ID — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • SCHEDULED_AT — TIMESTAMP — NOT NULL
  • ACTION — VARCHAR2(500)
  • STATUS_CODE — VARCHAR2(20) — NOT NULL

INFLOW_CHANNEL

  • CHANNEL_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
  • CHANNEL_NAME — VARCHAR2(50) — NOT NULL
  • CHANNEL_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

INSURANCE_APPLICATION

  • APPLICATION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • PROCESS_ID — NUMBER(18) — 외래 키 — NOT NULL
  • PRODUCT_CODE — VARCHAR2(20) — 외래 키 → PRODUCT_MASTER.PRODUCT_CODE — NOT NULL
  • APPLIED_AT — TIMESTAMP — NOT NULL
  • PREMIUM — NUMBER(18,2) — NOT NULL
  • PAYMENT_CYCLE — VARCHAR2(20) — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

MANAGEMENT_REPORT

  • REPORT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • SNAPSHOT_ID — NUMBER(18) — 외래 키 → STATISTICS_SNAPSHOT.SNAPSHOT_ID
  • REPORT_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • REPORT_TITLE — VARCHAR2(100) — NOT NULL
  • GENERATED_AT — TIMESTAMP — NOT NULL
  • GENERATED_BY — VARCHAR2(30) — 외래 키 — NOT NULL

MASKING_POLICY

  • POLICY_ID — VARCHAR2(20) — 기본 키 — NOT NULL
  • TARGET_TABLE — VARCHAR2(30) — NOT NULL
  • TARGET_FIELD — VARCHAR2(30) — NOT NULL
  • MASK_PATTERN — VARCHAR2(50) — NOT NULL
  • APPLY_ROLE_ID — VARCHAR2(20) — 외래 키 → ROLE.ROLE_ID
  • DOWNLOAD_FORCE_YN — CHAR(1) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

MENU

  • MENU_ID — VARCHAR2(20) — 기본 키 — NOT NULL
  • MENU_NAME — VARCHAR2(50) — NOT NULL
  • MENU_PATH — VARCHAR2(200)
  • PARENT_MENU_ID — VARCHAR2(20) — 외래 키 → MENU.MENU_ID
  • SORT_ORDER — NUMBER(4) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

MENU_PERMISSION

  • MENU_PERMISSION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • ROLE_ID — VARCHAR2(20) — 외래 키 → ROLE.ROLE_ID — NOT NULL
  • MENU_ID — VARCHAR2(20) — 외래 키 → MENU.MENU_ID — NOT NULL
  • VISIBLE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

MOCK_DATA_EXECUTION

  • EXECUTION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • DATA_SET_ID — VARCHAR2(20) — 외래 키 → MOCK_DATA_SET.DATA_SET_ID — NOT NULL
  • EXECUTION_TYPE — VARCHAR2(20) — NOT NULL
  • GENERATED_COUNT — NUMBER(9) — NOT NULL
  • EXECUTED_AT — TIMESTAMP — NOT NULL
  • EXECUTED_BY — VARCHAR2(30) — 외래 키 — NOT NULL

MOCK_DATA_SET

  • DATA_SET_ID — VARCHAR2(20) — 기본 키 — NOT NULL
  • DATA_SET_NAME — VARCHAR2(50) — NOT NULL
  • VERSION — VARCHAR2(20) — NOT NULL
  • TARGET_DOMAIN — VARCHAR2(50)
  • DESCRIPTION — VARCHAR2(300)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

PAYMENT

  • PAYMENT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • PROCESS_ID — NUMBER(18) — 외래 키 — NOT NULL
  • PREMIUM — NUMBER(18,2) — NOT NULL
  • METHOD_CODE — VARCHAR2(20) — NOT NULL
  • SCHEDULED_DATE — DATE — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

PAYMENT_FAILURE_REASON

  • REASON_ID — NUMBER(18) — 기본 키 — NOT NULL
  • RESULT_ID — NUMBER(18) — 외래 키 → PAYMENT_RESULT.RESULT_ID — NOT NULL
  • REASON_CODE — VARCHAR2(20) — NOT NULL
  • DETAIL — VARCHAR2(300)

PAYMENT_RESULT

  • RESULT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • PAYMENT_ID — NUMBER(18) — 외래 키 → PAYMENT.PAYMENT_ID — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • PROCESSED_AT — TIMESTAMP — NOT NULL

PERFORMANCE_REPORT

  • REPORT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키
  • BASE_DATE — DATE — NOT NULL
  • PERIOD_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • REPORT_FORMAT_CODE — VARCHAR2(20) — NOT NULL
  • GENERATED_AT — TIMESTAMP — NOT NULL
  • GENERATED_BY — VARCHAR2(30) — 외래 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL

PERFORMANCE_RULE

  • RULE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • METRIC_CODE — VARCHAR2(20) — NOT NULL
  • NUMERATOR_DEFINITION — VARCHAR2(300)
  • DENOMINATOR_DEFINITION — VARCHAR2(300)
  • APPLIED_FROM — DATE — NOT NULL
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

PERMISSION

  • PERMISSION_CODE — VARCHAR2(30) — 기본 키 — NOT NULL
  • PERMISSION_NAME — VARCHAR2(50) — NOT NULL
  • DESCRIPTION — VARCHAR2(200)
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

PREMIUM_QUOTE

  • QUOTE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • PRODUCT_CODE — VARCHAR2(20) — 외래 키 → PRODUCT_MASTER.PRODUCT_CODE — NOT NULL
  • QUOTED_AT — TIMESTAMP — NOT NULL
  • EXPECTED_PREMIUM — NUMBER(18,2)
  • COVERAGE_CONDITION — VARCHAR2(500)
  • QUOTE_CHANNEL_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

PREMIUM_QUOTE_CONDITION

  • CONDITION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • QUOTE_ID — NUMBER(18) — 외래 키 → PREMIUM_QUOTE.QUOTE_ID — NOT NULL
  • AGE_GROUP_CODE — VARCHAR2(20)
  • COVERAGE_AMOUNT — NUMBER(18,2)
  • PAYMENT_PERIOD — NUMBER(3)
  • INSURANCE_PERIOD — NUMBER(3)

PRIORITY_RULE

  • RULE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • QUOTE_WEIGHT — NUMBER(3) — NOT NULL
  • INTEREST_WEIGHT — NUMBER(3) — NOT NULL
  • CHANNEL_WEIGHT — NUMBER(3) — NOT NULL
  • APPLIED_FROM — DATE — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

PRIVACY_CONSENT

  • CONSENT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CUSTOMER_ID — VARCHAR2(30) — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
  • COLLECTION_AGREED_YN — CHAR(1) — NOT NULL
  • USE_AGREED_YN — CHAR(1) — NOT NULL
  • RETENTION_AGREED_YN — CHAR(1) — NOT NULL
  • MARKETING_AGREED_YN — CHAR(1) — NOT NULL
  • CONSENT_AT — TIMESTAMP — NOT NULL
  • CONSENT_CHANNEL_CODE — VARCHAR2(20) — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

PRODUCT_MASTER

  • PRODUCT_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
  • PRODUCT_NAME — VARCHAR2(100) — NOT NULL
  • PRODUCT_GROUP_CODE — VARCHAR2(20) — NOT NULL
  • SALE_STATUS_CODE — VARCHAR2(20) — NOT NULL
  • BASE_PREMIUM — NUMBER(18,2)
  • COVERAGE_DESC — VARCHAR2(1000)
  • ACTIVE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

RECONTACT_TARGET

  • RECONTACT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CHURN_CUSTOMER_ID — NUMBER(18) — 외래 키 → CHURN_CUSTOMER.CHURN_CUSTOMER_ID — NOT NULL
  • REGISTERED_AT — TIMESTAMP — NOT NULL
  • TARGET_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • OPT_OUT_CHECKED_YN — CHAR(1) — NOT NULL
  • PRIORITY_SCORE — NUMBER(6)
  • PRIORITY_RANK — NUMBER(6)
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

RECOVERY_HISTORY

  • RECOVERY_ID — NUMBER(18) — 기본 키 — NOT NULL
  • CHURN_CUSTOMER_ID — NUMBER(18) — 외래 키 → CHURN_CUSTOMER.CHURN_CUSTOMER_ID — NOT NULL
  • PROCESS_ID — NUMBER(18) — 외래 키
  • RECOVERED_AT — TIMESTAMP — NOT NULL
  • TARGET_PROCESS — VARCHAR2(50)
  • NOTE — VARCHAR2(500)

REPORT_FILE

  • FILE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • REPORT_ID — NUMBER(18) — 외래 키 → MANAGEMENT_REPORT.REPORT_ID — NOT NULL
  • FILE_FORMAT_CODE — VARCHAR2(20) — NOT NULL
  • FILE_NAME — VARCHAR2(200) — NOT NULL
  • FILE_LOCATION — VARCHAR2(300) — NOT NULL
  • MASKED_YN — CHAR(1) — NOT NULL
  • DOWNLOAD_COUNT — NUMBER(6) — NOT NULL

RESTORE_EXECUTION

  • RESTORE_ID — NUMBER(18) — 기본 키 — NOT NULL
  • BACKUP_ID — NUMBER(18) — 외래 키 → BACKUP_EXECUTION.BACKUP_ID — NOT NULL
  • RESTORED_AT — TIMESTAMP — NOT NULL
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • EXECUTED_BY — VARCHAR2(30) — 외래 키 — NOT NULL
  • NOTE — VARCHAR2(500)

ROLE

  • ROLE_ID — VARCHAR2(20) — 기본 키 — NOT NULL
  • ROLE_NAME — VARCHAR2(50) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

ROLE_PERMISSION

  • ROLE_PERMISSION_ID — NUMBER(18) — 기본 키 — NOT NULL
  • ROLE_ID — VARCHAR2(20) — 외래 키 → ROLE.ROLE_ID — NOT NULL
  • PERMISSION_CODE — VARCHAR2(30) — 외래 키 → PERMISSION.PERMISSION_CODE — NOT NULL
  • GRANTED_AT — TIMESTAMP — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

STATISTICS_SNAPSHOT

  • SNAPSHOT_ID — NUMBER(18) — 기본 키 — NOT NULL
  • BASE_DATE — DATE — 기본 키 — NOT NULL
  • PERIOD_TYPE_CODE — VARCHAR2(20) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE — NOT NULL
  • COLLECTED_AT — TIMESTAMP — NOT NULL
  • SOURCE_RANGE — VARCHAR2(200)
  • STATUS_CODE — VARCHAR2(20) — NOT NULL
  • TOTAL_CUSTOMER_COUNT — NUMBER(12) — NOT NULL
  • UNIQUE_CUSTOMER_COUNT — NUMBER(12) — NOT NULL
  • CONSULT_REQUEST_COUNT — NUMBER(12) — NOT NULL
  • COMPLETION_COUNT — NUMBER(12) — NOT NULL
  • PREMIUM_TOTAL — NUMBER(18,2) — NOT NULL
  • CANDIDATE_COUNT — NUMBER(12) — NOT NULL
  • CONFIRMED_COUNT — NUMBER(12) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CREATED_BY — VARCHAR2(30) — NOT NULL
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — VARCHAR2(30)

STAT_CHANNEL

  • CHANNEL_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
  • SNAPSHOT_ID — NUMBER(18) — 외래 키 → STATISTICS_SNAPSHOT.SNAPSHOT_ID — NOT NULL
  • INFLOW_COUNT — NUMBER(12) — NOT NULL
  • CONVERSION_COUNT — NUMBER(12) — NOT NULL
  • COMPLETION_COUNT — NUMBER(12) — NOT NULL
  • CHURN_COUNT — NUMBER(12) — NOT NULL

STAT_CHURN_DETAIL

  • DIMENSION_TYPE — VARCHAR2(20) — 기본 키 — NOT NULL
  • DIMENSION_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
  • SNAPSHOT_ID — NUMBER(18) — 외래 키 → STATISTICS_SNAPSHOT.SNAPSHOT_ID — NOT NULL
  • CHURN_COUNT — NUMBER(12) — NOT NULL

STAT_COUNSELOR

  • SNAPSHOT_ID — NUMBER(18) — 외래 키 → STATISTICS_SNAPSHOT.SNAPSHOT_ID — NOT NULL
  • COUNSELOR_ID — VARCHAR2(30) — 외래 키 — NOT NULL
  • CONSULTATION_COUNT — NUMBER(12) — NOT NULL
  • CONTACT_ATTEMPT_COUNT — NUMBER(12) — NOT NULL
  • CONTACT_SUCCESS_COUNT — NUMBER(12) — NOT NULL
  • APPLICATION_CONV_COUNT — NUMBER(12) — NOT NULL
  • COMPLETION_COUNT — NUMBER(12) — NOT NULL
  • PREVENTION_COUNT — NUMBER(12) — NOT NULL

외 11개 테이블