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)
