코드 리스트
GET {{baseUrl}}/api/v1/common/getCodeList
공통 코드 리스트를 불러옵니다.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
table_name | string | ||
column_name | string | ||
use_yn | string |
RESPONSES
status: OK
{"result":[{"code_nm":"20-24","use_yn":"Y","column_name":"age","row_num":59,"totalCount":87,"table_name":"audience_master","code_id":"C"},{"code_nm":"35-39","use_yn":"Y","column_name":"age","row_num":11,"totalCount":87,"table_name":"audience_master","code_id":"F"},{"code_nm":"15-19","use_yn":"Y","column_name":"age","row_num":75,"totalCount":87,"table_name":"audience_master","code_id":"B"},{"code_nm":"30-34","use_yn":"Y","column_name":"age","row_num":27,"totalCount":87,"table_name":"audience_master","code_id":"E"},{"code_nm":"25-29","use_yn":"Y","column_name":"age","row_num":43,"totalCount":87,"table_name":"audience_master","code_id":"D"},{"code_nm":"전체","use_yn":"Y","column_name":"age","row_num":5,"totalCount":87,"table_name":"audience_master","code_id":"A"},{"code_nm":"40-44","use_yn":"Y","column_name":"age","row_num":82,"totalCount":87,"table_name":"audience_master","code_id":"G"},{"code_nm":"65이상","use_yn":"Y","column_name":"age","row_num":87,"totalCount":87,"table_name":"audience_master","code_id":"L"},{"code_nm":"45-49","use_yn":"Y","column_name":"age","row_num":65,"totalCount":87,"table_name":"audience_master","code_id":"H"},{"code_nm":"60-64","use_yn":"Y","column_name":"age","row_num":17,"totalCount":87,"table_name":"audience_master","code_id":"K"},{"code_nm":"55-59","use_yn":"Y","column_name":"age","row_num":33,"totalCount":87,"table_name":"audience_master","code_id":"J"},{"code_nm":"50-54","use_yn":"Y","column_name":"age","row_num":49,"totalCount":87,"table_name":"audience_master","code_id":"I"},{"code_nm":"전체","use_yn":"Y","column_name":"class","row_num":70,"totalCount":87,"table_name":"audience_master","code_id":"A"},{"code_nm":"2등급","use_yn":"Y","column_name":"class","row_num":38,"totalCount":87,"table_name":"audience_master","code_id":"C"},{"code_nm":"1등급","use_yn":"Y","column_name":"class","row_num":54,"totalCount":87,"table_name":"audience_master","code_id":"B"},{"code_nm":"갱신없음","use_yn":"Y","column_name":"renewal_cycle_condition","row_num":71,"totalCount":87,"table_name":"audience_master","code_id":"NONE"},{"code_nm":"1주일마다","use_yn":"Y","column_name":"renewal_cycle_condition","row_num":55,"totalCount":87,"table_name":"audience_master","code_id":"WEEK"},{"code_nm":"1개월마다","use_yn":"Y","column_name":"renewal_cycle_condition","row_num":1,"totalCount":87,"table_name":"audience_master","code_id":"MONTH"},{"code_nm":"1일마다","use_yn":"Y","column_name":"renewal_cycle_condition","row_num":22,"totalCount":87,"table_name":"audience_master","code_id":"1DAY"},{"code_nm":"남성","use_yn":"Y","column_name":"sex","row_num":7,"totalCount":87,"table_name":"audience_master","code_id":"MALE"},{"code_nm":"여성","use_yn":"Y","column_name":"sex","row_num":23,"totalCount":87,"table_name":"audience_master","code_id":"FEMALE"},{"code_nm":"전체","use_yn":"Y","column_name":"sex","row_num":39,"totalCount":87,"table_name":"audience_master","code_id":"ALL"},{"code_nm":"신규 회원 제외","use_yn":"Y","column_name":"sign_up_code","row_num":62,"totalCount":87,"table_name":"audience_master","code_id":"EXCEPT_NEW"},{"code_nm":"전체","use_yn":"Y","column_name":"sign_up_code","row_num":78,"totalCount":87,"table_name":"audience_master","code_id":"ALL"},{"code_nm":"가입 기간 설정","use_yn":"Y","column_name":"sign_up_code","row_num":30,"totalCount":87,"table_name":"audience_master","code_id":"PERIOD"},{"code_nm":"신규 회원만","use_yn":"Y","column_name":"sign_up_code","row_num":46,"totalCount":87,"table_name":"audience_master","code_id":"NEW"},{"code_nm":"이미지","use_yn":"Y","column_name":"add_content","row_num":84,"totalCount":87,"table_name":"campaign_channel","code_id":"IMAGE"},{"code_nm":"버튼","use_yn":"Y","column_name":"add_content","row_num":14,"totalCount":87,"table_name":"campaign_channel","code_id":"BUTTON"},{"code_nm":"이미지+버튼","use_yn":"Y","column_name":"add_content","row_num":67,"totalCount":87,"table_name":"campaign_channel","code_id":"IMAGE_BUTTON"},{"code_nm":"팝업을 클릭할 때 까지 반복 노출","use_yn":"Y","column_name":"exposure_count","row_num":35,"totalCount":87,"table_name":"campaign_channel","code_id":"POPUP_CLICK"},{"code_nm":"1번만 노출","use_yn":"Y","column_name":"exposure_count","row_num":51,"totalCount":87,"table_name":"campaign_channel","code_id":"ONE"},{"code_nm":"상단","use_yn":"Y","column_name":"exposure_position","row_num":73,"totalCount":87,"table_name":"campaign_channel","code_id":"TOP"},{"code_nm":"하단","use_yn":"Y","column_name":"exposure_position","row_num":19,"totalCount":87,"table_name":"campaign_channel","code_id":"BOTTOM"},{"code_nm":"페이지 중간","use_yn":"Y","column_name":"exposure_position","row_num":3,"totalCount":87,"table_name":"campaign_channel","code_id":"MIDDLE"},{"code_nm":"페이지 선택","use_yn":"Y","column_name":"exposure_screen","row_num":80,"totalCount":87,"table_name":"campaign_channel","code_id":"SHOPPING_BASKET"},{"code_nm":"페이지 선택","use_yn":"Y","column_name":"exposure_screen","row_num":57,"totalCount":87,"table_name":"campaign_channel","code_id":""},{"code_nm":"페이지 선택","use_yn":"Y","column_name":"exposure_screen","row_num":9,"totalCount":87,"table_name":"campaign_channel","code_id":"MAIN"},{"code_nm":"페이지 선택","use_yn":"Y","column_name":"exposure_screen","row_num":25,"totalCount":87,"table_name":"campaign_channel","code_id":"JOIN_US"},{"code_nm":"페이지 선택","use_yn":"Y","column_name":"exposure_screen","row_num":41,"totalCount":87,"table_name":"campaign_channel","code_id":"DIRECT_INPUT"},{"code_nm":"페이지 로딩 [] 초 후 노출","use_yn":"Y","column_name":"exposure_timing","row_num":63,"totalCount":87,"table_name":"campaign_channel","code_id":"AFTER_PAGE_LOAD"},{"code_nm":"즉시노출","use_yn":"Y","column_name":"exposure_timing","row_num":31,"totalCount":87,"table_name":"campaign_channel","code_id":"IMMEDIATELY"},{"code_nm":"페이지 [] 회 이동 후 노출","use_yn":"Y","column_name":"exposure_timing","row_num":47,"totalCount":87,"table_name":"campaign_channel","code_id":"AFTER_PAGE_MOVE"},{"code_nm":"로그인한 고객","use_yn":"Y","column_name":"login_status","row_num":85,"totalCount":87,"table_name":"campaign_channel","code_id":"LOGIN"},{"code_nm":"모든 방문자","use_yn":"Y","column_name":"login_status","row_num":15,"totalCount":87,"table_name":"campaign_channel","code_id":"ALL"},{"code_nm":"로그인하지 않은 고객","use_yn":"Y","column_name":"login_status","row_num":68,"totalCount":87,"table_name":"campaign_channel","code_id":"NOT_LOGIN"},{"code_nm":"재방문 고객","use_yn":"Y","column_name":"visit_type","row_num":20,"totalCount":87,"table_name":"campaign_channel","code_id":"NOT_FIRST"},{"code_nm":"첫 방문 고객","use_yn":"Y","column_name":"visit_type","row_num":36,"totalCount":87,"table_name":"campaign_channel","code_id":"FIRST"},{"code_nm":"구분 하지 않음","use_yn":"Y","column_name":"visit_type","row_num":52,"totalCount":87,"table_name":"campaign_channel","code_id":"ALL"},{"code_nm":"분","use_yn":"Y","column_name":"basic_condition_array","row_num":58,"totalCount":87,"table_name":"campaign_master","code_id":"MINUTE"},{"code_nm":"주","use_yn":"Y","column_name":"basic_condition_array","row_num":10,"totalCount":87,"table_name":"campaign_master","code_id":"WEEK"},{"code_nm":"시간","use_yn":"Y","column_name":"basic_condition_array","row_num":74,"totalCount":87,"table_name":"campaign_master","code_id":"HOUR"},{"code_nm":"누적","use_yn":"Y","column_name":"basic_condition_array","row_num":26,"totalCount":87,"table_name":"campaign_master","code_id":"SUM"},{"code_nm":"한번","use_yn":"Y","column_name":"basic_condition_array","row_num":42,"totalCount":87,"table_name":"campaign_master","code_id":"ONCE"},{"code_nm":"일","use_yn":"Y","column_name":"basic_condition_array","row_num":4,"totalCount":87,"table_name":"campaign_master","code_id":"DAY"},{"code_nm":"특정일","use_yn":"Y","column_name":"send_condition_array","row_num":64,"totalCount":87,"table_name":"campaign_master","code_id":"DATETIME"},{"code_nm":"매월","use_yn":"Y","column_name":"send_condition_array","row_num":16,"totalCount":87,"table_name":"campaign_master","code_id":"MONTHLY"},{"code_nm":"월요일","use_yn":"Y","column_name":"send_condition_array","row_num":32,"totalCount":87,"table_name":"campaign_master","code_id":"MONDAY"},{"code_nm":"금요일","use_yn":"Y","column_name":"send_condition_array","row_num":48,"totalCount":87,"table_name":"campaign_master","code_id":"FRIDAY"},{"code_nm":"일요일","use_yn":"Y","column_name":"send_condition_array","row_num":69,"totalCount":87,"table_name":"campaign_master","code_id":"SUNDAY"},{"code_nm":"수요일","use_yn":"Y","column_name":"send_condition_array","row_num":21,"totalCount":87,"table_name":"campaign_master","code_id":"WEDNESDAY "},{"code_nm":"화요일","use_yn":"Y","column_name":"send_condition_array","row_num":37,"totalCount":87,"table_name":"campaign_master","code_id":"TUESDAY"},{"code_nm":"목요일","use_yn":"Y","column_name":"send_condition_array","row_num":53,"totalCount":87,"table_name":"campaign_master","code_id":"THURSDAY"},{"code_nm":"매일","use_yn":"Y","column_name":"send_condition_array","row_num":81,"totalCount":87,"table_name":"campaign_master","code_id":"DAILY"},{"code_nm":"매주","use_yn":"Y","column_name":"send_condition_array","row_num":6,"totalCount":87,"table_name":"campaign_master","code_id":"WEEKLY"},{"code_nm":"토요일","use_yn":"Y","column_name":"send_condition_array","row_num":86,"totalCount":87,"table_name":"campaign_master","code_id":"SATURDAY"},{"code_nm":"완료","use_yn":"Y","column_name":"status","row_num":60,"totalCount":87,"table_name":"campaign_master","code_id":"END"},{"code_nm":"실행중","use_yn":"Y","column_name":"status","row_num":76,"totalCount":87,"table_name":"campaign_master","code_id":"ACT"},{"code_nm":"테스트","use_yn":"Y","column_name":"status","row_num":28,"totalCount":87,"table_name":"campaign_master","code_id":"TEST"},{"code_nm":"대기중","use_yn":"Y","column_name":"status","row_num":44,"totalCount":87,"table_name":"campaign_master","code_id":"STANDBY"},{"code_nm":"시스템 관리자","use_yn":"Y","column_name":"role_id","row_num":61,"totalCount":87,"table_name":"user_master","code_id":"SYSTEM"},{"code_nm":"슈퍼 관리자","use_yn":"Y","column_name":"role_id","row_num":77,"totalCount":87,"table_name":"user_master","code_id":"SUPER"},{"code_nm":"일반 사용자","use_yn":"Y","column_name":"role_id","row_num":12,"totalCount":87,"table_name":"user_master","code_id":"NOMAL"},{"code_nm":"회원 정보","use_yn":"Y","column_name":"category","row_num":83,"totalCount":87,"table_name":"var_text","code_id":"MEMBER_INFO"},{"code_nm":"상품/카테고리","use_yn":"Y","column_name":"category","row_num":13,"totalCount":87,"table_name":"var_text","code_id":"ITEM_CATEGORY"},{"code_nm":"맞춤형 캠페인","use_yn":"Y","column_name":"category","row_num":29,"totalCount":87,"table_name":"var_text","code_id":"CUSTOM_CAMPAIGN"},{"code_nm":"카테고리 전체","use_yn":"Y","column_name":"category","row_num":45,"totalCount":87,"table_name":"var_text","code_id":"ALL"},{"code_nm":"장바구니 유기 상품명","use_yn":"Y","column_name":"var","row_num":79,"totalCount":87,"table_name":"var_text","code_id":"SHOPPING_BASKET_ABANDON_ITEM_NAME"},{"code_nm":"리뷰 작성 필요한 상품명","use_yn":"Y","column_name":"var","row_num":8,"totalCount":87,"table_name":"var_text","code_id":"REVIEW_NEED_ITEM_NAME"},{"code_nm":"이름","use_yn":"Y","column_name":"var","row_num":72,"totalCount":87,"table_name":"var_text","code_id":"NAME"},{"code_nm":"등급 상승까지 남은 포인트 금액","use_yn":"Y","column_name":"var","row_num":24,"totalCount":87,"table_name":"var_text","code_id":"RANK_UP_POINT_AMOUNT"},{"code_nm":"휴먼예정일","use_yn":"Y","column_name":"var","row_num":40,"totalCount":87,"table_name":"var_text","code_id":"QUIESCENCE_EXPECT_DATE"},{"code_nm":"결제 이탈 상품명","use_yn":"Y","column_name":"var","row_num":56,"totalCount":87,"table_name":"var_text","code_id":"PAY_BREAKAWAY_ITEM_NAME"},{"code_nm":"보유 마일리지 금액","use_yn":"Y","column_name":"var","row_num":66,"totalCount":87,"table_name":"var_text","code_id":"HAVE_MILEAGE_AMOUNT"},{"code_nm":"다수 조회 카테고리명","use_yn":"Y","column_name":"var","row_num":18,"totalCount":87,"table_name":"var_text","code_id":"MULTI_INQUIRY_CATEGORY_NAME"},{"code_nm":"회원등급","use_yn":"Y","column_name":"var","row_num":34,"totalCount":87,"table_name":"var_text","code_id":"MEMBER_RANK"},{"code_nm":"보유 포인트 금액","use_yn":"Y","column_name":"var","row_num":50,"totalCount":87,"table_name":"var_text","code_id":"HAVE_POINT_AMOUNT"},{"code_nm":"다수 조회 상품명","use_yn":"Y","column_name":"var","row_num":2,"totalCount":87,"table_name":"var_text","code_id":"MULTI_INQUIRY_ITEM_NAME"}],"count":87,"totalCount":87,"status":200}