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 (메시지등록일시)