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