class Region(db.Model): __tablename__ = 'region' id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(255)) slug = db.Column(db.String(255), unique=True) created = db.Column(db.DateTime()) updated = db.Column(db.DateTime()) active = db.Column(db.Integer()) osm_id = db.Column(db.Integer()) geo_json = db.Column(db.Text()) rgs = db.Column(db.String(255)) region_level = db.Column(db.Integer()) postalcode = db.Column(db.String(255)) fulltext = db.Column(db.String(255)) lat = db.Column(db.Numeric(precision=10,scale=7)) lon = db.Column(db.Numeric(precision=10,scale=7)) def __init__(self): pass def __repr__(self): return '<Hoster %r>' % self.name
class TrafficItem(db.Model): __tablename__ = 'traffic_item' id = db.Column(db.Integer(), primary_key=True) created = db.Column(db.DateTime()) updated = db.Column(db.DateTime()) active = db.Column(db.Integer()) name = db.Column(db.String(255)) slug = db.Column(db.String(255)) external_id = db.Column(db.String(255)) item_type = db.Column(db.Integer()) # 1 Baustelle 2 Auto-Parkplatz 3 Fahrrad-Ständer 4 Verkehrszählung 5 Sperranhänger raw_status = db.Column(db.Integer()) # 1 komplett roh, 2 verarbeitet is_meta = db.Column(db.Integer()) zoom_from = db.Column(db.Integer()) zoom_till = db.Column(db.Integer()) lat = db.Column(db.Numeric(precision=10,scale=7)) lon = db.Column(db.Numeric(precision=10,scale=7)) area = db.Column(db.Text()) traffic_item_provider_id = db.Column(db.Integer, db.ForeignKey('traffic_item_provider.id')) traffic_item_meta = db.relationship("TrafficItemMeta", backref="TrafficItem", lazy='dynamic') def __init__(self): pass def __repr__(self): return '<TrafficItem %r>' % self.name
class SharingStation(db.Model): __tablename__ = 'sharing_station' id = db.Column(db.Integer(), primary_key=True) created = db.Column(db.DateTime()) updated = db.Column(db.DateTime()) active = db.Column(db.Integer()) name = db.Column(db.String(255)) slug = db.Column(db.String(255)) external_id = db.Column(db.String(255)) vehicle_free = db.Column(db.Integer()) vehicle_all = db.Column(db.Integer()) station_type = db.Column( db.Integer() ) # 1 Fahrrad 2 Lastenrad 3 Fahrradanhänger 4 PKW 5 Transporter 6 Fahrradbox lat = db.Column(db.Numeric(precision=10, scale=7)) lon = db.Column(db.Numeric(precision=10, scale=7)) vehicle = db.relationship("Vehicle", backref="SharingStation", lazy='dynamic') sharing_provider_id = db.Column(db.Integer, db.ForeignKey('sharing_provider.id')) def __init__(self): pass def __repr__(self): return '<Region %r>' % self.name
class Region(db.Model): __tablename__ = 'region' id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(255)) slug = db.Column(db.String(255), unique=True) created = db.Column(db.DateTime()) updated = db.Column(db.DateTime()) active = db.Column(db.Integer()) osm_id = db.Column(db.Integer()) geo_json = db.Column(db.Text()) rgs = db.Column(db.String(255)) region_level = db.Column(db.Integer()) postalcode = db.Column(db.String(255)) lat = db.Column(db.Numeric(precision=10,scale=7)) lon = db.Column(db.Numeric(precision=10,scale=7)) region_parent_id = db.Column(db.Integer, db.ForeignKey('region.id')) region_parent = db.relationship("Region", backref="region_children", remote_side=[id]) service_sites = db.relationship("ServiceSite", backref="region", lazy='dynamic') # hosts as defined in Host def __init__(self): pass def __repr__(self): return '<Hoster %r>' % self.name
class IndicatorValue(db.Model): __tablename__ = 'IndicatorValue' id = db.Column(db.Integer(), primary_key=True) clinic_id = db.Column(db.Integer(), db.ForeignKey('Clinic.id'), index=True) history_id = db.Column(db.Integer(), db.ForeignKey('History.id'), index=True) patient_id = db.Column(db.Integer(), db.ForeignKey('Patient.id')) history_event_id = db.Column(db.Integer(), db.ForeignKey('HistoryEvent.id')) indicator_id = db.Column(db.Integer(), db.ForeignKey('Indicator.id')) slice = db.Column(db.String(100)) time_created = db.Column(db.DateTime(), default=datetime.utcnow()) date_value = db.Column(db.Date()) date_time_value = db.Column(db.DateTime()) text_value = db.Column(db.String(100)) num_value = db.Column(db.Numeric()) num_deviation = db.Column(db.Numeric()) def_value = db.Column(db.Integer()) comment = db.Column(db.String(500)) events = db.relationship('HistoryEvent', backref='indicator_values')
class ConstructionSite(db.Model): __tablename__ = 'construction_site' id = db.Column(db.Integer(), primary_key=True) title = db.Column(db.String(255)) descr = db.Column(db.Text()) # Allg. Beschreibung reason = db.Column(db.Text()) # Begründung für Baustelle type = db.Column(db.Text()) # Art der Verkehrseinschränkung constructor = db.Column(db.Text()) # Bauherr execution = db.Column(db.Text()) # Ausführendes Bauunternehmen location_descr = db.Column(db.Text()) # Ort restriction = db.Column(db.Text()) # Einschränkungen area = db.Column(db.Text()) # GeoJSON lat = db.Column(db.Numeric(precision=10, scale=7)) lon = db.Column(db.Numeric(precision=10, scale=7)) external_id = db.Column( db.String(255)) # Externe ID (innerhalb der Source einzigartig) external_url = db.Column(db.Text()) # Externe URL begin = db.Column(db.DateTime()) # Start der Baumaßnahme end = db.Column(db.DateTime()) # Ende der Baumaßnahme created_at = db.Column(db.DateTime()) updated_at = db.Column(db.DateTime()) source_id = db.Column(db.Integer()) # Quelle licence_name = db.Column(db.Text()) licence_url = db.Column(db.Text()) licence_owner = db.Column(db.Text()) def __init__(self): pass def __repr__(self): return '<ConstructionSite %r>' % self.id
class Tree(db.Model): __tablename__ = 'tree' id = db.Column(db.Integer(), primary_key=True) type = db.Column(db.Integer()) public = db.Column(db.Integer()) author = db.Column(db.String(255)) email = db.Column(db.String(255)) ip = db.Column(db.String(15)) hostname = db.Column(db.String(255)) address = db.Column(db.String(255)) postalcode = db.Column(db.String(255)) city = db.Column(db.String(255)) picture = db.Column(db.Integer()) descr = db.Column(db.Text()) lat = db.Column(db.Numeric(precision=10,scale=7)) lng = db.Column(db.Numeric(precision=10,scale=7)) external_id = db.Column(db.String(255)) created_at = db.Column(db.DateTime()) updated_at = db.Column(db.DateTime()) tree_type_old = db.Column(db.String(255)) tree_type_new = db.Column(db.String(255)) chop_reason = db.Column(db.String(255)) source = db.Column(db.String(255)) tree_suggest = db.relationship('TreeSuggest', backref='tree', lazy='dynamic') def __init__(self): pass def __repr__(self): return '<Tree %r>' % self.id
class ProfileResponse(db.Model): __tablename__ = 'ProfileResponse' id = db.Column(db.Integer(), primary_key=True) date_value = db.Column(db.Date()) clinic_id = db.Column(db.Integer(), db.ForeignKey('Clinic.id'), index=True) history_id = db.Column(db.Integer(), db.ForeignKey('History.id')) patient_id = db.Column(db.Integer(), db.ForeignKey('Patient.id')) history_event_id = db.Column(db.Integer(), db.ForeignKey('HistoryEvent.id')) profile_id = db.Column(db.Integer(), db.ForeignKey('Profile.id'), index=True) profile_item_id = db.Column(db.Integer(), db.ForeignKey('ProfileItem.id')) response = db.Column(db.String(100), unique=False) response_value = db.Column(db.Numeric())