asset
Tables (3)
KFFICE_EMP
- EMP_KTS_SABUN — VARCHAR(20) — Primary key — NOT NULL
TB_OA_ASSET
- ASSET_ID — BIGINT — Primary key — NOT NULL
- ASSET_TYPE — VARCHAR(20) — NOT NULL
- MGMT_TYPE — VARCHAR(10) — NOT NULL
- MODEL_NAME — VARCHAR(100) — NOT NULL
- SERIAL_NO — VARCHAR(100)
- PURCHASE_YEAR — SMALLINT — NOT NULL
- PURCHASE_DATE — DATE
- EMP_KTS_SABUN — VARCHAR(20) — Foreign key → KFFICE_EMP.EMP_KTS_SABUN
- LOCATION — VARCHAR(100)
- STATUS — VARCHAR(20) — NOT NULL
- REMARK — VARCHAR(500)
TB_OA_PC_SPEC
- ASSET_ID — BIGINT — Foreign key → TB_OA_ASSET.ASSET_ID — NOT NULL
- CPU_MODEL — VARCHAR(100) — NOT NULL
- RAM_SIZE_GB — INT — NOT NULL
- DISK_TYPE — VARCHAR(20)
- DISK_SIZE_GB — INT — NOT NULL
- OS_TYPE — VARCHAR(50)