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