ㅇㅇ
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) — 비고