도자기 테이블
테이블 (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