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)