Project

General

Profile

Actions

Feature #201

closed

Define type hierarchy for events, professions and change in ownership

Added by Alexander Watzinger about 10 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Category:
Data import/export
Target version:
Start date:
2014-01-18
Estimated time:

Files

Ereignistypen.docx (14.7 KB) Ereignistypen.docx Alexander Watzinger, 2014-01-25 17:32
Actions #1

Updated by Alexander Watzinger about 10 years ago

Ereignistyp

SELECT count(`Ereignistyp`) as ecount,  `Ereignistyp` FROM `tbl_3_ereignis` GROUP BY `Ereignistyp` order by ecount DESC

275 Schenkung
64 Besitzwechsel
19 Tausch
10 Schlacht
8 Mission
8 Kauf
8 Amtszeit
4 Anwesenheit
3 Kampfhandlungen
3 Verwandschaft
3 Conversio
3 Aufstand
2 Flucht
2
2 Prekarie/Prästarie
2 Unterwerfung
2 Papstweisung
2 Grenzziehung
2 Gründung Kirche
2 Besitzbestätigung
1 Tod
1 Gründung Bistum
1 Besitzstreit
1 Bewegung
1 Kriegszug
1 Schenkung und als Lehen zurück
1 Geiselhaft
1 Kirchenweihe
1 Rechtliche Abhängigkeit
1 Bestattung

Actions #2

Updated by Alexander Watzinger about 10 years ago

Titel/Rang

SELECT count(`Titel/Rang`) as tcount,  `Titel/Rang` FROM `tbl_4_person` GROUP BY `Titel/Rang` order by tcount DESC

295
289 Adelig
231 Unfrei
106 Frei
70 Priester
38 Graf
26 Herzog
9 Chorbischof
9 Bischof
8 Erzbischof
6 Kleriker
6 König
6 Kaiser
5 Abt
5 Militär
5 Diakon
4 Kloster
3 Richter
3 Fürst
3 Kaplan
3 Gewaltbote
2 Patriarch
2 Nonne
2 Dekan
2 Subdiakon
2 Bistum
1 Kaghan
1 Vassal
1 Kämmerer
1 Markgraf

Actions #3

Updated by Alexander Watzinger about 10 years ago

  • Status changed from New to Assigned
  • Assignee set to Katharina Winckler
Actions #5

Updated by Alexander Watzinger about 10 years ago

  • Status changed from Assigned to Closed
Actions #6

Updated by Alexander Watzinger almost 9 years ago

  • Category set to 51
Actions #7

Updated by Alexander Watzinger almost 9 years ago

  • Project changed from 9 to OpenAtlas
  • Category changed from 51 to 52
Actions #8

Updated by Alexander Watzinger almost 9 years ago

  • Target version set to Alpha
Actions #9

Updated by Alexander Watzinger over 4 years ago

  • Category changed from 52 to Data import/export
Actions

Also available in: Atom PDF