GnG

Tables (4)

Requested asset (요청 자산)

  • sc_req_item (RITM 티켓 sys id) — Primary key — RITM 티켓의 sys_id
  • alm_hardware. sys id (alm_hardware) — Foreign key → alm_hardware.sys id
  • asset state (상태)
  • asset assign (양수인)
  • sc_task (task Id)
  • sc_task.sys id — Foreign key → scTask.sys_id — NOT NULL
  • number (Field)
  • sc_req_item (RITM 티켓 sys id2) — Foreign key → scTask.sc_req_item — RITM 티켓의 sys_id

alm_hardware (하드웨어)

  • sys id (alm_hardware) — Primary key
  • model (자산명)
  • category (카테고리)
  • status (상태)
  • sub status (하위 상태)
  • assigne (양수인)
  • asset_id (자산ID(바코드 id)) — NOT NULL — 바코드 id

scTask (작업)

  • sys_id (PK) — Primary key — NOT NULL — 요청자산 FK
  • sc_req_item (RITM 티켓 sys id) — Foreign key → sc_req_item.sc_req_item — RITM 티켓의 sys_id
  • number (Field)
  • sc_req_item.requester (티켓 요청자) — sc_req_item 요청자
  • status (상태)
  • task template (task id)

sc_req_item (RITM 티켓)

  • cat_item (Key) — Primary key — NOT NULL — 요청 내역
  • sc_req_item (RITM 티켓 sys id) — Foreign key → Requested asset.sc_req_item — RITM 티켓, sc task
  • alm_hardware.sys id (alm_hardware) — Foreign key → Requested asset.alm_hardware. sys id — alm_hardware
  • requester (요청자)
  • status (상태)
  • sys_id (Field)