00194923-01_OIS_DB.pdf - 第3页

OIS Datenbank Version 4.1 Schnittstellenbeschreibung OIS Database Version 4.1 Interface Description 3 von 47 Contents/Inhaltsverzeichnis Seite 1 General ...................................................................…

100%1 / 47
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
2 von 47
Dokumentvorlage (Versionsbeschreibung_Vorlage.dot) Software Versionsbeschreibungen SD EA 1 Version 2 vom 08.08.02
UNIX is a registered trademark of AT&T
X-Windows is a trademark
LINUX is a trademark
Microsoft and MS-DOS are registered trademarks of Microsoft Corporation
Microsoft Windows is registered trademark of Microsoft Corporation
(The reproduction, transmission or use of this document or its contents is not permitted
without express written authority.
Offenders will be liable for damages. All rights, including rights created by patent grant or
registration of a utility model or design, are reserved.)
(We have checked the contents of the printed documentation to ensure that is in
agreement with the hardware and software described therein. However, since discre-
pancies cannot be ruled out, we cannot assume responsibility for complete agreement.
the information given in this printed documentation is however regulary reviewed and
necessary corrections included in subsequent editions. We would appreciate any
suggestions for improvements.)
Siemens AG 2006 All rights reserved Subject to change without prior notice
Item-No.: 00194923-01 Siemens AG
To be ordered from:
Siemens AG, Automation and Drives
Electronic Assembly Systems
Rupert-Mayer-Strasse 44
D-81359 Munich / Germany
Printed in the Federal Republic of Germany
UNIX ist ein Warenzeichen von AT&T
X-Windows ist ein Warenzeichen
LINUX ist ein Warenzeichen
Microsoft und MS-DOS sind eingetragene Warenzeichen von Microsoft Corporation
Microsoft Windows ist ein eingetragenes Warenzeichen von Microsoft Corporation
(Weitergabe sowie Vervielfältigung dieser Unterlage, Verwertung und Mitteilung ihres
Inhalts sind nicht gestattet, soweit nicht ausdrücklich zugestanden.
Zuwiderhandlungen verpflichten zu Schadenersatz. Alle Rechte vorbehalten, insbe-
sondere für den Fall der Patenterteilung oder GM-Eintragung.)
(Wir haben den Inhalt der Druckschrift auf Übereinstimmung mit der beschriebenen
Hard- und Software geprüft. Dennoch können Abweichungen nicht ausgeschlossen
werden, so daß wir für die vollständige Übereinstimmung keine Gewähr übernehmen.
Die Angaben in dieser Druckschrift werden jedoch regelmäßig überprüft und notwendi-
ge Korrekturen sind in den nachfolgenden Auflagen enthalten. Für Verbesserungsvor-
schläge sind wir dankbar.)
Siemens AG 2006 All rights reserved Technische Änderungen vorbehalten
Artikel-Nr.: 00194923-01 Siemens AG
Bestellung an:
Siemens AG, Automation and Drives
Electronic Assembly Systems
Rupert-Mayer-Strasse 44
D-81359 München
Printed in the Federal Republic of Germany
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
3 von 47
Contents/Inhaltsverzeichnis
Seite
1
General........................................................................................................................................................6
2 Data interface..............................................................................................................................................6
3 Restrictions..................................................................................................................................................6
4 Database.....................................................................................................................................................7
4.1 Name of the database..........................................................................................................................7
4.2 Version of the database schema .........................................................................................................7
4.3 Users....................................................................................................................................................7
4.4 Tables ..................................................................................................................................................7
4.4.1 BOARD table ................................................................................................................................8
4.4.2 EVENT table.................................................................................................................................8
4.4.3 USEREVENT table.......................................................................................................................8
4.4.4 PICKUPERROR table...................................................................................................................9
4.4.5 USEDCOMPONENTS table.........................................................................................................9
4.4.6 STATION table............................................................................................................................10
4.4.7 STATE table................................................................................................................................10
4.4.8 STATESHARE table...................................................................................................................10
4.4.9 DATAMODEL table.....................................................................................................................10
4.4.10 SHIFTWORK table .....................................................................................................................11
4.4.11 EVENTTEXT table......................................................................................................................11
4.5 Views of Version 4 .............................................................................................................................11
4.5.1 V_STATION4 view......................................................................................................................11
4.6 Views of Version 3 .............................................................................................................................11
4.6.1 V_BOARD3 view ........................................................................................................................11
4.6.2 V_EVENT3 view .........................................................................................................................11
4.6.3 V_EVENTANDTEXT3 view ........................................................................................................11
4.6.4 V_USEREVENT3 view...............................................................................................................12
4.6.5 V_USEREVENTANDTEXT3 view ..............................................................................................12
4.6.6 V_PICKUPERROR3 view...........................................................................................................12
4.6.7 V_USEDCOMPONENTS3 view .................................................................................................12
4.6.8 V_STATION3 view......................................................................................................................12
4.6.9 V_STATE3 view..........................................................................................................................12
4.6.10 V_STATESHARE3 view.............................................................................................................12
4.6.11 V_DATAMODEL3 view...............................................................................................................12
4.7 Views of Version 2 .............................................................................................................................13
4.7.1 V_BOARD2 view ........................................................................................................................13
4.7.2 V_EVENT2 view .........................................................................................................................13
4.7.3 V_EVENTANDTEXT2 view ........................................................................................................13
4.7.4 V_USEREVENT2 view...............................................................................................................13
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
4 von 47
4.7.5 V_USEREVENTANDTEXT2 view.............................................................................................. 13
4.7.6 V_PICKUPERROR2 view.......................................................................................................... 13
4.7.7 V_USEDCOMPONENTS2 view................................................................................................. 13
4.7.8 V_STATION2 view..................................................................................................................... 14
4.7.9 V_STATE2 view......................................................................................................................... 14
4.7.10 V_STATESHARE2 view............................................................................................................. 14
4.7.11 V_DATAMODEL2 view.............................................................................................................. 14
4.8 Views of Version 1............................................................................................................................. 14
5 State machines......................................................................................................................................... 15
5.1 Machines with one processing area.................................................................................................. 15
5.2 Machines with two processing areas (HS-50, HS60, HF)................................................................. 17
6 Appendix................................................................................................................................................... 18
6.1 Time slices ........................................................................................................................................ 18
6.2 OIS relevant machine error messages.............................................................................................. 19
1 Allgemeines.............................................................................................................................................. 25
2 Datenschnittstelle..................................................................................................................................... 25
3 Einschränkungen...................................................................................................................................... 26
4 Datenbank ................................................................................................................................................ 27
4.1 Name der Datenbank........................................................................................................................ 27
4.2 Version des Datenbank-Schemas..................................................................................................... 27
4.3 Benutzer............................................................................................................................................ 27
4.4 Tabellen............................................................................................................................................. 27
4.4.1 Tabelle BOARD.......................................................................................................................... 28
4.4.2 Tabelle EVENT .......................................................................................................................... 28
4.4.3 Tabelle USEREVENT ................................................................................................................ 28
4.4.4 Tabelle PICKUPERROR............................................................................................................ 29
4.4.5 Tabelle USEDCOMPONENTS .................................................................................................. 29
4.4.6 Tabelle STATION....................................................................................................................... 30
4.4.7 Tabelle STATE........................................................................................................................... 30
4.4.8 Tabelle STATESHARE ..............................................................................................................30
4.4.9 Tabelle DATAMODEL................................................................................................................ 30
4.4.10 Tabelle SHIFTWORK................................................................................................................. 31
4.4.11 Tabelle EVENTTEXT................................................................................................................. 31
4.5 Views der Version 4 .......................................................................................................................... 31
4.5.1 View V_STATION4 .................................................................................................................... 31
4.6 Views der Version 3 .......................................................................................................................... 31
4.6.1 View V_BOARD3....................................................................................................................... 31
4.6.2 View V_EVENT3........................................................................................................................ 31
4.6.3 View V_EVENTANDTEXT3....................................................................................................... 31
4.6.4 View V_USEREVENT3.............................................................................................................. 32
4.6.5 View V_USEREVENTANDTEXT3............................................................................................. 32