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())
