CSM
Tables (38)
IRIS_CODE_SET
- IDX — NUMBER(38,0)
- P_CODE — VARCHAR2(100) — 부모코드
- CODE — VARCHAR2(100) — 코드
- CODE_NM — VARCHAR2(100) — 코드명
- CODE_COLOR — VARCHAR2(20) — 색상
- UDF_VAL_03 — VARCHAR2(100)
- UDF_VAL_04 — VARCHAR2(100)
- UDF_VAL_05 — VARCHAR2(100)
- UDF_VAL_06 — VARCHAR2(100)
- UDF_VAL_07 — VARCHAR2(100)
- ORDER — NUMBER(38,0) — 정렬
- IS_USE — VARCHAR2(1) — 사용여부
- DEL_YN — VARCHAR2(1) — 삭제여부
- ETC — VARCHAR2(500) — 비고
- REG_UNO — NUMBER(38,0) — 최초
- REG_USER — VARCHAR2(100) — 최초
- REG_DATE — DATE — 최초
- MOD_UNO — NUMBER(38,0) — 최종
- MOD_USER — VARCHAR2(100) — 최종
- MOD_DATE — DATE — 최종
IRIS_COMPARE_LOG
- CNO — NUMBER — NOT NULL
- SNO — NUMBER — NOT NULL — 현장번호
- JNO — NUMBER — NOT NULL — 프로젝트번호
- USER_ID — VARCHAR2(100) — 아이디
- USER_NM — VARCHAR2(100) — NOT NULL — 이름
- BEFORE_STATE — VARCHAR2(2) — NOT NULL — 이전비교상태
- AFTER_STATE — VARCHAR2(2) — NOT NULL — 현재비교상태
- RECORD_DATE — DATE — 근무날짜
- UDF_VAL02 — VARCHAR2(20)
- UDF_VAL03 — VARCHAR2(20)
- UDF_VAL04 — VARCHAR2(20)
- UDF_VAL05 — VARCHAR2(20)
- UDF_VAL06 — VARCHAR2(20)
- UDF_VAL07 — VARCHAR2(20)
- UDF_VAL08 — VARCHAR2(20)
- UDF_VAL09 — VARCHAR2(20)
- USER_KEY — VARCHAR2(36)
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
- REG_AGENT — VARCHAR2(4000)
IRIS_DAILY_JOB
- IDX — NUMBER(38,0)
- JNO — NUMBER(38,0) — 프로젝트
- CONTENT — VARCHAR2(4000) — 작업내용
- CONTENT_COLOR — VARCHAR2(100) — 표시색상
- MAIN_CONTENT — VARCHAR2(4000) — 주요
- UDF_VAL_03 — VARCHAR2(100) — 기타
- UDF_VAL_04 — VARCHAR2(100) — 기타
- UDF_VAL_05 — VARCHAR2(100) — 기타
- UDF_VAL_06 — VARCHAR2(100) — 기타
- UDF_VAL_07 — VARCHAR2(100) — 기타
- UDF_VAL_08 — VARCHAR2(100) — 기타
- UDF_VAL_09 — VARCHAR2(100) — 기타
- UDF_VAL_10 — VARCHAR2(100) — 기타
- IS_USE — VARCHAR2(1) — 사용
- TARGET_DATE — DATE — 적용
- REG_DATE — DATE — 생성
- MOD_DATE — DATE — 수정
- REG_UNO — NUMBER(38,0) — 최초
- REG_USER — VARCHAR2(255)
- MOD_UNO — NUMBER(38,0)
- MOD_USER — VARCHAR2(255)
IRIS_DEDUCTION_SET
- SNO — NUMBER — NOT NULL — 현장번호
- JNO — NUMBER — 프로젝트번호
- USER_NM — VARCHAR2(100) — NOT NULL — 이름
- DEPARTMENT — VARCHAR2(100) — NOT NULL — 회사명
- GENDER — VARCHAR2(4) — NOT NULL — M:남자
- REG_NO — VARCHAR2(20) — NOT NULL — 생년월일
- PHONE — VARCHAR2(20) — NOT NULL — 폰번호
- IN_RECOG_TIME — DATE — 출근시간
- OUT_RECOG_TIME — DATE — 퇴근시간
- RECORD_DATE — DATE — 근무날짜
- DEDUCT_ORDER — NUMBER — 차수
- FILE_UUID — VARCHAR2(36) — 파일_UUID
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- UDF_VAL_10 — VARCHAR2(20)
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
- REG_AGENT — VARCHAR2(4000)
- MOD_DATE — DATE
- MOD_USER — VARCHAR2(100)
- MOD_UNO — NUMBER
- MOD_AGENT — VARCHAR2(4000)
IRIS_DEVICE_HISTORY
- HNO — NUMBER — NOT NULL
- DNO — NUMBER — NOT NULL
- DEVICE_NM — VARCHAR2(30)
- JNO — NUMBER
- OPEN_DATE — DATE
- CLOSE_DATE — DATE
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- UDF_VAL_10 — VARCHAR2(20)
- RAW_GUID — RAW(20)
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_USER — VARCHAR2(255)
- MOD_UNO — NUMBER
IRIS_DEVICE_SET
- DNO — NUMBER — Primary key — NOT NULL
- SNO — NUMBER — 현장
- DEVICE_SN — VARCHAR2(30) — NOT NULL — 홍채인식기
- DEVICE_NM — VARCHAR2(30) — 홍채인식기
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- JNO — NUMBER — 프로젝트번호
- ETC — VARCHAR2(4000) — 비고
- IS_USE — VARCHAR2(4) — 사용여부
- RAW_GUID — RAW(20) — GUID
- REG_DATE — DATE — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- REG_USER — VARCHAR2(255) — 최초
- REG_UNO — NUMBER — 최초
- MOD_DATE — DATE — 최종
- MOD_AGENT — VARCHAR2(4000) — 최종
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_USER — VARCHAR2(255) — 최종
- MOD_UNO — NUMBER — 최종
IRIS_EQUIP_SET
- SNO — NUMBER — Primary key — NOT NULL
- JNO — NUMBER — Primary key — NOT NULL
- RECORD_DATE — DATE — Primary key — NOT NULL
- CNT — NUMBER(38,0)
- COLUMN5 — VARCHAR2(20)
- COLUMN6 — VARCHAR2(20)
- COLUMN7 — VARCHAR2(20)
- COLUMN8 — VARCHAR2(20)
- COLUMN9 — VARCHAR2(20)
- COLUMN10 — VARCHAR2(20)
- COLUMN11 — VARCHAR2(20)
- COLUMN12 — VARCHAR2(20)
- COLUMN13 — VARCHAR2(20)
- COLUMN14 — VARCHAR2(20)
- COLUMN15 — VARCHAR2(20)
- REG_AGENT — VARCHAR2(4000)
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
- REG_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- MOD_USER — VARCHAR2(255)
- MOD_UNO — NUMBER
- MOD_DATE — DATE
IRIS_JOB_MAN_HOUR_LOG
- LNO — NUMBER — Primary key — NOT NULL
- JNO — NUMBER
- CHANGE_SETTING — VARCHAR2(100) — 변경
- MESSAGE — VARCHAR2(4000) — 로그메시지
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- UDF_VAL_10 — VARCHAR2(20)
- REG_DATE — DATE — 최초
- REG_USER — VARCHAR2(100) — 최초
- REG_UNO — NUMBER — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
IRIS_JOB_SET
- JNO — NUMBER
- IN_TIME — DATE — 출근시간
- OUT_TIME — DATE — 퇴근시간
- RESPITE_TIME — NUMBER — 출/퇴근
- CANCEL_CODE — VARCHAR2(100) — 마감
- CANCEL_DAY — NUMBER(38,0) — 마감
- UDF_VAL_02 — VARCHAR2(255)
- UDF_VAL_03 — VARCHAR2(255)
- UDF_VAL_04 — VARCHAR2(255)
- UDF_VAL_05 — VARCHAR2(255)
- UDF_VAL_06 — VARCHAR2(255)
- UDF_VAL_07 — VARCHAR2(255)
- UDF_VAL_08 — VARCHAR2(255)
- UDF_VAL_09 — VARCHAR2(255)
- UDF_VAL_10 — VARCHAR2(255)
- REG_DATE — DATE — 최초
- REG_UNO — NUMBER — 최초
- REG_USER — VARCHAR2(255) — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_DATE — DATE — 최종
- MOD_UNO — NUMBER — 최종
- MOD_USER — VARCHAR2(255) — 최종
- MOD_AGENT — VARCHAR2(4000) — 최종
- 15) — ||
- HOST) — ||
- OS_USER) — ||
IRIS_JOB_WORK_RATE
- SNO — NUMBER — NOT NULL
- JNO — NUMBER — NOT NULL — 프로젝트
- RECORD_DATE — DATE — NOT NULL — 기록
- WORK_RATE — NUMBER — 공정률
- UDF_VAL_01 — VARCHAR2(255)
- UDF_VAL_02 — VARCHAR2(255)
- UDF_VAL_03 — VARCHAR2(255)
- UDF_VAL_04 — VARCHAR2(255)
- UDF_VAL_05 — VARCHAR2(255)
- UDF_VAL_06 — VARCHAR2(255)
- UDF_VAL_07 — VARCHAR2(255)
- UDF_VAL_08 — VARCHAR2(255)
- UDF_VAL_09 — VARCHAR2(255)
- UDF_VAL_10 — VARCHAR2(255)
- MOD_AGENT — VARCHAR2(4000) — 최종
- MOD_DATE — DATE — 최종
- MOD_UNO — NUMBER — 최종
- MOD_USER — VARCHAR2(255) — 최종
IRIS_MAN_HOUR
- MHNO — NUMBER — 공수
- WORK_HOUR — NUMBER — 노동시간
- MAN_HOUR — NUMBER(38,2) — 공수
- JNO — NUMBER — NOT NULL — 프로젝트
- ETC — VARCHAR2(255) — 비고
- UDF_VAL_02 — VARCHAR2(255)
- UDF_VAL_03 — VARCHAR2(255)
- UDF_VAL_04 — VARCHAR2(255)
- UDF_VAL_05 — VARCHAR2(255)
- UDF_VAL_06 — VARCHAR2(255)
- UDF_VAL_07 — VARCHAR2(255)
- UDF_VAL_08 — VARCHAR2(255)
- UDF_VAL_09 — VARCHAR2(255)
- UDF_VAL_10 — VARCHAR2(255)
- REG_DATE — DATE — 최초
- REG_UNO — NUMBER — 최초
- REG_USER — VARCHAR2(255) — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_DATE — DATE — 최종
- MOD_UNO — NUMBER — 최종
- MOD_USER — VARCHAR2(255) — 최종
- MOD_AGENT — VARCHAR2(4000) — 최종
- 15) — ||
- HOST) — ||
- OS_USER) — ||
IRIS_MENU_SET
- IDX — NUMBER(38,0)
- MENU_ID — VARCHAR2(100) — NOT NULL — 메뉴
- MENU_NM — VARCHAR2(100) — 메뉴명
- UDF_VAL_01 — VARCHAR2(100)
- HAS_CHILD — VARCHAR2(100) — 자식여부
- PARENT_ID — VARCHAR2(100) — 부모
- IS_USE — VARCHAR2(100) — 사용여부
- MENU_ORDER — NUMBER(38,0) — 메뉴
- SUB_ORDER — NUMBER — 자식
- SVG_NAME — VARCHAR2(100)
- IS_TEMP — VARCHAR2(20)
IRIS_NOTICE_BOARD
- IDX — NUMBER(38,0)
- SNO — NUMBER(38,0) — 적용
- TITLE — VARCHAR2(200) — 공지사항
- CONTENT — CLOB — 내용
- SHOW_YN — VARCHAR2(1) — 사용자에게
- IS_USE — VARCHAR2(1) — 사용
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- UDF_VAL_10 — VARCHAR2(20)
- REG_UNO — NUMBER(38,0) — 최초
- REG_USER — VARCHAR2(100) — 최초
- REG_DATE — DATE — 최초
- MOD_UNO — NUMBER(38,0) — 최종
- MOD_USER — VARCHAR2(100) — 최종
- MOD_DATE — DATE — 최종
- REG_USER_DUTY_NAME — VARCHAR2(100) — 최초
- POSTING_PERIOD — VARCHAR2(100) — 공지
- POSTING_END_DATE — DATE — 공지
- JNO — NUMBER(38,0) — 프로젝트
- IS_IMPORTANT — VARCHAR2(1) — 중요
- POSTING_START_DATE — DATE — 공지
- IS_PUBLIC — VARCHAR2(1) — 전체공개여부
IRIS_RECD_LOG
- LOG_NO — NUMBER — Primary key — NOT NULL — 로그
- TRANS_ID — NUMBER — 트랜잭션
- DEVICE_SN — VARCHAR2(4000) — 홍채인식기
- USER_GUID — VARCHAR2(4000) — 장치가
- IRIS_DATA — CLOB — JSON로그
- IS_SUCCESS — VARCHAR2(1) — 성공여부
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(4000)
- UDF_VAL_06 — VARCHAR2(4000)
- UDF_VAL_07 — VARCHAR2(4000)
- UDF_VAL_08 — VARCHAR2(4000) — JSON
- UDF_VAL_09 — VARCHAR2(4000) — IS_USE
- UDF_VAL_10 — VARCHAR2(4000) — 받은
- IS_USE — VARCHAR2(4) — 사용여부
- RAW_GUID — RAW(20) — GUID
- REG_DATE — DATE — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- REG_USER — VARCHAR2(255) — 최초
- REG_UNO — NUMBER — 최초
- MOD_DATE — DATE — 최종
- MOD_AGENT — VARCHAR2(4000) — 최종
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_USER — VARCHAR2(255) — 최종
- MOD_UNO — NUMBER — 최종
IRIS_RECD_SET
- IRIS_NO — NUMBER — Primary key — NOT NULL
- TRANS_ID — NUMBER — NOT NULL — 트랜잭션
- DNO — VARCHAR2(30) — 홍채인식기
- SNO — NUMBER — 현장
- JNO — NUMBER — JOB
- USER_GUID — VARCHAR2(50) — 장치가
- USER_ID — VARCHAR2(50) — 실제
- USER_NM — VARCHAR2(30) — 작업자
- ROLE — VARCHAR2(50) — 접근
- DEPARTMENT — VARCHAR2(100) — 부서나
- VERIFIED_BY — VARCHAR2(100) — 홍채
- VERIFIED_CARD — VARCHAR2(100) — RFID모듈
- TRANS_TYPE — VARCHAR2(10) — 출
- TRANS_RESULT — VARCHAR2(30) — 인증
- RECOG_MODE — VARCHAR2(30) — 인증모드
- MATCHED_EYE — VARCHAR2(30) — 일치된
- IRIS_SCORE — NUMBER(*,4) — 홍채
- FACE_SCORE — NUMBER(*,4) — 얼굴
- FUSION_SCORE — NUMBER(*,4) — 얼굴
- FACE_IMG — CLOB — 인증사진
- IPD_VALUE — NUMBER(*,2) — 양눈의
- ELAPSED_SEC — NUMBER(*,2) — 인증하는데
- RECOG_TIME — DATE — 인증한
- VERIFIED_CARD_ID — VARCHAR2(100)
- VERIFIED_CARD_WIEGAND — VARCHAR2(100)
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- IS_WORKER — VARCHAR2(2) — IRIS_WORKER_SET
- IS_DAILY_WORKER — VARCHAR2(2) — IRIS_WORKER_DAILY_SET
- REG_NO — VARCHAR2(20) — 주민등록번호
- DISC_NAME — VARCHAR2(32)
- LOG_NO — NUMBER
- DEVICE_IP — VARCHAR2(50) — 장치의
- IS_USE — VARCHAR2(4) — 사용여부
- RAW_GUID — RAW(20) — GUID
- REG_DATE — DATE — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- REG_USER — VARCHAR2(255) — 최초
- REG_UNO — NUMBER — 최초
- MOD_DATE — DATE — 최종
- MOD_AGENT — VARCHAR2(4000) — 최종
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_USER — VARCHAR2(255) — 최종
- MOD_UNO — NUMBER — 최종
IRIS_SCH_REST_SET
- CNO — NUMBER — Primary key — NOT NULL
- JNO — NUMBER — NOT NULL
- IS_EVERY_YEAR — VARCHAR2(2) — Y:항상
- REST_YEAR — NUMBER — 연도
- REST_MONTH — NUMBER — 월
- REST_DAY — NUMBER — 일
- REASON — VARCHAR2(100) — 휴무
- COLUMN5 — VARCHAR2(20)
- COLUMN6 — VARCHAR2(20)
- COLUMN7 — VARCHAR2(20)
- COLUMN8 — VARCHAR2(20)
- COLUMN9 — VARCHAR2(20)
- COLUMN10 — VARCHAR2(20)
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- REG_UNO — NUMBER
- REG_USER — VARCHAR2(100)
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- MOD_UNO — NUMBER
- MOD_USER — VARCHAR2(100)
IRIS_SITE_DATE
- IDX — NUMBER(38,0)
- SNO — NUMBER(38,0) — 현장
- OPENING_DATE — DATE — 현장
- CLOSING_PLAN_DATE — DATE — 현장
- CLOSING_FORECAST_DATE — DATE — 현장
- CLOSING_ACTUAL_DATE — DATE — 현장
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- IS_USE — VARCHAR2(1)
- REG_UNO — NUMBER — 생성자
- REG_USER — VARCHAR2(100) — 생성자
- REG_DATE — DATE — 생성일시
- REG_AGENT — VARCHAR2(4000)
- MOD_UNO — NUMBER
- MOD_USER — VARCHAR2(100)
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
IRIS_SITE_JOB
- SNO — NUMBER — Primary key — NOT NULL
- JNO — NUMBER — Primary key — NOT NULL — JOB
- IS_USE — VARCHAR2(1) — 사용여부
- IS_DEFAULT — VARCHAR2(1) — 기본값
- WORK_RATE — NUMBER
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- STATUS — VARCHAR2(4) — 사용여부(운영:
- RAW_GUID — RAW(20) — GUID
- REG_DATE — DATE — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- REG_USER — VARCHAR2(255) — 최초
- REG_UNO — NUMBER — 최초
- MOD_DATE — DATE — 최종
- MOD_AGENT — VARCHAR2(4000) — 최종
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_USER — VARCHAR2(255) — 최종
- MOD_UNO — NUMBER — 최종
IRIS_SITE_POS
- IDX — NUMBER(38,0) — Primary key — NOT NULL
- SNO — NUMBER(38,0) — NOT NULL — 현장
- ADDRESS_NAME_DEPTH1 — VARCHAR2(200) — 지번주소
- ADDRESS_NAME_DEPTH2 — VARCHAR2(200) — 지번주소
- ADDRESS_NAME_DEPTH3 — VARCHAR2(200) — 지번주소
- ADDRESS_NAME_DEPTH4 — VARCHAR2(200) — 지번주소
- ADDRESS_NAME_DEPTH5 — VARCHAR2(200) — 지번주소
- ROAD_ADDRESS_NAME_DEPTH1 — VARCHAR2(200) — 도로명주소
- ROAD_ADDRESS_NAME_DEPTH2 — VARCHAR2(200) — 도로명주소
- ROAD_ADDRESS_NAME_DEPTH3 — VARCHAR2(200) — 도로명주소
- ROAD_ADDRESS_NAME_DEPTH4 — VARCHAR2(200) — 도로명주소
- ROAD_ADDRESS_NAME_DEPTH5 — VARCHAR2(200) — 도로명주소
- UDF_VAL_01 — VARCHAR2(200)
- UDF_VAL_02 — VARCHAR2(200)
- UDF_VAL_03 — VARCHAR2(200)
- UDF_VAL_04 — VARCHAR2(200)
- UDF_VAL_05 — VARCHAR2(200)
- UDF_VAL_06 — VARCHAR2(200)
- IS_USE — VARCHAR2(1)
- LATITUDE — NUMBER(38,10) — 위도
- LONGITUDE — NUMBER(38,10) — 경도
- REG_UNO — NUMBER(38,0) — 생성자
- REG_USER — VARCHAR2(50) — 생성자
- REG_DATE — DATE — 생성일시
- MOD_UNO — NUMBER
- MOD_USER — VARCHAR2(50)
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
IRIS_SITE_SET
- SNO — NUMBER — Primary key — NOT NULL
- SITE_NM — VARCHAR2(255) — 현장
- STATUS — VARCHAR2(1) — 현장
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- UDF_VAL_10 — VARCHAR2(20)
- UDF_VAL_11 — VARCHAR2(20)
- UDF_VAL_12 — VARCHAR2(20)
- LOC_CODE — VARCHAR2(5) — 현장
- LOC_NAME — VARCHAR2(20) — 현장
- ETC — VARCHAR2(4000) — 비고
- IS_USE — VARCHAR2(4) — 사용여부
- RAW_GUID — RAW(20) — GUID
- REG_DATE — DATE — 최초
- REG_AGENT — VARCHAR2(4000) — 최초
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- REG_USER — VARCHAR2(255) — 최초
- REG_UNO — NUMBER — 최초
- MOD_DATE — DATE — 최종
- MOD_AGENT — VARCHAR2(4000) — 최종
- 15) — ||
- HOST) — ||
- OS_USER) — ||
- MOD_USER — VARCHAR2(255) — 최종
- MOD_UNO — NUMBER — 최종
IRIS_STATISTICS
- STAT_NO — NUMBER(38,0) — Primary key — NOT NULL
- SNO — NUMBER — NOT NULL
- JNO — NUMBER
- RECORD_DATE — DATE — NOT NULL
- STATUS — VARCHAR2(20) — 현장상태
- WORK_RATE — NUMBER — 공정률
- EQUIP_COUNT — NUMBER(38,0) — 장비
- WORKER_COUNT_ALL — NUMBER(38,0) — 일일누계
- WORKER_COUNT_DAY — NUMBER(38,0) — 일일소계
- WORKER_COUNT_CONS — NUMBER(38,0) — HTENC-공사
- WORKER_COUNT_SAFE — NUMBER(38,0) — HTENC-안전
- WORKER_COUNT_COMP_MANAGER — NUMBER(38,0) — 협력사-관리
- WORKER_COUNT_COMP_WORKER — NUMBER(38,0) — 협력사-근로자
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- UDF_VAL_10 — VARCHAR2(20)
- UDF_VAL_11 — VARCHAR2(20)
- UDF_VAL_12 — VARCHAR2(20)
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- MOD_USER — VARCHAR2(255)
- MOD_UNO — NUMBER
IRIS_TBM_SET
- SNO — NUMBER — NOT NULL — 현장번호
- JNO — NUMBER — 프로젝트번호
- DEPARTMENT — VARCHAR2(100) — NOT NULL — 회사명
- DISC_NAME — VARCHAR2(100) — 직종
- USER_NM — VARCHAR2(100) — NOT NULL — 이름
- TBM_ORDER — NUMBER — NOT NULL — 차수
- TBM_DATE — DATE — NOT NULL — TBM
- FILE_UUID — VARCHAR2(36) — 파일
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- DEL_YN — VARCHAR2(4) — 삭제여부
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
- REG_AGENT — VARCHAR2(4000)
- MOD_DATE — DATE
- MOD_USER — VARCHAR2(100)
- MOD_UNO — NUMBER
- MOD_AGENT — VARCHAR2(4000)
IRIS_UPLOADED_FILES
- CNO — NUMBER — NOT NULL
- FILE_TYPE — VARCHAR2(50) — NOT NULL — 파일타입
- FILE_PATH — VARCHAR2(200) — NOT NULL — 경로
- FILE_NAME — VARCHAR2(100) — NOT NULL — 파일명
- UPLOAD_ROUND — NUMBER — 차수
- FILE_UUID — VARCHAR2(36) — 파일_UUID
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- WORK_DATE — DATE — 업로드날짜
- JNO — NUMBER — 프로젝트번호
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
- REG_AGENT — VARCHAR2(4000)
IRIS_USER_MENU
- ROLE_CODE — VARCHAR2(20) — Primary key — NOT NULL
- MENU_ID — VARCHAR2(100) — Primary key — NOT NULL — 메뉴아이디
- IS_USE — VARCHAR2(2) — 사용여부
- COLUMN4 — VARCHAR2(20)
- COLUMN5 — VARCHAR2(20)
- COLUMN6 — VARCHAR2(20)
- COLUMN7 — VARCHAR2(20)
- COLUMN8 — VARCHAR2(20)
- COLUMN9 — VARCHAR2(20)
- COLUMN10 — VARCHAR2(20)
- COLUMN11 — VARCHAR2(20)
- COLUMN12 — VARCHAR2(20)
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
- MOD_DATE — DATE
- MOD_USER — VARCHAR2(100)
- MOD_UNO — NUMBER
IRIS_USER_ROLE
- ROLE_CODE — VARCHAR2(20) — Primary key — NOT NULL — 권한코드
- ROLE_NAME — VARCHAR2(50) — NOT NULL — 권한명
- ROLE_ORDER — NUMBER — 권한순서
- ETC — VARCHAR2(4000) — 비고
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- UDF_VAL_10 — VARCHAR2(20)
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
IRIS_USER_ROLE_MAP
- USER_UNO — NUMBER — NOT NULL — 유저번호
- ROLE_CODE — VARCHAR2(20) — NOT NULL — 권한코드
- JNO — NUMBER — 권한이
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
- REG_AGENT — VARCHAR2(4000)
IRIS_WEATHER
- SNO — NUMBER — Primary key — NOT NULL — 현장번호
- RECOG_TIME — DATE — Primary key — NOT NULL — 날씨
- LGT — VARCHAR2(255) — 낙뢰
- PTY — VARCHAR2(255) — 강수형태
- RN1 — VARCHAR2(255) — 1시간
- SKY — VARCHAR2(255) — 하늘상태
- T1H — VARCHAR2(255) — 기온
- REH — VARCHAR2(255) — 습도
- UUU — VARCHAR2(255) — 풍속
- VVV — VARCHAR2(255) — 풍속
- VEC — VARCHAR2(255) — 풍향
- WSD — VARCHAR2(255) — 풍속
IRIS_WORKER_DAILY_HIS
- CNO — NUMBER — NOT NULL
- SNO — NUMBER — 현장번호
- JNO — NUMBER — 프로젝트번호
- USER_KEY — VARCHAR2(36) — NOT NULL — 유저키
- RECORD_DATE — DATE — 홍채인식기등록날짜
- IN_RECOG_TIME — DATE — 출근기록
- OUT_RECOG_TIME — DATE — 퇴근기록
- IS_DEADLINE — VARCHAR2(20) — 마감여부
- WORK_STATE — VARCHAR2(2) — 출퇴근코드
- IS_OVERTIME — VARCHAR2(2) — 철야여부
- WORK_HOUR — NUMBER — 공수
- HIS_STATUS — VARCHAR2(6) — BEFORE:
- REASON — VARCHAR2(4000) — 사유
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- REASON_TYPE — VARCHAR2(2) — 01:추가
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
IRIS_WORKER_DAILY_LOG
- LNO — NUMBER — Primary key — NOT NULL
- SNO — NUMBER
- JNO — NUMBER — 프로젝트번호
- USER_ID — VARCHAR2(100) — 아이디
- RECOG_TIME — DATE — 근무날짜
- TRANS_TYPE — VARCHAR2(10) — 출/퇴근
- MESSAGE — VARCHAR2(4000) — 변경
- UDF_VAL_01 — VARCHAR2(20)
- UDF_VAL_02 — VARCHAR2(20)
- UDF_VAL_03 — VARCHAR2(20)
- UDF_VAL_04 — VARCHAR2(20)
- UDF_VAL_05 — VARCHAR2(20)
- UDF_VAL_06 — VARCHAR2(20)
- UDF_VAL_07 — VARCHAR2(20)
- UDF_VAL_08 — VARCHAR2(20)
- UDF_VAL_09 — VARCHAR2(20)
- USER_KEY — VARCHAR2(36)
- REG_DATE — DATE
- REG_USER — VARCHAR2(100)
- REG_UNO — NUMBER
- REG_AGENT — VARCHAR2(4000)
IRIS_WORKER_DAILY_SET
- CNO — NUMBER — Primary key — NOT NULL
- SNO — NUMBER — NOT NULL
- JNO — NUMBER — NOT NULL — 프로젝트
- USER_KEY — VARCHAR2(36) — NOT NULL — 사용자키
- RECORD_DATE — DATE — NOT NULL — 기록
- IN_RECOG_TIME — DATE — 출근시간
- OUT_RECOG_TIME — DATE — 퇴근시간
- IS_DEADLINE — VARCHAR2(20) — 일일데이터
- WORK_STATE — VARCHAR2(2) — 출퇴근
- IS_OVERTIME — VARCHAR2(2) — Y:철야
- COMPARE_STATE — VARCHAR2(2) — S:반영
- WORK_HOUR — NUMBER — 공수
- DEPARTMENT — VARCHAR2(100) — 부서
- DNO — VARCHAR2(30) — 홍채인식기번호
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- MOD_USER — VARCHAR2(255)
- MOD_UNO — NUMBER
IRIS_WORKER_HISTORY
- WHNO — NUMBER — Primary key — NOT NULL — 근로자이력
- WNO (WNO2) — NUMBER — Foreign key → IRIS_WORKER_INFO.WNO — NOT NULL
- USER_KEY — VARCHAR2(36) — NOT NULL — 유저키
- SNO — NUMBER — 현장번호
- JNO — NUMBER — 프로젝트번호
- DEPARTMENT — VARCHAR2(100) — 회사명
- IS_MANAGE — VARCHAR2(2) — 관리자
- DISC_NAME — VARCHAR2(100) — 공종
- WORKER_TYPE — VARCHAR2(2) — 근로자
- IS_RETIRE — VARCHAR2(2) — 퇴사여부
- RETIRE_DATE — DATE — 퇴사날짜
- WORK_TYPE — VARCHAR2(255) — 직종
- IRIS_NO — NUMBER(38,0)
- DAILY_REASON — VARCHAR2(2000) — 일용근로자
- DEL_YN — VARCHAR2(4)
- IS_LATEST_IN_JNO — VARCHAR2(4) — 프로젝트
- VALID_FROM — DATE — 사용
- VALID_TO — DATE — 사용
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- MOD_USER — VARCHAR2(255)
- MOD_UNO — NUMBER
IRIS_WORKER_INFO
- WNO — NUMBER — Primary key — NOT NULL
- USER_KEY — VARCHAR2(36) — NOT NULL
- USER_ID — VARCHAR2(50) — NOT NULL — 아이디(핸드폰번호와동일)
- USER_NM — VARCHAR2(30) — 이름
- PHONE — VARCHAR2(50) — 핸드폰번호
- REG_NO — VARCHAR2(4000) — 주민번호
- TRG_EDITABLE_YN — VARCHAR2(2) — 배치
- IRIS_NO — NUMBER(38,0)
- DEL_YN — VARCHAR2(2) — 삭제여부
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- MOD_USER — VARCHAR2(255)
- MOD_UNO — NUMBER
IRIS_WORKER_SET
- WNO — NUMBER — Primary key — NOT NULL
- USER_KEY — VARCHAR2(36) — NOT NULL
- SNO — NUMBER — NOT NULL — 현장번호
- JNO — NUMBER — NOT NULL — 프로젝트번호
- USER_ID — VARCHAR2(50) — NOT NULL — 아이디(핸드폰번호와동일)
- USER_NM — VARCHAR2(30) — 이름
- PHONE — VARCHAR2(50) — 핸드폰번호
- REG_NO — VARCHAR2(4000) — 주민번호
- IS_DEL — VARCHAR2(2) — 삭제여부
- TRG_EDITABLE_YN — VARCHAR2(2) — 배치
- IRIS_NO — NUMBER(38,0)
- IS_MANAGE — VARCHAR2(2) — 관리자
- DEPARTMENT — VARCHAR2(100) — 부서
- DISC_NAME — VARCHAR2(100) — 공종
- WORKER_TYPE — VARCHAR2(2) — 근로자타입
- IS_USE — VARCHAR2(2) — 사용
- IS_RETIRE — VARCHAR2(2) — 퇴직여부
- RETIRE_DATE — DATE — 퇴직날짜
- WORK_TYPE — VARCHAR2(255) — 직종타입
- DAILY_REASON — VARCHAR2(2000) — 일용근로자
- REG_DATE — DATE
- REG_AGENT — VARCHAR2(4000)
- REG_USER — VARCHAR2(255)
- REG_UNO — NUMBER
- MOD_DATE — DATE
- MOD_AGENT — VARCHAR2(4000)
- MOD_USER — VARCHAR2(255)
- MOD_UNO — NUMBER
JOB_MANAGER
- JNO — NUMBER — Primary key — NOT NULL
- AUTH — VARCHAR2(32) — Primary key — NOT NULL — 권한
- UNO — NUMBER — Primary key — NOT NULL — 직원
- TEAM_LEADER — CHAR(1) — 팀장
- REG_USER — NUMBER — 등록자
- REG_DATE — TIMESTAMP — 등록일
- MOD_USER — NUMBER — 수정자
- MOD_DATE — TIMESTAMP — 수정일
JOB_MANAGER_FUNC
- JNO — NUMBER — Primary key — NOT NULL — 프로젝트
- UNO — NUMBER — Primary key — NOT NULL — 직원
- FUNC_NO — NUMBER — Primary key — NOT NULL — 공종(현장)
JOB_SUBCON_FUNC
- JNO — NUMBER — Primary key — NOT NULL — 프로젝트
- CNO — NUMBER — Primary key — NOT NULL — 협력업체
- FUNC_NO — NUMBER — Primary key — NOT NULL — 공종(현장)
JOB_SUBCON_INFO
- CNO — NUMBER — Primary key — NOT NULL — 협력업체
- JNO — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2(30) — 안전보건시스템
- PW — VARCHAR2(100) — 안전보건시스템
- CELLPHONE — VARCHAR2(20) — 휴대전화
- EMAIL — VARCHAR2(200) — 이메일
- UNO — NUMBER — 관리감독자
- IS_USE — CHAR(1) — 사용여부
- CREATE_YEAR — NUMBER — 생성년도
- SERIAL_NUM — NUMBER — 년도
- COMP_NAME — VARCHAR2(256) — 협력업체
근로자 이력 (IRIS_WORKER_HISTORYw)
- WHNO — NUMBER — Primary key — NOT NULL
- USER_KEY — NUMBER — NOT NULL
- WNO — VARCHAR(50)
- SNO — VARCHAR(50)
- JNO — VARCHAR(50)
- DEPARTMENT — VARCHAR(100)
- IS_MANAGE — VARCHAR(1)
- DISC_NAME — VARCHAR(100)
- WORKER_TYPE — VARCHAR(50)
- IS_RETIRE — CHAR(1)
- RETIRE_DATE — DATE
- WORK_TYPE — VARCHAR(50)
- IRIS_NO — VARCHAR(100)
- DAILY_REASON — VARCHAR(255)
- VALID_FROM — DATETIME — NOT NULL
- VALID_TO — DATETIME
- REG_DATE — DATETIME
- REG_AGENT — VARCHAR(100)
- REG_USER — VARCHAR(100)
- REG_UNO — VARCHAR(50)
- MOD_DATE — DATETIME
- MOD_AGENT — VARCHAR(100)
- MOD_USER — VARCHAR(100)
- MOD_UNO — VARCHAR(50)