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)