1
Tables (16)
KAKAO_GROUP
- GNO — NUMBER(10,0) — Primary key — NOT NULL
- GROUP_KEY — VARCHAR2(45) — NOT NULL
- GROUP_NAME — VARCHAR2(135) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MOD_DATE — DATE
KAKAO_IMAGE
- INO — NUMBER(10,0) — Primary key — NOT NULL
- PNO — NUMBER(10,0) — NOT NULL
- TITLE — VARCHAR2(60) — NOT NULL
- LINK_URI — VARCHAR2(255)
- IMG_URI — VARCHAR2(255) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MOD_DATE — DATE
- SHARE_FLAG — CHAR(1) — NOT NULL
- IMGTYPE — CHAR(1) — 와이드이미지타입여부
KAKAO_MAP
- PNO — NUMBER(10,0) — Primary key — NOT NULL
- GNO — NUMBER(10,0) — Primary key — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- MAP_DATE — DATE — NOT NULL
- MOD_DATE — DATE
KAKAO_PROFILE
- PNO — NUMBER(10,0) — Primary key — NOT NULL
- SENDER_KEY — VARCHAR2(45) — NOT NULL
- YELLOW_ID — VARCHAR2(135) — NOT NULL
- PROFILE_NAME — VARCHAR2(60) — NOT NULL
- STATUS — CHAR(1) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MOD_DATE — DATE
- DORMANT_YN — CHAR(1 CHAR) — NOT NULL — 휴면
KAKAO_TEMPLATE
- TNO — NUMBER(10,0) — Primary key — NOT NULL
- SENDER_TYPE — CHAR(1) — NOT NULL — 발신프로필
- SENDER_KEY — VARCHAR2(40) — NOT NULL — 발신프로필키
- TEMPLATE_NAME — VARCHAR2(600 CHAR) — NOT NULL — 템플릿명
- TEMPLATE_STATUS — CHAR(1) — NOT NULL — 템플릿
- INSPECT_STATUS — VARCHAR2(3) — NOT NULL — 검수상태
- CREATE_DATE — DATE — NOT NULL — 생성일시
- MOD_DATE — DATE — 수정일시
- TEMPLATE_CODE — VARCHAR2(90 CHAR) — NOT NULL — 템플릿
- INSPECT_REQ_DATE — DATE — 승인요청
- TEMPLATE_TYPE — CHAR(1 CHAR) — 템플릿
- HIDE_YN — CHAR(1 CHAR) — NOT NULL — 숨김
- CATEGORY_CODE — CHAR(6 CHAR) — 카테고리
- DORMANT_YN — CHAR(1 CHAR) — NOT NULL — 휴면
- BLOCK_YN — CHAR(1 CHAR) — 차단
KAKAO_TEMPLATE_BRAND
- BRNO — NUMBER(10,0) — Primary key — NOT NULL
- TNO — NUMBER(10,0) — NOT NULL — 템플릿
- IMG_TYPE — CHAR(1 CHAR) — NOT NULL — 이미지타입
- IMG_URI — VARCHAR2(255 CHAR) — NOT NULL — 이미지
- LINK_URI — VARCHAR2(255 CHAR) — NOT NULL — 링크
- UNSUBSCRIBE_CONTENT — VARCHAR2(24 CHAR) — NOT NULL
- CONT_TYPE — CHAR(1 CHAR) — NOT NULL — 텍스트
KAKAO_TEMPLATE_BUTTON
- BNO — NUMBER(10,0) — Primary key — NOT NULL
- TNO — NUMBER(10,0) — NOT NULL
- BORDER — NUMBER(1,0) — NOT NULL
- BUTTON_NAME — VARCHAR2(60) — NOT NULL
- BUTTON_TYPE — VARCHAR2(2) — NOT NULL
- BUTTON_CATEGORY — CHAR(3 CHAR) — NOT NULL — DEF(기본)
KAKAO_TEMPLATE_BUTTON_LINK
- LNO — NUMBER(10,0) — Primary key — NOT NULL
- BNO — NUMBER(10,0) — NOT NULL
- LINK_TYPE — VARCHAR2(3) — NOT NULL
- LINK_URI — VARCHAR2(500 CHAR) — NOT NULL
RCS_BRAND
- BRAND_NO — NUMBER(10,0) — Primary key — NOT NULL
- BRAND_ID — VARCHAR2(13) — NOT NULL — 브랜드
- BRAND_KEY — VARCHAR2(18) — NOT NULL — 브랜드
- BRAND_NM — VARCHAR2(60 CHAR) — NOT NULL — 브랜드
- REG_DATE — DATE — NOT NULL — 등록일시
- MOD_DATE — DATE — 상태변경일시(브랜드
- CHATBOT_UPDATE — DATE — 최종
- MSGBASE_UPDATE — DATE — 최종
- APRV_RST — CHAR(3) — NOT NULL — 승인상태
RCS_CHATBOT
- CHATBOT_NO — NUMBER(10,0) — Primary key — NOT NULL
- BRAND_NO — NUMBER(10,0) — NOT NULL — 브랜드
- CHATBOT_ID — VARCHAR2(40) — NOT NULL — 챗봇(발신번호)
- CHATBOT_NM — VARCHAR2(100 CHAR) — NOT NULL — 챗봇(발신번호)
- SUB_NUM — VARCHAR2(12) — NOT NULL — 회신번호(A2P는
- RCS_DISPLAY — VARCHAR2(2) — NOT NULL — 전시여부(NN|NY|YN|YY)
- REG_DATE — DATE — NOT NULL — 등록일시
- MOD_DATE — DATE — 수정일시
- APRV_DATE — DATE — 승인일시
- MAIN_NUM — CHAR(1) — NOT NULL — 대표번호
- APRV_RST — CHAR(3) — NOT NULL — 승인상태
- APRV_REASON — VARCHAR2(200 CHAR) — 승인사유
- DEL_FLAG — CHAR(1) — NOT NULL — 삭제여부(Y|N
- DAOU_STATUS — CHAR(3 CHAR) — NOT NULL — 다우
- CERT_FILE_NAME — VARCHAR2(800 CHAR)
RCS_FILE
- FILE_NO — NUMBER(10,0) — Primary key — NOT NULL — 파일
- BRAND_NO — NUMBER(10,0) — NOT NULL
- FILE_ID — VARCHAR2(64) — NOT NULL — 파일
- TITLE — VARCHAR2(20 CHAR) — NOT NULL — 제목
- FILE_EXT — VARCHAR2(5) — NOT NULL — 확장자
- REG_DATE — DATE — NOT NULL — 등록일시
- EXPIRY_DATE — DATE — NOT NULL — 만료일시
- SHARE_YN — CHAR(1 CHAR) — NOT NULL — 공유
RCS_MSGBASE
- MSGBASE_NO — NUMBER(10,0) — Primary key — NOT NULL
- BRAND_NO — NUMBER — NOT NULL — 브랜드
- MSGBASE_ID — VARCHAR2(40) — 메시지베이스
- MSGBASE_NM — VARCHAR2(90 CHAR) — NOT NULL — 메시지베이스
- FORM_ID — VARCHAR2(10) — NOT NULL — 메시지베이스
- REG_DATE — DATE — NOT NULL — 등록일시
- MOD_DATE — DATE — 수정일시
- APRV_DATE — DATE — 승인일시
- APRV_RST — VARCHAR2(10) — NOT NULL — 승인상태(승인대기
- APRV_REASON — VARCHAR2(200 CHAR) — 승인사유
- FMT_STR — CLOB — NOT NULL — formattedString(최대65535byte)
- INPUT_TEXT — VARCHAR2(1500 CHAR) — 카드타입이
- GW_YN — CHAR(1 CHAR) — GW
USER_CALLERBOOK
- CNO — NUMBER(10,0) — NOT NULL
- USERNO — NUMBER(10,0) — NOT NULL
- CALLER_NUMBER — VARCHAR2(24) — NOT NULL
- AUTH_DEVICE — VARCHAR2(15) — NOT NULL
- STATUS — CHAR(1) — NOT NULL
- USE_FLAG — CHAR(1)
- MODIFYDATE — CHAR(14) — NOT NULL
- MEMO — VARCHAR2(500 CHAR)
- MENU — CHAR(3) — NOT NULL
- CHATBOT_NO — NUMBER(10,0) — 챗봇번호
- TITLE — VARCHAR2(100 CHAR) — 발신번호명
USER_KAKAO
- KNO — NUMBER(10,0) — Primary key — NOT NULL
- USERNO — NUMBER(10,0) — NOT NULL
- PNO — NUMBER(10,0) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- MOD_DATE — DATE
- PNO) — PCTFREE
USER_KAKAO_MAP
- MNO — NUMBER(10,0) — Primary key — NOT NULL
- MASTER_USERNO — NUMBER(10,0) — NOT NULL — 카카오
- SLAVE_USERNO — NUMBER(10,0) — NOT NULL — 카카오
- USE_YN — CHAR(1) — 사용여부
- CREATE_DATE — DATE — 생성일
- MOD_DATE — DATE — 수정일
USER_RCS_BRAND
- URB_NO — NUMBER(10,0) — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL — 사용자
- BRAND_NO — NUMBER — NOT NULL — 브랜드
- REG_DATE — DATE — NOT NULL — 등록일시
- STATUS — CHAR(3 CHAR) — 다우승인상태
- CONFIRM_DATE — DATE — 다우승인일시
- RCS_COM_NO — VARCHAR2(10 CHAR) — RCS