00194923-01_OIS_DB.pdf - 第10页

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 B yte I P Name of the line strLine nvarchar(1024) 2048 Name of …

100%1 / 47
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
9 von 47
4.4.4 PICKUPERROR table
PICKUPERROR OIS name Data type Byte CI P
Identification number of the Station (Reference to
Table STATION)
lId int 4
9
Date/time at which this error occurred dtTime datetime 8
9
Serial number of manufactured PCB lBoardNumber int 4
Error number lError int 4
Error when retrieving the component with this
designation
strPartNumber nvarchar(50) 100
Component component shape strComponentShape nvarchar(20) 40
Table/location from which the component was
retrieved
ucTable tinyint 1
Track number sTrack smallint 2
Tower ucTower tinyint 1
Level sLevel smallint 2
Division sReceptacle smallint 2
Head identification ucHead tinyint 1
Segment of head ucSegment tinyint 1
Designation of nozzle sNozzle smallint 2
4.4.5 USEDCOMPONENTS table
USEDCOMPONENTS OIS name Data type Byte CI P
Identification number of the Station (Reference to
Table STATION)
lId int 4
9
Date/time at which the data record was created dtTime datetime 8
9
Serial number of manufactured PCB lBoardNumber int 4
Number of attempts to access this track sAccessTotal smallint 2
Number of rejected parts because an ident error sRejectIdent smallint 2
Table/location from which the component was
retrieved
ucTable tinyint 1
Track number sTrack smallint 2
Tower (MTC only, otherwise dummy) ucTower tinyint 1
Level (WPC or MTC only, otherwise dummy) sLevel smallint 2
Division sReceptacle smallint 2
Number of rejected parts because a vacuum error sRejectVacuum smallint 2
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