hico
Tables (7)
TB_CAPA (역량 테이블)
- CAPA_ID (Key) — Primary key — NOT NULL
- POSI_ENUM (Field1)
- CAPA_NM (Field2)
- ORDER_NO (Field3)
- DEL_YN (Field4)
TB_CAPA_ANS (역량 평가 답변 테이블)
- CAPA_ANS_ID (Key) — Primary key — NOT NULL
- CAPA_QUES_ID (Key2) — Foreign key → TB_CAPA_QUES.CAPA_QUES_ID — NOT NULL
- USER_NO (Field)
- CAPA_ANS_CD (Field2)
- DEL_YN (Field3)
TB_CAPA_CNTS (역량-콘텐츠 테이블)
- CAPA_CNTS_ID (Key) — Primary key — NOT NULL
- CAPA_ID (Key2) — Foreign key → TB_CAPA.CAPA_ID — NOT NULL
- CNTS_ID (Key3) — Foreign key → TB_CNTS.CNTS_ID — NOT NULL
- DEL_YN (Field)
TB_CAPA_QUES (역량 평가 문항 테이블)
- CAPA_QUES_ID (Key) — Primary key — NOT NULL
- CAPA_ID (Key2) — Foreign key → TB_CAPA.CAPA_ID — NOT NULL
- CAPA_QUES_TYPE_CD (Field2)
- CAPA_QUES_CNT (Field3)
- DEL_YN (Field4)
TB_CNTS (콘텐츠 테이블)
- CNTS_ID (Key) — Primary key — NOT NULL
- CNTS_URL (Field)
- ...
TB_MODULES (모듈 테이블)
- MODU_ID (Key) — Primary key — NOT NULL
- MODU_TITLE (Field)
- MODU_CONT (Field3)
- Field4
- Field5
- REG_USER_NO (Field2)
TB_MODULES_ITM (모듈 아이템 테이블)
- MODU_ITM_ID (Key) — Primary key — NOT NULL
- MODU_ID (Key2) — Foreign key → TB_MODULES.MODU_ID — NOT NULL
- CNTS_ID (Key3) — Foreign key → TB_CNTS.CNTS_ID — NOT NULL
- ORDER_NO (Field)
- DEL_YN (Field2)