00194923-01_OIS_DB.pdf - 第4页
Schnittstellenbeschreibung OIS Datenbank Version 4.1 Interface Description OIS Database Version 4.1 4 von 47 4.7.5 V_USEREVENTANDT EXT2 view................................................................................…
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
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
5 von 47
4.6.6 View V_PICKUPERROR3..........................................................................................................32
4.6.7 View V_USEDCOMPONENTS3.................................................................................................32
4.6.8 View V_STATION3.....................................................................................................................32
4.6.9 View V_STATE3.........................................................................................................................32
4.6.10 View V_STATESHARE3.............................................................................................................32
4.6.11 View V_DATAMODEL3..............................................................................................................32
4.7 Views der Version 2...........................................................................................................................33
4.7.1 View V_BOARD2........................................................................................................................33
4.7.2 View V_EVENT2.........................................................................................................................33
4.7.3 View V_EVENTANDTEXT2........................................................................................................33
4.7.4 View V_USEREVENT2...............................................................................................................33
4.7.5 View V_USEREVENTANDTEXT2..............................................................................................33
4.7.6 View V_PICKUPERROR2..........................................................................................................33
4.7.7 View V_USEDCOMPONENTS2.................................................................................................33
4.7.8 View V_STATION2.....................................................................................................................34
4.7.9 View V_STATE2.........................................................................................................................34
4.7.10 View V_STATESHARE2.............................................................................................................34
4.7.11 View V_DATAMODEL2..............................................................................................................34
4.8 Views der Version 1...........................................................................................................................34
5 Zustandsautomaten...................................................................................................................................35
5.1 Maschinen mit einem Bearbeitungsbereich.......................................................................................35
5.2 Maschinen mit zwei Bearbeitungsbereichen(HS-50, HS-60, HF)......................................................37
6 Anhang......................................................................................................................................................38
6.1 Zeitanteile...........................................................................................................................................38
6.2 OIS relevante Maschinen Fehlermeldungen .....................................................................................39