ERP

Tables (10)

ATTENDANCE (근태)

  • EMPNO — VARCHAR2(10) — Foreign key → EMPLOYEE.사원번호 — NOT NULL — AUTO_INCREMENT
  • ATDWORK (출근) — NUMBER — NOT NULL
  • ATDABSENCE (결근) — NUMBER
  • ATDLATE (지각) — NUMBER
  • ATDEARLY (조퇴) — NUMBER
  • ATDANNUAL (연차) — NUMBER
  • ATDSICK (병가) — NUMBER
  • ATDWORKTIME (출근시간) — DATE — NOT NULL
  • ATDLATETIME (퇴근시간) — DATE — NOT NULL
  • ATDWORKTIME (근무시간) — NUMBER

EMPLOYEE (사원)

  • 사원번호 (EMPNO) — VARCHAR2(10) — Primary key — NOT NULL — AUTO_INCREMENT
  • 비밀번호 (EMPPASS) — VARCHAR2(30) — NOT NULL
  • EMPNAME — VARCHAR2(30)
  • 부서번호 (EMPDIV) — VARCHAR2(10) — NOT NULL
  • EMPJOB (담당업무) — VARCHAR2(30) — NOT NULL
  • EMPCOSTAT (재직상태) — VARCHAR2(30) — NOT NULL
  • EMPSAL (급여) — VARCHAR2(9) — NOT NULL
  • EMPHP1 (연락처1) — VARCHAR2(3) — NOT NULL
  • EMPHP2 (연락처2) — VARCHAR2(4) — NOT NULL
  • EMPHP3 (연락처3) — VARCHAR2(5) — NOT NULL
  • EMPADDR (사원주소) — VARCHAR2(250) — NOT NULL
  • EMPJOINDATE (입사일) — DATE — NOT NULL
  • EMPRETIREDATE (퇴사일) — DATE

NOTICE (공지게시판)

  • NOTICENO (공지사항번호) — NUMBER — Primary key — NOT NULL
  • EMPNO (사원번호) — VARCHAR2(10) — Foreign key → EMPLOYEE.사원번호 — NOT NULL — AUTO_INCREMENT
  • NOTICETITLE (공지사항 제목) — VARCHAR2(250) — NOT NULL
  • NOTICECONTENT (공지사항 내용) — VARCHAR2(2000) — NOT NULL
  • NOTICEWRITER (공지사항 작성자) — VARCHAR2(30) — NOT NULL
  • NOTICEDATE (공지사항 작성일자) — DATE — NOT NULL
  • NOTICECNT (공지사항 조회수) — NUMBER — NOT NULL

NOTICEFILE (공지게시판 첨부파일)

  • NFILENO (파일 ID) — NUMBER — Primary key — NOT NULL
  • NOTICENO (공지사항번호) — NUMBER — Foreign key → NOTICE.NOTICENO — NOT NULL
  • NFILENAME (첨부파일) — VARCHAR2(100) — NOT NULL
  • NFILEPATH (첨부파일 경로) — VARCHAR2(500) — NOT NULL
  • NFILEORIGIN (원본파일) — VARCHAR2(100) — NOT NULL

SCHEDULE (캘린더)

  • SCDNO (일정번호) — NUMBER — Primary key — NOT NULL
  • EMPNO (사원번호) — VARCHAR2(10) — Foreign key → EMPLOYEE.사원번호 — NOT NULL — AUTO_INCREMENT
  • SCDSUB (일정제목) — VARCHAR2(200) — NOT NULL
  • SCDPTC (참여자) — VARCHAR2(500 — NOT NULL
  • SCDCONTENT (내용) — VARCHAR2(500 — NOT NULL
  • SCDDATE (날짜) — DATE — NOT NULL
  • SCDTYPE (종류( 휴가, 회의, 출장() — VARCHAR2(30) — NOT NULL

SIGN (결재)

  • SIGNNO (결재문서번호) — VARCHAR2(50) — Primary key — NOT NULL
  • EMPDIV (부서번호) — VARCHAR2(10) — Primary key
  • EMPNO (사원ID값) — VARCHAR2(10) — Foreign key → EMPLOYEE.사원번호 — NOT NULL — AUTO_INCREMENT
  • SIGNWRITER (결재작성자) — VARCHAR2(30) — NOT NULL
  • SIGNSUB (결재 제목) — VARCHAR2(250) — NOT NULL
  • SIGNCONTENT (결재내용) — VARCHAR2(2000) — NOT NULL
  • SIGNWRITEDATE (결재 작성일) — DATE — NOT NULL
  • SGINSTATE (결재 상태(승인,반려,미승인)) — VARCHAR2(30) — NOT NULL
  • SIGNDATE (결재날짜(승인,반려)) — VARCHAR2(30) — NOT NULL

SIGNBUSINESS (출장)

  • BSINO (출장걸재번호) — VARCHAR2(100) — Primary key — NOT NULL
  • SIGNNO (결재문서번호) — VARCHAR2(50) — Foreign key → SIGN.SIGNNO — NOT NULL
  • BSISTART (출장 시작일) — DATE — NOT NULL
  • BSIEND (출장 종료일) — DATE — NOT NULL
  • BSICONTENT (출장 내용) — VARCAHR2(2000) — NOT NULL
  • BSILOCATION (출장 장소) — VARCHAR2(100) — NOT NULL

SIGNEXPENSE (지출)

  • EXPNO (지출결재번호) — VARCHAR2(100) — Primary key — NOT NULL
  • SIGNNO (결재문서번호) — VARCHAR2(50) — Foreign key → SIGN.SIGNNO — NOT NULL
  • EXPNAME (지출품목) — VARCHAR2(250) — NOT NULL
  • EXPQUANTITY (지출 수량) — NUMBER — NOT NULL
  • EXPTOTAL (지출 금액) — NUMBER — NOT NULL
  • EXPCONTENT (지출내용) — VARCAHR2(2000) — NOT NULL
  • EXPDATE (지출일) — DATE — NOT NULL

SIGNMEETING (회의)

  • MEETNO (회의결재번호) — VARCAHR2(100) — Primary key — NOT NULL
  • SIGNNO (결재문서번호) — VARCHAR2(50) — Foreign key → SIGN.SIGNNO — NOT NULL
  • MEETSTART (회의시작시간) — DATE — NOT NULL
  • MEETEND (회의종료시간) — DATE — NOT NULL
  • MEETCONTENT (회의 내용) — VARCAHR2(2000) — NOT NULL
  • MEETLOCATION (회의 장소) — VARCHAR2(100) — NOT NULL
  • MEETPARTICIPANT (회의 참가자) — VARCHAR2(300) — NOT NULL

SIGNVACATION (휴가)

  • VACNO (휴가결재번호) — VARCHAR2(100) — Primary key — NOT NULL
  • SIGNNO (결재문서번호) — VARCHAR2(50) — Foreign key → SIGN.SIGNNO — NOT NULL
  • VACSTART (휴가 시작일) — DATE — NOT NULL
  • VACEND (휴가 종료일) — DATE — NOT NULL
  • VACTYPE (휴가 종류) — VARCHAR2(250) — NOT NULL
  • VACCONTENT (휴가 내용) — VARCAHR2(2000) — NOT NULL
  • VACTOTAL (총 휴가) — NUMBER — NOT NULL
  • VACUSE (사용 휴가) — NUMBER — NOT NULL