profile
테이블 (3)
유저스크린 (UserScreen)
- 유저아이디 (usrid) — varchar2 (30) — 기본 키 — NOT NULL — userID
- 스크린번호 (screenNo) — int — 기본 키 — NOT NULL — 1~4
- 뷰모드 (viewMode) — varchar2 (10) — 2D / 3D
- 위도 (positionLatitude) — varchar2 (30) — 24.98093796
- 경도 (positionLongitude) — varchar2 (30) — 55.05480194
- 앵글 (viewAngle) — varchar2 (30) — 0.0 ~ 360.0
- 거리 (viewDistance) — int — Distance
- 등록일 (regDate) — date — sysdate
유저펑션키 (UserFunctionKey)
- 유저아이디 (usrid) — varchar2 (30) — 기본 키 — NOT NULL
- 펑션키 (hotKey) — int — 기본 키 — NOT NULL — 1~10 : keyNum F1~F10
- 뷰모드 (viewMode) — varchar2 (10) — 2D / 3D
- 위도 (positionLatitude) — varchar2 (30) — 24.98093796
- 경도 (positionLongitude) — varchar2 (30) — 55.05480194
- 앵글 (viewAngle) — varchar2 (30) — 0.0 ~ 360.0
- 거리 (viewDistance) — int — Distance
- 등록일 (regDate) — date — sysdate
유저필터 (UserFilter)
- 유저아이디 (usrid) — varchar2 (30) — 기본 키 — NOT NULL — userID
- 블록컨테이터필터 (blockContainerFilter) — varchar2 (10) — OPR / CLASS / TYPE / TIER
- 장비컨테이너필터 (equipmentContainerFilter) — varchar2 (10) — OPR / CLASS / TYPE / JOB
- 중복컨테이너 (containerOverlap) — varchar2 (2) — Y / N
- 뜬컨테이너 (containerEmptyPlace) — varchar2 (2) — Y / N
- 잡타입별컨테이너 (jobTypeContainerColor) — varchar2 (10) — DS : Discharge, LD : Load, MI : Movement In Yard, MO : Movement Out,RH : Rehandleing, AH : Auto Rehandleing,LC : Loadin…
- DS컬러 (dsColor) — varchar2 (20) — Color Code Value
- ID컬러 (ldColor) — varchar2 (20) — Color Code Value
- MI컬러 (miColor) — varchar2 (20) — Color Code Value
- MO컬러 (moColor) — varchar2 (20) — Color Code Value
- RH컬러 (rhColor) — varchar2 (20) — Color Code Value
- AH컬러 (ahColor) — varchar2 (20) — Color Code Value
- LC컬러 (lcColor) — varchar2 (20) — Color Code Value
- GI컬러 (giColor) — varchar2 (20) — Color Code Value
- GO컬러 (goColor) — varchar2 (20) — Color Code Value
- GC컬러 (gcColor) — varchar2 (20) — Color Code Value
- mphYt — varchar2 (10) — NONE / BOTH / UNDER / OVER
- mphQc — varchar2 (10) — NONE / BOTH / UNDER / OVER
- mphTc — varchar2 (10) — NONE / BOTH / UNDER / OVER
- mphRs — varchar2 (10) — NONE / BOTH / UNDER / OVER
- mphEh — varchar2 (10) — NONE / BOTH / UNDER / OVER
- eqFilterUse — varchar2 (2) — Y / N
- eqFilterYt — varchar2 (2) — Y / N
- eqFilterQc — varchar2 (2) — Y / N
- eqFilterTc — varchar2 (2) — Y / N
- eqFilterRs — varchar2 (2) — Y / N
- eqFilterEh — varchar2 (2) — Y / N
- gangFilterUse — varchar2 (2) — Y / N
- allSelect — varchar2 (2) — Y / N
- blockFilterUse — varchar2 (2) — Y / N
- 생성일 (regDate) — date — sysdate