Add feature to display purpose of an entity

1 files changed, 55 insertions, 18 deletions

diff --git a/db_creation.py b/db_creation.py
index a704a85..7edc449 100644
--- a/db_creation.py
+++ b/db_creation.py
@@ -354,6 +354,23 @@ def create_tables(conn):
 	PRIMARY KEY("id" AUTOINCREMENT)
 ); """
 
+    ucel = """ CREATE TABLE "ucel" (
+	"id"	INTEGER NOT NULL,
+	"ucel"	TEXT NOT NULL UNIQUE,
+	PRIMARY KEY("id" AUTOINCREMENT)
+); """
+
+    ucel_relation = """ CREATE TABLE "ucel_relation" (
+	"id"	INTEGER NOT NULL UNIQUE,
+	"company_id"	INTEGER NOT NULL,
+	"ucel_id"	INTEGER NOT NULL,
+	"zapis_datum"	DATE,
+	"vymaz_datum"	DATE,
+	PRIMARY KEY("id" AUTOINCREMENT),
+	FOREIGN KEY("company_id") REFERENCES "companies"("id"),
+	FOREIGN KEY("ucel_id") REFERENCES "ucel"("id")
+); """
+
     zakladni_kapital = """ CREATE TABLE "zakladni_kapital" (
 	"id"	INTEGER NOT NULL UNIQUE,
 	"company_id"	INTEGER NOT NULL,
@@ -400,7 +417,7 @@ def create_tables(conn):
     jediny_akcionar, konkurz_events, nazvy, ostatni_skutecnosti, pocty_clenu_DR, pocty_clenu_organu, podily, pravni_formy, 
     pravni_formy_relation, pravnicke_osoby, predmety_cinnosti, predmety_cinnosti_relation, prdmety_podnikani, predmety_podnikani_relation,
     prokura_common_texts, prokuriste, sidlo_relation, spolecnici, statutarni_organ_clen_relation, statutarni_organ_relation, statutarni_organy, 
-    zakladni_kapital, zapis_soudy, zpusoby_jednani, zpusoby_jednani_relation]
+    ucel, ucel_relation, zakladni_kapital, zapis_soudy, zpusoby_jednani, zpusoby_jednani_relation]
     for elem in list_of_tables:
         try:
             c = conn.cursor()
@@ -537,6 +554,22 @@ def create_indices(conn):
 	"id"
 ); """
 
+    pravnicke_osoby1 = """ CREATE INDEX "pravnicke_osoby1" ON "pravnicke_osoby" (
+	"ico"
+); """
+
+    pravnicke_osoby2 = """ CREATE INDEX "pravnicke_osoby2" ON "pravnicke_osoby" (
+	"id"
+); """
+
+    pravnicke_osoby3 = """ CREATE INDEX "pravnicke_osoby3" ON "pravnicke_osoby" (
+	"reg_cislo"
+); """
+
+    pravnicke_osoby4 = """ CREATE INDEX "pravnicke_osoby4" ON "pravnicke_osoby" (
+	"nazev"
+); """
+
     predmety_cinnosti_relation1 = """ CREATE INDEX "index predmety cinnosti relation1" ON "predmety_cinnosti_relation" (
 	"company_id"
 ); """
@@ -650,6 +683,26 @@ def create_indices(conn):
 	"company_id"
 ); """
 
+    ucel1 = """ CREATE INDEX "index ucel1" ON "ucel" (
+	"ucel"
+); """
+
+    ucel2 = """ CREATE INDEX "index ucel2" ON "predmety_podnikani" (
+	"id"
+); """
+
+    ucel_relation1 = """ CREATE INDEX "index ucel relation1" ON "ucel_relation" (
+	"company_id"
+); """
+
+    ucel_relation2 = """ CREATE INDEX "index ucel relation2" ON "ucel_relation" (
+	"id"
+); """
+
+    ucel_relation3 = """ CREATE INDEX "index ucel relation3" ON "ucel_relation" (
+	"ucel_id"
+); """
+
     zakladni_kapital1 = """ CREATE INDEX "index zakladni kapital1" ON "zakladni_kapital" (
 	"company_id"
 ); """
@@ -674,22 +727,6 @@ def create_indices(conn):
 	"zpusob_jednani_id"
 ); """
 
-    pravnicke_osoby1 = """ CREATE INDEX "pravnicke_osoby1" ON "pravnicke_osoby" (
-	"ico"
-); """
-
-    pravnicke_osoby2 = """ CREATE INDEX "pravnicke_osoby2" ON "pravnicke_osoby" (
-	"id"
-); """
-
-    pravnicke_osoby3 = """ CREATE INDEX "pravnicke_osoby3" ON "pravnicke_osoby" (
-	"reg_cislo"
-); """
-
-    pravnicke_osoby4 = """ CREATE INDEX "pravnicke_osoby4" ON "pravnicke_osoby" (
-	"nazev"
-); """
-
     fyzicke_osoby1 = """ CREATE INDEX "fyzicke_osoby1" ON "fyzicke_osoby" (
 	"id"
 ); """
@@ -703,7 +740,7 @@ def create_indices(conn):
 	prokuriste2, prokuriste3, prokuriste4, sidlo_relation1, sidlo_relation_2, sidlo_relation_3, soudni_zapis1, soudni_zapis2, spolecnici1, 
 	spolecnici2, spolecnici3, spolecnici4, spolecnici5, statutarni_organy, statutarni_organy_relation1, statutarni_organy_relation2, 
 	statutarni_organy_relation_3, zakladni_kapital1, zakladni_kapital2, zpusob_jednani, zpusob_jednani_relation1, zpusob_jednani_relation2, 
-	zpusob_jednani_relation3, pravnicke_osoby1, pravnicke_osoby2, pravnicke_osoby3, pravnicke_osoby4, fyzicke_osoby1]
+	zpusob_jednani_relation3, pravnicke_osoby1, pravnicke_osoby2, pravnicke_osoby3, pravnicke_osoby4, fyzicke_osoby1, ucel1, ucel2, ucel_relation1, ucel_relation2, ucel_relation3]
     i = 0
     for elem in list_of_indices:
         i += 1