00194923-01_OIS_DB.pdf - 第9页

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 B yte CI P Identification number of t he Station (Refere…

100%1 / 47
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
8 von 47
4.4.1 BOARD table
BOARD OIS name Data type Byte CI P
Identification number of the Station (Reference to
Table STATION)
lId int 4
9
End date/time of PCB manufacture dtTime datetime 8
9
Manufactured production batch strRecipe nvarchar(100) 200
Name of the set-up strSetup nvarchar(50) 100
Name of the PCB strBoard nvarchar(50) 100
Serial number of manufactured PCB lBoardNumber int 4
Conveyor belt 1 / 2 ucConveyor tinyint 1
Cycle time of PCB sDuration smallint 2
Starting time since production batch manufactured dtRecipeStart datetime 8
Starting time since set-up used for manufacture dtSetupStart datetime 8
PCB barcode strBarcode nvarchar(40) 80
PCB status (0 = OK; 1 = aborted; 2 = continued) ucStatus tinyint 1
4.4.2 EVENT table
EVENT 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 event occurred dtTime datetime 8
9
Serial number of manufactured PCB lBoardNumber int 4
Conveyor belt 1 / 2 ucConveyor tinyint 1
Processing area 1 / 2 ucProcessingArea tinyint 1
Event number sEvent smallint 2
4.4.3 USEREVENT table
USEREVENT 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 event occurred dtTime datetime 8
9
Serial number of manufactured PCB lBoardNumber int 4
Conveyor belt 1 / 2 ucConveyor tinyint 1
Processing area 1 / 2 ucProcessingArea tinyint 1
User event number sEvent smallint 2
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