diff options
author | Petr Šmerkl <46304018+SveterCZE@users.noreply.github.com> | 2021-03-07 09:30:54 +0100 |
---|---|---|
committer | Petr Šmerkl <46304018+SveterCZE@users.noreply.github.com> | 2021-03-07 09:30:54 +0100 |
commit | 3f6f1d7d72e4ad84aeb06875989749d1af207fa5 (patch) | |
tree | d10dbdea6d25011b7126f1d42e3059dd36cce8e5 /models.py | |
parent | bbf5af7bfcbd544d74ede44266d309eec286bc93 (diff) | |
download | justice-3f6f1d7d72e4ad84aeb06875989749d1af207fa5.tar.gz |
display sole shareholder and prokura
Diffstat (limited to 'models.py')
-rw-r--r-- | models.py | 38 |
1 files changed, 38 insertions, 0 deletions
@@ -241,6 +241,40 @@ class Spolecnici_Association(db.Model): oznaceni_po = db.relationship("Pravnicka_Osoba") podily = db.relationship("Podily_Association") +class Prokurista_Association(db.Model): + __tablename__ = "prokuriste" + id = db.Column(db.Integer, primary_key=True) + company_id = db.Column(db.Integer, db.ForeignKey('companies.id')) + zapis_datum = db.Column(MyType) + vymaz_datum = db.Column(MyType) + prokurista_fo_id = db.Column(db.Integer, db.ForeignKey('fyzicke_osoby.id')) + adresa_id = db.Column(db.Integer, db.ForeignKey('adresy.id')) + adresa = db.relationship("Sidlo") + jmeno = db.relationship("Fyzicka_Osoba") + text_prokurista = db.Column(db.String) + +class Prokura_Common_Text_Association(db.Model): + __tablename__ = "prokura_common_texts" + id = db.Column(db.Integer, primary_key=True) + company_id = db.Column(db.Integer, db.ForeignKey('companies.id')) + zapis_datum = db.Column(MyType) + vymaz_datum = db.Column(MyType) + prokura_text = db.Column(db.String) + +class Jediny_Akcionar_Association(db.Model): + __tablename__ = "jediny_akcionar" + id = db.Column(db.Integer, primary_key=True) + company_id = db.Column(db.Integer, db.ForeignKey('companies.id')) + zapis_datum = db.Column(MyType) + vymaz_datum = db.Column(MyType) + text_akcionar = db.Column(db.String) + akcionar_fo_id = db.Column(db.Integer, db.ForeignKey('fyzicke_osoby.id')) + akcionar_po_id = db.Column(db.Integer, db.ForeignKey('pravnicke_osoby.id')) + adresa_id = db.Column(db.Integer, db.ForeignKey('adresy.id')) + adresa = db.relationship("Sidlo") + jmeno = db.relationship("Fyzicka_Osoba") + oznaceni_po = db.relationship("Pravnicka_Osoba") + class Podily_Association(db.Model): __tablename__ = "podily" id = db.Column(db.Integer, primary_key=True) @@ -254,6 +288,7 @@ class Podily_Association(db.Model): souhrn_text = db.Column(db.String) splaceni_typ = db.Column(db.String) splaceni_text = db.Column(db.String) + druh_podilu = db.relationship("Druhy_Podilu") class Zpusob_Jednani_Association(db.Model): __tablename__ = 'zpusoby_jednani_relation' @@ -292,6 +327,9 @@ class Company(db.Model): statutarni_organ_text = db.relationship("Statutarni_Organ_Association", back_populates="company") dozorci_rada_text = db.relationship("Dozorci_Rada_Association") spolecnici = db.relationship("Spolecnici_Association") + prokurista = db.relationship("Prokurista_Association") + prokura_common_text = db.relationship("Prokura_Common_Text_Association") + jediny_akcionar = db.relationship("Jediny_Akcionar_Association") class Obce(db.Model): __tablename__ = "obce" |