client_erd
Tables (15)
alarm_message
- alarmId — varchar(50) — Primary key — NOT NULL — Alarm ID
- alarnDateTime — datetime — Alarm Date
- alarmTypeCd — varchar(50) — Alarm Type
- alarmMessage — varchar(1024) — Alarm Message
- readYn — char(1) — Read YN
- readDateTime — datetime — Readed Date
client_action_log
- logDateTime — datetime(3) — Primary key — NOT NULL — log Date
- action — varchar(50) — Action
- message — varchar(1024) — message
- messageId — varchar(50) — messageId
- targetClassId — varchar(50) — targetClassId
- targetTypeId — varchar(50) — targetTypeId
- targetRequestId — varchar(50) — targetRequestId
- failReason — varchar(2048) — Fail Reason
client_key_files
- fileId — varchar(50) — Primary key — NOT NULL — file ID
- clientRequestId (clientRequestId2) — varchar(50) — Foreign key → client_request_key.clientRequestId — NOT NULL — Key request ID
- fileName — varchar(128) — file name
- fileExtension — varchar(50) — file extension
- filePath — varchar(256) — file path
- fileSize — bigint(20) — file size
- fileCheckSum — varchar(50) — file CheckSum
- keyClassId — varchar(50) — CLASS
- keyTypeId — varchar(50) — TYPE
- keyStatusCd — varchar(50) — NOT NULL — Key status code(rcv, use, del)
- fileIdx — bigint(20) — Key Type file index
- receiveDateTime — datetime — recieve Date
- endUseDateTime — datetime(3) — Used Date
- endUsePCBNo — varchar(50) — Used PCB No
- endUseDllVersion — varchar(50) — Used Dll Version
- endUseDuration — bigint(20) — Used running time
- errorDateTime — datetime — error Date
- errorReason — varchar(1024) — error Reason
- scrapDateTime — datetime — delete Date
- createDateTime — datetime — create Date
- updateDateTime — datetime — update Date
client_key_scraped_files
- fileId (fileId2) — varchar(50) — Foreign key → client_key_files.fileId — NOT NULL — file ID
- clientRequestId (clientRequestId2) — varchar(50) — Foreign key → client_key_files.clientRequestId — NOT NULL — Key request ID
- fileName — varchar(128) — fileName
- fileExtension — varchar(50) — fileExtension
- filePath — varchar(256) — filePath
- fileSize — bigint(20) — fileSize
- fileCheckSum — varchar(50) — fileCheckSum
- keyClassId — varchar(50) — keyClassId
- keyTypeId — varchar(50) — keyTypeId
- keyStatusCd — varchar(50) — NOT NULL — keyStatusCd
- fileIdx — bigint(20) — Key Type fileIdx
- receiveDateTime — datetime — receiveDateTime
- endUsePCBNo — varchar(50) — endUsePCBNo
- endUseDllVersion — varchar(50) — Used Dll Version
- endUseDateTime — datetime(3) — endUseDateTime
- endUseDuration — bigint(20) — endUseDuration
- errorDateTime — datetime — errorDateTime
- errorReason — varchar(1024) — errorReason
- scrapDateTime — datetime — scrapDateTime
- createDateTime — datetime — createDateTime
- updateDateTime — datetime — updateDateTime
client_key_stock
- companyId — varchar(50) — Primary key — NOT NULL — Company ID
- clientId — varchar(50) — Primary key — NOT NULL — Clinet PC ID
- divisionId — varchar(50) — Primary key — NOT NULL — DIVISION
- siteId — varchar(50) — Primary key — NOT NULL — SITE
- keyClassId — varchar(50) — Primary key — NOT NULL — CLASS
- keyTypeId — varchar(50) — Primary key — NOT NULL — TYPE
- inventoryQty — int(11) — present stock qty
- safetyQty — int(11) — safty stock qty
- defaultRequestQty — int(11) — standart request qty
- description — varchar(4086) — description
- managerId — varchar(50) — Manage Id
- createDateTime — datetime — createDate
- updateDateTime — datetime — updateDate
- clientRequestId — varchar(50) — recent Key request ID
- requestQty — int(11) — recent request qty
- requestDateTime — datetime — recent requestDate
- receiveQty — int(11) — recent recieve qty
- receiveDateTime — datetime — recent recive Date
- scrapQty — int(11) — recent delete qty
- scrapDateTime — datetime — recent delete Date
- endUseQty — int(11) — used qty
- endUseDateTime — datetime — used Date
client_key_stock_his
- timeStamp — datetime(6) — Primary key — NOT NULL — TimeStamp
- companyId — varchar(50) — NOT NULL — Company ID
- clientId — varchar(50) — NOT NULL — Clinet PC ID
- divisionId — varchar(50) — NOT NULL — DIVISION
- siteId — varchar(50) — NOT NULL — SITE
- keyClassId — varchar(50) — NOT NULL — CLASS
- keyTypeId — varchar(50) — NOT NULL — TYPE
- inventoryQty — int(11) — present stock qty
- safetyQty — int(11) — safty stock qty
- defaultRequestQty — int(11) — request qty
- description — varchar(4086) — stock update history
- managerId — varchar(50) — Manage Id
- createDateTime — datetime — createDate
- updateDateTime — datetime — updateDate
- clientRequestId — varchar(50) — recent Key request ID
- requestQty — int(11) — recent request qty
- requestDateTime — datetime — recent requestDate
- receiveQty — int(11) — recent recive qty
- receiveDateTime — datetime — recent recive Date
- scrapQty — int(11) — recent delete qty
- scrapDateTime — datetime — recent delete Date
- endUseQty — int(11) — used qty
- endUseDateTime — datetime — used Date
- action — varchar(100)
client_key_used_files
- fileId (fileId2) — varchar(50) — Foreign key → client_key_files.fileId — NOT NULL — file ID
- clientRequestId (clientRequestId2) — varchar(50) — Foreign key → client_key_files.clientRequestId — NOT NULL — Key request ID
- fileName — varchar(128) — fileName
- fileExtension — varchar(50) — fileExtension
- filePath — varchar(256) — filePath
- fileSize — bigint(20) — fileSize
- fileCheckSum — varchar(50) — fileCheckSum
- keyClassId — varchar(50) — keyClassId
- keyTypeId — varchar(50) — keyTypeId
- keyStatusCd — varchar(50) — NOT NULL — keyStatusCd
- fileIdx — bigint(20) — Key Type fileIdx
- receiveDateTime — datetime — receiveDateTime
- endUsePCBNo — varchar(50) — endUsePCBNo
- endUseDateTime — datetime(3) — endUseDateTime
- endUseDuration — bigint(20) — endUseDuration
- errorDateTime — datetime — errorDateTime
- errorReason — varchar(1024) — errorReason
- scrapDateTime — datetime — scrapDateTime
- createDateTime — datetime — createDateTime
- updateDateTime — datetime — updateDateTime
- endUseDllVersion — varchar(50) — endUseDllVersion
client_me
- clientId — varchar(50) — Primary key — NOT NULL — ClientServerId
- companyId — varchar(50) — CompanyId
- publicKey — varchar(4000) — Public Key
- secretKey — varchar(8000) — Secret Key
- apiKey — varchar(1024) — API Key
- dllVersion — varchar(100) — dll Version
- registrationDateTime — datetime — registrationDateTime
- approvalDateTime — datetime — approvalDateTime
- passPhase — varchar(2048) — passPhase
- statusCd — varchar(50) — statusCd
- createDateTime — datetime — createDateTime
- updateDateTime — datetime — updateDateTime
- divisionId — varchar(50) — Company Division ID
- siteId — varchar(100) — Company Site ID
- machineId — varchar(100) — Machine ID
- version — varchar(50)
- addcol — varchar(100)
client_request_check
- clientRequestId (clientRequestId2) — varchar(50) — Foreign key → client_request_key.clientRequestId — NOT NULL — Key request ID
- companyId — varchar(50) — NOT NULL — Company ID
- clientId — varchar(50) — NOT NULL — Company Clinet PC ID
- divisionId — varchar(50) — NOT NULL — DIVISION
- siteId — varchar(50) — NOT NULL — SITE
- keyClassId — varchar(50) — NOT NULL — CLASS
- keyTypeId — varchar(50) — NOT NULL — TYPE
- requestQty — int(11) — NOT NULL — requestQty
- currentKeyQty — int(11) — NOT NULL — currentKeyQty
- currentUsedKeyQty — int(11) — NOT NULL — currentUsedKeyQty
- currentScrapKeyQty — int(11) — NOT NULL — currentScrapKeyQty
- currentKeyFileQty — int(11) — NOT NULL — currentKeyFileQty
- checkDateTime — datetime — checkDateTime
client_request_key
- clientRequestId — varchar(50) — Primary key — NOT NULL — Key request ID
- requestId — varchar(50) — NOT NULL — request ID
- requestTypeCd — varchar(50) — NOT NULL — reqeust Type code(Auto, manual)
- companyId — varchar(50) — NOT NULL — companyId
- clientId — varchar(50) — NOT NULL — ClientServerId
- divisionId — varchar(50) — NOT NULL — DIVISION
- siteId — varchar(50) — NOT NULL — SITE
- keyClassId — varchar(50) — NOT NULL — CLASS
- keyTypeId — varchar(50) — NOT NULL — TYPE
- requestUserId — varchar(50) — NOT NULL — requester id
- requestQty — int(11) — NOT NULL — request qty
- requestDateTime — datetime — request Date
- requestComment — varchar(1024) — NOT NULL — request desc
- managerId — varchar(50) — manager Id
- manageDateTime — datetime — req. process date
- manageStatusCd — varchar(50) — process type(Apr/partial Apr/Rej/Manual)
- manageQty — int(11) — Apr Qty
- manageComment — varchar(256) — Manage Comment
- reservationDateTime — datetime — Reservation proc Date
- transferDateTime — datetime — Trans proc Date
- receiveDateTime — datetime — Trans Rcv Date
- scrapDateTime — datetime — Del Date
- scrapReason — varchar(1024) — Del desc
- fromRange — varchar(128) — Range Start
- toRange — varchar(128) — Range stok
- createDateTime — datetime — createDate
- updateDateTime — datetime — updateDate
client_user
- loginId — varchar(50) — Primary key — NOT NULL — login Id
- password — varchar(256) — login passwd
- userName — varchar(256) — login user name
- userEmail — varchar(256) — User email
- userStatusCd — varchar(50) — User status
- clientId — varchar(50) — NOT NULL — ClientServerId
- lastLoginDateTime — datetime — privious login Date
- loginDateTime — datetime — login Date
- createDateTime — datetime — createDate
- updateDateTime — datetime — updateDate
code
- codeId — varchar(50) — Primary key — NOT NULL — code
- codeGroupId (codeGroupId2) — varchar(50) — Foreign key → code_group.codeGroupId — NOT NULL — code grp ID
- codeName — varchar(50) — NOT NULL — code name
- codeNameEng — varchar(50) — NOT NULL — code eng name
- codeGroupId — varchar(50) — NOT NULL — code grp ID
- orderNo — int(11) — NOT NULL — order
- description — varchar(1024) — desc
- useYn — char(1) — NOT NULL — Use YN
- simpleCode — varchar(50) — short code
- referenceCode — varchar(50) — reference code
- referenceValue1 — varchar(128) — reference1
- referenceValue2 — varchar(128) — reference2
- referenceValue3 — varchar(128) — reference3
- createDateTime — datetime — NOT NULL — createDate
- updateDateTime — datetime — NOT NULL — updateDate
- managerId — varchar(50) — managerId
code_group
- codeGroupId — varchar(50) — Primary key — NOT NULL — code grp ID
- codeGroupName — varchar(50) — code grp name
- description — varchar(1024) — desc
- useYN — char(1) — use YN
- managerId — varchar(50) — admin ID
- createDateTime — datetime — NOT NULL — create date
- updateDateTime — datetime — NOT NULL — update date
task_queue
- taskId — varchar(50) — Primary key — NOT NULL — task ID
- timeStamp — datetime — NOT NULL — TimeStamp
- taskMethod — varchar(50) — task name
- keyClassId — varchar(50) — Key Class
- keyTypeId — varchar(50) — Key Type
- clientRequestId — varchar(50) — Client request ID
- requestedDateTime — datetime — Server request Date
- failedDateTime — datetime — Fail Date
- completedDateTime — datetime — Finish Date
- etc — varchar(2048) — etc value
- failReason — varchar(2048) — failReason
- messageId — varchar(50) — messageId
- message — varchar(1024) — message
task_queue_his
- logDateTimeKey — datetime(3) — Primary key — NOT NULL — log Time Key
- taskId — varchar(50) — Primary key — NOT NULL — task ID
- timeStamp — datetime — NOT NULL — TimeStamp
- taskMethod — varchar(50) — task name
- keyClassId — varchar(50) — Key Class
- keyTypeId — varchar(50) — Key Type
- clientRequestId — varchar(50) — Client request ID
- requestedDateTime — datetime — Server request Date
- failedDateTime — datetime — Fail Date
- completedDateTime — datetime — Finish Date
- etc — varchar(2048) — etc value
- failReason — varchar(2048) — failReason
- messageId — varchar(50) — messageId
- message — varchar(1024) — message