도자기 그릇
테이블 (13)
SF_CONSUMABLEDEFINITION
- CONSUMABLEDEFID — varchar(50) — 기본 키 — NOT NULL
- CONSUMABLEDEFVERSION — varchar(50) — NOT NULL
- CONSUMABLEDEFNAME — nvarchar(160)
- DESCRIPTION — nvarchar(2500)
- ENTERPRISEID — varchar(50)
- CONSUMABLECLASSID — 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
- CONSUMABLELOTID — varchar(50) — 기본 키 — NOT NULL
- DESCRIPTION — nvarchar(2500)
- CONSUMABLEDEFID (CONSUMABLEDEFID2) — varchar(50) — 외래 키 → SF_CONSUMABLEDEFINITION.CONSUMABLEDEFID — NOT NULL
- CONSUMABLESTATE — varchar(50)
- CREATEDQTY — decimal(18, 0) — NOT NULL
- CONSUMABLELOTQTY — decimal(18, 0) — NOT NULL
- 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_EQUIPMENT
- EQUIPMENTID — varchar(50) — 기본 키 — NOT NULL
- EQUIPMENTNAME — nvarchar(160)
- 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) — NOT NULL
- LASTLOTID — varchar(50)
- LASTPRODUCTDEFID — varchar(50)
- LASTPRODUCTDEFVERSION — varchar(50)
- LASTPROCESSSEGMENTID — varchar(50)
- LASTPROCESSSEGMENTVERSION — varchar(50)
- UPPERLIMIT — varchar(50)
- LOWERLIMIT — varchar(50)
- STANDARDTIME — varchar(50
SF_LOT
- LOTID — varchar(50) — 기본 키 — NOT NULL
- DESCRIPTION — nvarchar(2500)
- PRODUCTDEFID — varchar(50)
- PRODUCTDEFVERSION — varchar(50)
- PROCESSDEFID — varchar(50)
- PROCESSDEFVERSION — varchar(50)
- PROCESSPATHSTACK — varchar(70) — 외래 키 → SF_PROCESSPATH.PROCESSPATHID — NOT NULL
- USERSEQUENCE — varchar(50)
- PROCESSSEGMENTID — varchar(50)
- PROCESSSEGMENTVERSION — varchar(50)
- WORKORDERID — varchar(50) — 외래 키 → SF_WORKORDER.WORKORDERID — NOT NULL
- TRACKINUSER — varchar(50)
- TRACKINTIME — datetime2(6)
- TRACKOUTUSER — varchar(50)
- TRACKOUTTIME — datetime2(6)
- LOTSTATE — varchar(50)
- PROCESSSTATE — varchar(50)
- CREATEDQTY — decimal(18, 0)
- QTY — decimal(18, 0)
- DEFECTQTY — 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(250
SF_LOTDEFECT
- TXNHISTKEY — varchar(50) — 기본 키 — NOT NULL
- LOTID — varchar(50) — 외래 키 → SF_LOT.LOTID — NOT NULL
- 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) — 외래 키 → SF_REASONCODE.REASONCODEID — NOT NULL
- 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
- TXNHISTKEY — varchar(50) — 기본 키 — NOT NULL
- LOTID — varchar(50) — 외래 키 → SF_LOT.LOTID — NOT NULL
- TXNGROUPHISTKEY — varchar(50)
- TXNID — varchar(50)
- LOTNAME — nvarchar(160)
- DESCRIPTION — nvarchar(2500)
- ENTERPRISEID — varchar(50)
- ORIGINALPLANTID — varchar(50)
- PREVPLANTID — varchar(50)
- PLANTID — varchar(50)
- PREVAREAID — varchar(50)
- AREAID — varchar(50)
- PREVEQUIPMENTID — varchar(50)
- EQUIPMENTID — varchar(50)
- LOCATIONID — varchar(50)
- RECIPEDEFID — varchar(50)
- RECIPEDEFVERSION — varchar(50)
- PRODUCTIONORDERID — varchar(50)
- WORKORDERID — varchar(50)
- PREVPRODUCTDEFID — varchar(50)
- PREVPRODUCTDEFVERSION — varchar(50)
- PRODUCTDEFID — varchar(50)
- PRODUCTDEFVERSION — varchar(50)
- PREVPROCESSDEFID — varchar(50)
- PREVPROCESSDEFVERSION — varchar(50)
- PROCESSDEFID — varchar(50)
- PROCESSDEFVERSION — varchar(50)
- PROCESSPATHSTACK — varchar(2500)
- PREVUSERSEQUENCE — varchar(50)
- PREVPROCESSSEGMENTID — varchar(50)
- PREVPROCESSSEGMENTVERSION — varchar(50)
- USERSEQUENCE — varchar(50)
- PROCESSSEGMENTID — varchar(50)
- PROCESSSEGMENTVERSION — varchar(50)
- RAWMATERIALID — varchar(50)
- ROOTLOTID — varchar(50)
- PARENTLOTID — varchar(50)
- CHILDLOTID — varchar(50)
- CARRIERID — varchar(50)
- LOTGROUPID — varchar(50)
- PREVLOTTYPE — varchar(50)
- LOTTYPE — varchar(50)
- HASSUBLOT — varchar(50)
- PRIORITY — decimal(18, 0)
- DUEDATE — datetime2(6)
- TRACKINUSER — varchar(50)
- TRACKINTIME — datetime2(6)
- TRACKOUTUSER — varchar(50)
- TRACKOUTTIME — datetime2(6)
- PREVLOTSTATE — varchar(50)
- LOTSTATE — varchar(50)
- PREVPROCESSSTATE — varchar(50)
- PROCESSSTATE — varchar(50)
- ISHOLD — varchar(50)
- ISREWORK — varchar(50)
- CREATEDQTY — decimal(18, 0)
- PREVQTY — decimal(18, 0)
- QTY — decimal(18, 0)
- PREVDEFECTQTY — decimal(18, 0)
- DEFECTQTY — decimal(18, 0)
- … +17
SF_PREFIX
- PREFIX — nvarchar(50) — 기본 키 — NOT NULL
- SERIAL — nvarchar(50) — 기본 키 — NOT NULL
- VALIDSTATE — nvarchar(50
SF_PROCESSDEFINITION
- PROCESSDEFID — varchar(50) — 기본 키 — NOT NULL
- PROCESSDEFVERSION — varchar(50) — 기본 키 — NOT NULL
- PROCESSDEFNAME — nvarchar(160)
- 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
- VERSIONSTATE — varchar(50)
- VALIDSTATE — varchar(50
SF_PROCESSPATH
- PROCESSPATHID — varchar(70) — 기본 키 — NOT NULL
- PATHSEQUENCE — decimal(18, 0)
- USERSEQUENCE — varchar(50)
- PROCESSDEFVERSION — varchar(50) — 외래 키 → SF_PROCESSDEFINITION.PROCESSDEFVERSION — NOT NULL
- PROCESSDEFID — varchar(50) — 외래 키 → SF_PROCESSDEFINITION.PROCESSDEFID — NOT NULL
- PROCESSSEGMENTID — varchar(50) — 외래 키 → SF_PROCESSSEGMENT.PROCESSSEGMENTID — NOT NULL
- PROCESSSEGMENTVERSION — varchar(50) — 외래 키 → SF_PROCESSSEGMENT.PROCESSSEGMENTVERSION — NOT NULL
- PATHTYPE — 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_PROCESSSEGMENT
- PROCESSSEGMENTID — varchar(50) — 기본 키 — NOT NULL
- PROCESSSEGMENTVERSION — varchar(50) — 기본 키 — NOT NULL
- PROCESSSEGMENTNAME — nvarchar(160)
- DESCRIPTION — nvarchar(2500)
- ISTRACKINREQUIRED — 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
- PRODUCTDEFID — varchar(50) — 기본 키 — NOT NULL
- PRODUCTDEFVERSION — varchar(50) — 기본 키 — NOT NULL
- PRODUCTDEFNAME — nvarchar(160)
- DESCRIPTION — nvarchar(2500)
- ENTERPRISEID — varchar(50)
- PRODUCTDEFTYPE — varchar(50)
- OWNER — varchar(50)
- 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_REASONCODE
- REASONCODEID — varchar(50) — 기본 키 — NOT NULL
- REASONCODENAME — nvarchar(160)
- 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_WORKORDER
- WORKORDERID — varchar(50) — 기본 키 — NOT NULL
- ENTERPRISEID — varchar(50)
- PLANQTY — decimal(18, 0)
- PRODUCTDEFID — varchar(50) — 외래 키 → SF_PRODUCTDEFINITION.PRODUCTDEFID — NOT NULL
- PRODUCTDEFVERSION — varchar(50) — 외래 키 → SF_PRODUCTDEFINITION.PRODUCTDEFVERSION — NOT NULL
- OWNER — varchar(50)
- 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