데이터 가공&분석/PostgreSQL
2. 체크리스트 사례기반 json데이터 가공 및 활용 - PostgreSQL
피부과 코딩네이터
2024. 5. 11. 11:58
- 체크리스트 JSON 데이터 양식 (스크롤로 넘기세요)
[
{
"firstno": 1,
"seconde": [
{
"v_third": [
{
"id": "a10101",
"repeat": "N",
"thirdname": "성명",
"v_thirdno": 1,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a10102",
"repeat": "N",
"thirdname": "신장",
"v_thirdno": 2,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "cm",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "NUMBER",
"propertiesno": "1"
}
]
},
{
"id": "a10103",
"repeat": "N",
"thirdname": "생년월일",
"v_thirdno": 3,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "DATE",
"propertiesno": "1"
}
]
},
{
"id": "a10104",
"repeat": "N",
"thirdname": "성별",
"v_thirdno": 4,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "a010105",
"radioname": "남성",
"valuetype": "RADIO",
"propertiesno": "1"
},
{
"check": "FALSE",
"event": "Y",
"label": "",
"value": "",
"enable": "a010105|a010106",
"disable": "",
"radioname": "여성",
"valuetype": "RADIO",
"propertiesno": "2"
}
]
},
{
"id": "a10105",
"repeat": "N",
"thirdname": "군필여부",
"v_thirdno": 5,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "a010106",
"radioname": "필",
"valuetype": "RADIO",
"propertiesno": "1"
},
{
"check": "FALSE",
"event": "Y",
"label": "",
"value": "",
"enable": "a010106",
"disable": "",
"radioname": "미필",
"valuetype": "RADIO",
"propertiesno": "2"
}
]
},
{
"id": "a10106",
"repeat": "N",
"thirdname": "군별",
"v_thirdno": 6,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "육군|해군|공군|해병|기타",
"valuetype": "SELECT",
"propertiesno": "1"
}
]
}
],
"secondeno": 1,
"secondename": "지원자 기본정보"
},
{
"v_third": [
{
"id": "a10201",
"repeat": "N",
"thirdname": "보유여부",
"v_thirdno": 1,
"properties": [
{
"check": "FALSE",
"event": "Y",
"label": "",
"value": "",
"enable": "a010205",
"disable": "a010202|a010203|a010204",
"radioname": "보유",
"valuetype": "RADIO",
"propertiesno": "1"
},
{
"check": "FALSE",
"event": "Y",
"label": "",
"value": "",
"enable": "a010202|a010203|a010204",
"disable": "a010205",
"radioname": "미보유",
"valuetype": "RADIO",
"propertiesno": "2"
}
]
},
{
"id": "a10202",
"repeat": "N",
"thirdname": "TOEIC 점수",
"v_thirdno": 2,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "900 이상",
"valuetype": "RADIO",
"propertiesno": "1"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "800 이상",
"valuetype": "RADIO",
"propertiesno": "2"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "700 이상",
"valuetype": "RADIO",
"propertiesno": "3"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "600 이상",
"valuetype": "RADIO",
"propertiesno": "4"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "600 미만",
"valuetype": "RADIO",
"propertiesno": "5"
}
]
},
{
"id": "a10203",
"repeat": "N",
"thirdname": "시험응시 학교",
"v_thirdno": 3,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "DATE",
"propertiesno": "1"
}
]
},
{
"id": "a10204",
"repeat": "N",
"thirdname": "시험응시 일자",
"v_thirdno": 4,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a10205",
"repeat": "N",
"thirdname": "미보유 사유",
"v_thirdno": 5,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
}
],
"secondeno": 2,
"secondename": "TOEIC 성적"
},
{
"v_third": [
{
"id": "a10301",
"repeat": "Y",
"thirdname": "보유여부",
"v_thirdno": 1,
"properties": [
{
"check": "FALSE",
"event": "Y",
"label": "",
"value": "",
"enable": "a010305",
"disable": "a010302|a010303|a010304",
"radioname": "보유",
"valuetype": "RADIO",
"propertiesno": "1"
},
{
"check": "FALSE",
"event": "Y",
"label": "",
"value": "",
"enable": "a010302|a010303|a010304",
"disable": "a010305",
"radioname": "미보유",
"valuetype": "RADIO",
"propertiesno": "2"
}
]
},
{
"id": "a10302",
"repeat": "Y",
"thirdname": "자격증명",
"v_thirdno": 2,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a10303",
"repeat": "Y",
"thirdname": "취득일자",
"v_thirdno": 3,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "DATE",
"propertiesno": "1"
}
]
},
{
"id": "a10304",
"repeat": "Y",
"thirdname": "발급기관",
"v_thirdno": 4,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a10305",
"repeat": "Y",
"thirdname": "미보유 사유",
"v_thirdno": 5,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
}
],
"secondeno": 3,
"secondename": "보유 자격"
}
],
"firstcode": "01",
"firstname": "지원자 인적사항"
},
{
"firstno": 2,
"seconde": [
{
"v_third": [
{
"id": "a20101",
"repeat": "N",
"thirdname": "PL 경험",
"v_thirdno": 1,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "보유",
"valuetype": "RADIO",
"propertiesno": "1"
}
]
},
{
"id": "a20102",
"repeat": "N",
"thirdname": "개발자 등급",
"v_thirdno": 2,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "미보유",
"valuetype": "RADIO",
"propertiesno": "2"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "A",
"valuetype": "RADIO",
"propertiesno": "1"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "B",
"valuetype": "RADIO",
"propertiesno": "2"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "C",
"valuetype": "RADIO",
"propertiesno": "3"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "D",
"valuetype": "RADIO",
"propertiesno": "4"
},
{
"check": "FALSE",
"event": "",
"label": "",
"value": "",
"enable": "",
"disable": "",
"radioname": "등급외",
"valuetype": "RADIO",
"propertiesno": "5"
}
]
}
],
"secondeno": 1,
"secondename": "개발등급"
},
{
"v_third": [
{
"id": "a20201",
"repeat": "N",
"thirdname": "SI",
"v_thirdno": 1,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a20202",
"repeat": "N",
"thirdname": "SM",
"v_thirdno": 2,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a20203",
"repeat": "N",
"thirdname": "서비스",
"v_thirdno": 3,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a20204",
"repeat": "N",
"thirdname": "솔루션",
"v_thirdno": 4,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
}
],
"secondeno": 2,
"secondename": "프론트 경험"
},
{
"v_third": [
{
"id": "a20301",
"repeat": "N",
"thirdname": "SI",
"v_thirdno": 1,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a20302",
"repeat": "N",
"thirdname": "SM",
"v_thirdno": 2,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a20303",
"repeat": "N",
"thirdname": "서비스",
"v_thirdno": 3,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
},
{
"id": "a20304",
"repeat": "N",
"thirdname": "솔루션",
"v_thirdno": 4,
"properties": [
{
"check": "FALSE",
"event": "",
"label": "회",
"value": "",
"enable": "",
"disable": "",
"radioname": "",
"valuetype": "TEXT",
"propertiesno": "1"
}
]
}
],
"secondeno": 3,
"secondename": "백엔드 경험"
}
],
"firstcode": "02",
"firstname": "개발자 역량 적정성"
}
]
