00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE.pdf - 第77页
ASM OIS/SIS Daten banken 16.0 (R18- 2) / Schnitts tellenbeschreibung Ausgabe 11/2018 3 Inhalt 1 A llgemeines 7 2 Datenschnittste lle 8 3 Einschränkungen 9 4 Datenbank 10 4.1 Vorbelegter Name der Datenban k ..............…
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.: 00900170-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.: 00900170-01
Rupert-Mayer-Straße 44
81379 München
Deutschland
www.asm-smt.com
ASM OIS/SIS Datenbanken 16.0 (R18-2) / Schnittstellenbeschreibung Ausgabe 11/2018
3
Inhalt
1 Allgemeines 7
2 Datenschnittstelle 8
3 Einschränkungen 9
4 Datenbank 10
4.1 Vorbelegter Name der Datenbank ................................................................... 10
4.2 Version des Datenbank-Schemas ................................................................... 10
4.3 Benutzer .......................................................................................................... 10
4.4 Datenbank-Wartung ........................................................................................ 11
4.4.1 "DB lösche alte Daten" .................................................................................... 11
4.4.2 Automatische Reorganisation von Indexes und Statistik .................................. 12
4.4.3 Periodische manuelle Wartung der OIS-Datenbank in OIS V10.x / V11.x ........ 12
4.5 Tabellen .......................................................................................................... 13
4.5.1 OIS-Tabellen ................................................................................................... 14
4.5.1.1 Tabelle STATETEXT ....................................................................................... 14
4.5.1.2 Tabelle FEEDERTYPE .................................................................................... 14
4.5.1.3 Tabelle BOARD ............................................................................................... 14
4.5.1.4 Tabelle EVENT................................................................................................ 16
4.5.1.5 Tabelle USEREVENT ...................................................................................... 16
4.5.1.6 Tabelle PICKUPERROR ................................................................................. 17
4.5.1.7 Tabelle PARTNUMBER ................................................................................... 18
4.5.1.8 Tabelle COMPONENTSHAPE ........................................................................ 18
4.5.1.9 Tabelle STATION ............................................................................................ 19
4.5.1.10 Tabelle STATE ................................................................................................ 20
4.5.1.11 Tabelle STATESHARE .................................................................................... 20
4.5.1.12 Tabelle DATAMODEL ..................................................................................... 20
4.5.1.13 Tabelle SHIFTWORK ...................................................................................... 20
4.5.1.14 Tabelle EVENTTEXT....................................................................................... 21
4.5.1.15 Tabelle STATETRANSITION ........................................................................... 21
4.5.1.16 Tabelle GantryState ........................................................................................ 23
4.5.1.17 Tabelle PlocState ............................................................................................ 24
4.5.1.18 Tabelle CompBlock ......................................................................................... 24
4.5.1.19 Tabelle CompDetail ......................................................................................... 24
4.5.1.20 Tabelle CompPosition ..................................................................................... 26
4.5.1.21 Tabelle Panel .................................................................................................. 26
4.5.1.22 Tabelle SpliceEvent ......................................................................................... 27
4.5.1.23 Tabelle ProcessingLocation............................................................................. 27
4.5.1.24 Tabelle PlocAvailability .................................................................................... 28
4.5.1.25 Tabelle LaneAssignment ................................................................................. 29
4.5.1.26 Tabelle AssistCollection .................................................................................. 29
4.5.1.27 Tabelle ErrorMessage ..................................................................................... 30
4.5.2 SIS-Tabellen ................................................................................................... 31
4.5.2.1 Tabelle RECIPE .............................................................................................. 31
4.5.2.2 Tabelle TRACK ............................................................................................... 34
4.5.2.3 Tabelle DATAMODEL ..................................................................................... 35
4.5.2.4 Tabelle BOARD ............................................................................................... 35
4.5.2.5 Tabelle HEAD ................................................................................................. 36
4
4.5.2.6 Tabelle RECIPEADDON ................................................................................. 36
5 OIS Views 38
5.1 Views der Version 16.0 .................................................................................... 38
5.1.1 View V_PLOCSTATE_160 .............................................................................. 38
5.1.2 View V_GANTRYSTATE_160 ......................................................................... 38
5.1.3 View V_PANEL_160 ....................................................................................... 38
5.1.4 View V_PICKUPERROR_160 ......................................................................... 38
5.1.5 View V_USEDCOMPONENTS_160 ................................................................ 38
5.1.6 View V_EVENT_160 ....................................................................................... 39
5.1.7 View V_BOARD_160....................................................................................... 39
5.2 Views der Version 15.1 .................................................................................... 39
5.2.1 View V_FEEDERTYPE151 ............................................................................. 39
5.2.2 View V_STATION151 ...................................................................................... 39
5.3 Views der Version 14.1 .................................................................................... 39
5.3.1 View V_BOARD141 ........................................................................................ 39
5.3.2 View V_EVENT141 ......................................................................................... 39
5.3.3 View V_EVENTANDTEXT14 ........................................................................... 40
5.3.4 View V_STATETRANSITION141 .................................................................... 40
5.3.5 View V_STATETRANSITIONANDTEXT141 .................................................... 40
5.3.6 View V_SPLICEEVENT141 ............................................................................. 40
5.4 Views der Version 14.0 .................................................................................... 40
5.4.1 View V_STATION14 ........................................................................................ 40
5.5 Views der Version 12....................................................................................... 40
5.5.1 View V_USEDCOMPONENTS12 .................................................................... 40
5.6 Views der Version 11....................................................................................... 41
5.6.1 View V_PANEL11 ........................................................................................... 41
5.6.2 View V_BOARD11 .......................................................................................... 41
5.7 Views der Version 10....................................................................................... 41
5.7.1 View V_USEDCOMPONENTS10 .................................................................... 41
5.7.2 View V_PlocState10 ........................................................................................ 41
5.7.3 View V_GantryState10 .................................................................................... 41
5.8 Views der Version 9 ........................................................................................ 42
5.8.1 View V_BOARD9 ............................................................................................ 42
5.8.2 View V_EVENT9 ............................................................................................. 42
5.8.3 View V_STATION9 .......................................................................................... 42
5.9 Views der Version 8 ........................................................................................ 42
5.9.1 View V_BOARD8 ............................................................................................ 42
5.9.2 View V_Event8 ................................................................................................ 42
5.10 Views der Version 7 ........................................................................................ 42
5.10.1 View V_BOARD7 ............................................................................................ 42
5.10.2 View V_ PICKUPERROR7 .............................................................................. 43
5.10.3 View V_RECIPECHANGE7 ............................................................................. 43
5.11 Views der Version 6 ........................................................................................ 43
5.11.1 View V_USEDCOMPONENTS6 ...................................................................... 43
5.11.2 View V_PARTNUMBER6 ................................................................................ 43
5.11.3 View V_COMPONENTSHAPE6 ...................................................................... 44
5.11.4 View V_PICKUPERROR6 ............................................................................... 44
5.11.5 View V_EVENT6 ............................................................................................. 44
5.11.6 View V_EVENTANDTEXT6 ............................................................................. 44
5.11.7 View V_USEREVENT6 ................................................................................... 44
5.11.8 View V_USEREVENTANDTEXT6 ................................................................... 44
5.11.9 View V_STATETRANSITION6 ........................................................................ 44
5.12 Views der Version 5 ........................................................................................ 45
5.12.1 View V_BOARD5 ............................................................................................ 45
5.12.2 View V_EVENT5 ............................................................................................. 45
5.12.3 View V_EVENTANDTEXT5 ............................................................................. 45
5.12.4 View V_USEREVENT5 ................................................................................... 45
5.12.5 View V_USEREVENTANDTEXT5 ................................................................... 45
5.12.6 View V_PICKUPERROR5 ............................................................................... 45
5.12.7 View V_USEDCOMPONENTS5 ...................................................................... 46