class PlantsSpreadAtMaturityByRegion(db.Model): __tablename__ = 'plants_spread_at_maturity_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) spread = db.Column(db.Integer) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'spread_at_maturity_by_region') region = db.relationship('Regions') def __init__(self, plant, region, spread): self.plant = plant self.region = region self.spread = spread
class Transactions(db.Model): __tablename__ = 'transactions' id = db.Column(db.Integer, primary_key=True) timestamp = db.Column(db.DateTime(timezone=False), server_default="timezone('utc'::text, now())") users_id = db.Column(db.Integer, db.ForeignKey(u'users.id')) transaction_type = db.Column(db.String) plants_id = db.Column(db.Integer, db.ForeignKey(u'plants.id')) ignore = db.Column(db.Boolean) actions = db.relationship(Actions, backref='transaction') user = db.relationship('Users') plant = db.relationship('Plants') def __str__(self): return str(self.id)
class PlantsWaterNeedsByRegion(db.Model): __tablename__ = 'plants_water_needs_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) water_needs_id = db.Column(db.Integer, db.ForeignKey('water_needs.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'water_needs_by_region') water_needs = db.relationship('WaterNeeds') region = db.relationship('Regions') def __init__(self, plant, region, water_needs_id): self.plant = plant self.region = region self.water_needs_id = water_needs_id
class PlantsLeafRetentionByRegion(db.Model): __tablename__ = 'plants_leaf_retention_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) leaf_retention_id = db.Column(db.Integer, db.ForeignKey('leaf_retention.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'leaf_retention_by_region') leaf_retention = db.relationship(LeafRetention) region = db.relationship('Regions') def __init__(self, plant, region, leaf_retention_id): self.plant = plant self.region = region self.leaf_retention_id = leaf_retention_id
class PlantsSoilDrainageTolByRegion(db.Model): __tablename__ = 'plants_soil_drainage_tol_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) soil_drainage_tol_id = db.Column(db.Integer, db.ForeignKey('soil_drainage_tol.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'soil_drainage_tol_by_region') soil_drainage_tol = db.relationship('SoilDrainageTol') region = db.relationship('Regions') def __init__(self, plant, region, soil_drainage_tol_id): self.plant = plant self.region = region self.soil_drainage_tol_id = soil_drainage_tol_id
class PlantsHarvestPeriodByRegion(db.Model): __tablename__ = 'plants_harvest_period_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) harvest_period_id = db.Column(db.Integer, db.ForeignKey('harvest_period.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'harvest_period_by_region') harvest_period = db.relationship(HarvestPeriod) region = db.relationship('Regions') def __init__(self, plant, region, harvest_period_id): self.plant = plant self.region = region self.harvest_period_id = harvest_period_id
class PlantsInsectRegulatorByRegion(db.Model): __tablename__ = 'plants_insect_regulator_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) insects_id = db.Column(db.Integer, db.ForeignKey('insects.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'insect_regulator_by_region') insect = db.relationship(Insects) region = db.relationship('Regions') def __init__(self, plant, region, insects_id): self.plant = plant self.region = region self.insects_id = insects_id
class PlantsFertilityNeedsByRegion(db.Model): __tablename__ = 'plants_fertility_needs_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) fertility_needs_id = db.Column(db.Integer, db.ForeignKey('fertility_needs.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'fertility_needs_by_region') fertility_needs = db.relationship(FertilityNeeds) region = db.relationship('Regions') def __init__(self, plant, region, fertility_needs_id): self.plant = plant self.region = region self.fertility_needs_id = fertility_needs_id
class PlantsEndemicStatusByRegion(db.Model): __tablename__ = 'plants_endemic_status_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) endemic_status_id = db.Column(db.Integer, db.ForeignKey('endemic_status.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'endemic_status_by_region') endemic_status = db.relationship(EndemicStatus) region = db.relationship('Regions') def __init__(self, plant, region, endemic_status_id): self.plant = plant self.region = region self.endemic_status_id = endemic_status_id
class PlantsErosionControlByRegion(db.Model): __tablename__ = 'plants_erosion_control_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) erosion_control_id = db.Column(db.Integer, db.ForeignKey('erosion_control.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'erosion_control_by_region') erosion_control = db.relationship(ErosionControl) region = db.relationship('Regions') def __init__(self, plant, region, erosion_control_id): self.plant = plant self.region = region self.erosion_control_id = erosion_control_id
class PlantsDurationByRegion(db.Model): __tablename__ = 'plants_duration_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) duration_id = db.Column(db.Integer, db.ForeignKey('duration.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'duration_by_region') duration = db.relationship(Duration) region = db.relationship('Regions') def __init__(self, plant, region, duration_id): self.plant = plant self.region = region self.duration_id = duration_id
class PlantsCanopyDensityByRegion(db.Model): __tablename__ = 'plants_canopy_density_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) canopy_density_id = db.Column(db.Integer, db.ForeignKey('canopy_density.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'canopy_density_by_region') canopy_density = db.relationship(CanopyDensity) region = db.relationship('Regions') def __init__(self, plant, region, canopy_density_id): self.plant = plant self.region = region self.canopy_density_id = canopy_density_id
class PlantsAnimalRegulatorByRegion(db.Model): __tablename__ = 'plants_animal_regulator_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) animals_id = db.Column(db.Integer, db.ForeignKey('animals.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'animal_regulator_by_region') animal = db.relationship(Animals) region = db.relationship('Regions') def __init__(self, plant, region, animals_id): self.plant = plant self.region = region self.animals_id = animals_id
class PlantsActiveGrowthPeriodByRegion(db.Model): __tablename__ = 'plants_active_growth_period_by_region' id = db.Column(db.Integer, primary_key=True) plants_id = db.Column(db.Integer, db.ForeignKey('plants.id')) active_growth_period_id = db.Column(db.Integer, db.ForeignKey('active_growth_period.id')) regions_id = db.Column(db.Integer, db.ForeignKey('regions.id')) plant = db.relationship(Plants, backref = 'active_growth_period_by_region') active_growth_period = db.relationship(ActiveGrowthPeriod) region = db.relationship('Regions') def __init__(self, plant, region, active_growth_period_id): self.plant = plant self.region = region self.active_growth_period_id = active_growth_period_id
class Actions(db.Model): __tablename__ = 'actions' id = db.Column(db.Integer, primary_key=True) transactions_id = db.Column(db.Integer, db.ForeignKey(u'transactions.id')) action_type = db.Column(db.String) regions_id = db.Column(db.Integer, db.ForeignKey(u'regions.id')) property = db.Column(db.String) value = db.Column(db.String) citation = db.Column(db.String) region = db.relationship('Regions') def __str__(self): return str(self.id)
class Plants(db.Model): __tablename__ = 'plants' __view__ = ModelViewAddToTransactions id = db.Column(db.Integer, primary_key=True) genus = db.Column(db.String) species = db.Column(db.String) common_name = db.Column(db.String) drought_tol_id = db.Column(db.Integer, db.ForeignKey(u'drought_tol.id')) flood_tol_id = db.Column(db.Integer, db.ForeignKey(u'flood_tol.id')) humidity_tol_id = db.Column(db.Integer, db.ForeignKey(u'humidity_tol.id')) salt_tol_id = db.Column(db.Integer, db.ForeignKey(u'salt_tol.id')) toxin_removal_id = db.Column(db.Integer, db.ForeignKey(u'toxin_removal.id')) wind_tol_id = db.Column(db.Integer, db.ForeignKey(u'wind_tol.id')) minimum_temperature_tol = db.Column(db.Integer) innoculant = db.Column(db.String) variety = db.Column(db.String) fire_tol_id = db.Column(db.Integer, db.ForeignKey(u'fire_tol.id')) livestock_bloat_id = db.Column(db.Integer, db.ForeignKey(u'livestock_bloat.id')) pH_min = db.Column(db.Numeric) pH_max = db.Column(db.Numeric) toxicity_id = db.Column(db.Integer, db.ForeignKey(u'toxicity.id')) lifespan_id = db.Column(db.Integer, db.ForeignKey(u'lifespan.id')) allelopathic_id = db.Column(db.Integer, db.ForeignKey(u'allelopathic.id')) def __str__(self): return '{0} {1} ({2})'.format(self.genus, self.species, self.common_name) biochemical_materials = db.relationship('PlantsBiochemicalMaterialProd', backref='plant') cultural_and_amenity_products = db.relationship('PlantsCulturalAndAmenityProd', backref='plant') families = db.relationship('Family', backref='plant') family_common_names = db.relationship('FamilyCommonName', backref='plant') flower_colors = db.relationship('PlantsFlowerColor', backref='plant') foliage_colors = db.relationship('PlantsFoliageColor', backref='plant') foods = db.relationship('PlantsFoodProd', backref='plant') fruit_colors = db.relationship('PlantsFruitColor', backref='plant') layers = db.relationship('PlantsLayer', backref='plant') medicinals = db.relationship('PlantsMedicinalsProd', backref='plant') mineral_nutrients = db.relationship('PlantsMineralNutrientsProd', backref='plant') raw_materials = db.relationship('PlantsRawMaterialsProd', backref='plant') url_tags = db.relationship('UrlTags', backref='plant')