id = models.IntegerField(primary_key=True)
nom = models.CharField(max_length=255)
prenom = models.CharField(max_length=255)
- implantation = models.ForeignKey(to='Implantation', db_column='implantation', related_name='lieu_travail_theorique_de') # SGRH
- implantation_physique = models.ForeignKey(to='Implantation', db_column='implantation_physique', related_name='lieu_travail_reel_de')
+ implantation = models.ForeignKey(
+ 'references.Implantation',
+ db_column='implantation',
+ related_name='lieu_travail_theorique_de'
+ )
+ implantation_physique = models.ForeignKey(
+ 'references.Implantation',
+ db_column='implantation_physique',
+ related_name='lieu_travail_reel_de'
+ )
courriel = models.CharField(max_length=255, null=True, blank=True)
genre = models.CharField(max_length=3)
fonction = models.CharField(max_length=255, null=True, blank=True)
telephone_poste = models.CharField(max_length=255, null=True, blank=True)
telephone_ip = models.CharField(max_length=255, null=True, blank=True)
- responsable = models.ForeignKey(to='Employe', db_column='responsable', related_name='responsable_de', null=True, blank=True)
+ responsable = models.ForeignKey(
+ 'references.Employe',
+ db_column='responsable',
+ related_name='responsable_de',
+ null=True, blank=True
+ )
mandat_debut = models.DateField(null=True, blank=True)
mandat_fin = models.DateField(null=True, blank=True)
date_entree = models.DateField(null=True, blank=True)
- service = models.ForeignKey('Service', db_column='service')
- poste_type_1 = models.ForeignKey('PosteType', null=True, blank=True, db_column='poste_type_1', related_name='poste_type_1')
- poste_type_2 = models.ForeignKey('PosteType', null=True, blank=True, db_column='poste_type_2', related_name='poste_type_2')
+ service = models.ForeignKey('references.Service', db_column='service')
+ poste_type_1 = models.ForeignKey(
+ 'references.PosteType',
+ null=True, blank=True,
+ db_column='poste_type_1',
+ related_name='poste_type_1'
+ )
+ poste_type_2 = models.ForeignKey(
+ 'references.PosteType',
+ null=True, blank=True,
+ db_column='poste_type_2',
+ related_name='poste_type_2'
+ )
# meta
actif = models.BooleanField()
class Authentification(models.Model):
"""Authentification"""
- id = models.ForeignKey('Employe', primary_key=True, db_column='id')
+ id = models.ForeignKey('references.Employe', primary_key=True, db_column='id')
courriel = models.CharField(max_length=255, unique=True)
motdepasse = models.CharField(max_length=255)
actif = models.BooleanField()
class GroupeArh(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
actif = models.BooleanField()
class Meta:
class GroupeDirRegion(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
- region = models.ForeignKey('Region', db_column='region')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ region = models.ForeignKey('references.Region', db_column='region')
actif = models.BooleanField()
class Meta:
class GroupeAdmRegion(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
- region = models.ForeignKey('Region', db_column='region')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ region = models.ForeignKey('references.Region', db_column='region')
actif = models.BooleanField()
class Meta:
class GroupeRespImplantation(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
- implantation = models.ForeignKey('Implantation', db_column='implantation')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ implantation = models.ForeignKey('references.Implantation', db_column='implantation')
type = models.CharField(max_length=255, blank=True, null=True)
actif = models.BooleanField()
class GroupeDirProgramme(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
- service = models.ForeignKey('Service', db_column='service')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ service = models.ForeignKey('references.Service', db_column='service')
actif = models.BooleanField()
class Meta:
class GroupeDirDelegProgrammeReg(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
- region = models.ForeignKey('Region', db_column='region')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
+ region = models.ForeignKey('references.Region', db_column='region')
actif = models.BooleanField()
class Meta:
class GroupeComptable(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
actif = models.BooleanField()
class Meta:
class GroupeComptableRegional(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
actif = models.BooleanField()
class Meta:
class GroupeComptableLocal(models.Model):
id = models.AutoField(primary_key=True)
- employe = models.ForeignKey('Employe', db_column='employe')
+ employe = models.ForeignKey('references.Employe', db_column='employe')
actif = models.BooleanField()
class Meta:
presentation = models.TextField(null=True, blank=True)
partenaires = models.TextField(null=True, blank=True)
service = models.CharField(max_length=255, choices=SERVICE_CHOICES, blank=True, null=True)
- objectif_specifique = models.ForeignKey('ObjectifSpecifique', blank=True, null=True, db_column='objectif_specifique')
- implantation = models.ForeignKey('Implantation', null=True, blank=True, db_column='implantation')
- etablissement = models.ForeignKey('Etablissement', null=True, blank=True, db_column='etablissement')
+ objectif_specifique = models.ForeignKey(
+ 'references.ObjectifSpecifique',
+ blank=True, null=True,
+ db_column='objectif_specifique'
+ )
+ implantation = models.ForeignKey('references.Implantation', null=True,
+ blank=True, db_column='implantation')
+ etablissement = models.ForeignKey('references.Etablissement', null=True,
+ blank=True, db_column='etablissement')
date_debut = models.DateField(null=True, blank=True)
date_fin = models.DateField(null=True, blank=True)
# meta
nom = models.CharField(max_length=255)
nom_court = models.CharField(max_length=255, null=True, blank=True)
description = models.TextField(null=True, blank=True)
- projet = models.ForeignKey('Projet', db_column='projet')
+ projet = models.ForeignKey('references.Projet', db_column='projet')
# meta
actif = models.BooleanField()
class ObjectifSpecifique(models.Model):
id = models.IntegerField(primary_key=True)
nom = models.CharField(max_length=255)
- objectif_strategique = models.ForeignKey('ObjectifStrategique', db_column='objectif_strategique')
+ objectif_strategique = models.ForeignKey('references.ObjectifStrategique',
+ db_column='objectif_strategique')
# meta
actif = models.BooleanField()
id = models.IntegerField(primary_key=True)
code = models.CharField(max_length=255, unique=True)
- code_projet = models.ForeignKey('Projet', to_field='code', db_column='code_projet')
- code_poste = models.ForeignKey('Poste', to_field='code', db_column='code_poste')
- code_bureau = models.ForeignKey('Bureau', to_field='code', db_column='code_bureau')
- code_programme = models.ForeignKey('Programme', to_field='code', db_column='code_programme')
+ code_projet = models.ForeignKey('references.Projet', to_field='code', db_column='code_projet')
+ code_poste = models.ForeignKey('references.Poste', to_field='code', db_column='code_poste')
+ code_bureau = models.ForeignKey('references.Bureau', to_field='code', db_column='code_bureau')
+ code_programme = models.ForeignKey('references.Programme',
+ to_field='code',
+ db_column='code_programme')
# meta
actif = models.BooleanField()
"""
code = models.CharField(max_length=255, unique=True)
nom = models.CharField(max_length=255, db_index=True)
- implantation_bureau = models.ForeignKey('Implantation',
+ implantation_bureau = models.ForeignKey('references.Implantation',
db_column='implantation_bureau',
related_name='gere_region', null=True, blank=True)
# meta
nom = models.CharField(max_length=255)
nom_court = models.CharField(max_length=255, blank=True)
nom_long = models.CharField(max_length=255, blank=True)
- implantation = models.ForeignKey('Implantation', db_column='implantation')
- region = models.ForeignKey('Region', db_column='region')
+ implantation = models.ForeignKey('references.Implantation', db_column='implantation')
+ region = models.ForeignKey('references.Region', db_column='region')
# meta
actif = models.BooleanField()
nom_court = models.CharField(max_length=255, blank=True)
nom_long = models.CharField(max_length=255, blank=True)
type = models.CharField(max_length=255)
- bureau_rattachement = models.ForeignKey('Implantation', db_column='bureau_rattachement')
- region = models.ForeignKey('Region', db_column='region')
+ bureau_rattachement = models.ForeignKey('references.Implantation', db_column='bureau_rattachement')
+ region = models.ForeignKey('references.Region', db_column='region')
fuseau_horaire = models.CharField(max_length=255, blank=True)
code_meteo = models.CharField(max_length=255, blank=True)
# responsable
adresse_postale_code_postal = models.CharField(max_length=20, blank=True, null=True)
adresse_postale_code_postal_avant_ville = models.NullBooleanField()
adresse_postale_region = models.CharField(max_length=255, blank=True, null=True)
- adresse_postale_pays = models.ForeignKey('Pays', to_field='code', db_column='adresse_postale_pays', related_name='impl_adresse_postale')
+ adresse_postale_pays = models.ForeignKey('references.Pays',
+ to_field='code',
+ db_column='adresse_postale_pays',
+ related_name='impl_adresse_postale')
# adresse physique
adresse_physique_precision_avant = models.CharField(max_length=255, blank=True)
adresse_physique_no = models.CharField(max_length=30, blank=True)
adresse_physique_code_postal = models.CharField(max_length=30, blank=True)
adresse_physique_code_postal_avant_ville = models.NullBooleanField()
adresse_physique_region = models.CharField(max_length=255, blank=True)
- adresse_physique_pays = models.ForeignKey('Pays', to_field='code', db_column='adresse_physique_pays', related_name='impl_adresse_physique')
+ adresse_physique_pays = models.ForeignKey('references.Pays',
+ to_field='code',
+ db_column='adresse_physique_pays',
+ related_name='impl_adresse_physique')
# autres coordonnées
telephone = models.CharField(max_length=255, blank=True)
telephone_interne = models.CharField(max_length=255, blank=True)
code = models.CharField(max_length=2, unique=True)
code_iso3 = models.CharField(max_length=3, unique=True)
nom = models.CharField(max_length=255)
- region = models.ForeignKey('Region', db_column='region')
- code_bureau = models.ForeignKey('Bureau', to_field='code',
+ region = models.ForeignKey('references.Region', db_column='region')
+ code_bureau = models.ForeignKey('references.Bureau', to_field='code',
db_column='code_bureau', blank=True,
null=True)
nord_sud = models.CharField(max_length=255, blank=True, null=True)
# Infos de base
nom = models.CharField(max_length=255)
- pays = models.ForeignKey('Pays', to_field='code', db_column='pays',
+ pays = models.ForeignKey('references.Pays', to_field='code', db_column='pays',
related_name='+')
- region = models.ForeignKey('Region', db_column='region', blank=True,
+ region = models.ForeignKey('references.Region', db_column='region', blank=True,
null=True, related_name='+', verbose_name='région')
- implantation = models.ForeignKey('Implantation',
+ implantation = models.ForeignKey('references.Implantation',
db_column='implantation',
related_name='+', blank=True, null=True)