금융 서비스 이탈 가능 고객 예측 현황 시스템
테이블 (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개 테이블