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)