ㅇㅇ

Tables (27)

APPROVAL_LINES

  • APPROVAL_ID — NUMBER
  • DOC_ID — VARCHAR2(20) — Foreign key → DOCUMENTS.DOC_ID — NOT NULL — 문서ID
  • APPROVER_ID — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 결재자ID
  • APPROVAL_ORDER — NUMBER — NOT NULL — 결재순서
  • APPROVAL_STATUS — VARCHAR2(20) — NOT NULL — 결재상태
  • APPROVAL_DATE — DATE — 결재일시
  • APPROVAL_COMMENT — VARCHAR2(1000) — 결재의견
  • APPROVAL_TYPE — VARCHAR2(10) — NOT NULL — 결재타입

ATTACHMENTS

  • FILE_ID — NUMBER
  • DOC_ID — VARCHAR2(20) — Foreign key → DOCUMENTS.DOC_ID — NOT NULL — 문서ID
  • ORIGINAL_NAME — VARCHAR2(200) — NOT NULL — 원본파일명
  • SAVED_NAME — VARCHAR2(200) — NOT NULL — 저장파일명
  • FILE_PATH — VARCHAR2(500) — NOT NULL — 파일경로
  • FILE_SIZE — NUMBER — NOT NULL — 파일크기
  • FILE_TYPE — VARCHAR2(100) — NOT NULL — 파일타입
  • UPLOAD_DATE — DATE — NOT NULL — 업로드일시

ATTENDS

  • ATD_NO — NUMBER
  • EMP_NO — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 사원번호
  • ATD_DATE — DATE — NOT NULL — 출결일자
  • ATD_TYPE — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 출결유형
  • ATD_STATUS — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 출결상태
  • ATD_REMARKS — VARCHAR2(200) — 비고

CLIENTS

  • CLT_CODE — VARCHAR2(50) — Primary key — NOT NULL
  • CLT_NAME — VARCHAR2(50) — 거래처명
  • CLT_PHONE — VARCHAR2(50) — 전화번호
  • CLT_EMAIL — VARCHAR2(50) — EMAIL
  • CLT_ADDRESS — VARCHAR2(50) — 주소
  • CLT_COMMENTS — VARCHAR2(100) — 비고

COMMONCODE

  • COMMON_CODE — VARCHAR2(30) — Primary key — NOT NULL
  • COMMON_NAME — VARCHAR2(100) — NOT NULL — 코드
  • COMMON_CONTENT — VARCHAR2(300) — NOT NULL — 코드
  • COMMONCODE_IS_ACTIVE — VARCHAR2(1) — NOT NULL — 사용여부

COMMONCODE_DETAIL

  • COMMONCODE_DETAIL — VARCHAR2(30) — Primary key — NOT NULL
  • COMMON_CODE — VARCHAR2(30) — Foreign key → COMMONCODE.COMMON_CODE — NOT NULL — 코드
  • COMMONDETAIL_NAME — VARCHAR2(100) — NOT NULL — 코드그룹
  • SORT_ORDER — NUMBER — 정렬
  • COMMON_CONTENT — VARCHAR2(200) — NOT NULL — 코드
  • COMMONCODE_DETAIL_IS_ACTIVE — CHAR(1) — NOT NULL — 사용여부

DEPARTMENTS

  • DEPT_NO — NUMBER
  • EMP_ID — VARCHAR2(100) — Foreign key → EMPLOYEES.EMP_ID — 사원
  • DEPT_NAME — VARCHAR2(100) — 부서명
  • POSITION_NAME — VARCHAR2(100) — 직위명

DOCUMENTS

  • DOC_ID — VARCHAR2(20) — Primary key — NOT NULL
  • DOC_NUMBER — VARCHAR2(30) — NOT NULL — 문서번호
  • FORM_ID — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 양식ID
  • TITLE — VARCHAR2(200) — NOT NULL — 제목
  • CONTENT — CLOB — NOT NULL — 내용
  • DRAFTER_ID — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 기안자ID
  • DRAFT_DEPT — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 기안부서
  • DRAFT_DATE — DATE — NOT NULL — 기안일자
  • DOC_STATUS — VARCHAR2(20) — NOT NULL — 문서상태
  • APPROVAL_DATE — DATE — 최종결재일
  • IS_TEMP_SAVED — CHAR(1) — NOT NULL — 임시저장여부
  • UPDATE_DATE — DATE — 수정일

DOC_FORM_CONTENTS

  • FORM_ID — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL
  • FORM_CONTENT — CLOB — HTML
  • CREATOR_ID — NUMBER — NOT NULL — 생성자
  • CREATE_DATE — DATE — NOT NULL — 생성일
  • UPDATER_ID — NUMBER — 수정자
  • UPDATE_DATE — DATE — 수정일

EMPLOYEES

  • EMP_NO — NUMBER
  • EMP_ID — VARCHAR2(50) — 사원
  • EMP_LEVEL — VARCHAR2(50) — 사원
  • EMP_PASSWORD — VARCHAR2(200) — 비밀번호
  • EMP_NAME — VARCHAR2(50) — 이름
  • EMP_PROFILE — VARCHAR2(50) — 프로필사진
  • EMP_BIRTHDAY — VARCHAR2(50) — 생년월일
  • EMP_EMAIL — VARCHAR2(50) — 이메일
  • EMP_GENDER — VARCHAR2(50) — 성별
  • EMP_PHONE — VARCHAR2(50) — 휴대폰
  • EMP_POST_CODE — VARCHAR2(50) — 우편번호
  • EMP_ADDRESS1 — VARCHAR2(50) — 기본주소
  • EMP_ADDRESS2 — VARCHAR2(50) — 상세주소
  • EMP_START_DATE — DATE — 입사일
  • EMP_END_DATE — DATE — 퇴사일
  • EMP_END_REASON — VARCHAR2(50) — 퇴사사유
  • EMPLOYMENT_TYPE — VARCHAR2(50) — 채용구분
  • EMP_TYPE — VARCHAR2(50) — 고용유형
  • EMP_STATUS — VARCHAR2(50) — 재직상태
  • EMP_EDUCATION_LEVEL — VARCHAR2(50) — 학력
  • EMP_GRADE — VARCHAR2(50) — 성과등급
  • EMP_MARITAL_STATUS — VARCHAR2(50) — 결혼여부
  • SAL_NO — VARCHAR2(50) — 급여번호
  • BANK_NAME — VARCHAR2(50) — 은행명
  • ACCOUNT_NAME — VARCHAR2(50) — 계좌명
  • EMP_APPOINTMENT_TYPE — VARCHAR2(50) — 발령구분
  • EMP_PARKING_STATUS — VARCHAR2(50) — 주차등록
  • EMP_CAR_NUMBER — VARCHAR2(50) — 차량번호

HOLIDAYS

  • HOL_NO — NUMBER
  • HOL_NAME — VARCHAR2(100) — NOT NULL — 공휴일명
  • HOL_DATE — DATE — NOT NULL — 공휴일일자
  • HOL_TYPE — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 공휴일유형
  • HOL_RECUR_YN — CHAR(1) — NOT NULL — 반복여부
  • HOL_REMARKS — VARCHAR2(200) — 비고

LEAVES

  • LEV_NO — NUMBER
  • EMP_NO — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 사원번호
  • LEV_TYPE — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 휴가유형
  • LEV_START_DATE — DATE — NOT NULL — 시작일
  • LEV_END_DATE — DATE — NOT NULL — 종료일
  • LEV_DAYS — NUMBER — NOT NULL — 휴가일수
  • LEV_REASON — VARCHAR2(200) — 사유
  • LEV_REQ_DATE — DATE — NOT NULL — 신청일시
  • LEV_APPROVAL_STATUS — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 승인상태
  • LEV_APPROVER — NUMBER — Foreign key → EMPLOYEES.EMP_NO — 승인자
  • LEV_APPROVAL_DATE — DATE — 승인일시
  • LEV_REMARKS — VARCHAR2(200) — 비고

LOTS

  • LOT_NO — VARCHAR2(50) — Primary key — NOT NULL
  • PDT_CODE — VARCHAR2(50) — Foreign key → PRODUCTS.PDT_CODE — 제품
  • CREATION_DATE — DATE — 생성일
  • EXPIRY_DATE — DATE — 만료일
  • QUANTITY — NUMBER — 수량

MATERIALS

  • MTL_CODE — VARCHAR2(50) — Primary key — NOT NULL
  • MTL_NAME — VARCHAR2(50) — 원자재명
  • MTL_SPECIFICATION — VARCHAR2(50) — 규격
  • MTL_SHIPPING_PRICE — VARCHAR2(50) — 출고단가
  • MTL_COMMENTS — VARCHAR2(100) — 비고

NOTICES

  • NOTI_NO — NUMBER
  • NOTI_SUBJECT — VARCHAR2(500) — 공지제목
  • NOTI_CONTENT — CLOB — 공지내용
  • NOTI_FILE — VARCHAR2(500) — 첨부파일경로
  • NOTI_CATEGORY — VARCHAR2(100) — 공지분류
  • NOTI_DATE — DATE — 작성일
  • NOTI_VIEW_COUNT — VARCHAR2(500) — 조회수
  • EMP_ID — VARCHAR2(50) — Foreign key → EMPLOYEES.EMP_ID — 사원

OVERTIMES

  • OT_NO — NUMBER
  • EMP_NO — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 사원번호
  • OT_DATE — DATE — NOT NULL — 초과근무일
  • OT_START_TIME — TIMESTAMP — NOT NULL — 시작시간
  • OT_END_TIME — TIMESTAMP — NOT NULL — 종료시간
  • OT_TOTAL_HOUR — NUMBER(5,1) — NOT NULL — 총시간
  • OT_TYPE — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 초과근무유형
  • OT_REASON — VARCHAR2(200) — 사유
  • OT_REQ_DATE — DATE — NOT NULL — 신청일시
  • OT_APPROVAL_STATUS — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 승인상태
  • OT_APPROVER — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 승인자
  • OT_APPROVAL_DATE — DATE — NOT NULL — 승인일시
  • OT_REMARKS — VARCHAR2(200) — 비고

PAYSLIP

  • PAY_NO — NUMBER
  • EMP_NO — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 사원번호
  • SAL_NO — NUMBER — Foreign key → SALARIES.SAL_NO — NOT NULL — 급여번호
  • PAY_DATE — DATE — NOT NULL — 발급일

PO_REQUESTS

  • PRQ_NO — NUMBER
  • PRQ_DATE — DATE — NOT NULL — 발주일자
  • EMP_ID — VARCHAR2(50) — Foreign key → EMPLOYEES.EMP_ID — NOT NULL — 사원번호
  • WHS_CODE — VARCHAR2(50) — Foreign key → WAREHOUSES.WHS_CODE — NOT NULL — 창고코드
  • MTL_CODE — VARCHAR2(50) — Foreign key → MATERIALS.MTL_CODE — NOT NULL — 원자재코드
  • CLT_CODE — VARCHAR2(50) — Foreign key → CLIENTS.CLT_CODE — NOT NULL — 거래처코드
  • PRQ_QUANTITY — NUMBER — NOT NULL — 수량
  • PRQ_VALUE — NUMBER — NOT NULL — 공급가액
  • PRQ_STATUS — VARCHAR2(50) — NOT NULL — 종결여부
  • PRQ_COMMENTS — VARCHAR2(100) — 비고

PRODUCTS

  • PDT_CODE — VARCHAR2(50) — Primary key — NOT NULL
  • PDT_NAME — VARCHAR2(50) — 완제품명
  • PDT_SPECIFICATION — VARCHAR2(50) — 규격
  • PDT_SHIPPING_PRICE — VARCHAR2(50) — 출고단가
  • PDT_COMMENTS — VARCHAR2(100) — 비고

RECIPIENTS

  • RECIPIENT_ID — NUMBER
  • DOC_ID — VARCHAR2(20) — Foreign key → DOCUMENTS.DOC_ID — NOT NULL — 문서ID
  • RECEIVER_ID — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 수신자사원ID
  • READ_STATUS — VARCHAR2(10) — NOT NULL — 수신상태
  • READ_DATE — DATE — 읽은일시

SALARIES

  • SAL_NO — NUMBER
  • EMP_NO — NUMBER — Foreign key → EMPLOYEES.EMP_NO — 사원번호
  • SAL_TYPE — NUMBER — NOT NULL — 급여유형
  • SAL_NAME — VARCHAR2(100) — NOT NULL — 급여명
  • SAL_NOTE — VARCHAR2(1000) — 급여설명
  • SAL_SAVE_YEAR — DATE — NOT NULL — 적용년도
  • SAL_UPDATE_DATE — DATE — NOT NULL — 수정일시
  • SALARY — NUMBER — NOT NULL — 기본급
  • SAL_BONUS — NUMBER — 수당
  • SAL_TAX — NUMBER — 공제액
  • SAL_REAL — NUMBER — NOT NULL — 실지급액
  • SAL_BANK_NAME — VARCHAR2(50) — NOT NULL — 은행명
  • SAL_BANK_NUMBE — VARCHAR2(50) — NOT NULL — 계좌명
  • SAL_DATE — DATE — NOT NULL — 급여지급일
  • SAL_STATE — NUMBER — NOT NULL — 급여지급상태

SHIPMENT_REG

  • SHIP_REG_CODE — NUMBER
  • SHIP_REQ_CODE — NUMBER — Foreign key → SHIPMENT_REQ.SHIP_REQ_CODE — NOT NULL — 출하요청
  • SRQ_NO — NUMBER — Foreign key → SO_REQUESTS.SRQ_NO — NOT NULL — 수주번호
  • PDT_CODE — VARCHAR2(50) — Foreign key → PRODUCTS.PDT_CODE — NOT NULL — 품목코드
  • SHIP_REAL_QTY — NUMBER — 출하수량
  • LOT_NO — VARCHAR2(50) — Foreign key → LOTS.LOT_NO — NOT NULL — LOT
  • UNIT — VARCHAR2(20) — 기준단위
  • SHIP_REAL_DATE — DATE — 출하일
  • STATUS — VARCHAR2(50) — 진행상태
  • CLT_CODE — VARCHAR2(50) — Foreign key → CLIENTS.CLT_CODE — NOT NULL — 거래처
  • WHS_CODE — VARCHAR2(50) — Foreign key → WAREHOUSES.WHS_CODE — NOT NULL — 창고코드
  • SRQ_VALUE — NUMBER — 공급
  • SHIP_REG_PDT_SUM — NUMBER(10, 2) — 금액
  • ADDR — VARCHAR2(100) — 배송주소

SHIPMENT_REQ

  • SHIP_REQ_CODE — NUMBER
  • PDT_CODE — VARCHAR2(50) — Foreign key → PRODUCTS.PDT_CODE — NOT NULL — 품목코드
  • SRQ_NO — NUMBER — Foreign key → SO_REQUESTS.SRQ_NO — NOT NULL — 수주번호
  • EMP_IDX — VARCHAR2(50) — Foreign key → EMPLOYEES.EMP_ID — NOT NULL — 요청자
  • SHIP_REQ_QTY — NUMBER — 출하수량
  • SHIP_REQ_DATE — DATE — 출하요청일
  • SHIP_EXP_DATE — DATE — 예상
  • CLT_CODE — VARCHAR2(50) — Foreign key → CLIENTS.CLT_CODE — NOT NULL — 거래처
  • PDT_SHIPPING_PRICE — NUMBER(10, 2) — 출고
  • SHIP_REQ_PDT_SUM — NUMBER(10, 2) — 금액

SO_REQUESTS

  • SRQ_NO — NUMBER
  • SRQ_DATE — DATE — NOT NULL — 수주일자
  • EMP_ID — VARCHAR2(50) — Foreign key → EMPLOYEES.EMP_ID — NOT NULL — 사원번호
  • WHS_CODE — VARCHAR2(50) — Foreign key → WAREHOUSES.WHS_CODE — NOT NULL — 창고코드
  • PDT_CODE — VARCHAR2(50) — Foreign key → PRODUCTS.PDT_CODE — NOT NULL — 완제품코드
  • CLT_CODE — VARCHAR2(50) — Foreign key → CLIENTS.CLT_CODE — NOT NULL — 거래처코드
  • SRQ_QUANTITY — NUMBER — NOT NULL — 수량
  • SRQ_VALUE — NUMBER — NOT NULL — 공급가액
  • SRQ_STATUS — VARCHAR2(50) — NOT NULL — 종결여부
  • SRQ_COMMENTS — VARCHAR2(100) — 비고

WAREHOUSES

  • WHS_CODE — VARCHAR2(50) — Primary key — NOT NULL
  • WHS_NAME — VARCHAR2(50) — 창고명
  • WHS_LOCATION — VARCHAR2(50) — 창고위치
  • WHS_USED — VARCHAR2(50) — 창고사용
  • WHS_COMMENTS — VARCHAR2(100) — 비고

WORK_SCHEDULES

  • WSCHD_NO — NUMBER
  • WSCHD_NAME — VARCHAR2(100) — NOT NULL — 일정명
  • WSCHD_TARG_TYPE — VARCHAR2(30) — NOT NULL — 적용대상유형
  • WSCHD_TARG_NO — NUMBER — 대상ID
  • WSCHD_START_TIME — VARCHAR2(5) — NOT NULL — 근무시작시간
  • WSCHD_END_TIME — VARCHAR2(5) — NOT NULL — 근무종료시간
  • WSCHD_BRK_START — VARCHAR2(5) — 휴식시작시간
  • WSCHD_BRK_END — VARCHAR2(5) — 휴식종료시간
  • WSCHD_DAY — VARCHAR2(20) — NOT NULL — 근무일
  • WSCHD_START_DATE — DATE — NOT NULL — 시작일자
  • WSCHD_END_DATE — DATE — NOT NULL — 종료일자
  • WSCHD_IS_ACTIVE — CHAR(1) — NOT NULL — 사용여부
  • WSCHD_REMARKS — VARCHAR2(200) — 비고

WORK_TIMES

  • WKT_NO — NUMBER
  • EMP_NO — NUMBER — Foreign key → EMPLOYEES.EMP_NO — NOT NULL — 사원번호
  • WKT_DATE — DATE — NOT NULL — 근무일자
  • WKT_START_TIME — TIMESTAMP — 출근시간
  • WKT_END_TIME — TIMESTAMP — 퇴근시간
  • WKT_STATUS — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 근무상태
  • WKT_TYPE — VARCHAR2(30) — Foreign key → COMMONCODE_DETAIL.COMMONCODE_DETAIL — NOT NULL — 기준근무유형
  • WKT_REMARKS — VARCHAR2(200) — 비고