schedular
Tables (12)
ATTENDANTS (참석자)
- ATT_GROUP_INDEX (참석자인덱스) — NUMBER — Primary key — NOT NULL
- SCH_INDEX (일정인덱스) — NUMBER — Foreign key → SCHADUAL.SCH_INDEX — NOT NULL
- FGRADE (직책) — NUMBER
CLASS_GRP (범위 그룹지정)
- SCH_CLASS_GROUPID (범위그룹ID) — NUMBER — Primary key — NOT NULL
- SCH_CLASS_GROUPNM (범위그룹명) — VAR2
CTGR_GRP (범주 선택자)
- CATEGORY_INDEX (범주 인덱스) — NUMBER — Primary key — NOT NULL
- CATEGORY_NAME (범주명) — VAR2
DEPT (부서)
- DEPT_CO (부서코드) — NUMBER — Primary key — NOT NULL
- DEPT_NM (부서명) — NUMBER
DETAIL_SCH (Untitled)
- detail_sch_index (디테일인덱스) — NUMBER — Primary key — NOT NULL
- SCH_INDEX (인덱스) — NUMBER — Foreign key → SCHADUAL.SCH_INDEX — NOT NULL
- DETAIL_SCH_START_DT (시작날짜) — DATE
- DETAIL_SCH_END_DT (종료날짜) — DATE
EMPLOYEE (가장 중심)
- EMP_NO (급여번호) — NUMBER — Primary key — NOT NULL
- EMP_NM (성명) — NUMBER
- EMP_MAIL (이메일) — VAR2
- DEPT_CO (부서코드) — NUMBER — Foreign key → DEPT.DEPT_CO — NOT NULL
- FGRADE (직책) — VAR2
NOTICES (알림)
- NOTICE_ID (인덱스) — NUMBER — Primary key — NOT NULL
- SCH_INDEX (일정인덱스) — NUMBER — Foreign key → SCHADUAL.SCH_INDEX — NOT NULL
- NOTICE_MAIL (메일) — VAR2
- NOTICE_POPUP (팝업) — VAR2
- NOTICE_SMS (문자) — VAR2
- NOTICE_MSG (내부메신저) — VAR2
- NOTICE_CONT (알림시간) — VAR2
SCHADUAL (일정)
- SCH_INDEX (인덱스) — NUMBER — Primary key — NOT NULL
- SCH_TITLE (제목) — NUMBER
- SCH_START_DT (시작날짜) — NUMBER
- SCH_END_DT (종료날짜) — NUMBER
- SCH_REP (반복형태) — VAR2
- SCH_TOPIC (중요여부) — VAR2
- SCH_DISC (공개여부) — VAR2
- SCH_CATEGORY (범주) — NUMBER
- SCH_DESC (내용) — VAR2
- SCH_CLASS_INDEX (범위 인덱스) — NUMBER — Foreign key → SCHDUL_CLASS.SCH_CLASS_INDEX — NOT NULL
- SCH_RECURID (반복ID) — VAR2
- SCH_ALLDAY (하루종일) — VAR2
- SCH_EXCEPTION (예외날짜) — VAR2
SCHDUL_CLASS (범위)
- SCH_CLASS_INDEX (범위 인덱스) — NUMBER — Primary key — NOT NULL
- SCH_CLASS (범위) — NUMBER
- SCH_CLASS_GROUPID (범위그룹ID) — NUMBER — Foreign key → CLASS_GRP.SCH_CLASS_GROUPID — NOT NULL
SCHDUL_CTGR (범주)
- SCH_CATEGORY_INDEX (스케쥴러 범주 인덱스) — NUMBER — Primary key — NOT NULL
- CATEGORY_INDEX (범주 인덱스) — NUMBER — Foreign key → CTGR_GRP.CATEGORY_INDEX — NOT NULL
- SCH_INDEX (인덱스2) — NUMBER — Foreign key → SCHADUAL.SCH_INDEX — NOT NULL
SCH_ALLOW (일정수락)
- SCH_ALLOW_GROUP (수락거절여부) — NUMBER
- ATT_GROUP_INDEX (참석자인덱스) — NUMBER — Foreign key → ATTENDANTS.ATT_GROUP_INDEX — NOT NULL
- SCH_ID (인덱스) — NUMBER — Foreign key → ATTENDANTS.SCH_INDEX — NOT NULL
- EMP_NO (급여번호) — NUMBER — Foreign key → EMPLOYEE.EMP_NO — NOT NULL
SCH_CMT (댓글)
- CMT_ID (댓글 인덱스) — NUMBER — Primary key — NOT NULL
- SCH_INDEX (인덱스) — NUMBER — Foreign key → SCHADUAL.SCH_INDEX — NOT NULL
- CMT_CNT (내용) — NUMBER
- CMT_CLASS (계층) — NUMBER
- CMT_ORDER (댓글순서) — NUMBER
- CMT_GROUP (댓글그룹) — NUMBER
- CMT_DATE (등록날짜) — NUMBER