00194923-01_OIS_DB.pdf - 第11页

OIS Datenbank Version 4.1 Schnittstellenbeschreibung OIS Database Version 4.1 Interface Description 11 von 47 4.4.10 SHIFTWORK table SHIFTWORK OIS name Data type Byte I P Name of shift strName nvarchar(32) 64 9 Starting …

100%1 / 47
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
10 von 47
4.4.6 STATION table
STATION OIS name Data type Byte I P
Name of the line strLine nvarchar(1024) 2048
Name of the station strStation nvarchar(128) 256
Number of placement areas ucProcessingArea tinyint 1
Text for the user strText nvarchar(32) 64
TCP/IP address or computer name of station strComputer nvarchar(255) 510
Identification number of the Station lId int 4
Position of the stations within a line lOrder int 4
Machine identification MID strMid nvarchar(50) 100
Is a machine identification available bMid bit 1
4.4.7 STATE table
STATE OIS name Data type Byte I P
8 user-defined states (T
1
– T
8
), availability (T
b
) and
the definition "show table states" (T
9
)
strTimeShare nvarchar(32) 64
9
Name of share of time strName nvarchar(32) 64
Color of share of time lColor int 4
Show share of time bDefined bit 1
4.4.8 STATESHARE table
STATESHARE OIS name Data type Byte I P
8 user-defined states (T
1
– T
8
), availability (T
b
) and
the definition "show table states" (T
9
)
strTimeShare nvarchar(32) 64
9
State of the machine, individual states of the
machine
lState int 4
9
Share of time lPercent int 4
4.4.9 DATAMODEL table
DATAMODEL OIS name Data type Byte I P
Name of the entry strName nvarchar(32) 64
Value 1 of data type int lLong int 4
Value 2 of data type string strString nvarchar(255) 510
Value 3 of data type datetime dtTime datetime 8
Value 4 of data type double dDouble float 8
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
11 von 47
4.4.10 SHIFTWORK table
SHIFTWORK OIS name Data type Byte I P
Name of shift strName nvarchar(32) 64
9
Starting time of shift dtStart datetime 8
4.4.11 EVENTTEXT table
EVENTTEXT OIS name Data type Byte I P
Event number sEvent smallint 2
Event name strName nvarchar(32) 64
4.5 Views of Version 4
4.5.1 V_STATION4 view
Supplies all the columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid
4.6 Views of Version 3
4.6.1 V_BOARD3 view
Supplies all the columns of the BOARD table in the following sequence:
lId, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, ucStatus
4.6.2 V_EVENT3 view
Supplies all the columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.6.3 V_EVENTANDTEXT3 view
Supplies all the columns of the EVENT table as well as the appropriate event name for the corresponding
event number from the EVENTTEXT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
12 von 47
4.6.4 V_USEREVENT3 view
Supplies all the columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.6.5 V_USEREVENTANDTEXT3 view
Supplies all the columns of the USEREVENT table as well as the appropriate event name for the
corresponding event number from the EVENTTEXT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
4.6.6 V_PICKUPERROR3 view
Supplies all the columns of the PICKUPERROR table in the following sequence:
lId, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower, sLevel,
sReceptacle, ucHead, ucSegment, sNozzle
4.6.7 V_USEDCOMPONENTS3 view
Supplies all the columns of the USEDCOMPONENTS table in the following sequence:
lId, dtTime, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, ucTable, sTrack, ucTower, sLevel,
sReceptacle
4.6.8 V_STATION3 view
Supplies all the columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder
4.6.9 V_STATE3 view
Supplies all the columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
4.6.10 V_STATESHARE3 view
Supplies all the columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
4.6.11 V_DATAMODEL3 view
Supplies all the columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble