00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN.pdf
ASM OIS/SIS Databases 1 4.0 (R16 - 2) Interface Descriptio n ASM OIS/SIS Datenbanken 14.0 (R16 - 2) Schnittstellenb eschreibung Ausgabe 12/2016 Edition
ASM OIS/SIS Databases 14.0 (R16-2)
Interface Description
ASM OIS/SIS Datenbanken 14.0 (R16-2)
Schnittstellenbeschreibung
Ausgabe 12/2016 Edition
All names identified by ® are registered trademarks of the ASM Assembly Systems GmbH & Co. KG. The
remaining trademarks in this publication may be trademarks whose use by third parties for their own purposes
could violate the rights of the owner.
We have reviewed the contents of this publication to ensure consistency with the hardware and software
described. Since variance cannot be precluded entirely, we cannot guarantee full consistency. However, the
information given in this publication is reviewed regularly and any necessary corrections are included in
subsequent editions.
Copyright © ASM Assembly Systems Technical data subject to change
ASM Assembly Systems GmbH & Co. KG Item-no.: 00900045-01
Rupert-Mayer-Strasse 44
81379 München
Germany
www.asm-smt.com
Alle mit dem Schutzrechtsvermerk ® gekennzeichneten Bezeichnungen sind eingetragene Marken der ASM
Assembly Systems GmbH & Co. KG. Die übrigen Bezeichnungen in dieser Schrift können Marken sein, deren
Benutzung durch Dritte für deren Zwecke die Rechte der Inhaber verletzen kann.
Wir haben den Inhalt der Druckschrift auf Übereinstimmung mit der beschriebenen Hard- und Software geprüft.
Dennoch können Abweichungen nicht ausgeschlossen werden, sodass wir für die vollständige Übereinstimmung
keine Gewähr übernehmen. Die Angaben in dieser Druckschrift werden regelmäßig überprüft und notwendige
Korrekturen sind in den nachfolgenden Auflagen enthalten.
Copyright © ASM Assembly Systems Änderungen vorbehalten
ASM Assembly Systems GmbH & Co. KG Artikel-Nr.: 00900045-01
Rupert-Mayer-Straße 44
81379 München
Deutschland
www.asm-smt.com
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
3
Contents
1 General 7
2 Data Interface 8
3 Restrictions 9
4 Database 10
4.1 Name of the Database ....................................................................................... 10
4.2 Version of the Database Schema ...................................................................... 10
4.3 Users ................................................................................................................. 10
4.4 Database Maintenance ...................................................................................... 11
4.4.1 "DB remove old data" ......................................................................................... 11
4.4.2 Automatic Reorganization of Indexes and Statistics .......................................... 12
4.4.3 Periodic Manual Maintenance of the OIS Database in OIS V10.x / V11.x ......... 12
4.5 Tables ................................................................................................................ 13
4.5.1 OIS Tables ......................................................................................................... 14
4.5.1.1 STATETEXT Table ............................................................................................ 14
4.5.1.2 FEEDERTYPE Table ......................................................................................... 14
4.5.1.3 BOARD Table .................................................................................................... 14
4.5.1.4 EVENT Table ..................................................................................................... 16
4.5.1.5 USEREVENT Table ........................................................................................... 16
4.5.1.6 PICKUPERROR Table....................................................................................... 17
4.5.1.7 USEDCOMPONENTS Table ............................................................................. 19
4.5.1.8 PARTNUMBER Table ........................................................................................ 19
4.5.1.9 COMPONENTSHAPE Table ............................................................................. 20
4.5.1.10 STATION Table ................................................................................................. 20
4.5.1.11 STATE Table ..................................................................................................... 20
4.5.1.12 STATESHARE Table ......................................................................................... 21
4.5.1.13 DATAMODEL Table .......................................................................................... 21
4.5.1.14 SHIFTWORK Table ........................................................................................... 21
4.5.1.15 EVENTTEXT Table ............................................................................................ 21
4.5.1.16 STATETRANSITION Table ................................................................................ 22
4.5.1.17 RECIPECHANGE Table .................................................................................... 24
4.5.1.18 SESSION Table ................................................................................................. 24
4.5.1.19 GantryState Table .............................................................................................. 25
4.5.1.20 PlocState Table ................................................................................................. 25
4.5.1.21 CompBlock Table .............................................................................................. 26
4.5.1.22 CompDetail Table .............................................................................................. 26
4.5.1.23 CompPosition Table........................................................................................... 28
4.5.1.24 Panel Table ........................................................................................................ 28
4.5.2 SIS Tables ......................................................................................................... 29
4.5.2.1 RECIPE Table ................................................................................................... 29
4.5.2.2 TRACK Table ..................................................................................................... 32
4.5.2.3 DATAMODEL Table .......................................................................................... 33
4.5.2.4 BOARD Table .................................................................................................... 33
4.5.2.5 HEAD Table ....................................................................................................... 34
4.5.2.6 RECIPEADDON Table....................................................................................... 34