ERD

Tables (176)

ADMIN_PORTAL.FAQ (자주 묻는 질문)

  • FAQ_ID (FAQ ID) — binary(16) — Primary key — NOT NULL
  • CATEGORY_CODE (카테고리 코드) — varchar(50) — NOT NULL — 카테고리 코드
  • EXTERNAL_NUMBER (관리 번호) — int — NOT NULL — 관리번호
  • QUESTION (질문) — varchar(1000) — NOT NULL — 질문
  • ANSWER (답변) — text — NOT NULL — 답변
  • TAG (검색 태그) — varchar(1000) — 검색태그
  • MODIFY_IND (수정 가능 여부) — varchar(10) — 수정가능여부
  • ACTIVE_IND (전시 여부) — varchar(10) — 전시여부
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.FAQ_ATTACHMENTS (FAQ_ATTACHMENTS)

  • FAQ_ATTACHMENTS_ID — binary(16) — Primary key — NOT NULL
  • FAQ_ID (FAQ ID) — binary(16) — Foreign key → ADMIN_PORTAL.FAQ.FAQ_ID — NOT NULL
  • FILE_PATH (파일 위치) — varchar(500) — NOT NULL — 파일위치
  • FILE_NAME (파일 이름) — varchar(100) — 파일이름
  • FILE_SIZE (파일 크기) — int — 파일사이즈
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime

ADMIN_PORTAL.FAQ_CATEGORY (FAQ_CATEGORY)

  • FAQ_CATEGORY_ID — binary(16) — Primary key — NOT NULL
  • CATEGORY_CODE (카테고리 코드) — varchar(50) — NOT NULL — 카테고리 코드
  • CATEGORY_NAME (카테고리 이름) — varchar(100) — NOT NULL — 카테고리 이름
  • CATEGORY_ORDER (카테고리 순서) — int — NOT NULL — 카테고리 순서
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime

ADMIN_PORTAL.FAQ_VIEWS (FAQ_VIEWS)

  • FAQ_VIEWS_ID — binary(16) — Primary key — NOT NULL
  • FAQ_ID (FAQ ID) — binary(16) — Foreign key → ADMIN_PORTAL.FAQ.FAQ_ID — NOT NULL
  • VIEW_COUNT — int — 조회수
  • VIEW_DATE — date — NOT NULL — 조회일자

ADMIN_PORTAL.INDIVIDUAL (INDIVIDUAL)

  • INDIVIDUAL_ID — binary(16) — Primary key — NOT NULL
  • EXTERNAL_NUMBER (관리 번호) — int — NOT NULL — 관리번호
  • TITLE (제목) — varchar(1000) — NOT NULL — 제목
  • REMARK (비고) — varchar(2000) — NOT NULL — 비고
  • CONTENT (내용) — text — NOT NULL — 내용
  • ACTIVE_IND (전시 여부) — varchar(10) — 전시여부
  • MODIFY_IND — varchar(10) — 수정가능여부
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.INSURANCE (INSURANCE)

  • INSURANCE_ID (보험 ID) — binary(16) — Primary key — NOT NULL
  • EXTERNAL_NUMBER (관리 번호) — int — NOT NULL — 관리번호
  • TITLE (제목) — varchar(1000) — NOT NULL — 제목
  • REMARK (비고) — varchar(2000) — NOT NULL — 비고
  • ACTIVE_IND (전시 여부) — varchar(10) — 전시여부
  • MODIFY_IND (수정 가능 여부) — varchar(10) — 수정가능여부
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.INSURANCE_ATTACHMENTS (INSURANCE_ATTACHMENTS)

  • INSURANCE_ATTACHMENTS_ID — binary(16) — Primary key — NOT NULL
  • INSURANCE_ID (보험 ID) — binary(16) — Foreign key → ADMIN_PORTAL.INSURANCE.INSURANCE_ID — NOT NULL
  • FILE_PATH (파일 경로) — varchar(500) — NOT NULL — 파일위치
  • FILE_NAME (파일 이름) — varchar(100) — NOT NULL — 파일이름
  • FILE_SIZE (파일 크기) — int — 파일사이즈
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime

ADMIN_PORTAL.JOB_POSTING (채용 공고)

  • JOB_POSTING_ID (채용 공고 ID) — binary(16) — Primary key — NOT NULL
  • EXTERNAL_NUMBER (관리 번호) — int — NOT NULL — 관리번호
  • JOB_POSITION (채용 구분) — varchar(100) — NOT NULL — 채용구분
  • TITLE (제목) — varchar(100) — NOT NULL — 제목
  • DEPARTMENT (소속) — varchar(100) — NOT NULL — 소속
  • ACTIVE_IND (전시 여부) — varchar(10) — 전시여부
  • MODIFY_IND (수정 가능 여부) — varchar(10) — 수정가능여부
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.JOB_POSTING_CONTENT (JOB_POSTING_CONTENT)

  • JOB_POSTING_CONTENT_ID — binary(16) — Primary key — NOT NULL
  • JOB_POSTING_ID (채용 공고 ID) — binary(16) — Foreign key → ADMIN_PORTAL.JOB_POSTING.JOB_POSTING_ID — NOT NULL
  • CONTENT_ORDER (순서) — int — NOT NULL — 순서
  • TITLE (제목) — varchar(100) — NOT NULL — 제목
  • CONTENT (내용) — text — 내용
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.NOTICE (NOTICE)

  • NOTICE_ID (공지 ID) — binary(16) — Primary key — NOT NULL
  • CATEGORY_CODE (카테고리 코드) — varchar(50) — NOT NULL — 카테고리 코드
  • EXTERNAL_NUMBER (관리 번호) — int — NOT NULL — 관리번호
  • TITLE (제목) — varchar(1000) — NOT NULL — 제목
  • CONTENT (콘텐츠) — text — NOT NULL — 콘텐츠
  • VIEWS (조회 수) — int — 조회수
  • PRIORITY_IND (상단 배치 여부) — varchar(10) — 상단배치여부
  • MODIFY_IND (수정 가능 여부) — varchar(10) — 수정가능여부
  • ACTIVE_IND (전시 여부) — varchar(10) — 전시여부
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.NOTICE_ATTACHMENTS (NOTICE_ATTACHMENTS)

  • NOTICE_ATTACHMENTS_ID — binary(16) — Primary key — NOT NULL
  • NOTICE_ID (공지 ID) — binary(16) — Foreign key → ADMIN_PORTAL.NOTICE.NOTICE_ID — NOT NULL
  • FILE_PATH — varchar(500) — NOT NULL — 파일위치
  • FILE_NAME — varchar(100) — 파일이름
  • FILE_SIZE — int — 파일사이즈
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime

ADMIN_PORTAL.NOTICE_CATEGORY (NOTICE_CATEGORY)

  • NOTICE_CATEGORY_ID — binary(16) — Primary key — NOT NULL
  • CATEGORY_CODE — varchar(50) — NOT NULL — 카테고리 코드
  • CATEGORY_NAME — varchar(100) — NOT NULL — 카테고리 이름
  • CATEGORY_ORDER — int — NOT NULL — 카테고리 순서
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime

ADMIN_PORTAL.POPUP_IMAGE_ATTACHMENTS (POPUP_IMAGE_ATTACHMENTS)

  • POPUP_IMAGE_ATTACHMENTS_ID — binary(16) — Primary key — NOT NULL
  • POPUP_IMAGE_ID — binary(16) — NOT NULL — POPUP_IMAGE ID
  • IMAGE_TYPE — varchar(10) — 팝업타입 P: "PC", M: "Mobile"
  • FILE_PATH — varchar(500) — NOT NULL — 파일위치
  • FILE_NAME — varchar(100) — NOT NULL — 파일이름
  • FILE_SIZE — int — 파일사이즈
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime

ADMIN_PORTAL.POPUP_TEXT (POPUP_TEXT)

  • POPUP_TEXT_ID — binary(16) — Primary key — NOT NULL
  • CATEGORY_CODE — varchar(50) — NOT NULL — 카테고리 코드
  • EXTERNAL_NUMBER — int — NOT NULL — 관리번호
  • TITLE — varchar(1000) — NOT NULL — 제목
  • CONTENT — text — NOT NULL — 콘텐츠
  • PUBLICATION_START_DATE — datetime — NOT NULL — 게재시작일
  • PUBLICATION_END_DATE — datetime — NOT NULL — 게재종료일
  • LINK_TYPE — varchar(10) — _: 사용안함, N: 공지사항, U: URL
  • LINK_CONTENT — varchar(100) — LINK
  • APP_PUBLICATION_TYPE — varchar(10) — APP 게재범위 "Y": 전체, "A": Android, "I": iOS, "N": 오픈 안함
  • APP_DEEP_LINK — varchar(100) — APP DEEP LINK
  • PRIORITY_IND — varchar(10) — 우선출력여부
  • ACTIVE_IND — varchar(10) — 전시여부
  • MODIFY_IND — varchar(10) — 수정가능여부
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.POPUP_TEXT_CATEGORY (POPUP_TEXT_CATEGORY)

  • POPUP_TEXT_CATEGORY_ID — binary(16) — Primary key — NOT NULL
  • CATEGORY_CODE — varchar(50) — NOT NULL — 카테고리 코드
  • CATEGORY_NAME — varchar(100) — NOT NULL — 카테고리 이름
  • CATEGORY_ORDER — int — NOT NULL — 카테고리 순서
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime

ADMIN_PORTAL.PRIVACY (PRIVACY)

  • PRIVACY_ID — binary(16) — Primary key — NOT NULL
  • EXTERNAL_NUMBER — int — NOT NULL — 관리번호
  • TITLE — varchar(1000) — NOT NULL — 제목
  • CONTENT — text — NOT NULL — 내용
  • ACTIVE_IND — varchar(10) — 전시여부
  • MODIFY_IND — varchar(10) — 수정가능여부
  • STATUS_IND — varchar(10) — NOT NULL — 상태 C: 현행 시행, P: 이전
  • EFFECTIVE_DATE — date — NOT NULL — 시행일자
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.PRODUCT (PRODUCT)

  • PRODUCT_ID — binary(16) — Primary key — NOT NULL
  • CLIENT_OFFER_ID (CLIENT_OFFER_ID2) — binary(16) — Foreign key — NOT NULL
  • EXTERNAL_NUMBER — int — NOT NULL — 관리번호
  • REGISTRATION_IND — varchar(10) — 가입가능 여부
  • MODIFY_IND — varchar(10) — 수정가능여부
  • ACTIVE_IND — varchar(10) — 전시여부
  • ACTIVE_ORDER — int — 전시 순서
  • PRODUCT_URL — varchar(100) — 상품 URL
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ADMIN_PORTAL.PRODUCT_INFORMATION (PRODUCT_INFORMATION)

  • PRODUCT_INFORMATION_ID — binary(16) — Primary key — NOT NULL
  • PRODUCT_ID (PRODUCT_ID2) — binary(16) — Foreign key → ADMIN_PORTAL.PRODUCT.PRODUCT_ID — NOT NULL
  • INFORMATION_TYPE — varchar(20) — NOT NULL — PRODUCT: 상품, REGISTRATION: 가입, COMPENSATION: 보상, OTHER: 기타
  • INFORMATION — text — 안내 문구
  • INFORMATION_URL — varchar(100) — 안내 문구 URL
  • CREATED_BY — varchar(100) — NOT NULL
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(100)
  • UPDATED_DATE — datetime

ASSET.AGREEMENT (가입자 정보)

  • AGREEMENT_ID (가입자 ID) — binary(16) — Primary key — NOT NULL
  • REPLACED_AGREEMENT_ID — binary(16)
  • AGREEMENT_STATUS_CODE (가입자 상태 코드) — varchar(40) — Foreign key → ASSET.AGREEMENT_STATUS.AGREEMENT_STATUS_CODE — NOT NULL
  • CLIENT_ACCOUNT_ID (고객사 계정 ID) — binary(16) — Foreign key → CLIENT.CLIENT_ACCOUNT.CLIENT_ACCOUNT_ID — NOT NULL
  • CLIENT_OFFER_ID — binary(16) — Foreign key — NOT NULL
  • AGREEMENT_NBR — binary(16) — NOT NULL
  • AGREEMENT_START_DATE — datetime
  • AGREEMENT_END_DATE — datetime
  • TERMINATION_DATE — datetime
  • AGREEMENT_TERMINATION_RSN_CD — varchar(40)
  • SUBSCRIPTION_NBR — int
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • ADDRESS_ID — binary(16)
  • CLIENT_PRODUCT_SKU_NBR — varchar(40)
  • CONTACT_POINT_ID — binary(16)
  • ACTIVE_IND — varchar(10)
  • CUSTOMER_VERIFIED_ADDRESS_ID — binary(16)
  • EXTERNAL_REFERENCE_ID — varchar(500)
  • AGREEMENT_STATUS_REASON_CODE — varchar(40)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • KEYSPEC — varchar(500)
  • IS_RECONTRACTED — varchar(10)
  • RECONTRACT_DATE — datetime
  • CURRENT_PROGRAM_END_DATE — date
  • CURRENT_PROGRAM_CODE — varchar(50)
  • OLD_PROGRAM_CODE — varchar(50)
  • OLD_PROGRAM_END_DATE — date
  • NEW_PROGRAM_EFFECTIVE_DATE — date
  • AGREEMENT_TYPE — varchar(50)
  • SUSPEND_DATE — datetime
  • RESUME_DATE — datetime
  • PREVIOUS_AGREEMENT_NBR — binary(16)
  • ONE_TIME_COLLECTION — varchar(40)
  • INSURANCE_COMPANY_CODE — varchar(10)
  • VIP_IND — varchar(10)
  • UPGRADE_FLAG — varchar(10)
  • PRODUCT_TYPE — varchar(50)
  • ORDER_TYPE — varchar(50)
  • OLD_CLIENT_OFFER_ID — binary(16)
  • SERVICE_MANAGEMENT_NUMBER — varchar(20)
  • IS_MASKED — varchar(1)
  • CLAIM_LIMIT — int
  • IS_PURGED — varchar(1) — NOT NULL
  • SECOND_DEVICE_SERVICE_MANAGEMENT_NUMBER — varchar(20)
  • CONTRACT_PRODUCT_ID — binary(16)

ASSET.AGREEMENT_PURCHASE (가입자 구매 정보)

  • AGREEMENT_PURCHASE_ID (가입자 구매 ID) — binary(16) — Primary key — NOT NULL
  • AGREEMENT_ID (가입자 ID) — binary(16) — Foreign key → ASSET.AGREEMENT.AGREEMENT_ID — NOT NULL
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • CURRENCY_CODE (화폐 코드) — varchar(40)
  • CLIENT_STORE_ID — varchar(10)
  • RETAIL_NAME — varchar(100)
  • RETAIL_SKU — varchar(100)
  • TRADE_ITEM_NBR — varchar(40)
  • PURCHASE_DATE — datetime
  • PURCHASE_PRICE — decimal(15, 2)
  • TAX_AMOUNT — decimal(15, 2)
  • TOTAL_AMOUNT — decimal(15, 2)
  • SALES_PERSON_NAME — varchar(100)
  • TERMINATION_CLIENT_STORE_ID — varchar(10)
  • TERMINATION_SALES_PERSON_NAME — varchar(100)
  • PURCHASE_TRANSACTION_NBR — varchar(40)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • REGION_CODE — varchar(40)
  • ACTIVE_IND — varchar(10)
  • STORE_CODE — varchar(200)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • KEYSPEC — varchar(500)
  • TIER_ID — int
  • INSURANCE_SEQUENCE_NUMBER — varchar(50)
  • EQP_INSU_CNT — varchar(10)
  • UNPAID_PREMIUM_AMOUNT — decimal(15, 2)

ASSET.AGREEMENT_STATUS (가입자 상태)

  • AGREEMENT_STATUS_CODE (가입자 상태 코드) — varchar(40) — Primary key — NOT NULL
  • AGREEMENT_STATUS_NAME (가입자 상태명) — varchar(100)
  • AGREEMENT_STATUS_DESC — varchar(500)
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

ASSET.ASSET (단말 고유 정보(MDN, 시리얼번호, IMEI 등))

  • ASSET_ID — binary(16) — Primary key — NOT NULL
  • ASSET_STATUS_CODE — varchar(40) — Foreign key → ASSET.ASSET_STATUS.ASSET_STATUS_CODE — NOT NULL
  • CLIENT_ACCOUNT_ID (고객사 계정 ID) — binary(16) — Foreign key → CLIENT.CLIENT_ACCOUNT.CLIENT_ACCOUNT_ID — NOT NULL
  • PARENT_ASSET_ID — binary(16)
  • ASSET_CONDITION_CODE — varchar(40)
  • ASSET_CATALOG_ID (단말기 ID) — binary(16) — Foreign key → ASSET.ASSET_CATALOG.ASSET_CATALOG_ID — NOT NULL
  • PERSONALIZED_NAME — varchar(100)
  • ASSET_START_DATE — datetime
  • ASSET_END_DATE — datetime
  • SERIAL_NBR — varchar(40)
  • SUBSCRIPTION_NBR — varchar(40)
  • MOBILE_EQUIPMENT_ID — varchar(40)
  • MOBILE_DEVICE_NBR — varchar(255)
  • RECEIVED_DATE — datetime
  • REPLACEMENT_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • CLIENT_ASSET_SKU_NBR — varchar(100)
  • REPLACED_ASSET_ID — binary(16)
  • ASSET_INSTANCE_CODE — varchar(40)
  • REFERENCE_ASSET_ID — binary(16)
  • OWNER_ID — binary(16)
  • COUNTRY_CALLING_CODE — varchar(40)
  • EXTERNAL_REFERENCE_ID — varchar(40)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • ASSET_STATUS_REASON_CODE — varchar(100)
  • KEYSPEC — varchar(500)
  • SECOND_REPLACEMENT_FLAG — varchar(1)
  • SKT_IMEI_NUM — varchar(500)
  • EQUIPMENT_ACTIVATION_DATE — datetime
  • REPLACEMENT_AGENT_CODE — varchar(100)
  • REPLACEMENT_AGENT_NAME — varchar(200)
  • SECOND_DEVICE_CLIENT_ASSET_SKU_NBR — varchar(100)
  • SECOND_DEVICE_SERIAL_NBR — varchar(40)
  • SECOND_DEVICE_REGISTERED_DATE — varchar(40)
  • SECOND_DEVICE_CREATED_DATE — datetime
  • SECOND_DEVICE_ASSET_CATALOG_ID — binary(16)

ASSET.ASSET_CATALOG (단말기 마스터)

  • ASSET_CATALOG_ID (단말기 ID) — binary(16) — Primary key — NOT NULL
  • ASSET_MODEL_ID (단말기 모델 ID) — binary(16) — Foreign key → ASSET.ASSET_MODEL.ASSET_MODEL_ID — NOT NULL
  • ASSET_COLOR_ID (단말기 색상 ID) — binary(16)
  • ASSET_CATALOG_NAME (단말기명) — varchar(100)
  • ASSET_CATALOG_DESC — varchar(500)
  • ASSET_CATALOG_START_DATE — datetime
  • ASSET_CATALOG_END_DATE — datetime
  • REFURBISHED_IND — varchar(10)
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • PRIVATE_LABEL — varchar(50)
  • BOM_IND — varchar(10)
  • ASSET_MAKE_ID (단말기 제조사 ID) — binary(16) — Foreign key → ASSET.ASSET_MAKE.ASSET_MAKE_ID — NOT NULL
  • CREATED_SYSTEM_ID — int
  • ASSET_ITEM_ID — binary(16)
  • MARKET_ID — int

ASSET.ASSET_CONDITION (ASSET_CONDITION)

  • ASSET_CONDITION_CODE — varchar(40) — Primary key — NOT NULL
  • ASSET_CONDITION_NAME — varchar(100)
  • ASSET_CONDITION_DESC — varchar(500)
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

ASSET.ASSET_CTLG_CLNT_CHNL_AST_XREF (ASSET_CATALOG와 CLIENT_CHANNEL_ASSET 매핑정보)

  • AST_CTLG_CLNT_CHNL_AST_XREF_ID — binary(16) — Primary key — NOT NULL
  • CLIENT_CHANNEL_ASSET_ID — binary(16) — Foreign key → ASSET.CLIENT_CHANNEL_ASSET.CLIENT_CHANNEL_ASSET_ID — NOT NULL
  • ASSET_CATALOG_ID (단말기 ID) — binary(16) — Foreign key → ASSET.ASSET_CATALOG.ASSET_CATALOG_ID — NOT NULL
  • EFFECTIVE_START_DATE — datetime
  • EFFECTIVE_END_DATE — datetime
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

ASSET.ASSET_INSTANCE (ASSET_INSTANCE)

  • ASSET_INSTANCE_CODE — varchar(40) — Primary key — NOT NULL
  • ASSET_INSTANCE_NAME — varchar(100)
  • ASSET_INSTANCE_DESC — varchar(500)
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

ASSET.ASSET_ITEM_ID (단말기 아이템)

  • ASSET_ITEM_ID (단말기 아이템 ID) — binary(16) — NOT NULL
  • ITEM_ID (아이템 ID) — varchar(100)
  • ASSET_ITEM_ID_DESC — varchar(500)
  • ASSET_ITEM_ID_START_DATE — datetime
  • ASSET_ITEM_ID_END_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int
  • MARKET_ID — int

ASSET.ASSET_MAKE (단말기 제조사)

  • ASSET_MAKE_ID (단말기 제조사 ID) — binary(16) — Primary key — NOT NULL
  • ASSET_MAKE_NAME (단말기 제조사명) — varchar(100)
  • ASSET_MAKE_DESC — varchar(500)
  • ASSET_MAKE_START_DATE — datetime
  • ASSET_MAKE_END_DATE — datetime
  • PRIVATE_LABEL — varchar(50)
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

ASSET.ASSET_MODEL (단말기 모델)

  • ASSET_MODEL_ID (단말기 모델 ID) — binary(16) — Primary key — NOT NULL
  • ASSET_TYPE_ID (단말기 유형 ID) — binary(16) — Foreign key → ASSET.ASSET_TYPE.ASSET_TYPE_ID — NOT NULL
  • ASSET_MAKE_ID (단말기 제조사 ID) — binary(16) — Foreign key → ASSET.ASSET_MAKE.ASSET_MAKE_ID — NOT NULL
  • ASSET_MODEL_NBR (단말기 모델 번호) — varchar(40)
  • ASSET_MODEL_START_DATE — datetime
  • ASSET_MODEL_END_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int
  • FAMILY — varchar(200)
  • CAPACITY — varchar(100)
  • COLOR — varchar(100)
  • IS_REPAIRABLE — varchar(10)
  • FULFILLMENT_GROUP_ID — varchar(30)
  • ESIM — varchar(10)

ASSET.ASSET_MODEL_MAPPING (ASSET_MODEL_MAPPING)

  • ASSET_MODEL_MAPPING_ID — binary(16) — Primary key — NOT NULL
  • MODEL_CODE (SKT 모델 코드) — varchar(5) — SKT 모델코드
  • MODEL_NAME (SKT 모델명) — varchar(80) — SKT 모델명
  • MODEL_TYPE (모델타입(01: 유통단말, 02: 비유통단말)) — varchar(2) — 모델타입(01: 유통단말, 02: 비유통단말)
  • PET_NAME (단말기 펫 이름) — varchar(200) — 단말기 팻네임
  • COLOR_CODE (색상 코드) — varchar(2) — 색상코드
  • COLOR_NAME (색상명) — varchar(80) — 색상이름
  • BASE_MODEL_CODE (대표 단말 코드) — varchar(5) — 대표단말코드
  • BASE_MODEL_NAME (대표 단말명) — varchar(80) — 대표단말이름
  • PRICE (출고가) — decimal(10, 2) — 출고가
  • RENEW_PRICE (리뉴폰 출고가) — decimal(10, 2) — 리뉴폰 출고가

ASSET.ASSET_PURCHASE (단말기 구매 정보)

  • ASSET_PURCHASE_ID — binary(16) — Primary key — NOT NULL
  • ASSET_ID (ASSET_ID2) — binary(16) — Foreign key → ASSET.ASSET.ASSET_ID — NOT NULL
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • CLIENT_STORE_ID — binary(16)
  • CURRENCY_CODE — varchar(40)
  • RETAIL_MAKE — varchar(50)
  • RETAIL_MODEL_NBR — varchar(40)
  • RETAIL_ASSET_COLOR — varchar(50)
  • RETAIL_NAME — varchar(100)
  • RETAIL_SKU — varchar(100)
  • TRADE_ITEM_NBR — varchar(40)
  • PURCHASE_DATE — datetime — 개통일
  • PURCHASE_PRICE — decimal(15, 2)
  • TAX_AMOUNT — decimal(15, 2)
  • TOTAL_AMOUNT — decimal(15, 2)
  • SALES_PERSON_NAME — varchar(100)
  • PURCHASE_TRANSACTION_NBR — varchar(40)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • REGION_CODE — varchar(40)
  • ACTIVE_IND — varchar(10)
  • STORE_CODE — varchar(200)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • KEYSPEC — varchar(500)
  • SIM_TYPE — varchar(50)
  • SIM_HLR — varchar(50)

ASSET.ASSET_STATUS (ASSET_STATUS)

  • ASSET_STATUS_CODE — varchar(40) — Primary key — NOT NULL
  • ASSET_STATUS_NAME — varchar(100)
  • ASSET_STATUS_DESC — varchar(500)
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

ASSET.ASSET_TYPE (ASSET_TYPE)

  • ASSET_TYPE_ID (단말기 유형 ID) — binary(16) — Primary key — NOT NULL
  • ASSET_CATEGORY_ID — binary(16)
  • ASSET_TYPE_NAME — varchar(100)
  • ASSET_TYPE_DESC — varchar(500)
  • ASSET_TYPE_START_DATE — datetime
  • ASSET_TYPE_END_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

ASSET.CLIENT_CHANNEL_ASSET (닥스 동기화 단말기 정보)

  • CLIENT_CHANNEL_ASSET_ID — binary(16) — Primary key — NOT NULL
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • CLIENT_ASSET_SKU_NAME — varchar(100)
  • CLIENT_ASSET_SKU_NBR — varchar(40)
  • CLIENT_ASSET_MAKE — varchar(100)
  • CLIENT_ASSET_MODEL — varchar(40)
  • SKU_START_DATE — datetime
  • SKU_END_DATE — datetime
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • BASE_ITEM_IND — varchar(10)
  • ACTIVE_IND — varchar(10)
  • MARKET_ID — int

ASSET.ENROLLMENT_SOLUTO (ENROLLMENT_SOLUTO)

  • ENROLLMENT_SOLUTO_ID — int — Primary key
  • MESSAGE_ID — varchar(100)
  • ENROLLMENT_START_DATE — datetime
  • ENROLLMENT_END_DATE — datetime
  • SERVICE_MANAGEMENT_NUMBER — varchar(50)
  • PRODUCT_SKU_NBR — varchar(50)
  • MOBILE_DEVICE_NBR — varchar(1000)
  • MIN — varchar(50)
  • INSURANCENUMBER — varchar(50)
  • MODEL_CODE — varchar(50)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(1)
  • SUBSCRIPTION_NBR — binary(16)
  • IS_SOLUTO_CONNECT — varchar(1)
  • ENROLLED_PHON_SERIAL_NUMBER — varchar(50)
  • MARKETING_DIVISION_NAME — varchar(80)
  • STORE_NAME — varchar(80)
  • STORE_ID — varchar(10)
  • SOURCE_FLAG — varchar(50)
  • APP_REMINDER_SMS_SENT — varchar(10)
  • APP_DOWNLOAD_DATE — datetime
  • APP_SMS_SENT_DATE — datetime

ASSET.FAMILY_PLAN_AGREEMENT_MAPPING (FAMILY_PLAN_AGREEMENT_MAPPING)

  • FAMILY_PLAN_AGREEMENT_MAPPING_ID — binary(16) — Primary key — NOT NULL
  • HOST_AGREEMENT_ID — binary(16)
  • AGREEMENT_ID (가입자 ID) — binary(16) — Foreign key → ASSET.AGREEMENT.AGREEMENT_ID — NOT NULL
  • STATUS — varchar(40) — NOT NULL
  • FAMILY_START_DATE — datetime — NOT NULL
  • FAMILY_END_DATE — datetime
  • TERMINATION_DATE — datetime
  • ACTIVE_IND — varchar(2)
  • CREATED_BY — varchar(255) — NOT NULL
  • CREATED_DATE — datetime — NOT NULL
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime

ASSET.SOLUTO_APP_DOWNLOAD_TRACKING (SOLUTO_APP_DOWNLOAD_TRACKING)

  • SOLUTO_APP_DOWNLOAD_TRACKING_Id — int — Primary key
  • MDN — varchar(15)

CHAT_ENGINE.CHAT_CHAT_ENGINE.USER_ACTIVITY (CE.CHAT_USER_ACTIVITY)

  • ACTIVITY_ID — binary(16) — Primary key — NOT NULL
  • USER_EMAIL — varchar(256) — NOT NULL
  • ACTIVITY_NAME — varchar(100)
  • ENGAGEMENT_ID — varchar(36) — Foreign key — NOT NULL
  • ACTIVITY_TYPE — varchar(100)
  • ACTIVITY_TIMESTAMP — varchar(100)
  • DURATION — varchar(100)
  • CREATED_BY — varchar(100)
  • CREATED_DATE — datetime
  • MODIFIED_BY — varchar(100)
  • MODIFIED_DATE — datetime
  • ACTIVE_IND — char

CHAT_ENGINE.CHAT_ENGAGEMENT_MASTER (CE.CHAT_ENGAGEMENT_MASTER)

  • ENGAGEMENT_ID — binary(16) — Primary key — NOT NULL
  • PARENT_ENGAGEMENT_ID — binary(16) — NOT NULL
  • USER_EMAIL — varchar(256)
  • CHANNEL_ID — binary(16) — NOT NULL
  • MOBILE_DEVICE_NBR — varchar(255)
  • START_TIME — datetime
  • END_TIME — datetime
  • DURATION — decimal(10, 2)
  • CSAT_RATING — decimal(10, 2)
  • STATUS — char(100)
  • WRAP_UP_CODE — varchar(100)
  • AVG_RESPONSE_TIME — decimal(10, 2)
  • VIOLATION_CNT — int
  • CLAIM_NUMBER — varchar(100)
  • CASE_NUMBER — varchar(100)
  • ENGAGEMENT_TYPE — varchar(100) — NOT NULL
  • STORE_CODE — varchar(100)
  • CARRIER — varchar(100)
  • SPEED_TO_ANSWER — decimal(10, 2)
  • REQUEST_TYPE — varchar(100)
  • SUBSCRIPTION_NO — varchar(100)
  • CREATED_BY — varchar(100)
  • CREATED_DATE — datetime
  • MODIFIED_BY — varchar(100)
  • MODIFIED_DATE — datetime
  • ACTIVE_IND — char
  • ARN — varchar(100)
  • OS_TYPE — varchar(45)
  • DEVICE_ID — varchar(256)
  • CHAT_REASON — varchar(100)
  • INTERACTION_ID — binary(16)
  • LANGUAGE_CODE — varchar(45)
  • SKILL_ID — varchar(100)
  • VISITOR_ID — binary(16)
  • VISITOR_NAME — varchar(1000)
  • TASK_ID — varchar(200)
  • CHAT_WAIT_TIME — decimal(10, 2)
  • REQUEST_CHANNEL — varchar(100)
  • CHAT_ACCEPT_TIME_STAMP — datetime
  • USER_AGENT — varchar(500)
  • AVERAGE_USER_RESPONSE_TIME — decimal(10, 2)
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • CUSTOMER_TYPE — varchar(100)
  • CUSTOMER_NAME — varchar(1000)
  • CUSTOMER_ENROLLED_FLAG — varchar(100)
  • T_SID — varchar(200)
  • TASK_QUEUE_NAME — varchar(200)
  • TASK_QUEUE_SID — varchar(200)
  • APP_IDENTIFER — varchar(100)
  • EXPERT_NAME — varchar(256)
  • ENGAGEMENT_ABANDONED_TIME — datetime
  • TRANSFERRED_FROM — varchar(100)
  • TRANSFERRED_TO — varchar(100)
  • TRANSFER_TYPE — varchar(100)
  • ACW_START_TIME — datetime
  • ACW_DURATION — decimal(10, 2)
  • ACW_END_TIME — datetime
  • ENGAGEMENT_DIRECTION — varchar(100) — NOT NULL
  • ENGAGEMENT_COST — decimal(10, 2)
  • START_QUEUE_TIME — datetime
  • … +1

CHAT_ENGINE.CHAT_ENGINE.ONLINE_GENERAL_INQUIRY (CE.ONLINE_GENERAL_INQUIRY)

  • GENERAL_INQUIRY_ID — binary(16) — Primary key — NOT NULL
  • CARRIER — varchar(45)
  • COUNTRY — varchar(45)
  • LANGUAGE — varchar(45)
  • ORIGINAL_QUESTION — varchar(500)
  • INQUIRY_DATE — datetime
  • TRANSLATED_QUESTION — varchar(500)
  • INTENT — varchar(100)
  • CREATED_BY — varchar(45)
  • CREATED_DATE — datetime

CHAT_ENGINE.CHAT_FEATURE_MASTER (CHAT_FEATURE_MASTER)

  • FEATURE_ID — binary(16) — Primary key — NOT NULL
  • FEATURE_NAME — varchar(100)
  • FEATURE_START_DATE — datetime
  • FEATURE_END_DATE — datetime
  • CREATED_BY_SYSTEM — varchar(100)
  • CREATED_BY — varchar(100)
  • CREATED_DATE — datetime
  • MODIFIED_BY — varchar(100)
  • MODIFIED_DATE — datetime
  • ACTIVE_IND — char

CHAT_ENGINE.CHAT_ROLE (CHAT_ROLE)

  • ROLE_ID — binary(16) — Primary key — NOT NULL
  • NAME — varchar(255) — NOT NULL
  • DESCRIPTION — varchar(1000)
  • ROLE_CODE — varchar(40)
  • CREATED_BY — varchar(255) — NOT NULL
  • CREATED_DATE — datetime — NOT NULL
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10) — NOT NULL
  • ROLE_NBR — int(18) — NOT NULL

CHAT_ENGINE.CHAT_ROLE_FEATURE_XREF (CHAT_ROLE_FEATURE_XREF)

  • ROLE_FEATURE_XREF_ID — binary(16) — Primary key — NOT NULL
  • ROLE_ID (ROLE_ID2) — binary(16) — Foreign key → CHAT_ENGINE.CHAT_ROLE.ROLE_ID — NOT NULL
  • FEATURE_ID (FEATURE_ID2) — binary(16) — Foreign key → CHAT_ENGINE.CHAT_FEATURE_MASTER.FEATURE_ID — NOT NULL
  • CREATED_BY — varchar(255) — NOT NULL
  • CREATED_DATE — datetime — NOT NULL
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10) — NOT NULL

CHAT_ENGINE.CHAT_SKILL_MASTER (CHAT_SKILL_MASTER)

  • SKILL_ID — binary(16) — Primary key — NOT NULL
  • SKILL_NAME — varchar(100)
  • SKILL_TYPE_CODE — varchar(100)
  • CLIENT_ID — binary(16) — NOT NULL
  • CREATED_BY — varchar(100)
  • CREATED_DATE — datetime
  • MODIFIED_BY — varchar(100)
  • MODIFIED_DATE — datetime
  • ACTIVE_IND — char

CHAT_ENGINE.CHAT_USER (CHAT_USER)

  • USER_ID — binary(16) — Primary key — NOT NULL
  • LOGIN_ID — varchar(255) — NOT NULL
  • NAME — varchar(500) — NOT NULL
  • NAME_TL — varchar(500)
  • CTI_ID — varchar(100)
  • DIAL_NBR — varchar(100)
  • LAST_LOGIN — varchar(255) — NOT NULL
  • CREATED_BY — varchar(255) — NOT NULL
  • CREATED_DATE — datetime — NOT NULL
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10) — NOT NULL
  • EMAIL_ADDRESS — varchar(256)
  • USER_NBR — int(18) — NOT NULL
  • INSURANCE_COMPANY_CODE — varchar(100)
  • ADMIN_USER_IP — varchar(45)
  • IS_PURGED — varchar(10)
  • TWILIO_USER_ID — varchar(100)
  • REPORTING_AUTH_USER_ID — varchar(100)
  • LANGUAGES — varchar(40)

CHAT_ENGINE.CHAT_USER_CLIENT (CHAT_USER_CLIENT)

  • USER_CLIENT_ID — binary(16) — Primary key — NOT NULL
  • CLIENT_ID (고객사 ID) — binary(16) — Foreign key → CLIENT.CLIENT.CLIENT_ID — NOT NULL
  • USER_EMAIL — varchar(256) — NOT NULL
  • CREATED_BY — varchar(100)
  • CREATED_DATE — datetime
  • MODIFIED_BY — varchar(100)
  • MODIFIED_DATE — datetime
  • ACTIVE_IND — char

CHAT_ENGINE.CHAT_USER_ROLE_XREF (CE.CHAT_USER_ROLE_XREF)

  • USER_ROLE_XREF_ID — binary(16) — Primary key — NOT NULL
  • USER_ID (USER_ID2) — binary(16) — Foreign key → CHAT_ENGINE.CHAT_USER.USER_ID — NOT NULL
  • ROLE_ID (ROLE_ID2) — binary(16) — Foreign key → CHAT_ENGINE.CHAT_ROLE.ROLE_ID — NOT NULL
  • CREATED_BY — varchar(255) — NOT NULL
  • CREATED_DATE — datetime — NOT NULL
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10) — NOT NULL

CHAT_ENGINE.CHAT_USER_SKILLS (CE.CHAT_USER_SKILLS)

  • USER_SKILL_ID — binary(16) — Primary key — NOT NULL
  • USER_EMAIL — varchar(256) — NOT NULL
  • SKILL_ID (SKILL_ID2) — binary(16) — Foreign key → CHAT_ENGINE.CHAT_SKILL_MASTER.SKILL_ID — NOT NULL
  • CREATED_BY — varchar(100)
  • CREATED_DATE — datetime
  • MODIFIED_BY — varchar(100)
  • MODIFIED_DATE — datetime
  • ACTIVE_IND — char

CLIENT.CLIENT (고객사 마스터)

  • CLIENT_ID (고객사 ID) — binary(16) — Primary key — NOT NULL
  • CLIENT_NBR (고객사 번호) — int
  • NAME (고객사명) — varchar(20) — NOT NULL
  • CLIENT_START_DATE — datetime
  • CLIENT_END_DATE — datetime
  • EXTERNAL_REFERENCE_ID — varchar(40)
  • MIGRATED_IND — varchar(10)
  • ACTIVE_IND — varchar(3)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255) — NOT NULL
  • CREATED_DATE — datetime — NOT NULL
  • UPDATED_BY — varchar(255) — NOT NULL
  • UPDATED_DATE — datetime — NOT NULL
  • LOAD_DATE — datetime — NOT NULL
  • ADDRESS_ID — binary(16)

CLIENT.CLIENT_ACCOUNT (고객사에서 수신되는 고객 계정)

  • CLIENT_ACCOUNT_ID (고객사 계정 ID) — binary(16) — Primary key — NOT NULL
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • CLIENT_ACCOUNT_STATUS_CODE (고객사 계정 상태 코드) — varchar(40)
  • CLIENT_ACCOUNT_NBR (고객 사계정 번호) — varchar(256)
  • CLIENT_ACCOUNT_START_DATE — datetime
  • CLIENT_ACCOUNT_END_DATE — datetime
  • EXTERNAL_REFERENCE_ID — varchar(30)
  • EXTERNAL_REFERENCE_NUMBER — varchar(50)
  • ACTIVE_IND — varchar(10)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • CLIENT_ACCOUNT_TYPE_CODE — varchar(40)
  • CLIENT_ACCOUNT_BILLING_STS_CD — varchar(40)
  • CLIENT_ACCOUNT_BILLING_CYCLE — varchar(100)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • KEYSPEC — varchar(500)
  • CLIENT_FACING_UNIT — varchar(50)

CLIENT.CLIENT_ACCOUNT_ROLE (고객사에서 수신되는 고객 계정 규칙)

  • CLIENT_ACCOUNT_ROLE_ID (고객사 계정 규칙 ID) — binary(16) — Primary key — NOT NULL
  • CLIENT_ACCOUNT_ROLE_TYPE_CODE (고객사 계정 규칙 타입 코드) — varchar(40)
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • CLIENT_ACCOUNT_ID (고객사 계정 ID) — binary(16) — Foreign key → CLIENT.CLIENT_ACCOUNT.CLIENT_ACCOUNT_ID — NOT NULL
  • ROLE_START_DATE — datetime
  • ROLE_END_DATE — datetime
  • CREATED_SYSTEM_ID — int
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime

CLIENT.CLIENT_CHANNEL (고객사 채널)

  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Primary key — NOT NULL
  • CLIENT_ID (고객사 ID) — binary(16) — Foreign key → CLIENT.CLIENT.CLIENT_ID — NOT NULL
  • CLIENT_CHANNEL_NBR (고객사 채널 번호) — binary(16)
  • NAME (고객사 채널명) — varchar(30)
  • CLIENT_CHANNEL_START_DATE — datetime
  • CLIENT_CHANNEL_END_DATE — datetime
  • EXTERNAL_REFERENCE_ID — varchar(40)
  • MIGRATED_IND — varchar(20)
  • ACTIVE_IND — varchar(10)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • ADDRESS_ID — binary(16)
  • TIME_ZONE — varchar(250)

CUSTOMER.ACTIVITY (에이전트 Audit)

  • ACTIVITY_ID — binary(16) — Primary key — NOT NULL
  • ACTIVITY_TYPE_CODE — varchar(40)
  • ACTIVITY_RESULT_CODE — varchar(40)
  • ACTIVITY_RESPONSE_TYPE_CODE — varchar(40)
  • SUB_ACTIVITY_TYPE_CODE — varchar(40)
  • REQUEST_TIME — datetime
  • RESPONSE_TIME — datetime
  • PROCESS_START_TIME — datetime
  • PROCESS_END_TIME — datetime
  • ACTIVITY_DETAIL_TEXT — varchar(100)
  • REQUESTED_BY — varchar(255)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • INTERACTION_LINE_ID — binary(16)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime

CUSTOMER.ACTIVITY_TYPE (ACTIVITY_TYPE_CODE)

  • ACTIVITY_TYPE_CODE — varchar(40) — Primary key
  • ACTIVITY_TYPE_NAME — varchar(100)
  • ACTIVITY_TYPE_NAME_TL — varchar(100)
  • ACTIVITY_TYPE_DESC — varchar(500)
  • ACTIVITY_TYPE_DESC_TL — varchar(500)
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int

CUSTOMER.ANNOUNCEMENT (ANNOUNCEMENT)

  • ANNOUNCEMENT_ID — binary(16) — Primary key — NOT NULL
  • ANNOUNCEMENT_TYPE_CODE — varchar(100) — NOT NULL
  • TITLE — varchar(1000)
  • CONTENTS — mediumtext
  • HIT — int
  • FILE_PATH — varchar(2000)
  • FILE_NAME — varchar(100)
  • CONTACT_TYPE_ID — int
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(50)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(50)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • EXTERNAL_SYSTSM_ID — int

CUSTOMER.CHARGE_ORDER (클레임 결제 정보)

  • CHARGE_ORDER_ID (결제 주문 ID) — binary(16) — Primary key — NOT NULL
  • PAYMENT_METHOD_TYPE_CODE — varchar(40)
  • CURRENCY_CODE (화폐 코드) — varchar(40)
  • CHARGE_ORDER_STATUS_CODE — varchar(40)
  • TOTAL_AMOUNT — decimal(15, 2)
  • TAX_AMOUNT — decimal(15, 2)
  • EXTERNAL_REFERENCE_ID — varchar(400)
  • EXTERNAL_SYSTEM_NAME — varchar(100)
  • OVERRIDE_BY — varchar(255)
  • OVERRIDE_TIME — datetime
  • OVERRIDE_REASON_CODE — varchar(40)
  • OVERRIDE_REMARK_TEXT — varchar(4000)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • PCI_TOKEN — varchar(40)
  • CHARGE_ORDER_TYPE_CODE — varchar(40)
  • CARD_TYPE_CODE — varchar(40)
  • CARD_CHECK_NBR — varchar(40)
  • ADDRESS_ID — binary(16)
  • PRE_AUTH_AMOUNT — decimal(15, 2)
  • ADDITIONAL_CHARGE_AUTH_IND — varchar(10)
  • CARD_HOLDER_NAME — varchar(100)
  • IDENTIFICATION_TYPE_CODE — varchar(40)
  • IDENTIFICATION_NBR — varchar(256)
  • ACTIVE_IND — varchar(10)
  • CANCELLATION_REASON_CODE — varchar(40)
  • CANCELLATION_SUB_REASON_CODE — varchar(40)
  • CARD_BRAND_CODE — varchar(40)
  • KEYSPEC — varchar(40)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • EXTERNAL_REF_URL — varchar(400)

CUSTOMER.CHARGE_ORDER_LINE (클레임 결제정보 매핑)

  • CHARGE_ORDER_LINE_ID — binary(16) — Primary key — NOT NULL
  • CHARGE_ORDER_ID (결제 주문 ID) — binary(16) — Foreign key → CUSTOMER.CHARGE_ORDER.CHARGE_ORDER_ID — NOT NULL
  • CHARGE_ORDER_LINE_TYPE_CODE — varchar(40)
  • FEE_AMOUNT — decimal(15, 2)
  • TAX_AMOUNT — decimal(15, 2)
  • TOTAL_AMOUNT — decimal(15, 2)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CALCULATION_AUDIT — varchar(1000)
  • CREATED_SYSTEM_ID — int
  • ADJUSTMENT_AMOUNT — decimal(15, 2)
  • ADJUSTED_BY — varchar(255)
  • ADJUSTMENT_DATE — datetime
  • ADJUSTMENT_REASON_CODE — varchar(40)
  • ACTIVE_IND — varchar(10)
  • CANCELLATION_REASON_CODE — varchar(40)
  • CANCELLATION_SUB_REASON_CODE — varchar(40)
  • CHARGE_ORDER_LINE_STATUS_CODE — varchar(40)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime

CUSTOMER.CONTACT_PREFERENCE (CONTACT_PREFERENCE)

  • CONTACT_PREFERENCE_ID — binary(16) — Primary key — NOT NULL
  • SERVICE_REQUEST_ID — binary(16)
  • PRIMARY_IND — varchar(10)
  • ADDRESS_ID — binary(16)
  • PREFERRED_TIME_CODE — varchar(40)
  • CONTACT_PREFERENCE_STS_CD — varchar(40)
  • LANGUAGE_CODE — varchar(40)
  • CONTACT_POINT_ID — binary(16)
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • CONTACT_MODE_CODE — varchar(40)
  • CUSTOMER_CASE_ID — binary(16)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYSTEM_ID — int
  • ACTIVE_IND — varchar(10)

CUSTOMER.CORRESPONDENCE_DETAILS (Web 결제 이후 sms/email 송신 정보)

  • CORRESPONDENCE_DETAILS_ID — binary(16) — Primary key — NOT NULL
  • CLIENT_ACCOUNT_ID (고객사 계정 ID) — binary(16) — Foreign key → CLIENT.CLIENT_ACCOUNT.CLIENT_ACCOUNT_ID — NOT NULL
  • MOBILE_DEVICE_NBR — varchar(255)
  • CLIENT_ID (고객사 ID) — binary(16) — Foreign key → CLIENT.CLIENT.CLIENT_ID — NOT NULL
  • CLIENT_NAME (고객사명) — varchar(255)
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER_CASE.CUSTOMER_CASE_ID — NOT NULL
  • AGREEMENT_ID (가입자 ID) — binary(16) — Foreign key → ASSET.AGREEMENT.AGREEMENT_ID — NOT NULL
  • SERVICE_REQUEST_ID — binary(16)
  • REFERENCE_TYPE — varchar(100)
  • REFERENCE_NUMBER — int
  • TEMPLATE_NAME — varchar(100)
  • SENT_STATUS — varchar(100)
  • SENT_TO — varchar(1000)
  • SENDER_NAME — varchar(100)
  • TYPE — varchar(100)
  • INTERNAL — varchar(100)
  • CREATEDBY — varchar(100)
  • CREATEDDATE — datetime
  • PROVIDER — varchar(100)
  • MESSAGE_ID — varchar(256)
  • ERROR_CODE — varchar(45)
  • ERROR_DESC — varchar(256)
  • VIRTUAL_ACCOUNT_NUMBER — varchar(80)

CUSTOMER.CORRESPONDENCE_SOLUTO_APP_REMINDER_HISTORY (CORRESPONDENCE_SOLUTO_APP_REMINDER_HISTORY)

  • CORRESPONDENCE_SOLUTO_APP_REMINDER_HISTORY_ID — binary(16) — Primary key — NOT NULL
  • MOBILE_DEVICE_NBR — varchar(255)
  • SMS_SENT_DATE — datetime
  • SMS_SENT_STATUS — varchar(20)
  • CORRESPONDANCE_TEMPLATE_ID — binary(1)
  • SMS_TEXT — varchar(4000)
  • SOLUTO_SMS_DAYS_LOWER_LIMIT — varchar(255)
  • SOLUTO_SMS_DAYS_UPPER_LIMIT — varchar(255)
  • SOLUTO_SMS_COUNT_LIMIT — varchar(255)
  • SOLUTO_SMS_ENABLED — varchar(255)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CREATED_SYS — varchar(50)
  • ACTIVE_IND — varchar(10)

CUSTOMER.CUSTOMER (고객 정보 마스터(가입자 이력과 매핑))

  • CUSTOMER_ID (고객 ID) — binary(16) — Primary key — NOT NULL
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • CUSTOMER_NBR (고객 번호) — int
  • FULL_NAME — varchar(1000)
  • FIRST_NAME — varchar(1000)
  • MIDDLE_NAME — varchar(500)
  • LAST_NAME — varchar(1000)
  • NAME_PREFIX — varchar(100)
  • NAME_SUFFIX — varchar(100)
  • PHONETIC_NAME — varchar(100)
  • CUSTOMER_START_DATE — datetime
  • CUSTOMER_END_DATE — datetime
  • EXTERNAL_REFERENCE_ID — varchar(10)
  • CREATED_SYSTEM_ID — int
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • LOAD_DATE — datetime
  • DATE_OF_BIRTH (생년월일) — varchar(500)
  • LAST_NAME_PREFIX — varchar(1000)
  • GENDER (성별) — varchar(100)
  • CUSTOMER_PREFERRED_LANGUAGE_CD — varchar(100)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • CALLER_UNDERAGE — varchar(10)
  • FIRST_IDENTIFICATION_NBR — varchar(500)
  • CITIZEN — varchar(20)

CUSTOMER.CUSTOMER_AGREEMENT_ROLE (CUSTOMER와 AGREEMENT 매핑 규칙)

  • CUSTOMER_AGREEMENT_ROLE_ID (고객 가입자 규칙 ID) — binary(16) — Primary key — NOT NULL
  • CUSTOMER_AGREEMENT_RL_TYP_CODE — varchar(100)
  • AGREEMENT_ID (가입자 ID) — binary(16) — Foreign key → ASSET.AGREEMENT.AGREEMENT_ID — NOT NULL
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • ROLE_START_DATE — datetime
  • ROLE_END_DATE — datetime
  • CREATED_SYSTEM_ID — int
  • EFFECTIVE_START_DATE — datetime
  • EFFECTIVE_END_DATE — datetime
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10)

CUSTOMER.CUSTOMER_CASE (클레임 마스터)

  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Primary key — NOT NULL
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • ASSET_ID — binary(16) — Foreign key → ASSET.ASSET.ASSET_ID — NOT NULL
  • AGREEMENT_ID (가입자 ID) — binary(16) — Foreign key → ASSET.AGREEMENT.AGREEMENT_ID — NOT NULL
  • CLIENT_ACCOUNT_ID (고객사 계정 ID) — binary(16) — Foreign key → CLIENT.CLIENT_ACCOUNT.CLIENT_ACCOUNT_ID — NOT NULL
  • CUSTOMER_CASE_STATUS_CODE (클레임 상태 코드) — varchar(40)
  • CUSTOMER_CASE_NBR (클레임 번호) — int
  • CUSTOMER_CASE_START_DATE — datetime
  • CUSTOMER_CASE_END_DATE — datetime
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • CANCELLATION_REASON_CODE — varchar(40)
  • INCIDENT_TYPE_CODE — varchar(40)
  • WARRANTY_TYPE_CODE — varchar(40)
  • ACTIVE_IND — varchar(10)
  • ORIGINAL_INCIDENT_DATE — datetime
  • ORIGINAL_COVERED_EVENT_CODE — varchar(40)
  • UNDERWRITER_ID — varchar(50)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • EXTERNAL_REFERENCE_NUMBER (보여지는 클레임 번호) — varchar(45)
  • RE_REPAIR_COUNT — int
  • IS_ALREADY_REPAIRED — varchar(10)
  • TRAVEL_INSURANCE — varchar(10)
  • REPAIR_SERVICE_PROVIDER — varchar(100)
  • ALTERNATIVE_PHONE_USAGE — varchar(50)
  • LOSS_DOMESTIC_OVERSEAS — varchar(255)
  • INCIDENT_BACKGROUND_CODE — varchar(20)
  • LOSS_DESCRIPTION — varchar(1000)
  • INCIDENT_SPOT_CODE — varchar(20)
  • INCIDENT_SPOT — varchar(256)
  • INCIDENT_CAUSED_BY_CODE — varchar(20)
  • INCIDENT_CAUSED_BY_SUB_CODE — varchar(20)
  • INCIDENT_CAUSED_BY_SUB — varchar(256)
  • LOSS_IN_AIRPORT — varchar(1000)
  • LOSS_ADDRESS_ID — binary(16)
  • POLICE_REPORT_ID — varchar(40)
  • FLAG_OF_INCIDENT_REPORT — varchar(10)
  • FLAG_OF_FOREIGNER — varchar(10)
  • AGREEMENT_TO_REENROLL — varchar(10)
  • CUSTOMER_CASE_CTGRY_TYP_CD — varchar(40)
  • IS_LEASED_MODEL — varchar(10)
  • LEASE_MODEL — varchar(30)
  • REASON_FOR_FILING_AFTER_THIRTY_DAYS — varchar(600)
  • AGREEMENT_TO_REENROLL_APPLICANT_NAME — varchar(1000)
  • AGREEMENT_TO_REENROLL_APPLICANT_RELATIONSHIP — varchar(50)
  • AGREEMENT_TO_REENROLL_APPLICANT_RELATIONSHIP_TL — varchar(50)
  • AGREEMENT_TO_REENROLL_UPDATED_DATE — datetime
  • IS_PURGED — varchar(1) — NOT NULL
  • ENROLLED_DEVICE_FLAG — varchar(10)

CUSTOMER.CUSTOMER_CASE_CATEGORY (클레임 카테고리(서비스, 결제, 배송))

  • CUSTOMER_CASE_CATEGORY_ID (클레임 카테고리 ID) — binary(16) — Primary key — NOT NULL
  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER_CASE.CUSTOMER_CASE_ID — NOT NULL
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • ITEM_TYPE_CODE — varchar(40) — NOT NULL
  • CUSTOMER_CASE_CTGRY_STS_CD — varchar(40)
  • CUSTOMER_CASE_CTGRY_TYP_CD — varchar(40)
  • SERVICE_REQUEST_ID — binary(16) — Foreign key — NOT NULL
  • ITEM_ID — binary(16)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • INTERACTION_LINE_ID — binary(16)
  • BULK_UPDATED_BY — varchar(255)

CUSTOMER.CUSTOMER_CASE_COMMERCIALS (클레임 금액 정보)

  • CUSTOMER_CASE_COMMERCIALS_ID — binary(16) — Primary key — NOT NULL
  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER_CASE.CUSTOMER_CASE_ID — NOT NULL
  • ENROLLED_EQUIPMENT_PRICE — decimal(10, 2)
  • REPLACEMENT_EQUIPMENT_PRICE — decimal(10, 2)
  • CLAIMED_EQUIPMENT_PRICE — decimal(10, 2)
  • CLAIM_LIMIT — decimal(10, 2)
  • REMAINING_BENEFIT — decimal(10, 2)
  • COVERED_AMOUNT — decimal(10, 2)
  • DEDUCTIBLE_PERCENT — decimal(10, 2)
  • DEDUCTIBLE_FIXED_AMOUNT — decimal(10, 2)
  • DEDUCTIBLE_AMOUNT — decimal(10, 2)
  • MINIMUM_DEDUCTIBLE — decimal(10, 2)
  • OVERAGE_AMOUNT — decimal(10, 2)
  • UNPAID_PREMIUM — decimal(10, 2)
  • SIM_CARD_PRICE — decimal(10, 2)
  • TOTAL_AMOUNT — decimal(10, 2)
  • SIM_CARD_TAX — decimal(10, 2)
  • SERVICEE_FEE_TAX — decimal(10, 2)
  • RECEIPT_AMOUNT — decimal(10, 2)
  • RECEIPT_COVERED_AMOUNT — decimal(10, 2)
  • REIMBURSEMENT_AMOUNT — decimal(10, 2)
  • REMAINING_COVERAGE — decimal(10, 2)
  • AMOUNT_PAID_BY_ADJUSTER — decimal(10, 2)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • EXTERNAL_SYSTEM_ID — int
  • REFURBISHED — varchar(10)
  • SCREEN_REPAIRED — varchar(10)
  • CPO_DISCOUNT_RATE — decimal(10, 2)
  • IS_CPO — varchar(10)
  • MAX_CLAIM_LIMIT_REPAIR_ONCE — decimal(15, 2)
  • LCD_ONLY_DAMAGE — varchar(10)

CUSTOMER.CUSTOMER_CASE_DOCUMENT (클레임 서류정보)

  • CUSTOMER_CASE_DOCUMENT_ID (클레임 서류 ID) — binary(16) — Primary key — NOT NULL
  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER_CASE.CUSTOMER_CASE_ID — NOT NULL
  • DOCUMENT_ID (서류 ID) — binary(16)
  • DOC_SOURCE_CHANNEL — varchar(40)
  • DOC_STATUS_CODE — varchar(40)
  • EXTERNAL_REFERENCE_NUMBER — varchar(45)
  • DOCUMENT_DESCRIPTION — varchar(1000)
  • DOCUMENT_PATH — varchar(1000)
  • TEMPLATE_DOCUMENT_PATH — varchar(1000)
  • DOCUMENT_REQUIRED_STATUS — varchar(10)
  • IS_REQUIRED_DOCUMENT — varchar(10)
  • DOC_RJCTN_RSN_CODE — varchar(1000)
  • DOC_INCOMPLETED_REASON_ID — binary(16)
  • RECEIVED_DATE — datetime
  • REVIEWED_DATE — datetime
  • ACTION_DATE — datetime
  • REVIEWED_BY — varchar(255)
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • COMMENT_TEXT — varchar(4000)
  • MOBILE_DEVICE_NBR — varchar(255)
  • ASURION_PATH — varchar(2000)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime
  • ATTACHMENT_DOCUMENT_COUNT — varchar(20)
  • EXTERNAL_REFERNCE_ID — int

CUSTOMER.CUSTOMER_CASE_DRAFT (클레임 접수 전 초안정보)

  • CUSTOMER_CASE_DRAFT_ID — binary(16) — Primary key — NOT NULL
  • AGREEMENT_ID (가입자 ID) — binary(16) — Foreign key → ASSET.AGREEMENT.AGREEMENT_ID — NOT NULL
  • DRAFT_DETAILS — longtext
  • CREATED_SYSTEM_ID — int
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime

CUSTOMER.CUSTOMER_CASE_ROLE (CUSTOMER_CASE_ROLE)

  • CUSTOMER_CASE_ROLE_ID — binary(16) — Primary key — NOT NULL
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER_CASE.CUSTOMER_CASE_ID — NOT NULL
  • CUSTOMER_CASE_ROLE_TYPE_CODE — varchar(40)
  • RELATIONSHIP_NAME_ID — binary(16)
  • RELATIONSHIP_CODE — varchar(255)
  • OTHER_RELATIONSHIP_NAME — varchar(100)
  • IS_CALLER — varchar(10)
  • EFFECTIVE_START_DATE — datetime
  • EFFECTIVE_END_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • BULK_UPDATED_BY — varchar(255)
  • BULK_UPDATED_DATE — datetime

CUSTOMER.CUSTOMER_CASE_STATUS_TRACKING (클레임 상태 이력(ACTIVE_IND='Y' 넣기))

  • CUSTOMER_CASE_STATUS_TRACKING_ID — binary(16) — Primary key — NOT NULL
  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER_CASE.CUSTOMER_CASE_ID — NOT NULL
  • SERVICE_REQUEST_ID — binary(16) — Foreign key — NOT NULL
  • CUSTOMER_CASE_STATUS_CODE — varchar(100)
  • SERVICE_REQUEST_STATUS_CODE — varchar(100)
  • CUSTOMER_CASE_CREATED_DATE — datetime
  • INCIDENT_DATE — datetime
  • NOTIF_DATE — datetime
  • CUSTOMER_CASE_CANCELLATION_DATE — datetime
  • DOCUMENT_RECEIVED_DATE — datetime
  • DOCUMENT_REVIEWED_DATE — datetime
  • ADJUSTER_APPROVAL_REQUESTED_DATE — datetime
  • ADJUSTER_APPROVAL_COMPLETION_DATE — datetime
  • PAYMENT_DATE — datetime
  • REQUESTED_SHIPMENT_DATE — datetime
  • SHIPMENT_CONFIRM_DATE — datetime
  • CUSTOMER_CASE_COMPLETION_DATE — datetime
  • CHANGED_DATE_TIME — datetime
  • AGREED_DATE_OF_NOTIFICATION — datetime
  • CUSTOMER_CASE_APPROVAL_XML — longtext
  • ASSET_RETURN_DATE — datetime
  • URGENT_FLAG — varchar(10)
  • URGENT_REQUESTED_DATE — datetime
  • DATE_SEND_TO_ADJUSTER — datetime
  • DATE_PAID_BY_ADJUSTER — datetime
  • SIM_ACTIVATION_DATE — date
  • CREATED_SYSTEM_ID — int
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • ACTIVE_IND — varchar(10)
  • IK_CLAIM_STATUS_ID — int
  • ADJUSTER_TASK_START_TIME — datetime
  • ADJUSTER_TASK_END_TIME — datetime
  • WEBFULFILMENT_ACCESS_DATETIME — datetime
  • PHONE_MODEL_CONFIRMATION_DATE — datetime
  • IS_EVER_ON_WBKO_FLAG — datetime
  • IS_ON_BACKORDER_CUSTOMER_CHOICE_FLAG — datetime
  • WBKO_RELEASE_DATE — datetime
  • SALVAGE_RETURN_DATE — datetime
  • REPAIR_COMPLETION_DATE — datetime
  • AGREED_DATE_OF_OPTIONAL_NOTIFICATION — datetime

CUSTOMER.CUSTOMER_CASE_SURVEY_ANSWER (CUSTOMER_CASE_SURVEY_ANSWER)

  • CUSTOMER_CASE_SURVEY_ANSWER_ID — binary(16) — Primary key — NOT NULL
  • CUSTOMER_CASE_SURVEY_ID — binary(16) — NOT NULL
  • SURVEY_QUESTION_ID — binary(16) — NOT NULL
  • STAR_COUNT — varchar(10)
  • LIKE_YN — varchar(10)
  • EPISODIC_SELECTION — longtext
  • COMMENT — longtext — ongtext NUL
  • CREATED_DATE — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • UPDATED_BY — varchar(255)

CUSTOMER.CUSTOMER_CORRESPONDENCE (Web 결제 이전 단계의 SMS/Email 송신정보)

  • CUSTOMER_CORRESPONDENCE_ID — binary(16) — Primary key — NOT NULL
  • CONTACT_PERSON_NAME — varchar(100)
  • MOBILE_DEVICE_NBR — varchar(255)
  • CLIENT_NAME — varchar(40)
  • CLIENT_ID (고객사 ID) — binary(16) — Foreign key → CLIENT.CLIENT.CLIENT_ID — NOT NULL
  • CLIENT_CHANNEL_ID (고객사 채널 ID) — binary(16) — Foreign key → CLIENT.CLIENT_CHANNEL.CLIENT_CHANNEL_ID — NOT NULL
  • SERVICE_REQUEST_ID — binary(16) — Foreign key — NOT NULL
  • CUSTOMER_CASE_ID (클레임 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER_CASE.CUSTOMER_CASE_ID — NOT NULL
  • CUSTOMER_ID (고객 ID) — binary(16) — Foreign key → CUSTOMER.CUSTOMER.CUSTOMER_ID — NOT NULL
  • CONTACT_POINT_ID — binary(16)
  • ADDRESS_ID — binary(16)
  • AGREEMENT_ID (가입자 ID) — binary(16) — Foreign key → ASSET.AGREEMENT.AGREEMENT_ID — NOT NULL
  • CLIENT_ACCOUNT_ID — binary(16)
  • INTERACTION_LINE_ID — binary(16)
  • EXTERNAL_REFERENCE_ID — varchar(10)
  • CORRESPONDENCE_TEMPLATE_ID — binary(16)
  • COMMUNICATION_PROCESS_ID — varchar(10)
  • CORRESPONDENCE_STATUS_CODE — varchar(40)
  • CORRESPONDENCE_REASON_CODE — varchar(40)
  • CORRESPONDENCE_METHOD_CODE — varchar(40)
  • LANGUAGE_CODE — varchar(40)
  • CORRESPONDENCE_MODE_CODE — varchar(40)
  • CORRESPONDENCE_RESULT_CODE — varchar(40)
  • MESSAGE_SUBJECT — longtext
  • REFERENCE_TYPE — varchar(100)
  • REFERENCE_NUMBER — varchar(1000)
  • TEMPLATE_NAME — varchar(100)
  • SENT_STATUS — varchar(100)
  • SENT_TO — varchar(450)
  • SENDER_NAME — varchar(100)
  • TYPE — varchar(100)
  • INTERNAL — varchar(100)
  • PROVIDER — varchar(100)
  • MESSAGE_ID — varchar(256)
  • ERROR_CODE — varchar(45)
  • ERROR_DESC — varchar(256)
  • TRIGERRING_DATE — date
  • COUNTRY_CALLING_CODE — varchar(25)
  • OPTED_IND — varchar(10)
  • REQUESTED_ATTEMPTS — decimal(15, 2)
  • ACTUAL_ATTEMPTS — decimal(15, 2)
  • PROVIDER_NAME — varchar(100)
  • CORRESPONDENCE_REQUEST_TYPE_CD — varchar(40)
  • KEYSPEC — varchar(500)
  • MESSAGE_CONTENT — longtext
  • CREATED_SYSTEM_ID — int
  • ACTIVE_IND — varchar(10)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime
  • EXTERNAL_SYSTEM_ID — int

CUSTOMER.CUSTOMER_CORRESPONDENCE_ATTRIBUTES (CUSTOMER_CORRESPONDENCE_ATTRIBUTES)

  • CUSTOMER_CORRESPONDENCE_ATTRIBUTES_ID — binary(16) — Primary key — NOT NULL
  • CUSTOMER_CORRESPONDENCE_ID — binary(16)
  • ATTRIBUTE_NAME — varchar(255)
  • ATTRIBUTE_VALUE — varchar(1000)
  • CREATED_BY — varchar(255)
  • CREATED_DATE — datetime
  • UPDATED_BY — varchar(255)
  • UPDATED_DATE — datetime

and 96 more tables