class TPlacettes (DB.Model): __tablename__ = "t_placettes" __table_args__ = {'schema': SCHEMA} id_placette = DB.Column('id_placette', DB.Integer, primary_key = True) id_dispositif = DB.Column('id_dispositif', DB.Integer, DB.ForeignKey('pr_psdrf.t_dispositifs.id_dispositif')) id_placette_orig = DB.Column('id_placette_orig', DB.String) strate = DB.Column('strate', DB.Integer) pente = DB.Column('pente', DB.Float) poids_placette = DB.Column('poids_placette', DB.Float) correction_pente = DB.Column('correction_pente', DB.Boolean) exposition = DB.Column('exposition', DB.Integer) profondeur_app = DB.Column('profondeur_app', DB.String) profondeur_hydr = DB.Column('profondeur_hydr', DB.Float) texture = DB.Column('texture', DB.String) habitat = DB.Column('habitat', DB.String) station = DB.Column('station', DB.String) typologie = DB.Column('typologie', DB.String) groupe = DB.Column('groupe', DB.String) groupe1 = DB.Column('groupe1', DB.String) groupe2 = DB.Column('groupe2', DB.String) ref_habitat = DB.Column('ref_habitat', DB.String) precision_habitat = DB.deferred(DB.Column('precision_habitat', DB.Text)) ref_station = DB.Column('ref_station', DB.String) ref_typologie = DB.Column('ref_typologie', DB.String) descriptif_groupe = DB.deferred(DB.Column('descriptif_groupe', DB.Text)) descriptif_groupe1 = DB.deferred(DB.Column('descriptif_groupe1', DB.Text)) descriptif_groupe2 = DB.deferred(DB.Column('descriptif_groupe2', DB.Text)) precision_gps = DB.Column('precision_gps', DB.String) cheminement = DB.deferred(DB.Column('cheminement', DB.Text)) geom = DB.Column('geom', Geometry('POINT', 2154)) geom_wgs84 = DB.Column('geom_wgs84', Geometry('POINT', 4326)) dispositif = DB.relationship('TDispositifs', foreign_keys=id_dispositif, back_populates='placettes')
class TArbresMesures (DB.Model): __tablename__ = "t_arbres_mesures" __table_args__ = {'schema': SCHEMA} id_arbre_mesure = DB.Column('id_arbre_mesure', DB.Integer, primary_key = True) id_arbre = DB.Column('id_arbre', DB.Integer, DB.ForeignKey('pr_psdrf.t_arbres.id_arbre')) id_cycle = DB.Column('id_cycle', DB.Integer, DB.ForeignKey('pr_psdrf.t_cycles.id_cycle')) diametre1 = DB.Column('diametre1', DB.Float) diametre2 = DB.Column('diametre2', DB.Float) type = DB.Column('type', DB.String) hauteur_totale = DB.Column('hauteur_totale', DB.Float) hauteur_branche = DB.Column('hauteur_branche', DB.Float) stade_durete = DB.Column('stade_durete', DB.Integer) stade_ecorce = DB.Column('stade_ecorce', DB.Integer) liane = DB.Column('liane', DB.String) diametre_liane = DB.Column('diametre_liane', DB.Float) coupe = DB.Column('coupe', DB.Unicode) limite = DB.Column('limite', DB.Boolean) id_nomenclature_code_sanitaire = DB.Column('id_nomenclature_code_sanitaire', DB.Integer) code_ecolo = DB.Column('code_ecolo', DB.String) ref_code_ecolo = DB.Column('ref_code_ecolo', DB.String) ratio_hauteur = DB.Column('ratio_hauteur', DB.Boolean) observation = DB.deferred(DB.Column('observation', DB.Text)) arbre = DB.relationship('TArbres', foreign_keys=id_arbre) cycle = DB.relationship('TCycles', foreign_keys=id_cycle)
class TReperes (DB.Model): __tablename__ = "t_reperes" __table_args__ = {'schema': SCHEMA} id_repere = DB.Column('id_repere', DB.Integer, primary_key = True) id_placette = DB.Column('id_placette', DB.Integer, DB.ForeignKey('pr_psdrf.t_placettes.id_placette')) azimut = DB.Column('azimut', DB.Float) distance = DB.Column('distance', DB.Float) diametre = DB.Column('diametre', DB.Float) observation = DB.deferred(DB.Column('observation', DB.Text)) placette = DB.relationship('TPlacettes', foreign_keys=id_placette)
class TArbres (DB.Model): __tablename__ = "t_arbres" __table_args__ = {'schema': SCHEMA} id_arbre = DB.Column('id_arbre', DB.Integer, primary_key = True) id_arbre_orig = DB.Column('id_arbre_orig', DB.Integer) id_placette = DB.Column('id_placette', DB.Integer, DB.ForeignKey('pr_psdrf.t_placettes.id_placette')) code_essence = DB.Column('code_essence', DB.String, DB.ForeignKey('pr_psdrf.bib_essences.code_essence')) azimut = DB.Column('azimut', DB.Float) distance = DB.Column('distance', DB.Float) taillis = DB.Column('taillis', DB.Boolean) observation = DB.deferred(DB.Column('observation', DB.Text)) placette = DB.relationship('TPlacettes', foreign_keys=id_placette) essence = DB.relationship('BibEssences', foreign_keys=code_essence)
class TRegenerations (DB.Model): __tablename__ = "t_regenerations" __table_args__ = {'schema': SCHEMA} id_regeneration = DB.Column('id_regeneration', DB.Integer, primary_key = True) id_cycle_placette = DB.Column('id_cycle_placette', DB.Integer, DB.ForeignKey('pr_psdrf.cor_cycles_placettes.id_cycle_placette')) sous_placette = DB.Column('sous_placette', DB.Integer) code_essence = DB.Column('code_essence', DB.String) recouvrement = DB.Column('recouvrement', DB.Float) classe1 = DB.Column('classe1', DB.Integer) classe2 = DB.Column('classe2', DB.Integer) classe3 = DB.Column('classe3', DB.Integer) taillis = DB.Column('taillis', DB.Boolean) abroutissement = DB.Column('abroutissement', DB.Boolean) id_nomenclature_abroutissement = DB.Column('id_nomenclature_abroutissement', DB.Integer) observation = DB.deferred(DB.Column('observation', DB.Text)) cor_cycles_placettes = DB.relationship('CorCyclesPlacettes', foreign_keys=id_cycle_placette)
class TBmSup30 (DB.Model): __tablename__ = "t_bm_sup_30" __table_args__ = {'schema': SCHEMA} id_bm_sup_30 = DB.Column('id_bm_sup_30', DB.Integer, primary_key = True) id_bm_sup_30_orig = DB.Column('id_bm_sup_30_orig', DB.Integer) id_placette = DB.Column('id_placette', DB.Integer, DB.ForeignKey('pr_psdrf.t_placettes.id_placette')) id_arbre = DB.Column('id_arbre', DB.Integer, DB.ForeignKey('pr_psdrf.t_arbres.id_arbre')) code_essence = DB.Column('code_essence', DB.String, DB.ForeignKey('pr_psdrf.bib_essences.code_essence')) azimut = DB.Column('azimut', DB.Float) distance = DB.Column('distance', DB.Float) orientation = DB.Column('orientation', DB.Float) azimut_souche = DB.Column('azimut_souche', DB.Float) distance_souche = DB.Column('distance_souche', DB.Float) observation = DB.deferred(DB.Column('observation', DB.Text)) placette = DB.relationship('TPlacettes', foreign_keys=id_placette) essence = DB.relationship('BibEssences', foreign_keys=code_essence) arbre = DB.relationship('TArbres', foreign_keys=id_arbre)
class TBmSup30Mesures (DB.Model): __tablename__ = "t_bm_sup_30_mesures" __table_args__ = {'schema': SCHEMA} id_bm_sup_30_mesure = DB.Column('id_bm_sup_30_mesure', DB.Integer, primary_key = True) id_bm_sup_30 = DB.Column('id_bm_sup_30', DB.Integer, DB.ForeignKey('pr_psdrf.t_bm_sup_30.id_bm_sup_30')) id_cycle = DB.Column('id_cycle', DB.Integer, DB.ForeignKey('pr_psdrf.t_cycles.id_cycle')) diametre_ini = DB.Column('diametre_ini', DB.Float) diametre_med = DB.Column('diametre_med', DB.Float) diametre_fin = DB.Column('diametre_fin', DB.Float) diametre_130 = DB.Column('diametre_130', DB.Float) longueur = DB.Column('longueur', DB.Float) ratio_hauteur = DB.Column('ratio_hauteur', DB.Boolean) contact = DB.Column('contact', DB.Float) chablis = DB.Column('chablis', DB.Boolean) stade_durete = DB.Column('stade_durete', DB.Integer) stade_ecorce = DB.Column('stade_ecorce', DB.Integer) observation = DB.deferred(DB.Column('observation', DB.Text)) bm_sup_30 = DB.relationship('TBmSup30', foreign_keys=id_bm_sup_30) cycle = DB.relationship('TCycles', foreign_keys=id_cycle)
class TTransects (DB.Model): __tablename__ = "t_transects" __table_args__ = {'schema': SCHEMA} id_transect = DB.Column('id_transect', DB.Integer, primary_key = True) id_cycle_placette = DB.Column('id_cycle_placette', DB.Integer, DB.ForeignKey('pr_psdrf.cor_cycles_placettes.id_cycle_placette')) code_essence = DB.Column('code_essence', DB.String) ref_transect = DB.Column('ref_transect', DB.String) distance = DB.Column('distance', DB.Float) orientation = DB.Column('orientation', DB.Float) azimut_souche = DB.Column('azimut_souche', DB.Float) distance_souche = DB.Column('distance_souche', DB.Float) diametre = DB.Column('diametre', DB.Float) diametre_130 = DB.Column('diametre_130', DB.Float) ratio_hauteur = DB.Column('ratio_hauteur', DB.Boolean) contact = DB.Column('contact', DB.Boolean) angle = DB.Column('angle', DB.Float) chablis = DB.Column('chablis', DB.Boolean) stade_durete = DB.Column('stade_durete', DB.Integer) stade_ecorce = DB.Column('stade_ecorce', DB.Integer) observation = DB.deferred(DB.Column('observation', DB.Text)) cor_cycles_placettes = DB.relationship('CorCyclesPlacettes', foreign_keys=id_cycle_placette)