dim

Tables (26)

DIM_ADMIN_TB

  • ADMIN_SQ — int — Primary key — NOT NULL
  • ADMIN_ID — varchar(20)
  • ADMIN_NAME — varchar(20)
  • ADMIN_PASSWORD — varchar(255)
  • ADMIN_ACCESS_TOKEN — varchar(500)
  • ADMIN_REFRESH_TOKEN — varchar(500)
  • ADMIN_EMAIL — varchar(100)
  • ROLE_TYPE — varchar(15) — ADMIN_VIEWER\r\n\r\n : 시스템 내 모든 데이터를 열람만 할 수 있는 권한. 데이터 수정, 삭제, 생성 등의 작업은 불가.\r\n사용 용도: 로그, 보고서, 기록 등을 조회할 수 있지만 변경 작업을…
  • ADMIN_STATUS — varchar(1)
  • S_KEY — varchar(32)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)
  • ADMIN_PHONE — varchar(20)

DIM_CONFIG_TB

  • CONFIG_SQ — int — Primary key — NOT NULL
  • SEND_TOKEN — varchar(350)
  • SEND_TOKEN_EXPIRED — varchar(20)
  • SEND_TOKEN_TYPE — varchar(10)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)
  • SCHEDULE_LOCK — varchar(5)
  • SENDER — varchar(3)
  • ONESHOT_BALANCE — decimal(10,2)
  • ONESHOT_BALANCE_DT — datetime

DIM_CS_IMAGE_TB

  • REG_SQ — int — Primary key — NOT NULL
  • CS_FK — int — NOT NULL
  • CS_IMG — varchar(255)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL

DIM_CS_TB

  • CS_SQ — int — Primary key — NOT NULL
  • CS_TYPE — int — 0: 주문/r/n 1: 쿠폰
  • ORDER_SQ — int
  • SEND_SQ — int
  • REQUEST_TYPE — int — 0: 쿠폰\r\n 1: 이용문의\r\n 2: 재발송\r\n 3: 환불 및 결제취소\r\n 4: 기간연장\r\n 5: 기타\r\n 6: 결제\r\n 7: 상품문의\r\n 8: 발송문의
  • REQUEST_TITLE — varchar(100)
  • REQUEST_CONTENT — text — 문의내용
  • REQUEST_ANSWER — text
  • REQUESTER — varchar(100) — 문의자
  • CLAIM_NUMBER — varchar(100) — 클레임 번호
  • PROCESSING_STATUS — int — 처리방식\r\n0: 처리완료\r\n1: 처리중\r\n2: 보류
  • CS_MEMO — text — 메모
  • REG_DT — datetime
  • MOD_DT — datetime
  • MOD_ID — varchar(100) — 담당자
  • PLATFORM_FK — int

DIM_CS_USER_TB

  • USER_SQ — int — Primary key — NOT NULL
  • USER_ID — varchar(20)
  • USER_NAME — varchar(20)
  • USER_PASSWORD — varchar(255)
  • USER_REFRESH_TOKEN — varchar(300)
  • USER_PHONE — varchar(20)
  • USER_EMAIL — varchar(100)
  • ROLE_TYPE — varchar(20) — USER_VIEWER\r\n글못씀\r\n\r\nUSER_EDITOR\r\n글씀
  • USER_TYPE — varchar(1)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)
  • USER_PASS_PHONE — varchar(100)
  • MEMO — varchar(255)
  • PLATFORM_FK — int

DIM_FAQ_TB

  • FAQ_SQ — int — Primary key — NOT NULL
  • FAQ_TYPE — int — 0: 쿠폰\r\n 1: 이용문의\r\n 2: 환불\r\n 3: 결제취소\r\n 4: 기간연장\r\n 5: 기타\r\n 6: 클레임\r\n 7: 상품문의\r\n 8: 수신결과 확인
  • FAQ_TITLE — varchar(500)
  • FAQ_CONTENT — text — 문의내용
  • FAQ_MEMO — text — 메모
  • REG_DT — datetime
  • MOD_DT — datetime
  • MOD_ID — varchar(100) — 담당자
  • PLATFORM_FK — int — NOT NULL

DIM_GOODS_ERROR_TB

  • ERROR_SQ — int — NOT NULL
  • GOODS_ID — varchar(10) — NOT NULL
  • ERROR_START_DT — datetime
  • ERROR_END_DT — datetime
  • VALID_YN — varchar(1)
  • REG_DT — datetime
  • MOD_DT — datetime
  • MOD_ID — varchar(20)

DIM_GOODS_MEDIA_TB

  • MEDIA_SQ — int — NOT NULL
  • GOODS_ID — varchar(10) — NOT NULL
  • PLATFORM_FK — int
  • REG_DT — datetime
  • MOD_DT — datetime
  • MOD_ID — varchar(20)

DIM_GOODS_TB

  • GOODS_ID — varchar(10) — Primary key — NOT NULL
  • SUPPLIER_GOODS_CODE — varchar(50)
  • SUPPLIER_ISSUED_CODE — varchar(20)
  • GOODS_BRAND — varchar(100)
  • GOODS_CATEGORY — varchar(20)
  • GOODS_NAME — varchar(100)
  • GOODS_IMG — varchar(255)
  • GOODS_PRICE — float
  • GOODS_DISCOUNT — float
  • GOODS_LIMIT — tinyint
  • GOODS_RM_YN — varchar(2)
  • GOODS_STATUS — varchar(2) — 1 판매중 2 팡매중지 3 단종 4 장애중지 5 발행중지(공급사)
  • GOODS_SALE_TYPE — varchar(4)
  • GOODS_DESC — text
  • GOODS_CORE_DISPLAY_YN — varchar(2)
  • GOODS_RETAIL_PRICE — float — 소비자 가격
  • GOODS_FRONT_DISPLAY_YN — varchar(2)
  • GOODS_DELIVERY_YN — varchar(2)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)
  • SUPPLIER_CODE — varchar(10)
  • GOODS_SALE_PRICE — float
  • DEPOSIT_TYPE — varchar(1)
  • SUPPLIER_GOODS_PRICE — float
  • SUPPLIER_GOODS_FEE — float
  • SALE_START_DT — datetime
  • SALE_END_DT — datetime

DIM_MSG_ONESHOT2_CHANGE_PHONE_TB

  • Phone_No — varchar(32) — Primary key — NOT NULL
  • Change_No — varchar(32) — NOT NULL
  • Save_Time — datetime — NOT NULL

DIM_MSG_ONESHOT2_ERRORCODE_TB

  • Error_Code — int — Primary key — NOT NULL
  • Error_Msg — varchar(100) — NOT NULL

DIM_MSG_ONESHOT2_LOG_TB

  • Msg_Id — int — Primary key — NOT NULL
  • Phone_No — varchar(32) — NOT NULL
  • Callback_No — varchar(32)
  • Status — int — NOT NULL
  • Msg_Type — int — NOT NULL
  • Send_Time — datetime — NOT NULL
  • Save_Time — datetime — NOT NULL
  • Subject — varchar(64)
  • Message — varchar(4000)
  • Kakao_Ad_Flag — varchar(1)
  • Kakao_Nation_Code — varchar(5)
  • Kakao_Sender_Key — varchar(40)
  • Kakao_Template_Code — varchar(30)
  • Kakao_Timeout — int
  • Kakao_Button — varchar(1000)
  • Kakao_ReSend — varchar(1)
  • Kakao_ReMessage — varchar(4000)
  • Kakao_ReType — int
  • Kakao_Org_Id — int
  • File_Count — int — NOT NULL
  • File_Type1 — varchar(3)
  • File_Type2 — varchar(3)
  • File_Type3 — varchar(3)
  • File_Name1 — varchar(1000)
  • File_Name2 — varchar(1000)
  • File_Name3 — varchar(1000)
  • Spam_Check — varchar(1) — NOT NULL
  • Deny_No — varchar(20)
  • Tran_time — datetime
  • Tran_Id — varchar(30)
  • Result — int
  • Telecom — varchar(3)
  • Delivery_Time — datetime
  • Result_Time — datetime
  • Message_Id — varchar(20)
  • Send_Fk — int

DIM_MSG_ONESHOT2_SPAM_TB

  • Deny_No — varchar(20) — Primary key — NOT NULL
  • Phone_No — varchar(32) — Primary key — NOT NULL
  • Save_Time — datetime — NOT NULL

DIM_MSG_ONESHOT2_TRAN_TB

  • Msg_Id — int — Primary key — NOT NULL
  • Phone_No — varchar(32) — NOT NULL
  • Callback_No — varchar(32)
  • Status — int — NOT NULL
  • Msg_Type — int — NOT NULL
  • Send_Time — datetime — NOT NULL
  • Save_Time — datetime — NOT NULL
  • Subject — varchar(64)
  • Message — varchar(4000)
  • Kakao_Ad_Flag — varchar(1)
  • Kakao_Nation_Code — varchar(5)
  • Kakao_Sender_Key — varchar(40)
  • Kakao_Template_Code — varchar(30)
  • Kakao_Timeout — int
  • Kakao_Button — varchar(1000)
  • Kakao_ReSend — varchar(1)
  • Kakao_ReMessage — varchar(4000)
  • Kakao_ReType — int
  • Kakao_Org_Id — int
  • File_Count — int — NOT NULL
  • File_Type1 — varchar(3)
  • File_Type2 — varchar(3)
  • File_Type3 — varchar(3)
  • File_Name1 — varchar(1000)
  • File_Name2 — varchar(1000)
  • File_Name3 — varchar(1000)
  • Spam_Check — varchar(1) — NOT NULL
  • Deny_No — varchar(20)
  • Tran_time — datetime
  • Tran_Id — varchar(30)
  • Result — int
  • Telecom — varchar(3)
  • Delivery_Time — datetime
  • Result_Time — datetime
  • Message_Id — varchar(20)
  • Send_Fk — int

DIM_ORDER_TB

  • ORDER_SQ — int — Primary key — NOT NULL
  • ORDER_ID — varchar(20) — NOT NULL — 주문번호
  • PLATFORM_ID — varchar(20) — NOT NULL
  • ORDER_PRICE — float — 판매가
  • QUANTITY — int — 수량
  • SEND_STATUS — int — 0 : 대기상태\r\n1 : 발송중\r\n2 : 발송완료\r\n3 : 취소상태
  • ORDER_PAYMENT_TYPE — int — 1:카드결제, 2 무통장, 3 가상계좌
  • CANCEL_DT — datetime
  • REQUEST_INFO — varchar(255)
  • TRANSMITTER_NUMBER — varchar(50)
  • TRANSMITTER_NAME — varchar(100)
  • SEND_SUBJECT — varchar(50)
  • SEND_CONTENT — text
  • RESERVE_CHECK — varchar(1)
  • RESERVE_DT — datetime
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)
  • GOODS_DISCOUNT — float
  • SEND_TYPE — int — 1:요청발급 ( 문자까지 전송) 2 : 쿠폰번호만 발급
  • GOODS_ID — varchar(10)
  • CL_ORDER_ID — varchar(20) — 클라이언트 유니크아이디
  • PLATFORM_USER_FK — int — 플랫폼 유저 번호
  • MESSAGE_TYPE — int — NOT NULL — 1: 문자, 2: 알림톡
  • TEMPLATE_CODE — varchar(20) — 템플릿 코드

DIM_ORDER_TB_OLD

  • ORDER_SQ — int — Primary key — NOT NULL
  • ORDER_ID — varchar(20) — NOT NULL — 주문번호
  • PLATFORM_ID — varchar(20) — NOT NULL
  • ORDER_PRICE — float — 판매가
  • QUANTITY — int — 수량
  • SEND_STATUS — int — 0 : 대기상태\r\n1 : 발송중\r\n2 : 발송완료\r\n3 : 취소상태
  • ORDER_PAYMENT_TYPE — int — 1:카드결제, 2 무통장, 3 가상계좌
  • CANCEL_DT — datetime
  • REQUEST_INFO — varchar(255)
  • TRANSMITTER_NUMBER — varchar(50)
  • TRANSMITTER_NAME — varchar(100)
  • SEND_SUBJECT — varchar(50)
  • SEND_CONTENT — text
  • RESERVE_CHECK — varchar(1)
  • RESERVE_DT — datetime
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)
  • GOODS_DISCOUNT — float
  • SEND_TYPE — int — 1:요청발급 ( 문자까지 전송) 2 : 쿠폰번호만 발급
  • GOODS_ID — varchar(10)

DIM_ORDER_VALIDATION_TB

  • PLATFORM_ID — varchar(20) — Primary key — NOT NULL
  • CL_ORDER_ID — varchar(20) — Primary key — NOT NULL — 클라이언트 유니크아이디
  • REG_TIME — timestamp(3)

DIM_PIN_TB

  • SEND_SQ — int — Primary key — NOT NULL
  • TRANSACTION_ID — varchar(50)
  • MESSAGE_ID — varchar(50)
  • RESPONSE_CODE — varchar(6)
  • PIN_STATUS — int — 0:대기 1:정상 2:사용 3:취소 4:유효기간초과
  • SEND_TYPE — int — 1:공급사발송요청 \r\n2:자체발송
  • ORDER_SQ — int
  • GOODS_ID — varchar(10)
  • SEND_REQUEST_DT — datetime
  • USED_DT — datetime
  • CANCEL_DT — datetime
  • PIN_NO — varchar(50)
  • PIN_EXTRA — varchar(100)
  • VALIDITY_START_DT — varchar(10)
  • VALIDITY_END_DT — varchar(10)
  • PLATFORM_NAME — varchar(20)
  • REG_DT — datetime
  • MOD_DT — datetime
  • MOD_ID — varchar(30)
  • AFFILIATED_STORE_CODE — varchar(10)
  • AFFILIATED_STORE_NAME — varchar(50)
  • RECEIVER_NUMBER — varchar(50)
  • RECEIVER_NAME — varchar(100)
  • RESEND — int

DIM_PLATFORM_TB

  • PLATFORM_SQ — int — Primary key — NOT NULL
  • PLATFORM_ID — varchar(20) — NOT NULL
  • PLATFORM_NAME — varchar(20)
  • PLATFORM_MANAGER — varchar(20)
  • PLATFORM_PASSWORD — varchar(255)
  • PLATFORM_TEL — varchar(20)
  • PLATFORM_ISSUE — varchar(1) — 플랫폼 발행 이슈
  • PLATFORM_COLOR — varchar(7)
  • REFRESH_TOKEN — varchar(300)
  • EMAIL — varchar(100)
  • ROLE_TYPE — varchar(10)
  • STATE_TYPE — varchar(1)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)
  • ENCRYPT_KEY — varchar(32)
  • ENCRYPT_IV — varchar(16)
  • DAY_LIMIT — int — 일한도
  • DEPOSIT_TYPE — int — 입금방식 1선입, 2 후불
  • TEMPLATE_YN — varchar(1)
  • TEMPLATE_NAME — varchar(30)
  • SEND_TYPE — int
  • PLATFORM_BIZ_NAME — varchar(50)
  • PLATFORM_BIZ_MANAGER — varchar(50)
  • PLATFORM_IMG — varchar(255)

DIM_REFUND_TB

  • REFUND_SQ — int — Primary key — NOT NULL
  • ORDER_SQ — int
  • PRICE_RATE — int — 환불금액(퍼센트)
  • NUMBER — varchar(50) — 연락처
  • BANK_NAME — varchar(50) — 은행명
  • ACCOUNT_NAME — varchar(100) — 게좌번호
  • ISSUE_TYPE — varchar(3) — 환불사유\r\n0: 단순변심\r\n1: 오발행\r\n2: CS처리\r\netc: 기타
  • ISSUE_NOTE — varchar(300) — 환불사유(기타)
  • NOTE — varchar(500) — 비고
  • REG_DT — datetime
  • MANAGER — varchar(100) — 담당자

DIM_RESERVES_TB

  • RESERVES_SQ — int — Primary key — NOT NULL
  • PLATFORM_SQ — int — NOT NULL
  • RESERVES_STATUS — int — 1 적립 2 사용 3 주문취소재적립
  • PRICE — float
  • REG_DT — datetime
  • MOD_DT — datetime
  • MOD_ID — varchar(30)
  • ORDER_SQ — int
  • MEMO — varchar(255)

DIM_SEND_RESULT_TB

  • SEND_SQ — int — Primary key — NOT NULL
  • SEND_FK — int
  • MESSAGE_ID — varchar(50)
  • SEND_RESULT — varchar(4) — GSN:\r\n01 미발송 문자 발송 대기중\r\n02 발송 문자 발송 요청 완료\r\n03 결과수신중 문자 발송 요청 후 결과 수신 대기 중\r\n04 결과수신완료 문자 발송 결과 수신 완료 상태로 최종 완료 상…
  • SEND_RESULT_MESSAGE — varchar(100)
  • SENDER — varchar(10)
  • TELECOM — varchar(10)
  • SEND_DT — datetime
  • SEND_SUBJECT — varchar(255)
  • SEND_CONTENT — text
  • REQUEST_MESSAGE_TYPE — int — 1:MMS 2:LMS 3:SMS
  • REG_DT — datetime
  • MOD_DT — datetime
  • MOD_ID — varchar(30)
  • TRANSMITTER_NUMBER — varchar(100) — 발신자
  • RECEIVER_NUMBER — varchar(100) — 수신자

DIM_SHARE_RESERVES_TB

  • SHARE_RESERVES_SQ — int — Primary key — NOT NULL
  • MAIN_PLATFORM_SQ — int — NOT NULL — 밸런스를 공유하는 주체 플랫폼
  • SHARED_PLATFORM_SQ — int — NOT NULL — 밸런스를 공유받는 플랫폼
  • SHARE_RATIO — float — 공유 비율 (1.0 = 100%)
  • REG_DT — datetime
  • MOD_DT — datetime

DIM_SHEDLOCK

  • SHEDLOCK_NAME — varchar(64) — Primary key — NOT NULL
  • SHEDLOCK_UNTIL — timestamp(3) — NOT NULL
  • SHEDLOCK_AT — timestamp(3) — NOT NULL
  • SHEDLOCK_BY — varchar(255) — NOT NULL

DIM_SUPPLIER_TB

  • SUPPLIER_SQ — int — Primary key — NOT NULL
  • SUPPLIER_ID — varchar(50) — NOT NULL
  • SUPPLIER_NAME — varchar(20)
  • SUPPLIER_MANAGER — varchar(20)
  • SUPPLIER_TEL — varchar(20)
  • SUPPLIER_EMAIL — varchar(50)
  • SUPPLIER_SEND_PRICE — int
  • SUPPLIER_LIMIT_ISSUE — decimal(15,2)
  • SUPPLIER_LIMIT_USED — decimal(15,2)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • MOD_ID — varchar(30)

DIM_TEMPLATE_IMAGE_TB

  • TEMPLATE_SQ — int — Primary key — NOT NULL
  • TEMPLATE_IMG — varchar(255)
  • TEMPLATE_NAME_KO — varchar(30)
  • TEMPLATE_NAME_EXT — varchar(30)
  • TEMPLATE_WIDTH — varchar(4)
  • TEMPLATE_HEIGHT — varchar(4)
  • REG_DT — datetime — NOT NULL
  • MOD_DT — datetime — NOT NULL
  • TEMPLATE_STATUS — varchar(1)