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