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