path: root/db_creation

CREATE TABLE "companies" (
	"id"	INTEGER,
	"ico"	TEXT NOT NULL UNIQUE,
	"nazev"	TEXT,
	"zapis"	DATE,
	"sidlo"	TEXT,
	"oddil"	TEXT,
	"vlozka"	TEXT,
	"soud"	TEXT,
	PRIMARY KEY("id" AUTOINCREMENT)
)

CREATE TABLE "insolvency_events" (
	"id"	INTEGER NOT NULL UNIQUE,
	"company_id"	TEXT NOT NULL,
	"insolvency_event"	TEXT UNIQUE,
	FOREIGN KEY("company_id") REFERENCES "companies"("id"),
	PRIMARY KEY("id" AUTOINCREMENT)
)

CREATE TABLE "obce" (
	"id"	INTEGER NOT NULL,
	"obec_jmeno"	TEXT NOT NULL UNIQUE,
	PRIMARY KEY("id" AUTOINCREMENT)
)

CREATE TABLE "obce_relation" (
	"company_id"	INTEGER NOT NULL UNIQUE,
	"obec_id"	INTEGER NOT NULL,
	FOREIGN KEY("obec_id") REFERENCES "obce"("id"),
	FOREIGN KEY("company_id") REFERENCES "companies"("id")
)

CREATE TABLE "osoby" (
	"id"	INTEGER NOT NULL,
	"osoba_jmeno"	TEXT UNIQUE,
	PRIMARY KEY("id" AUTOINCREMENT)
)

CREATE TABLE "pravni_formy" (
	"id"	INTEGER NOT NULL,
	"pravni_forma"	TEXT NOT NULL UNIQUE,
	PRIMARY KEY("id" AUTOINCREMENT)
)

CREATE TABLE "pravni_formy_relation" (
	"company_id"	INTEGER NOT NULL UNIQUE,
	"pravni_forma_id"	INTEGER NOT NULL,
	FOREIGN KEY("pravni_forma_id") REFERENCES "pravni_formy"("id"),
	FOREIGN KEY("company_id") REFERENCES "companies"("id")
)

CREATE TABLE sqlite_sequence(name,seq)

CREATE TABLE "ulice" (
	"id"	INTEGER NOT NULL,
	"ulice_jmeno"	TEXT NOT NULL UNIQUE,
	PRIMARY KEY("id" AUTOINCREMENT)
)

CREATE TABLE "ulice_relation" (
	"company_id"	INTEGER NOT NULL UNIQUE,
	"ulice_id"	INTEGER NOT NULL,
	FOREIGN KEY("company_id") REFERENCES "companies"("id"),
	FOREIGN KEY("ulice_id") REFERENCES "ulice"("id")
)

CREATE TABLE "predmety_cinnosti_relation" (
	"company_id"	INTEGER NOT NULL,
	"predmet_cinnosti_id"	INTEGER NOT NULL,
	"zapis_datum"	DATE,
	"vymaz_datum"	DATE,
	FOREIGN KEY("company_id") REFERENCES "companies"("id"),
	FOREIGN KEY("predmet_cinnosti_id") REFERENCES "predmety_cinnosti"("id")
)

CREATE TABLE "predmety_podnikani_relation" (
	"company_id"	INTEGER NOT NULL,
	"predmet_podnikani_id"	INTEGER NOT NULL,
	"zapis_datum"	DATE,
	"vymaz_datum"	DATE,
	FOREIGN KEY("company_id") REFERENCES "companies"("id"),
	FOREIGN KEY("predmet_podnikani_id") REFERENCES "predmety_podnikani"("id")
)

CREATE TABLE "predmety_cinnosti" (
	"id"	INTEGER NOT NULL,
	"predmet_cinnosti"	TEXT NOT NULL UNIQUE,
	PRIMARY KEY("id" AUTOINCREMENT)
)

CREATE TABLE "predmety_podnikani" (
	"id"	INTEGER NOT NULL,
	"predmet_podnikani"	TEXT NOT NULL UNIQUE,
	PRIMARY KEY("id" AUTOINCREMENT)
)