class Ville(db.Model):
__tablename__ = 'villes_france'
__table_args__ = {'schema': 'geopaysages'}
ville_id = db.Column(db.Integer,
primary_key=True,
server_default=db.FetchedValue())
ville_departement = db.Column(db.String)
ville_slug = db.Column(db.String)
ville_nom = db.Column(db.String)
ville_nom_simple = db.Column(db.String)
ville_nom_reel = db.Column(db.String)
ville_nom_soundex = db.Column(db.String)
ville_nom_metaphone = db.Column(db.String)
ville_code_postal = db.Column(db.String)
ville_commune = db.Column(db.String)
ville_code_commune = db.Column(db.String)
ville_arrondissement = db.Column(db.Integer)
ville_canton = db.Column(db.String)
ville_amdi = db.Column(db.Integer)
ville_population_2010 = db.Column(db.Integer)
ville_population_1999 = db.Column(db.Integer)
ville_population_2012 = db.Column(db.Integer)
ville_densite_2010 = db.Column(db.Integer)
ville_surface = db.Column(db.Integer)
ville_longitude_deg = db.Column(db.Integer)
ville_latitude_deg = db.Column(db.Integer)
ville_longitude_grd = db.Column(db.String)
ville_latitude_grd = db.Column(db.String)
ville_latitude_dms = db.Column(db.String)
ville_zmin = db.Column(db.Integer)
ville_zmax = db.Column(db.Integer)
class TPhoto(db.Model):
__tablename__ = 't_photo'
__table_args__ = {'schema': 'geopaysages'}
id_photo = db.Column(db.Integer,
primary_key=True,
server_default=db.FetchedValue())
id_site = db.Column(db.ForeignKey('geopaysages.t_site.id_site'))
path_file_photo = db.Column(db.String)
id_role = db.Column(db.ForeignKey('utilisateurs.t_roles.id_role'))
date_photo = db.Column(db.String)
filter_date = db.Column(db.Date)
legende_photo = db.Column(db.String)
display_gal_photo = db.Column(db.Boolean)
id_licence_photo = db.Column(
db.ForeignKey('geopaysages.dico_licence_photo.id_licence_photo'))
dico_licence_photo = db.relationship(
'DicoLicencePhoto',
primaryjoin=
'TPhoto.id_licence_photo == DicoLicencePhoto.id_licence_photo',
backref='t_photos')
t_role = db.relationship('TRole',
primaryjoin='TPhoto.id_role == TRole.id_role',
backref='t_photos')
t_site = db.relationship('TSite',
primaryjoin='TPhoto.id_site == TSite.id_site',
backref='t_photos')
class DicoStheme(db.Model):
__tablename__ = 'dico_stheme'
__table_args__ = {'schema': 'geopaysages'}
id_stheme = db.Column(db.Integer,
primary_key=True,
server_default=db.FetchedValue())
name_stheme = db.Column(db.String)
class Communes(db.Model):
__tablename__ = 'communes'
__table_args__ = {'schema': 'geopaysages'}
code_commune = db.Column(db.String,
primary_key=True,
server_default=db.FetchedValue())
nom_commune = db.Column(db.String)
class DicoLicencePhoto(db.Model):
__tablename__ = 'dico_licence_photo'
__table_args__ = {'schema': 'geopaysages'}
id_licence_photo = db.Column(db.Integer,
primary_key=True,
server_default=db.FetchedValue())
name_licence_photo = db.Column(db.String)
description_licence_photo = db.Column(db.String)
class TRole(db.Model):
__tablename__ = 't_roles'
__table_args__ = {'schema': 'utilisateurs', 'extend_existing': True}
groupe = db.Column(db.Boolean,
nullable=False,
server_default=db.FetchedValue())
id_role = db.Column(db.Integer,
primary_key=True,
server_default=db.FetchedValue())
identifiant = db.Column(db.String(100))
nom_role = db.Column(db.String(50))
prenom_role = db.Column(db.String(50))
desc_role = db.Column(db.Text)
_pass = db.Column('pass', db.String(100))
_pass_plus = db.Column('pass_plus', db.String(100))
email = db.Column(db.String(250))
id_organisme = db.Column(
db.ForeignKey('utilisateurs.bib_organismes.id_organisme',
onupdate='CASCADE'))
remarques = db.Column(db.Text)
date_insert = db.Column(db.DateTime)
date_update = db.Column(db.DateTime)
class TSite(db.Model):
__tablename__ = 't_site'
__table_args__ = {'schema': 'geopaysages'}
id_site = db.Column(db.Integer,
primary_key=True,
server_default=db.FetchedValue())
name_site = db.Column(db.String)
ref_site = db.Column(db.String)
desc_site = db.Column(db.String)
legend_site = db.Column(db.String)
testim_site = db.Column(db.String)
code_city_site = db.Column(db.String)
alti_site = db.Column(db.Integer)
path_file_guide_site = db.Column(db.String)
publish_site = db.Column(db.Boolean)
geom = db.Column(Geometry(geometry_type='POINT', srid=4326))
main_photo = db.Column(db.Integer)
class CorSthemeTheme(db.Model):
__tablename__ = 'cor_stheme_theme'
__table_args__ = {'schema': 'geopaysages'}
id_stheme_theme = db.Column(db.Integer,
nullable=False,
unique=True,
server_default=db.FetchedValue())
id_stheme = db.Column(db.ForeignKey('geopaysages.dico_stheme.id_stheme'),
primary_key=True,
nullable=False)
id_theme = db.Column(db.ForeignKey('geopaysages.dico_theme.id_theme'),
primary_key=True,
nullable=False)
dico_stheme = db.relationship(
'DicoStheme',
primaryjoin='CorSthemeTheme.id_stheme == DicoStheme.id_stheme',
backref='cor_stheme_themes')
dico_theme = db.relationship(
'DicoTheme',
primaryjoin='CorSthemeTheme.id_theme == DicoTheme.id_theme',
backref='cor_stheme_themes')
class CorSiteSthemeTheme(db.Model):
__tablename__ = 'cor_site_stheme_theme'
__table_args__ = {'schema': 'geopaysages'}
id_site_stheme_theme = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
id_site = db.Column(db.ForeignKey('geopaysages.t_site.id_site'),
primary_key=True,
nullable=False)
id_stheme_theme = db.Column(
db.ForeignKey('geopaysages.cor_stheme_theme.id_stheme_theme'),
primary_key=True,
nullable=False)
t_site = db.relationship(
'TSite',
primaryjoin='CorSiteSthemeTheme.id_site == TSite.id_site',
backref='cor_site_stheme_themes')
cor_stheme_theme = db.relationship(
'CorSthemeTheme',
primaryjoin=
'CorSiteSthemeTheme.id_stheme_theme == CorSthemeTheme.id_stheme_theme',
backref='cor_site_stheme_themes')