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