Errichtungsanordnung Veranstaltungsdatenbank

Dieses Dokument ist Teil der Anfrage „Aktuelle Errichtungsanordnung "stadtweite Veranstaltungsdatenbank"

/ 33
PDF herunterladen
changes; (Selbstbereinigung mit Löschung des Veranstaltungs-Datensatzes) +---------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------------------+------+-----+---------+-------+ | cid | int(10) unsigned | NO | | NULL | | | type | enum('N','C','P','K')| NO | | NULL | | | user | varchar(40) | YES | | NULL | | | descr | varchar(100) | YES | | NULL | | | cdate | datetime | YES | | NULL | | | changed | text | YES | | NULL | | | private | smallint(5) unsigned | YES | | NULL | | | req | smallint(5) unsigned | YES | | NULL | | +---------+----------------------+------+-----+---------+-------+ 8 rows in set (0.00 sec) color; +-------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------+------+-----+---------+----------------+ | id | tinyint(3) unsigned | NO | PRI | NULL | auto_increment | | gfx | char(8) | YES | | NULL | | | font | char(7) | YES | | NULL | | | name | char(32) | YES | | NULL | | +-------+---------------------+------+-----+---------+----------------+ 4 rows in set (0.02 sec) counter; +-------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------+------+-----+---------+-------+ | id | tinyint(3) unsigned | NO | PRI | 0 | | | count | int(10) unsigned | YES | | NULL | | +-------+---------------------+------+-----+---------+-------+ 1 row in set (0.00 sec) lfd. Nr. Kategorie der Änderung LogIn-Name veranlassende Dst. Änderungs-Datum Inhalt von geänderten Schlüsselfeldern Meldung vorbehalten für Gruppen-ID z.Zt. nicht verwendet laufende Nummer Hintergrund Grafik/Farbe Fontfarbe Name des Farbschemas Counter-ID (1=VDB allgemein) Counter deen; +-------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------+------+-----+---------+-------+ | de | mediumtext | YES | | NULL | | | en | mediumtext | YES | | NULL | | +-------+------------+------+-----+---------+-------+ Wortstamm für Übersetzungen in der VDB Deutscher Begriff Englischer Begriff Seite 11 von 33
11

2 rows in set (0.01 sec) dienstdhu; +-------+------------------------------------------------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------------------------------------------------------------------------+------+-----+---------+----------------+ | off | tinyint(3) unsigned | NO | PRI | NULL | auto_increment | | ehud1 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehud2 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehud3 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehud4 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehud5 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehud6 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | +-------+------------------------------------------------------------------------------------+------+-----+---------+----------------+ 7 rows in set (0.00 sec) dienstehu; +-------+------------------------------------------------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------------------------------------------------------------------------+------+-----+---------+----------------+ | off | tinyint(3) unsigned | NO | PRI | NULL | auto_increment | | ehu11 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehu12 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehu13 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehu14 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehu21 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehu22 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehu23 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | | ehu24 | enum('T','N','N2','I','II','III','IV','A','A1','A2','A3','A4','A5','A6','A7','A8') | YES | | NULL | | +-------+------------------------------------------------------------------------------------+------+-----+---------+----------------+ 9 rows in set (0.00 sec) diensttee; +-------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------+------+-----+---------+----------------+ | off | tinyint(3) unsigned | NO | PRI | NULL | auto_increment | | tee1 | enum('M','F','S') | YES | | NULL | | | tee2 | enum('M','F','S') | YES | | NULL | | +-------+---------------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) Seite 12 von 33
12

events; +---------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+----------------------+------+-----+---------+----------------+ | e_id | smallint(5) unsigned | NO | PRI | NULL | auto_increment | | event | char(25) | YES | | NULL | | | aktiv | tinyint(3) unsigned | NO | | 0 | | | e_von | date | YES | | NULL | | | e_bis | date | YES | | NULL | | | pic | char(20) | YES | | NULL | | | doc | char(20) | YES | | NULL | | | verantw | smallint(6) | YES | | NULL | | +---------+----------------------+------+-----+---------+----------------+ 8 rows in set (0.00 sec) Ereignis-Nummer Bezeichnung des Großereignisses 0/1 Koppeln mit Veranstaltungen möglich/nicht möglich Zeitraum des Ereignisses Beginn Zeitraum des Ereignisses Ende Dateiname des Thumbnails für die Darstellung Dateiname eines Dokumentes zur Erläuterung xsgroup.id der verantw. Dienststelle eventSet: +--------+-----------------------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+-----------------------------------------------------------+------+-----+---------+----------------+ | es_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ev_id | smallint(5) unsigned | NO | | NULL | | | vdbid | int(10) unsigned | NO | MUL | NULL | | | status | enum('','kein Bezug','direkter Bezug','indirekter Bezug') | YES | | NULL | | +--------+-----------------------------------------------------------+------+-----+---------+----------------+ 4 rows in set (0.02 sec) Seite 13 von 33 laufende Nummer Ereignis-Nummer Veranstaltungs-ID Art des Bezuges
13

Forces (ehem. Units;) +------------+------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------------+------+-----+---------+----------------+ | fid | int(10) unsigned | NO | PRI | NULL | auto_increment | laufende Nummer | name | varchar(30) | YES | | NULL | | Name der Einheit | bezeichner | varchar(40) | YES | | NULL | | Beschreibung der Einheit | art | enum | YES | | sonst. | | Einheitenart | ogrp | int(10) unsigned | YES | | NULL | | fid der Kopfdienststelle | grp | int(10) unsigned | YES | | NULL | | fid der vorgesetzten Dst. | HD | smallint(5) unsigned | YES | | NULL | | Sollstärke HöhererDienst (HD) | GD | smallint(5) unsigned | YES | | NULL | | Sollstärke GD | MD | smallint(5) unsigned | YES | | NULL | | Sollstärke MD | Ang | smallint(5) unsigned | YES | | NULL | | Sollstärke Angestellte | Arb | smallint(5) unsigned | YES | | NULL | | Sollstärke Arbeiter | bem | mediumtext | YES | | NULL | | Bemerkungen zur Einheit | kopfdst | smallint(5) unsigned | YES | | NULL | | xsgroup.id der Kopfdst. | vdbdst | smallint(5) unsigned | YES | | NULL | | xsgroup.id der Einheit | inactive | tinyint(3) unsigned | NO | | 0 | | inaktiv – kann nicht mehr verwendet werden | status | tinyint(3) unsigned | YES | | NULL | | flags für z.B. Verrechnung mit Vorausstärke +------------+------------------------+------+-----+---------+----------------+ 15 rows in set (0.00 sec) * enum('Dir','BPA','EHu','DHU','TEE','A','AHu','F³Sta','VkD','Bund','extern','sonst.','mixed','order') geo_info; +------------+--------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------------+------+-----+---------+-------+ | vdbid | int(10) unsigned | NO | PRI | NULL | | | koords | point | YES | | NULL | | | aufzug_geo | linestring | YES | | NULL | | | mult_geo | geometrycollection | YES | | NULL | | | aufzug_txt | text | NO | | NULL | | +------------+--------------------+------+-----+---------+-------+ 5 rows in set (0.02 sec) Seite 14 von 33 vdb.id Punktkoordinaten Polygon-Koordinaten für Strecken Koordinaten für kombinierte Geometrie Aufzugsstrecke (verbal)
14

history; +--------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+---------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | dat | date | YES | | NULL | | | txt | mediumtext | YES | | NULL | | | status | tinyint(3) unsigned | YES | | NULL | | +--------+---------------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) kennfilter; +-------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+-------+ | uid | int(10) unsigned | NO | PRI | 0 | | | kenn | text | YES | | NULL | | +-------+------------------+------+-----+---------+-------+ 2 rows in set (0.02 sec) Lfd. Nr. Datum Texteintrag Flag für öffentlich einsehbar ja/nein xsuser.id Zusammenfassung aktivierter Kennzahlen kennz; +-------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------------+------+-----+---------+----------------+ | id | int(4) unsigned | | PRI | NULL | auto_increment | | txt | varchar(100) | YES | | NULL | | | txt2 | varchar(100) | YES | | NULL | | +-------+-----------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) Seite 15 von 33 Kennzahl Kennzahlbezeichnung Kennzahlbezeichnung - Alternativtext
15

kraefte; +---------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------------------+------+-----+---------+-------+ | vdbid | int(10) unsigned | NO | PRI | NULL | | | pf | varchar(100) | YES | | NULL | | | pfdst | smallint(5) unsigned | YES | | NULL | | | pftel | char(40) | YES | | NULL | | | kbem | text | YES | | NULL | | | wanted | text | YES | | NULL | | | ekstd | float(7,2) | YES | | NULL | | | kstatus | smallint(5) unsigned | YES | | NULL | | | busy | datetime | YES | | NULL | | | busyby | char(20) | YES | | NULL | | +---------+----------------------+------+-----+---------+-------+ 10 rows in set (0.00 sec) kraefte_ua; +-------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+----------------------+------+-----+---------+----------------+ | uaid | smallint(5) unsigned | NO | PRI | NULL | auto_increment | | typ | enum('UA','EA') | YES | | NULL | | | name | tinytext | YES | | NULL | | | descr | mediumtext | YES | | NULL | | +-------+----------------------+------+-----+---------+----------------+ 4 rows in set (0.02 sec) kraeftefav; +---------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------------------+------+-----+---------+-------+ | uid | smallint(5) unsigned | NO | PRI | 0 | | | kraefte | mediumtext | YES | | NULL | | +---------+----------------------+------+-----+---------+-------+ 2 rows in set (0.03 sec) Seite 16 von 33 ID-Nr. der Veranstaltung Polizeiführer (Dienstgrad, Name aber u.U. nur Funktion) forces.id der PF-Dienststelle Telefonische Erreichbarkeit des Pf textl. Zusammenfassung der Einheiten für den Einsatz textl. Zusammenfassung von Anforderungen gesamt anfallende Einsatzkräftestunden Statusflag für den Einsatz (ehem. kctrl) Zeitstempel für in Bearbeitung bis…. Hinweis: Bearbeitung durch [Gruppenname] Laufende Nr. Art: Unter-/Einsatzabschnitt Name des UA/EA Aufgabenbeschreibung xsuser.id Zusammenfassung der forces.ids für Schnellauswahl
16

kraeftehoheit; +--------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+----------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | von | datetime | NO | MUL | NULL | | | bis | datetime | NO | | NULL | | | hoheit | smallint(5) unsigned | NO | | NULL | | | who | smallint(5) unsigned | NO | | NULL | | +--------+----------------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) kraefteu; (fast vollständig überarbeitet) +--------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+----------------------+------+-----+---------+----------------+ | kuid | int(10) unsigned | | PRI | NULL | auto_increment | | kid | int(10) unsigned | | | 0 | | | vdbid | int(10) unsigned | | | 0 | | | ua | smallint(5) unsigned | YES | | NULL | | | dstgrp | tinyint(3) unsigned | YES | | NULL | | | hd | tinyint(3) unsigned | YES | | NULL | | | gd | tinyint(3) unsigned | YES | | NULL | | | md | smallint(5) unsigned | YES | | NULL | | | ang | tinyint(3) unsigned | YES | | NULL | | | arb | tinyint(3) unsigned | YES | | NULL | | | ekstd | float(4,2) | YES | | NULL | | | uctrl | tinyint(3) unsigned | YES | | NULL | | | von | time | YES | | NULL | | | bis | time | YES | | NULL | | | bem | text | YES | | NULL | | | flag | tinyint(3) unsigned | YES | | NULL | | +--------+----------------------+------+-----+---------+----------------+ 16 rows in set (0.02 sec) Seite 17 von 33 laufende Nr. Gültigkeit Beginn Gültigkeit Ende xsgroup.id Gruppe des Hoheitsempfänger xsuser.id des Festlegenden laufende Nr. ID-Nr. der Einheit aus forces VDB-ID EA/UA DstGrp. Anz. Höherer Dienst Anz. Gehobener Dienst Anz. Mittlerer Dienst Anz. Angestellte Anz. Arbeiter EKStd. Statusmerkmal Einsatzzeit Beginn Einsatzzeit Ende Bemerkungen Kontrollmerkmal für weiterverbundene Aufgaben
17

kraeftev; +-----------+-------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------------------+------+-----+---------+----------------+ | vid | int(10) unsigned | | PRI | NULL | auto_increment | | kid | int(10) unsigned | YES | | NULL | | | datum | date | YES | | NULL | | | dstgrp | tinyint(3) unsigned | YES | | NULL | | | hd | tinyint(3) unsigned | NO | | 0 | | | gd | tinyint(3) unsigned | NO | | 0 | | | md | smallint(5) unsigned | NO | | 0 | | | ang | tinyint(3) unsigned | NO | | 0 | | | arb | tinyint(3) unsigned | NO | | 0 | | | status | tinyint(3) unsigned | NO | | NULL | | | bem | tinytext | YES | | NULL | | | vart | enum(“”,”voraus”,”ist”) | NO | | | | | oldvoraus | char(15) | YES | | NULL | | | von | time | YES | | NULL | | | bis | time | YES | | NULL | | +-----------+-------------------------+------+-----+---------+----------------+ 14 rows in set (0.01 sec) krimskrams; +-------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | typ | char(30) | YES | | NULL | | | value | text | YES | | NULL | | | stamp | datetime | YES | | NULL | | | time | int(10) unsigned | YES | | NULL | | +-------+------------------+------+-----+---------+----------------+ 5rows in set (0.00 sec) Seite 18 von 33 laufende Nr. Dst-ID aus forces Datum für die Vorausstärkemeldung ggf. Dienstgruppe Stärke HD Stärke GD Stärke MD Stärke Angestellte Stärke Arbeiter Status Bemerkungen Voraus- oder Iststärke alte Vorausstärke (vor Änderung) Uhrzeit von Uhrzeit bis Lfd. Nr. Name der Applikation Sperrvermerk Zeitstempel Zeit in Ticks für Debugging
18

locked; +-------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+-------+ | id | int(10) unsigned | NO | | 0 | | | datum | date | YES | | NULL | | +-------+------------------+------+-----+---------+-------+ 2 rows in set (0.02 sec) vdb.id Datum der Festlegung map_lay_dop; +-------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------------------+------+-----+---------+-------+ | src | smallint(5) unsigned | NO | PRI | NULL | | | u1 | smallint(5) unsigned | NO | | NULL | | | u2 | smallint(5) unsigned | NO | | NULL | | | u3 | smallint(5) unsigned | NO | | NULL | | | u4 | smallint(5) unsigned | NO | | NULL | | | u5 | smallint(5) unsigned | NO | | NULL | | | u6 | smallint(5) unsigned | NO | | NULL | | | u7 | smallint(5) unsigned | NO | | NULL | | | u8 | smallint(5) unsigned | NO | | NULL | | | u9 | smallint(5) unsigned | NO | | NULL | | +-------+----------------------+------+-----+---------+-------+ 10 rows in set (0.03 sec) analog zu map_lay_k5c für Orthophotos center-Segment map_lay_k5c (ehem. map_lay;) +-------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------------------+------+-----+---------+-------+ | src | smallint(5) unsigned | NO | PRI | NULL | | | u1 | smallint(5) unsigned | NO | | NULL | | | u2 | smallint(5) unsigned | NO | | NULL | | | u3 | smallint(5) unsigned | NO | | NULL | | | u4 | smallint(5) unsigned | NO | | NULL | | | u5 | smallint(5) unsigned | NO | | NULL | | | u6 | smallint(5) unsigned | NO | | NULL | | | u7 | smallint(5) unsigned | NO | | NULL | | | u8 | smallint(5) unsigned | NO | | NULL | | | u9 | smallint(5) unsigned | NO | | NULL | | +-------+----------------------+------+-----+---------+-------+ 10 rows in set (0.05 sec) center-Segment Position L.O. Position M.O. Position R.O. Position L.M. Position center Segement Position R.M. Position L.U. Position M.U. Position R.U. Seite 19 von 33
19

map_seg_dop; +-------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------+------+-----+---------+----------------+ | off | tinyint(3) unsigned | NO | PRI | NULL | auto_increment | | seg1 | char(4) | NO | | NULL | | | seg2 | char(4) | NO | | NULL | | | seg3 | char(4) | NO | | NULL | | | seg4 | char(4) | NO | | NULL | | | seg5 | char(4) | NO | | NULL | | | seg6 | char(4) | NO | | NULL | | | seg7 | char(4) | NO | | NULL | | | seg8 | char(4) | NO | | NULL | | | seg9 | char(4) | NO | | NULL | | | seg10 | char(4) | NO | | NULL | | | seg11 | char(4) | NO | | NULL | | | seg12 | char(4) | NO | | NULL | | | seg13 | char(4) | NO | | NULL | | | seg14 | char(4) | NO | | NULL | | | seg15 | char(4) | NO | | NULL | | | seg16 | char(4) | NO | | NULL | | | seg17 | char(4) | NO | | NULL | | | seg18 | char(4) | NO | | NULL | | | seg19 | char(4) | NO | | NULL | | | seg20 | char(4) | NO | | NULL | | | seg21 | char(4) | NO | | NULL | | | seg22 | char(4) | NO | | NULL | | | seg23 | char(4) | NO | | NULL | | | seg24 | char(4) | NO | | NULL | | | seg25 | char(4) | NO | | NULL | | +-------+---------------------+------+-----+---------+----------------+ 26 rows in set (0.03 sec) Seite 20 von 33 analog zu map_seg_k5c für Orthophotos
20

Zur nächsten Seite