도자기 테이블

테이블 (34)

SF_CODE

  • CODEID — varchar(50) — NOT NULL
  • CODECLASSID — varchar(50) — NOT NULL
  • CODENAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • PARENTCODEID — varchar(50)
  • DISPLAYSEQUENCE — decimal(18, 0)
  • DICTIONARYID — varchar(50)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VALIDSTATE — varchar(50

SF_CONSUMABLEDEFINITION (Untitled6)

  • CONSUMABLEDEFINITIONID (Key) — 기본 키 — NOT NULL

SF_CONSUMABLEDEFINITION

  • CONSUMABLEDEFID — varchar(50) — NOT NULL
  • CONSUMABLEDEFVERSION — varchar(50) — NOT NULL
  • CONSUMABLEDEFNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • CONSUMABLECLASSID — varchar(50)
  • CONSUMABLETYPE — varchar(50)
  • UNIT — varchar(50)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VERSIONSTATE — varchar(50)
  • VALIDSTATE — varchar(50

SF_CONSUMABLELOT (Untitled5)

  • CONSUMABLELOTID — 기본 키 — NOT NULL

SF_CONSUMABLELOT

  • CONSUMABLELOTID — varchar(50) — NOT NULL
  • CONSUMABLELOTNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • AREAID — varchar(50)
  • EQUIPMENTID — varchar(50)
  • LOCATIONID — varchar(50)
  • CONSUMABLEDEFID — varchar(50)
  • CONSUMABLEDEFVERSION — varchar(50)
  • CONSUMABLELOTGROUPID — varchar(50)
  • CONSUMABLESTATE — varchar(50)
  • CREATEDQTY — decimal(18, 0) — NOT NULL
  • CONSUMABLELOTQTY — decimal(18, 0) — NOT NULL
  • EXPIREDDATE — datetime2(6)
  • ISHOLD — varchar(50)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500 — varchar(250

SF_CONSUMABLELOTHISTORY (Untitled7)

  • HISTORY — 기본 키 — NOT NULL
  • CONSUMABLELOTID — 외래 키 → SF_CONSUMABLELOT.CONSUMABLELOTID — NOT NULL

SF_CONSUMEMATERIALLOT

  • MATERIALLOTID — varchar(50) — NOT NULL
  • MATERIALTYPE — varchar(50) — NOT NULL
  • LOTID — varchar(50) — NOT NULL
  • TXNHISTKEY — varchar(50) — NOT NULL
  • TXNGROUPHISTKEY — varchar(50)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • AREAID — varchar(50)
  • CONSUMEDQTY — decimal(18, 0)
  • EQUIPMENTID — varchar(50)
  • LOCATIONID — varchar(50)
  • PRODUCTDEFID — varchar(50)
  • PRODUCTDEFVERSION — varchar(50)
  • PROCESSDEFID — varchar(50)
  • PROCESSDEFVERSION — varchar(50)
  • PROCESSPATHID — varchar(70)
  • USERSEQUENCE — varchar(50)
  • PROCESSSEGMENTID — varchar(50)
  • PROCESSSEGMENTVERSION — varchar(50)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • TXNUSER — varchar(50)
  • TXNTIME — datetime2(6)
  • TXNREASONCODECLASS — varchar(50)
  • TXNREASONCODE — varchar(50)
  • TXNCOMMENT — nvarchar(2500 — varchar(250

SF_EQUIPMENT

  • EQUIPMENTID — varchar(50) — NOT NULL
  • EQUIPMENTNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • AREAID — varchar(50)
  • LOCATIONID — varchar(50)
  • EQUIPMENTTYPE — varchar(50)
  • DETAILEQUIPMENTTYPE — varchar(50)
  • EQUIPMENTCLASSID — varchar(50)
  • PARENTEQUIPMENTID — varchar(50)
  • RECIPECLASSID — varchar(50)
  • STATEMODELID — varchar(50)
  • VENDOR — varchar(50)
  • MODEL — varchar(50)
  • SERIALNO — varchar(50)
  • PROCESSUNIT — varchar(50)
  • MINCAPACITY — decimal(18, 0)
  • MAXCAPACITY — decimal(18, 0)
  • STATE — varchar(50)
  • E10STATE — varchar(50)
  • CONTROLMODE — varchar(50)
  • OPERATIONMODE — varchar(50)
  • CURRENTRECIPEDEFID — varchar(50)
  • CURRENTRECIPEDEFVERSION — varchar(50)
  • PROCESSEDLOTCOUNT — decimal(18, 0)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VALIDSTATE — varchar(50) — NOT NULL
  • LASTLOTID — varchar(50)
  • LASTPRODUCTDEFID — varchar(50)
  • LASTPRODUCTDEFVERSION — varchar(50)
  • LASTPROCESSSEGMENTID — varchar(50)
  • LASTPROCESSSEGMENTVERSION — varchar(50

SF_EQUIPMENT (Untitled11)

  • EQUIPMENTID — 기본 키 — NOT NULL

SF_EQUIPMENTHISTORY (Untitled17)

  • HISTKEY — 기본 키 — NOT NULL
  • EQUIPMENTID — 외래 키 → SF_EQUIPMENT.EQUIPMENTID — NOT NULL

SF_LOT (Untitled)

  • LOT ID (LOTID) — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • PRODUCTDEFID — 외래 키 → SF_PRODUCTDEFINITION.PRODUCTDEFID — NOT NULL
  • PRODUCTDEFVERSION — 외래 키 → SF_PRODUCTDEFINITION.PRODUCTDEFVERSION — NOT NULL

SF_LOT

  • LOTID — varchar(50) — NOT NULL
  • LOTNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • AREAID — varchar(50)
  • EQUIPMENTID — varchar(50)
  • LOCATIONID — varchar(50)
  • RECIPEDEFID — varchar(50)
  • RECIPEDEFVERSION — varchar(50)
  • ORIGINALPLANTID — varchar(50)
  • RAWMATERIALID — varchar(50)
  • ROOTLOTID — varchar(50)
  • PARENTLOTID — varchar(50)
  • CHILDLOTID — varchar(50)
  • CARRIERID — varchar(50)
  • LOTGROUPID — varchar(50)
  • LOTTYPE — varchar(50)
  • HASSUBLOT — varchar(50)
  • PRODUCTDEFID — varchar(50)
  • PRODUCTDEFVERSION — varchar(50)
  • PROCESSDEFID — varchar(50)
  • PROCESSDEFVERSION — varchar(50)
  • PROCESSPATHSTACK — nvarchar(2500)
  • USERSEQUENCE — varchar(50)
  • PROCESSSEGMENTID — varchar(50)
  • PROCESSSEGMENTVERSION — varchar(50)
  • PRODUCTIONORDERID — varchar(50)
  • WORKORDERID — varchar(50)
  • PRIORITY — decimal(18, 0)
  • DUEDATE — datetime2(6)
  • TRACKINUSER — varchar(50)
  • TRACKINTIME — datetime2(6)
  • TRACKOUTUSER — varchar(50)
  • TRACKOUTTIME — datetime2(6)
  • LOTSTATE — varchar(50)
  • PROCESSSTATE — varchar(50)
  • ISHOLD — varchar(50)
  • ISREWORK — varchar(50)
  • CREATEDQTY — decimal(18, 0)
  • QTY — decimal(18, 0)
  • DEFECTQTY — decimal(18, 0)
  • REWORKCOUNT — decimal(18, 0)
  • TOTALREWORKCOUNT — decimal(18, 0)
  • SUBPROCESSDEFID — varchar(50)
  • SUBPROCESSDEFVERSION — varchar(50)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • STARTEDUSER — varchar(50)
  • STARTEDDATE — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500 — varchar(250

SF_LOTDEFECT

  • LOTID — varchar(50) — NOT NULL
  • TXNHISTKEY — varchar(50) — NOT NULL
  • TXNGROUPHISTKEY — varchar(50)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • AREAID — varchar(50)
  • PRODUCTDEFID — varchar(50)
  • PRODUCTDEFVERSION — varchar(50)
  • PROCESSDEFID — varchar(50)
  • PROCESSDEFVERSION — varchar(50)
  • PROCESSPATHID — varchar(70)
  • USERSEQUENCE — varchar(50)
  • PROCESSSEGMENTID — varchar(50)
  • PROCESSSEGMENTVERSION — varchar(50)
  • DEFECTCODE — varchar(50)
  • DEFECTQTY — decimal(18, 0)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • TXNUSER — varchar(50)
  • TXNTIME — datetime2(6)
  • TXNREASONCODECLASS — varchar(50)
  • TXNREASONCODE — varchar(50)
  • TXNCOMMENT — nvarchar(2500 — varchar(250

SF_LOTHISTORY (Untitled4)

  • HISTORY — 기본 키 — NOT NULL
  • LOT ID (LOTID) — 외래 키 → SF_LOT.LOT ID — NOT NULL

SF_LOTHOLD (Untitled2)

  • HOLDCODE — 기본 키 — NOT NULL
  • LOT ID (LOTID) — 외래 키 → SF_LOT.LOT ID — NOT NULL

SF_LOTHOLD

  • LOTID — varchar(50) — NOT NULL
  • HOLDCODE — varchar(50) — NOT NULL
  • HOLDCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • HOLDUSER — varchar(50)
  • HOLDTIME — datetime2(6

SF_PROCESSDEFINITION

  • PROCESSDEFID — varchar(50) — NOT NULL
  • PROCESSDEFVERSION — varchar(50) — NOT NULL
  • PROCESSDEFNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • PROCESSCLASSID — varchar(50)
  • PROCESSDEFTYPE — varchar(50)
  • LEADTIME — decimal(18, 0)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VERSIONSTATE — varchar(50)
  • VALIDSTATE — varchar(50

SF_PROCESSDEFINITION (Untitled10)

  • PROCESSDEFID — 기본 키 — NOT NULL
  • PROCESSDEFVERSION — 기본 키 — NOT NULL

SF_PROCESSDEFINITIONHISTORY (Untitled19)

  • TXNHISTKEY — 기본 키 — NOT NULL
  • PROCESSDEFID — 외래 키 → SF_PROCESSDEFINITION.PROCESSDEFID — NOT NULL
  • PROCESSDEFVERSION — 외래 키 → SF_PROCESSDEFINITION.PROCESSDEFVERSION — NOT NULL

SF_PROCESSPATH (Untitled8)

  • PROCESSPATHID — 기본 키 — NOT NULL
  • PROCESSDEFID — 외래 키 → SF_PROCESSDEFINITION.PROCESSDEFID — NOT NULL
  • PROCESSDEFVERSION — 외래 키 → SF_PROCESSDEFINITION.PROCESSDEFVERSION — NOT NULL

SF_PROCESSPATH

  • PROCESSPATHID — varchar(70) — NOT NULL
  • PATHSEQUENCE — decimal(18, 0)
  • USERSEQUENCE — varchar(50)
  • PROCESSDEFID — varchar(50)
  • PROCESSDEFVERSION — varchar(50)
  • PROCESSSEGMENTID — varchar(50)
  • PROCESSSEGMENTVERSION — varchar(50)
  • PATHTYPE — varchar(50)
  • ALTERNATETYPE — varchar(50)
  • ALTERNATEPROCESSCLASSID — varchar(50)
  • REWORKPROCESSDEFID — varchar(50)
  • REWORKPROCESSDEFVERSION — varchar(50)
  • REWORKRETURNPATHID — varchar(50)
  • DESCRIPTION — nvarchar(2500)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VALIDSTATE — varchar(50

SF_PROCESSPATHHISTORY (Untitled20)

  • TXNHISTKEY — 기본 키 — NOT NULL
  • PROCESSPATHID — 외래 키 → SF_PROCESSPATH.PROCESSPATHID — NOT NULL

SF_PROCESSSEGMENT (Untitled9)

  • PROCESSSEGMENTID — 기본 키 — NOT NULL
  • PROCESSSEGMENTVERSION — 기본 키 — NOT NULL
  • PROCESSPATHID — 외래 키 → SF_PROCESSPATH.PROCESSPATHID — NOT NULL

SF_PROCESSSEGMENT

  • PROCESSSEGMENTID — varchar(50) — NOT NULL
  • PROCESSSEGMENTVERSION — varchar(50) — NOT NULL
  • PROCESSSEGMENTNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • AREAID — varchar(50)
  • PROCESSSEGMENTCLASSID — varchar(50)
  • PROCESSSEGMENTTYPE — varchar(50)
  • EQUIPMENTCLASSID — varchar(50)
  • ISTRACKINREQUIRED — varchar(50)
  • LEADTIME — decimal(18, 0)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VERSIONSTATE — varchar(50)
  • VALIDSTATE — varchar(50

SF_PROCESSSEGMENTHISTORY (Untitled18)

  • TXNHISTKEY — 기본 키 — NOT NULL
  • PROCESSSEGMENTID — 외래 키 → SF_PROCESSSEGMENT.PROCESSSEGMENTID — NOT NULL
  • PROCESSSEGMENTVERSION — 외래 키 → SF_PROCESSSEGMENT.PROCESSSEGMENTVERSION — NOT NULL

SF_PRODUCTDEFINITION

  • PRODUCTDEFID — varchar(50) — NOT NULL
  • PRODUCTDEFVERSION — varchar(50) — NOT NULL
  • PRODUCTDEFNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • PRODUCTCLASSID — varchar(50)
  • PRODUCTDEFTYPE — varchar(50)
  • DEFAULTQTY — decimal(18, 0)
  • HASSUBLOT — varchar(50)
  • OWNER — varchar(50)
  • LEADTIME — decimal(18, 0)
  • PROCESSDEFID — varchar(50)
  • PROCESSDEFVERSION — varchar(50)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VERSIONSTATE — varchar(50)
  • VALIDSTATE — varchar(50

SF_PRODUCTDEFINITION (Untitled3)

  • PRODUCTDEFID — 기본 키 — NOT NULL
  • PRODUCTDEFVERSION — 기본 키 — NOT NULL

SF_PRODUCTIONORDER (Untitled13)

  • PRODUCTIONORDERID — 기본 키 — NOT NULL

SF_PRODUCTIONORDERHISTORY (Untitled14)

  • HISTKEY — 기본 키 — NOT NULL
  • PRODUCTIONORDERID — 외래 키 → SF_PRODUCTIONORDER.PRODUCTIONORDERID — NOT NULL

SF_REASONCODE (Untitled15)

  • REASONCODEID — 기본 키 — NOT NULL

SF_REASONCODE

  • REASONCODEID — varchar(50) — NOT NULL
  • REASONCODENAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • REASONCODECLASSID — varchar(50)
  • DISPLAYSEQUENCE — decimal(18, 0)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VALIDSTATE — varchar(50

SF_STATE (Untitled16)

  • STATEID — 기본 키 — NOT NULL
  • STATEMODELID — 기본 키 — NOT NULL

SF_WORKORDER

  • WORKORDERID — varchar(50) — NOT NULL
  • PRODUCTIONORDERID — varchar(50)
  • WORKORDERNAME — nvarchar(160)
  • DESCRIPTION — nvarchar(2500)
  • ENTERPRISEID — varchar(50)
  • PLANTID — varchar(50)
  • AREAID — varchar(50)
  • EQUIPMENTID — varchar(50)
  • PRODUCTDEFID — varchar(50)
  • PRODUCTDEFVERSION — varchar(50)
  • PLANSTARTTIME — datetime2(6)
  • PLANENDTIME — datetime2(6)
  • PLANQTY — decimal(18, 0)
  • OWNER — varchar(50)
  • STATE — varchar(50)
  • STARTQTY — decimal(18, 0)
  • COMPLETEQTY — decimal(18, 0)
  • SCRAPQTY — decimal(18, 0)
  • CREATOR — varchar(50)
  • CREATEDTIME — datetime2(6)
  • STARTUSER — varchar(50)
  • STARTTIME — datetime2(6)
  • COMPLETEUSER — varchar(50)
  • COMPLETETIME — datetime2(6)
  • MODIFIER — varchar(50)
  • MODIFIEDTIME — datetime2(6)
  • LASTTXNHISTKEY — varchar(50)
  • LASTTXNID — varchar(50)
  • LASTTXNUSER — varchar(50)
  • LASTTXNTIME — datetime2(6)
  • LASTTXNCOMMENT — nvarchar(2500) — varchar(2500) NUL
  • VALIDSTATE — varchar(50) — NOT NULL
  • TEST — varchar(50

SF_WORKORDERHISTORY (CopyOfUntitled12)

  • HISTKEY — 기본 키 — NOT NULL
  • WORKORDERID — 외래 키 — NOT NULL