K-Deal
Tables (44)
IT_CUSTOMER
- CUST_CI — VARCHAR(100)
- CUST_NM — VARCHAR(100)
- CUST_BIRTH — VARCHAR(100)
- CUST_GENDER — ENUM('MALE'','FEMALE','UNKNOWN') — NOT NULL
IT_CUSTOMER_HISTORY
- HISTORY_NO — BIGINT — Primary key — NOT NULL
- CUST_CI — VARCHAR(100)
- UPDATE_SERVICE — VARCHAR(20) — NOT NULL
- CUST_NM — VARCHAR(100)
- CUST_PHONE — VARCHAR(100)
- CARRIER_TYPE — ENUM('KT','SKT','LGU','OTHER')
- CUST_BIRTH — VARCHAR(100)
- CUST_GENDER — ENUM('MALE'','FEMALE','UNKNOWN')
IT_MEMBER_HISTORY
- HISTORY_NO — BIGINT — Primary key — NOT NULL
- SERVICE_CODE — VARCHAR(20) — NOT NULL
- CUST_CI — VARCHAR(100)
- CUST_ID — VARCHAR(30)
- CARRIER_TYPE — VARCHAR(255)
- CUST_PHONE — VARCHAR(100)
- STATUS — ENUM('ACTIVE','RESIGN','IDLE')
- FCM_TOKEN — VARCHAR(5000)
- JOIN_DT — DATETIME
- RESIGN_DT — DATETIME
- PHONE_OS — ENUM('ANDROID','IOS','OTHER')
- EMAIL — VARCHAR(100)
- FIRST_BUY_DT — DATETIME
- CONNECT_TYPE — ENUM('WEB','APP')
- SMSRECEIVE_DT — DATETIME
- SMSRECEIVE_YN — ENUM('Y', 'N') — NOT NULL
- PUSHRECEIVE_DT — DATETIME
- PUSHRECEIVE_YN — ENUM('Y', 'N') — NOT NULL
- MKTRECEIVE_DT — DATETIME
- MKTRECEIVE_YN — ENUM('Y', 'N') — NOT NULL
- UPDATE_DT — DATETIME
IT_SERVICE
- SERVICE_CODE — VARCHAR(20) — Primary key — NOT NULL
- AUTH_ID — VARCHAR(1000)
- SERVICE_PWD — VARCHAR(1000)
- SERVICE_NAME — VARCHAR(100)
- USE_YN — ENUM('Y','N')
- REGISTER_ID — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_ID — VARCHAR(20)
- UPDATE_DT — DATETIME
IT_TERMS
- TERMS_CODE — VARCHAR(20) — Primary key — NOT NULL
- TERMS_VERSION — VARCHAR(10) — Primary key — NOT NULL
- SERVICE_CODE — VARCHAR(20) — Foreign key → IT_SERVICE.SERVICE_CODE — NOT NULL
- TERMS_NM — VARCHAR(100)
- TERMS_CONTENT — TEXT
- TERMS_START_DATE — DATE
- REGISTER_ID — VARCHAR(20)
- REGIST_DT — DATETIME
IT_TERMS_HISTORY
- HISTORY_NO — BIGINT — Primary key — NOT NULL
- SERVICE_CODE — VARCHAR(20) — NOT NULL
- TERMS_CODE — VARCHAR(20) — NOT NULL
- TERMS_VERSION — VARCHAR(10) — NOT NULL
- AGREE_YN — ENUM('Y','N')
- AGREE_DT — DATETIME
- CUST_CI — VARCHAR(100)
KD_ADMIN
- ADMIN_CODE — VARCHAR(20) — Primary key — NOT NULL
- GROUP_NO — BIGINT — NOT NULL
- ADMIN_PWD — VARCHAR(1000)
- ADMIN_NM — VARCHAR(100)
- TEAM_NM — VARCHAR(100)
- ADMIN_PHONE — VARCHAR(20)
- STATUS — ENUM('OK','DELETE')
- OTP_KEY — VARCHAR(20)
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_ADMIN_BEHAVIOR_HISTORY
- ADMIN_BEHAVIOR_NO — BIGINT — Primary key — NOT NULL
- ADMIN_CODE — VARCHAR(20) — NOT NULL
- MENU_NO — BIGINT — NOT NULL
- BEHAVIOR_TYPE — ENUM('CREATE','READ','UPDATE','DELETE')
- IP — VARCHAR(40)
- CREATE_DT — DATETIME
KD_ADMIN_GROUP
- GROUP_NO — BIGINT — Primary key — NOT NULL
- GROUP_NM — VARCHAR(100)
- USE_YN — ENUM('Y','N')
- REGISTER_ID — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_ID — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_ADMIN_MENU
- MENU_NO — BIGINT — Primary key — NOT NULL
- SUPER_MENU_NO — BIGINT
- SEQ — INT
- MENU_NM — VARCHAR(100)
- URL_PATH — VARCHAR(100)
- ACTIVE_URL_PATH — VARCHAR(100)
- ROUTE_NM — VARCHAR(50)
- USE_YN — ENUM('Y','N')
- MENU_ICON — VARCHAR(20)
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_ADMIN_MENU_AUTH
- MENU_AUTH_NO — BIGINT — Primary key — NOT NULL
- GROUP_NO — BIGINT — NOT NULL
- MENU_NO — BIGINT — NOT NULL
- CREATABLE_YN — ENUM('Y',''N')
- USE_YN — ENUM('Y','N')
- REGISTER_CODE — VARCHAR(20)
- REGISTE_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_APP_HISTORY
- APP_HISTORY_NO — BIGINT — Primary key — NOT NULL
- OS_TYPE — ENUM('ANDROID','IOS','OTHER')
- APP_VERSION — VARCHAR(10)
- MUST_UPDATE_YN — ENUM('Y','N')
- APP_UPDATE_REASON — VARCHAR(1000)
- APP_UPDATE_DT — DATETIME
- APP_RELEASE_DT — DATETIME
- CONTENT — VARCHAR(1000)
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_APP_PUSH
- PUSH_ID — VARCHAR(50) — Primary key — NOT NULL
- RESERVE_YN — ENUM('Y','N')
- TARGET_CLASS_TYPE — ENUM('ALL','LEVEL','GROUP','INDIVIDUAL')
- TARGET_CLASS_CD — VARCHAR(20)
- TARGET_CLASS_NO — varchar(255)
- RESERVE_SEND_DT — DATETIME
- STATUS — ENUM('WAIT','FINISHED','CANCELED')
- TARGET_CNT — INT
- SUCCESS_CNT — INT
- PUSH_TITLE — VARCHAR(100)
- PUSH_CONTENT — VARCHAR(1000)
- PUSH_ICON — VARCHAR(100)
- PUSH_MOVETO — VARCHAR(100)
- REGISTER_ID — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_ID — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_APP_PUSH_HISTORY
- PUSH_HISTORY_ID — VARCHAR(20) — Primary key — NOT NULL
- PUSH_ID — VARCHAR(20) — NOT NULL
- CUST_ID — VARCHAR(20) — NOT NULL
- SEND_DT — DATETIME
- SUCCESS_YN — ENUM('Y','N')
- READ_YN — ENUM('Y','N')
KD_AUTO_SMS_SENT_HISTORY
- SENT_ID — VARCHAR(30) — Primary key — NOT NULL
- TEMPLATE_NO — BIGINT — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- RECEIVE_PHONE — VARCHAR(100)
- MESSAGE_TYPE — ENUM('SMS','LMS','PUSH')
- SUCCESS_YN — ENUM('Y','N')
- SENT_DT — DATETIME
- CONTENT — VARCHAR(2000)
- READ_YN — ENUM('Y','N')
- IMAGE_URL — VARCHAR(255)
KD_AUTO_SMS_TEMPLATE
- TEMPLATE_NO — BIGINT — Primary key — NOT NULL
- SMS_CATEGORY — ENUM('MEMBER','ORDER','GIFT','INQUIRY')
- SMS_TYPE — ENUM(...)
- USE_YN — ENUM('Y','N')
- SMS_TITLE — VARCHAR(100)
- SMS_CONTENT — VARCHAR(1000)
- DELETE_YN — ENUM('Y','N')
- REGISTER_CODE — VARCHAR(20)
- REGISTE_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_BEHAVIOR_HISTORY
- BEHAVIOR_HISTORY_ID — VARCHAR(30) — Primary key — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- CARRIER_TYPE — ENUM('KT','SKT','LGU','KTM','SKM','LGM')
- PHONE — VARCHAR(100)
- CLIENT_ID — VARCHAR(30)
- BEHAVIOR_TYPE — ENUM(...)
- PAGE_CODE — VARCHAR(30)
- STAY_SECONDS — INT
- PRODUCT_NO — INT
- CATEGORY1_NO — INT
- CATEGORY2_NO — INT
- CATEGORY3_NO — INT
- CATEGORY4_NO — INT
- OPTION_NO — INT
- OPTION_CNT — INT
- GRADE_POINT — INT
- COUPON_NO — INT
- COUPON_ISSUE_NO — INT
- COUPON_END_YMDT — DATETIME
- CREATE_DT — DATETIME
- SEARCH_WORD — VARCHAR(100)
- SEARCH_RESULT_CNT — INT
- CONNECT_TYPE — ENUM('APP','WEB')
- PHONE_OS — ENUM('ANDROID','IOS','OTHER')
- SEARCH_TYPE — ENUM('DIRECT','RECENT','RAPID')
- DISPLAY_CATEGORY — VARCHAR(100)
- R_ID — VARCHAR(100)
- C_ID — VARCHAR(100)
- REFERER — VARCHAR(100)
- UTM_SOURCE — VARCHAR(100)
- UTM_MEDIUM — VARCHAR(100)
- UTM_CAMPAIGN — VARCHAR(100)
- UTM_CONTENT — VARCHAR(100)
- UTM_TERM — VARCHAR(100)
KD_BEHAVIOR_STAT
- STAT_NO — BIGINT — Primary key — NOT NULL
- CREATE_DATE — DATE
- CUST_CI — VARCHAR(100)
- CUST_ID — VARCHAR(30) — NOT NULL
- SHOPBY_CUST_NO — VARCHAR(10)
- CUST_NM — VARCHAR(100)
- CARRIER_TYPE — ENUM('KT','SKT','LGT',KTM','SKM','LGM')
- GRADE_NM — VARCHAR(200)
- CUST_GROUP — VARCHAR(200)
- REGIST_DT — DATETIME
- RESIGN_DT — DATETIME
- CONNECT_TYPE — ENUM('APP','WEB')
- PHONE_OS — ENUM('ANDROID','IOS','OTHER')
- APP_INFO_RECEIVE_YN — ENUM('Y','N')
- APP_INFO_RECEIVE_DT — DATETIME
- APP_BENEFIT_RECEIVE_YN — ENUM('Y','N')
- APP_BENEFIT_RECEIVE_DT — DATETIME
- MKT_RECEIVE_YN — ENUM('Y','N')
- MKT_RECEIVE_DT — DATETIME
- SUBSCRIBE_YN — ENUM('Y','N')
- SUBSCRIBE_DT — DATETIME
- UNSUBSCRIBE_DT — DATETIME
- SUBSCRIBE_CHANNEL — VARCHAR(100)
- SUBSCRIBE_PAGE — VARCHAR(100)
- UTM_MEDIUM — VARCHAR(100)
- FIRST_BUY_DT — DATETIME
- FIRST_VISIT_PAGE — VARCHAR(100)
- FIRST_CLICK_PAGE — VARCHAR(100)
- LAST_VISIT_PAGE — VARCHAR(100)
- VISIT_PAGE_CNT — INT
- TOTAL_STAY_SEC — INT
- STAY_SEC — INT
- RECENT_VISIT_PRODUCT_NO — INT
- DISPLAY_CATEGORY — VARCHAR(100)
- LIKE_CNT — INT
- REVIEW_CNT — INT
- COUPON_ISSUE_CNT — INT
- CART_CNT — INT
- SEARCH_TYPE — VARCHAR(50)
- SEARCH_CNT — INT
- SEARCH_WORD1 — VARCHAR(50)
- SEARCH_WORD2 — VARCHAR(50)
- SEARCH_WORD3 — VARCHAR(50)
- SEARCH_WORD4 — VARCHAR(50)
- SEARCH_WORD5 — VARCHAR(50)
- SEARCH_WORD6 — VARCHAR(50)
- SEARCH_WORD7 — VARCHAR(50)
- SEARCH_WORD8 — VARCHAR(50)
- SEARCH_WORD9 — VARCHAR(50)
- SEARCH_WORD10 — VARCHAR(50)
- ORDER_CNT — INT
- ORDER_AMT — LONG
- PAY_CNT — INT
- PAY_AMT — LONG
- CANCEL_CNT — INT
- CANCEL_AMT — LONG
- DISCOUNT_CNT — INT
- DISCOUNT_AMT — LONG
- GIFT_CNT — INT
- GIFT_AMT — LONG
- … +2
KD_BUY_PRODUCT
- BUY_PRODUCT_ID — VARCHAR(30) — Primary key — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- PRODUCT_NO — BIGINT
- BUY_CNT — INTEGER
KD_CATEGORY_CODE
- CATEGORY_NO — INT — Primary key — NOT NULL
- DEPTH — INT
- CATEGORY1 — INT
- NAME1 — VARCHAR(50)
- CATEGORY2 — INT
- NAME2 — VARCHAR(50)
- CATEGORY3 — INT
- NAME3 — VARCHAR(50)
- CATEGORY4 — INT
- NAME4 — VARCHAR(50)
- ADULT_YN — ENUM('Y','N')
- SENT_YN — ENUM('Y','N')
- REG_DT — DATETIME
KD_COUPON
- COUPON_NO — INT — Primary key — NOT NULL
- COUPON_NM — VARCHAR(100)
- COUPON_TYPE — VARCHAR(30)
- ISSUE_TYPE — VARCHAR(30)
- MIN_SALE_PRICE — INT
- MAX_SALE_PRICE — INT
- FIXED_YN — ENUM('Y','N')
- DISCOUNT — INT
- MAX_DISCOUNT_AMT — INT
- ISSUE_LIMIT_CNT — INT
- TOTAL_ISSUE_CNT — INT
- TOTAL_ISSUE_CNT_BY_ADMIN — INT
- TOTAL_USE_CNT — INT
- ISSUE_START_DT — DATETIME
- ISSUE_END_DT — DATETIME
- REGIST_DT — DATETIME
- UPDATE_DT — DATETIME
- COUPON_STATUS_TYPE — VARCHAR(30)
- PROMOTION_CODE — VARCHAR(20)
- SENT_YN — ENUM('Y','N')
- REASON — VARCHAR(200)
KD_COUPON_HISTORY
- HISTORY_NO — BIGINT — Primary key — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- COUPON_NO — INT
- COUPON_ISSUE_NO — INT
- SYSTEM_ISSUE_YN — ENUM('Y','N')
- ISSUE_DT — DATETIME
- EXPIRE_DT — DATETIME
- COUPON_USE_YN — ENUM('Y','N')
- ORDER_NO — VARCHAR(30)
- USE_DT — DATETIME
- DISCOUNT_AMT — INT
- CANCEL_DT — DATETIME
KD_CUST
- CUST_ID — VARCHAR(30) — Primary key — NOT NULL
- CONNECT_TYPE — ENUM('APP','WEB')
- GRADE_NO — INTEGER
- GRADE_NM — VARCHAR(20)
- SHOPBY_CUST_NO — VARCHAR(10)
- CUST_NM — VARCHAR(100)
- CUST_PHONE — VARCHAR(100)
- CUST_EMAIL — VARCHAR(100)
- STATUS — ENUM('ACTIVE','IDLE','RESIGN')
- CARRIER_TYPE — ENUM('KT','SKT','LGT',KTM','SKM','LGM')
- SUBSCRIBE_YN — ENUM('Y','N')
- SUBSCRIBE_DT — DATETIME
- UNSUBSCRIBE_DT — DATETIME
- MKT_RECEIVE_YN — ENUM('Y','N')
- MKT_RECEIVE_DT — DATETIME
- AD_RECEIVE_YN — ENUM('Y','N')
- AD_RECEIVE_DT — DATETIME
- PUSH_RECEIVE_YN — ENUM('Y','N')
- PUSH_RECEIVE_DT — DATETIME
- INFO_AGREE_YN — ENUM('Y','N')
- INFO_AGREE_DT — DATETIME
- APP_INFO_RECEIVE_YN — ENUM('Y','N')
- APP_INFO_RECEIVE_DT — DATETIME
- APP_BENEFIT_RECEIVE_YN — ENUM('Y','N')
- APP_BENEFIT_RECEIVE_DT — DATETIME
- FCM_TOKEN — VARCHAR(5000)
- LAST_CONN_DT — DATETIME
- FIRST_BUY_DT — DATETIME
- LAST_BUY_DT — DATETIME
- UPDATE_DT — DATETIME
- IDLE_DT — DATETIME
- RESIGN_DT — DATETIME
- RESIGN_REASON — VARCHAR(1000)
- REGIST_DT — DATETIME
- CUST_BIRTH_MMDD — VARCHAR(20)
- AD_SMS_SEND_DT — DATETIME
- CUST_GROUP_ID — varchar(25)
- CUST_LEVEL_ID — varchar(25)
- CLIENT_LEVEL — varchar(20)
- CLIENT_GROUP — varchar(20)
- UPDATER_CODE — varchar(50)
- SUBSCRIBE_CHANNEL — VARCHAR(100)
- SUBSCRIBE_PAGE — VARCHAR(100)
- REFERER_CHANNEL — VARCHAR(100)
KD_CUST_AUTH_HISTORY
- UUID — varchar(50) — Primary key — NOT NULL
- REGIST_DT — datetime
- UPDATE_DT — datetime
- CI — varchar(200) — NOT NULL
- CUST_BIRTH — varchar(100) — NOT NULL
- CUST_GENDER — enum('MALE','FEMALE','UNKNOWN') — NOT NULL
- CUST_NM — varchar(100) — NOT NULL
- CUST_PHONE — varchar(100) — NOT NULL
- CUST_NEW — enum('Y','N') — NOT NULL
- CARRIER_TYPE — enum('KTF','SKT','LGT','SKM','KTM','LGM','OTHER') — NOT NULL
KD_CUST_HISTORY
- HISTORY_NO — BIGINT — Primary key — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- CUST_LEVEL_ID — VARCHAR(30) — NOT NULL
- CUST_GROUP_ID — VARCHAR(30) — NOT NULL
- CUST_NM — VARCHAR(100)
- CUST_PHONE — VARCHAR(100)
- STATUS — ENUM('ACTIVE','IDLE','RESIGN')
- CARRIER_TYPE — ENUM('KT','SKT','LGU','OTHER')
- CUST_CI — VARCHAR(100)
- CUST_BIRTH — VARCHAR(100)
- CUST_GENDER — ENUM('MALE'','FEMALE','UNKNOWN')
KD_GIFT
- GIFT_ID — VARCHAR(30) — Primary key — NOT NULL
- SENDER_ID — VARCHAR(30) — NOT NULL
- RECEIVER_PHONE — (암호화)`
- RECEIVER_NM — (암호화)`
- RECEIVER_ID — VARCHAR(30)
- STATUS — ENUM('INIT','WAITING",'ACCEPT','REFUSE', 'EXPIRE', 'CANCELED')
KD_GIFT_OPTION
- GIFT_OPTION_ID — VARCHAR(30) — Primary key — NOT NULL
- GIFT_PRODUCT_ID — VARCHAR(20) — NOT NULL
- SHOPBY_OPTION_CD — VARCHAR(30)
- QUANTITY — INT
- PRICE — INT
- OPTION_INFO — (size:M|color:blue)`
KD_GIFT_PRODUCT
- GIFT_PRODUCT_ID — VARCHAR(30) — Primary key — NOT NULL
- GIFT_ID — VARCHAR(30) — NOT NULL
- SHOPBY_PRODUCT_CD — VARCHAR(30)
- QUANTITY — INT
- PRICE — INT
- PRODUCT_NM — VARCHAR(255)
- IMAGE_URL — VARCHAR(255)
- GIFT_ID2 — VARCHAR(30) — NOT NULL
KD_HOLIDAY_INFO
- HOLIDAY_DATE — DATE — Primary key — NOT NULL
KD_LOGIN_HISTORY
- LOGIN_ID — VARCHAR(50) — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — NOT NULL
- CONNECT_TYPE — ENUM('APP','WEB')
- PHONE_ID — VARCHAR(200)
- CONNECT_IP — VARCHAR(100)
- LOGIN_DT — DATETIME
KD_LOG_CENTER
- LOGTIM — VARCHAR(30) — Primary key — NOT NULL
- SEQ — BIGINT — Primary key — NOT NULL
- SYS_ID — VARCHAR(10)
- USER_ID — VARCHAR(20)
- USER_NM — VARCHAR(50)
- ORG_NM — VARCHAR(200)
- USER_IP — VARCHAR(20)
- CUST_ID — VARCHAR(30)
- DEAL_DTM2 — VARCHAR(30)
- RTRV_MENU — VARCHAR(100)
- RTRV_TYPE_NM — VARCHAR(20)
- MULTI_LOG_TYPE — VARCHAR(10)
- MULTI_LOG_PARAM — VARCHAR(500)
- RTRV_CAUS_NM — VARCHAR(500)
- CHECKSUM — VARCHAR(100)
KD_META_CODE
- SEQ — BIGINT — Primary key — NOT NULL
- CODE_GROUP — ENUM('benefitType','couponType','inquiryType','memberStatus') — NOT NULL
- CODE — VARCHAR(10)
- CODE_NM — VARCHAR(50)
- SENT_YN — ENUM('Y','N')
- REG_DT — DATETIME
KD_MKT_DETAIL
- MKT_DETAIL_ID — VARCHAR(30) — Primary key — NOT NULL
- MKT_NO — BIGINT — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- SEND_DT — DATETIME
- SEND_SUCCESS_YN — ENUM('Y','N')
- OPEN_DT — DATETIME
- CARRIER_TYPE — ENUM('KT','SKT','LGT',KTM','SKM','LGM')
KD_MKT_TEMPLATE
- MKT_NO — BIGINT — Primary key — NOT NULL
- MKT_TYPE — ENUM('BENEFIT','EVENT','NOTICE','OTHER')
- TYPE_OTHER — VARCHAR(100)
- SEND_TYPE — ENUM('ALL','PUSH','LMS')
- TITLE — VARCHAR(100)
- PUSH_CONTENT — VARCHAR(200)
- LMS_CONTENT — VARCHAR(2000)
- IMG_TARGET — ENUM('ALL','PUSH','LMS')
- IMG_FILE_URL — VARCHAR(500)
- PUSH_LANDING_URL — VARCHAR(500)
- SEND_METHOD — ENUM('AUTO','MANUAL')
- SEND_REGISTER_CODE — VARCHAR(20)
- SEND_REGIST_DT — DATETIME
- SEND_DT — DATETIME
- STATUS — ENUM('READY','RESERVED','SENT')
- DELETE_YN — ENUM('Y','N')
- SENT_CNT — INT
- FAIL_CNT — INT
- OPEN_CNT — INT
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_ORDER_HISTORY
- ORDER_HISTORY_ID — VARCHAR(30) — Primary key — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- SHOP_BY_ORDER_NO — VARCHAR(30)
- GIFT_YN — ENUM('Y','N')
- CARRIER_TYPE — ENUM('KT','SKT','LGU','KTM','SKM','LGM')
- PHONE — VARCHAR(100)
- PRODUCT_NO — INT
- PRODUCT_NM — VARCHAR(300)
- SALE_PRICE — INT
- IMMEDIATE_DISCOUNT_AMT — INT
- ADJUSTED_AMT — INT
- OPTION_ORDER_NO — INT
- OPTION_NO — INT
- OPTION_NM — VARCHAR(100)
- OPTION_PRICE — INT
- OPTION_CNT — INT
- ORDER_STATUS — VARCHAR(30)
- DELIVERY_NO — INT
- DELIVERY_AMT — INT
- REMOTE_DELIVERY_AMT — INT
- TOTAL_ORDER_AMT — INT
- COUPON_NO — INT
- COUPON_DISCOUNT_AMT — INT
- PAY_AMT — INT
- PAY_TYPE — VARCHAR(20)
- STATUS_CHANGE_DT — DATETIME
- ORDER_DT — DATETIME
- PAY_DT — DATETIME
- CANCEL_DT — DATETIME
- DELIVERY_READY_DT — DATETIME
- DELIVERY_START_DT — DATETIME
- DELIVERY_END_DT — DATETIME
- BUY_CONFIRM_DT — DATETIME
- RECEIVER_NAME — VARCHAR(100)
- RECEIVER_CONTACT — VARCHAR(100)
- RECEIVER_ADDRESS — VARCHAR(1000)
- RECEIVER_ZIP_CD — VARCHAR(6)
- DELIVERY_TYPE — VARCHAR(30)
- PAYMENT_EXPIRATION_DT — DATETIME
- COMMISSION_RATE — INT
- PARTNER_NM — VARCHAR(30)
- CONNECT_TYPE — ENUM('APP','WEB')
- PHONE_OS — ENUM('ANDROID','IOS','OTHER')
- SEARCH_TYPE — ENUM('DIRECT','RECENT','RAPID')
- R_ID — VARCHAR(100)
- C_ID — VARCHAR(100)
- REFERER — VARCHAR(100)
- UTM_SOURCE — VARCHAR(100)
- UTM_MEDIUM — VARCHAR(100)
- UTM_CAMPAIGN — VARCHAR(100)
- UTM_CONTENT — VARCHAR(100)
- UTM_TERM — VARCHAR(100)
KD_PARTNER
- PARTNER_NO — INT — Primary key — NOT NULL
- PARTNER_NM — VARCHAR(100)
- USE_YN — ENUM('Y','N')
- LEVEL — ENUM('S','A','B','C','D')
- SENT_YN — ENUM('Y','N')
- START_DT — DATETIME
- UPDATE_DT — DATETIME
KD_PARTNER_ASSESS
- ASSESS_NO — VARCHAR(10) — Primary key — NOT NULL
- PARTNER_NO — INT — NOT NULL
- YEAR — VARCHAR(4)
- MONTH — VARCHAR(2)
- AVG_RATE — DOUBLE
- TOTAL_SCORE — DOUBLE
- LEVEL — ENUM('S','A','B','C','D')
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
- ASSESS_CODE — VARCHAR(10) — NOT NULL
KD_PARTNER_ASSESS_INDICATOR
- ASSESS_CODE — VARCHAR(10) — Primary key — NOT NULL
- APPLY_DATE — DATE
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_PARTNER_ASSESS_INDICATOR_ITEM
- ASSESS_NO — BIGINT — Primary key — NOT NULL
- ASSESS_CODE — VARCHAR(10) — NOT NULL
- ACTIVE_YN — ENUM('Y','N')
- PERIOD_TYPE — ENUM('MONTH','QUARTER','HALF','YEAR')
- ASSESS_ITEM_TYPE — ENUM(...)
- INDICATE_VALUE — DOUBLE
- UNIT — VARCHAR(3)
- RATE — DOUBLE
- TITLE — VARCHAR(100)
- REMARK — TEXT
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_PARTNER_ASSESS_ITEM
- ASSESS_ITEM_NO — BIGINT — Primary key — NOT NULL
- ASSESS_NO — VARCHAR(10) — NOT NULL
- ASSESS_ITEM_TYPE — ENUM
- TITLE — VARCHAR(100)
- PERIOD_TYPE — ENUM
- INDICATOR_VALUE — DOUBLE
- RATE — DOUBLE
- PERFORM_VALUE — DOUBLE
- PERFORM_RATE — DOUBLE
- SCORE — DOUBLE
- REMARK — TEXT
- REGISTER_CODE — VARCHAR(20)
- REGIST_DT — DATETIME
- UPDATER_CODE — VARCHAR(20)
- UPDATE_DT — DATETIME
KD_PRIVATE_INFO_HISTORY
- HISTORY_NO — BIGINT — Primary key — NOT NULL
- ADMIN_CODE — VARCHAR(20) — NOT NULL
- MENU_NAME — VARCHAR(50)
- CLIENT_IP — VARCHAR(20)
- URL — VARCHAR(1000)
- TASK — ENUM('C','R','U','E')
- MASS_TYPE — ENUM('S','M')
- MASS_CNT — INT
- FILE_NAME — VARCHAR(100)
- TASK_REASON — VARCHAR(100)
- CREATE_DT — DATETIME
KD_PRODUCT
- PRODUCT_NO — INT — Primary key — NOT NULL
- PARTNER_NO — INT
- CATEGORY_NO — INT
- CATEGORY1 — INT
- CATEGORY2 — INT
- CATEGORY3 — INT
- CATEGORY4 — INT
- PRODUCT_NM — VARCHAR(300)
- BRAND_NM — VARCHAR(100)
- PARTNER_NM — VARCHAR(100)
- SALE_START_DT — DATETIME
- SALE_END_DT — DATETIME
- REGIST_DT — DATETIME
- UPDATE_DT — DATETIME
- SALE_PRICE — INT
- IMMEDIATE_DISCOUNT_AMT — INT
- DELIVERY_FEE — INT
- IMG_URL — VARCHAR(500)
- SENT_YN — ENUM('Y','N')
KD_PRODUCT_OPTION
- OPTION_NO — INT — Primary key — NOT NULL
- PRODUCT_NO — INT — NOT NULL
- OPTION_NM — VARCHAR(200)
- ADD_PRICE — INT
- DELETE_YN — ENUM('Y','N')
- REGIST_DT — DATETIME
- UPDATE_DT — DATETIME
- SENT_YN — ENUM('Y','N')
KD_SEARCH_HISTORY
- SEARCH_HISTORY_ID — VARCHAR(30) — Primary key — NOT NULL
- CUST_ID — VARCHAR(30) — NOT NULL
- SEARCH_WORD — VARCHAR(100)
- SEARCH_DT — DATETIME
- DELETE_YN — ENUM('Y','N')
- SEARCH_RESULT_CNT — INT