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)