dashboard

Tables (5)

L1_JOB (Untitled)

  • JOB_ID (업무아이디) — Primary key — NOT NULL
  • JOB_CN (업무내용)

L2_CATEGORY (Untitled2)

  • CATEGORY_ID (카테고리아이디) — Primary key — NOT NULL
  • JOB_ID (업무아이디) — Foreign key → L1_JOB.JOB_ID — NOT NULL
  • CATEGORY_CN (카테고리내용)

L3_GROUP (Untitled3)

  • GROUP_ID (그룹아이디) — Primary key — NOT NULL
  • CATEGORY_ID (카테고리아이디) — Foreign key → L2_CATEGORY.CATEGORY_ID — NOT NULL
  • JOB_ID (업무아이디) — Foreign key → L2_CATEGORY.JOB_ID — NOT NULL
  • GROUP_CN (그룹내용)

L4_TASK (Untitled4)

  • TASK_ID (과업아이디) — Primary key — NOT NULL
  • GROUP_ID (그룹아이디) — Foreign key → L3_GROUP.GROUP_ID — NOT NULL
  • CATEGORY_ID (카테고리아이디) — Foreign key → L3_GROUP.CATEGORY_ID — NOT NULL
  • JOB_ID (업무아이디) — Foreign key → L3_GROUP.JOB_ID — NOT NULL
  • TASK_CN (과업내용)
  • PLAN_BGNG_YMD (계획시작일)
  • PLAN_CMPTN_YMD (계획완료일)
  • PLAN_PD (계획일수)
  • EXCN_BGNG_YMD (실행시작일)
  • EXCN_CMPTN_YMD (실행완료일)
  • BNGN_YN (시작여부)
  • PL_APRV_YN (PL승인여부)
  • PM_APRV_YN (PM승인여부)
  • KLID_APRV_YN (개발원승인여부)
  • INPT_YN (직접입력여부)
  • BNGN_DT (시작일시)
  • PL_APRV_DT (PL승인일시)
  • PM_APRV_DT (PM승인일시)
  • KLID_APRV_DT (개발원승인일시)
  • INPT_DT (직접입력일시)

MSG (Untitled5)

  • MSG_SN (메시지일련번호) — Primary key — NOT NULL
  • MSG_CN (메시지내용)
  • MSG_REG_DT (메시지등록일시)