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