class Url(Model):
short_id = CharField(max_length=8, pk=True)
url = CharField(1500, unique=True)
created_at = DatetimeField(auto_now_add=True)
class Meta:
table = "urls"
class Tag(Model):
id = IntField(pk=True)
index_id = CharField(255)
male = CharField(1, null=True)
female = CharField(1, null=True)
tag = CharField(255, null=True)
url = CharField(255, null=True)
class IndicateurReferentielCommentaire(models.Model):
id = IntField(pk=True)
epci_id = CharField(max_length=36)
indicateur_id = CharField(max_length=136)
value = TextField()
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
latest = BooleanField()
class AdemeUtilisateur(models.Model):
id = IntField(pk=True)
ademe_user_id = CharField(max_length=300)
email = CharField(max_length=300)
nom = CharField(max_length=300)
prenom = CharField(max_length=300)
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
class MesureCustom(models.Model):
id = IntField(pk=True)
uid = CharField(max_length=36)
epci_id = CharField(max_length=36)
climat_pratic_thematic_id = CharField(max_length=100)
name = CharField(max_length=100)
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
class ActionStatus(models.Model):
id = IntField(pk=True)
action_id = CharField(max_length=36)
epci_id = CharField(max_length=36)
avancement = CharField(max_length=36)
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
latest = BooleanField()
class UtilisateurDroits(models.Model):
id = IntField(pk=True)
ademe_user_id = CharField(max_length=300)
epci_id = CharField(max_length=36)
ecriture = BooleanField()
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
latest = BooleanField()
class ActionMeta(models.Model):
id = IntField(pk=True)
action_id = CharField(max_length=36)
epci_id = CharField(max_length=36)
meta = JSONField()
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
latest = BooleanField()
class ActionCustom(models.Model):
id = IntField(pk=True)
uid = CharField(max_length=36)
epci_id = CharField(max_length=36)
mesure_id = CharField(max_length=36)
name = CharField(max_length=100)
description = TextField()
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
class Epci(models.Model):
id = IntField(pk=True)
uid = CharField(max_length=36)
insee = CharField(max_length=5)
siren = CharField(max_length=9)
nom = CharField(max_length=300)
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
latest = BooleanField()
class File(Model):
id = IntField(pk=True)
index_id = CharField(255)
width = IntField(null=True)
hash = CharField(64, null=True)
haswebp = IntField(null=True)
hasavifsmalltn = IntField(null=True)
name = TextField(null=True)
height = IntField(null=True)
hasavif = IntField(null=True)
class FicheActionCategorie(models.Model):
id = IntField(pk=True)
epci_id = CharField(max_length=36)
uid = CharField(max_length=36)
parent_uid = CharField(max_length=36)
nom = CharField(max_length=300)
fiche_actions_uids = JSONField()
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
latest = BooleanField()
deleted = BooleanField()
class IndicateurPersonnalise(models.Model):
id = IntField(pk=True)
epci_id = CharField(max_length=36)
uid = CharField(max_length=36)
custom_id = CharField(max_length=36)
nom = CharField(max_length=300)
description = TextField()
unite = CharField(max_length=36)
meta = JSONField()
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
latest = BooleanField()
deleted = BooleanField()
class Sub(Model):
type = CharField(max_length=10)
type_id = IntField()
uid = IntField()
live = BooleanField()
dynamic = BooleanField()
at = BooleanField()
bot_id = IntField()
class GalleryInfo(Model):
language_localname = TextField(null=True)
language = TextField(null=True)
date = TextField(null=True)
files = ManyToManyField("models.File")
tags = ManyToManyField("models.Tag")
japanese_title = TextField(null=True)
title = TextField(null=True)
id = CharField(255, pk=True)
type = TextField(null=True)
class FicheAction(models.Model):
id = IntField(pk=True)
epci_id = CharField(max_length=36)
uid = CharField(max_length=36)
custom_id = CharField(max_length=36)
avancement = CharField(max_length=36)
en_retard = BooleanField()
referentiel_action_ids = JSONField()
referentiel_indicateur_ids = JSONField()
titre = CharField(max_length=300)
description = TextField()
budget = FloatField()
personne_referente = CharField(max_length=100)
structure_pilote = CharField(max_length=300)
elu_referent = CharField(max_length=300)
partenaires = CharField(max_length=300)
commentaire = TextField()
date_debut = CharField(max_length=36)
date_fin = CharField(max_length=36)
indicateur_personnalise_ids = JSONField()
latest = BooleanField()
deleted = BooleanField()
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
class Index(Model):
id = IntField(pk=True)
index_id = CharField(255)
class Utilisateur(models.Model):
id = IntField(pk=True)
ademe_user_id = CharField(max_length=300)
vie_privee_conditions = CharField(max_length=300)
created_at = DatetimeField(auto_now_add=True)
modified_at = DatetimeField(auto_now=True)
class User(Model):
uid = IntField(pk=True)
name = CharField(max_length=20)
class Version(Model):
version = CharField(max_length=30)
