id = models.IntegerField(primary_key=True)
nom = models.CharField(max_length=255)
prenom = models.CharField(max_length=255)
- nationalite = models.ForeignKey('datamaster_modeles.Pays', to_field='code', related_name='nationalite', db_column='nationalite')
+ nationalite = models.ForeignKey('datamaster_modeles.Pays', to_field='code', related_name='employes_nationalite', db_column='nationalite')
date_naissance = models.DateField(null=True, blank=True)
#Infos personnelles
genre = models.CharField(max_length=1, choices=GENRE_CHOICES, null=True, blank=True)
ville = models.CharField(max_length=255, null=True, blank=True)
province = models.CharField(max_length=255, null=True, blank=True)
code_postal = models.CharField(max_length=255, null=True, blank=True)
- pays = models.ForeignKey('datamaster_modeles.Pays', to_field='code', null=True, blank=True, related_name='pays', db_column='pays')
+ pays = models.ForeignKey('datamaster_modeles.Pays', to_field='code', null=True, blank=True, related_name='employes', db_column='pays')
#Métas
date_creation = models.DateField(auto_now_add=True)
date_maj = models.DateField(auto_now=True)
code = models.CharField(max_length=10, unique=True)
employe = models.ForeignKey('Employe', db_column='employe')
#Postes
- poste1 = models.ForeignKey('Poste', db_column='poste1', related_name='poste1')
- implantation1 = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation1', related_name='implantation1')
+ poste1 = models.ForeignKey('Poste', db_column='poste1', related_name='dossiers_poste1')
+ implantation1 = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation1', related_name='dossiers_implantation1')
complement1 = models.TextField(null=True, blank=True)
responsable_implantation1 = models.IntegerField()
- poste2 = models.ForeignKey('Poste', db_column='poste2', related_name='poste2', blank=True, null=True)
- implantation2 = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation2', related_name='implantation2')
+ poste2 = models.ForeignKey('Poste', db_column='poste2', related_name='dossiers_poste2', blank=True, null=True)
+ implantation2 = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation2', related_name='dossiers_implantation2')
complement2 = models.TextField(null=True, blank=True)
responsable_implantation2 = models.IntegerField()
#Relations
service = models.ForeignKey('Service', db_column='service')
- responsable = models.ForeignKey('Employe', db_column='responsable', related_name='responsable')
- remplacement_de = models.ForeignKey('Employe', db_column='remplacement_de', related_name='remplacement_de')
+ responsable = models.ForeignKey('Employe', db_column='responsable', related_name='responsable_de')
+ remplacement_de = models.ForeignKey('Employe', db_column='remplacement_de', related_name='replaced_by')
type = models.CharField(max_length=1, choices=TYPE_DOSSIER_CHOICES)
statut = models.ForeignKey('Statut', db_column='statut')
organisme_bstg = models.ForeignKey('OrganismeBstg', db_column='organisme_bstg')
nom = models.CharField(max_length=255)
prenom = models.CharField(max_length=255)
#Relation
- employe = models.ForeignKey('Employe', db_column='employe', related_name='employe')
+ employe = models.ForeignKey('Employe', db_column='employe', related_name='ayants_droit')
lien_parente = models.CharField(max_length=10, choices=LIEN_PARENTE_CHOICES, null=True, blank=True)
#Méta
commentaire = models.TextField(null=True, blank=True)
#Identification
id = models.IntegerField(primary_key=True)
implantation = models.ForeignKey('datamaster_modeles.Implantation',
- db_column='implantation', related_name='+')
+ db_column='implantation', related_name='postes')
type_poste = models.ForeignKey('TypePoste', db_column='type_poste')
proportion = models.CharField(max_length=10, choices=PROPORTION_CHOICES)
#(sert à quoi?) renommer "regime_travail" ou autre? convertir data en % (data * 100; ex: 1 = 100%)
#Identification
id = models.IntegerField(primary_key=True)
valeur = models.FloatField()
- implantation = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation')
+ implantation = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation', related_name='valeurs_point')
#Méta
annee = models.IntegerField()
annee = models.IntegerField()
taux = models.FloatField()
#Relations
- implantation = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation')
+ implantation = models.ForeignKey('datamaster_modeles.Implantation', db_column='implantation', related_name='taux_change')
class Devise(models.Model):