00194923-01_OIS_DB.pdf - 第8页

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

100%1 / 47
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
7 von 47
4 Database
The only database system supported is the Microsoft SQL-Server product, version V8.0 (SQL-Server 2000).
4.1 Name of the database
SiplaceOis
4.2 Version of the database schema
The Version entry in the DATAMODEL table supplies the version number of the database schema in the
lLong column. The current version is 207.
4.3 Users
The following users are needed to access the database:
• 3
rd
-party user
− Name: SiplaceMonUser3P
− Password: <NULL>
• 3
rd
-party user
− Name: SiplaceOisUser3P
− Password: <NULL>
Note
The user SiplaceMonUser3P has been set up globally in the master database and permits access to all
monitoring databases (OIS and SIS). In the medium term, SiplaceMonUser3P will replace the user
SiplaceOisUser3P.
4.4 Tables
The layout of the individual tables is illustrated below. The specified data types correspond to the naming
scheme in the MS-SQL-Server.
Note: The sole purpose of the following tables is to clarify the views. No write access is permitted to these
tables.
Legend for tables: CI = Clustered index
I = Index
P = Primary key
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