[#2518] Aller chercher la date de modification des dossiers
[auf_rh_dae.git] / project / legacy / models.py
1 from django.db import models
2
3 class Classement(models.Model):
4 id_classement = models.IntegerField(primary_key=True)
5 type_classement = models.CharField(max_length=4)
6 echelon = models.CharField(max_length=127)
7 degre = models.CharField(max_length=32)
8 commentaire = models.CharField(max_length=127)
9 coefficient = models.FloatField()
10 date_modif = models.CharField(max_length=10)
11 actif = models.IntegerField()
12 class Meta:
13 db_table = u'classement'
14 managed = False
15
16 class Fiches(models.Model):
17 no_employe = models.IntegerField(primary_key=True)
18 nom = models.CharField(max_length=128)
19 prenom = models.CharField(max_length=128)
20 date_ouverture = models.CharField(max_length=10)
21 situation_famille = models.CharField(max_length=2)
22 nationalite = models.CharField(max_length=2)
23 tel_domicile = models.CharField(max_length=20)
24 tel_cellulaire = models.CharField(max_length=20)
25 no_rue = models.CharField(max_length=128)
26 ville = models.CharField(max_length=128)
27 etat_province = models.CharField(max_length=128)
28 code_postal_cedex = models.CharField(max_length=64)
29 pays_iso2 = models.CharField(max_length=2)
30 sexe = models.CharField(max_length=1)
31 date_entree = models.CharField(max_length=10)
32 remarque = models.TextField()
33 date_maj = models.CharField(max_length=10)
34 date_naissance = models.CharField(max_length=10)
35 class Meta:
36 db_table = u'fiches'
37 managed = False
38
39 class Dossiers(models.Model):
40 id_dossier = models.IntegerField(primary_key=True)
41 no_dossier = models.CharField(max_length=10, unique=True)
42 employe = models.ForeignKey(Fiches, related_name='dossiers', db_column='no_employe')
43 id_implantation_1 = models.SmallIntegerField()
44 poste_1 = models.SmallIntegerField()
45 complement_1 = models.CharField(max_length=128)
46 id_implantation_2 = models.SmallIntegerField()
47 poste_2 = models.SmallIntegerField()
48 complement_2 = models.CharField(max_length=128)
49 ids_direction_service = models.CharField(max_length=128)
50 remplacement_de = models.IntegerField()
51 responsable = models.ForeignKey(Fiches, related_name='+', db_column='responsable')
52 id_local_expatrie = models.IntegerField()
53 date_debut_mandat = models.CharField(max_length=10)
54 date_fin_mandat = models.CharField(max_length=10)
55 id_statut = models.IntegerField()
56 id_bstg = models.IntegerField()
57 id_classement = models.IntegerField()
58 id_type_contrat = models.IntegerField()
59 regime_travail = models.SmallIntegerField()
60 date_debut_contrat = models.CharField(max_length=10)
61 date_fin_contrat = models.CharField(max_length=10)
62 remarque = models.TextField()
63 responsable_implantation_1 = models.IntegerField()
64 responsable_implantation_2 = models.IntegerField()
65 class Meta:
66 db_table = u'dossiers'
67 managed = False
68
69 class TypeRemuneration(models.Model):
70 id_type_remuneration = models.IntegerField(primary_key=True)
71 type_remuneration = models.CharField(max_length=127)
72 type_paiement = models.CharField(max_length=127)
73 nature_remuneration = models.CharField(max_length=127)
74 actif = models.IntegerField()
75 class Meta:
76 db_table = u'type_remuneration'
77 managed = False
78
79 class HistoRemuneration(models.Model):
80 id_histo_remuneration = models.IntegerField(primary_key=True)
81 type_remuneration = models.ForeignKey(TypeRemuneration, db_column='id_type_remuneration',
82 related_name='+')
83 no_dossier = models.CharField(max_length=10)
84 montant = models.DecimalField(max_digits=20, decimal_places=4)
85 pourcentage = models.DecimalField(max_digits=20, decimal_places=4)
86 date_effective = models.CharField(max_length=10)
87 id_type_revalorisation = models.IntegerField()
88 code_devise = models.CharField(max_length=3)
89 usager = models.IntegerField()
90 stamp = models.IntegerField()
91 desactive = models.BooleanField()
92 desactive_par = models.IntegerField()
93 annule = models.BooleanField()
94 annule_par = models.IntegerField()
95 stamp_annule = models.IntegerField()
96 stamp_desactive = models.IntegerField()
97 class Meta:
98 db_table = u'histo_remuneration'
99 managed = False
100
101 class HistoFiches(models.Model):
102 id_histo = models.IntegerField(primary_key=True)
103 fiche = models.ForeignKey(Fiches, db_column='no_employe', related_name='historique')
104 nom = models.CharField(max_length=128)
105 prenom = models.CharField(max_length=128)
106 date_ouverture = models.CharField(max_length=10)
107 situation_famille = models.CharField(max_length=2)
108 nationalite = models.CharField(max_length=2)
109 tel_domicile = models.CharField(max_length=20)
110 tel_cellulaire = models.CharField(max_length=20)
111 no_rue = models.CharField(max_length=128)
112 ville = models.CharField(max_length=128)
113 etat_province = models.CharField(max_length=128)
114 code_postal_cedex = models.CharField(max_length=64)
115 pays_iso2 = models.CharField(max_length=2)
116 sexe = models.CharField(max_length=1)
117 date_entree = models.CharField(max_length=10)
118 remarque = models.TextField()
119 date_maj = models.CharField(max_length=10)
120 date_naissance = models.CharField(max_length=10)
121 stamp = models.IntegerField()
122 ip = models.CharField(max_length=15)
123 usager = models.IntegerField()
124 action = models.CharField(max_length=1)
125 requete = models.TextField()
126 class Meta:
127 db_table = u'histo_fiches'
128 managed = False
129
130 class HistoDossiers(models.Model):
131 id_histo = models.IntegerField(primary_key=True)
132 dossier = models.ForeignKey(Dossiers, db_column='no_dossier',
133 related_name='historique',
134 to_field='no_dossier')
135 no_employe = models.IntegerField()
136 id_implantation_1 = models.SmallIntegerField()
137 poste_1 = models.SmallIntegerField()
138 complement_1 = models.CharField(max_length=128)
139 id_implantation_2 = models.SmallIntegerField()
140 poste_2 = models.SmallIntegerField()
141 complement_2 = models.CharField(max_length=128)
142 ids_direction_service = models.CharField(max_length=128)
143 remplacement_de = models.IntegerField()
144 responsable = models.IntegerField()
145 id_local_expatrie = models.IntegerField()
146 date_debut_mandat = models.CharField(max_length=10)
147 date_fin_mandat = models.CharField(max_length=10)
148 id_statut = models.IntegerField()
149 id_bstg = models.IntegerField()
150 id_classement = models.IntegerField()
151 id_type_contrat = models.IntegerField()
152 regime_travail = models.SmallIntegerField()
153 date_debut_contrat = models.CharField(max_length=10)
154 date_fin_contrat = models.CharField(max_length=10)
155 remarque = models.TextField()
156 stamp = models.IntegerField()
157 ip = models.CharField(max_length=15)
158 usager = models.IntegerField()
159 action = models.CharField(max_length=1)
160 requete = models.TextField()
161 responsable_implantation_1 = models.IntegerField()
162 responsable_implantation_2 = models.IntegerField()
163 class Meta:
164 db_table = u'histo_dossiers'
165 managed = False
166
167 class FamilleEmploi(models.Model):
168 id_famille_emploi = models.SmallIntegerField(primary_key=True)
169 famille_emploi = models.CharField(max_length=64)
170 actif = models.IntegerField()
171 class Meta:
172 db_table = u'famille_emploi'
173 managed = False
174
175 class DirectionService(models.Model):
176 id_direction_service = models.SmallIntegerField(primary_key=True)
177 direction_service = models.CharField(max_length=256)
178 actif = models.IntegerField()
179 class Meta:
180 db_table = u'direction_service'
181 managed = False
182
183 class Postes(models.Model):
184 id_poste = models.SmallIntegerField(primary_key=True)
185 id_famille_emploi = models.SmallIntegerField()
186 titre_poste_m = models.CharField(max_length=128)
187 titre_poste_f = models.CharField(max_length=128)
188 datemaj = models.CharField(max_length=10)
189 actif = models.CharField(max_length=1)
190 poste_responsable = models.CharField(max_length=1)
191 description = models.CharField(max_length=128)
192 class Meta:
193 db_table = u'postes'
194 managed = False
195
196 class ImplantationPostes(models.Model):
197 id_implantation_postes = models.IntegerField(primary_key=True)
198 id_implantation = models.SmallIntegerField()
199 proportion = models.FloatField()
200 date_maj = models.CharField(max_length=10)
201 actif = models.TextField() # This field type is a guess.
202 type_poste = models.ForeignKey(Postes, db_column='id_poste')
203 class Meta:
204 db_table = u'implantation_postes'
205 managed = False
206
207 class OrganismesBstg(models.Model):
208 id_bstg = models.IntegerField(primary_key=True)
209 organisme_nom = models.CharField(max_length=128)
210 actif = models.IntegerField()
211 bstg_type = models.CharField(max_length=3)
212 class Meta:
213 db_table = u'organismes_bstg'
214 managed = False
215
216 class TauxChangeAnnuel(models.Model):
217 id_taux_change_annuel = models.IntegerField(primary_key=True)
218 code_devise = models.CharField(max_length=3)
219 nom_devise = models.CharField(max_length=32)
220 id_implantation = models.SmallIntegerField()
221 taux_annuel = models.DecimalField(max_digits=100, decimal_places=50)
222 annee = models.CharField(max_length=4)
223 class Meta:
224 db_table = u'taux_change_annuel'
225 managed = False
226
227 class ValeurPoint(models.Model):
228 id_valeur_point = models.IntegerField(primary_key=True)
229 id_implantation = models.SmallIntegerField()
230 valeur_point = models.DecimalField(max_digits=100, decimal_places=50)
231 date_actif = models.CharField(max_length=10)
232 class Meta:
233 db_table = u'valeur_point'
234 managed = False
235
236 class TypeContrat(models.Model):
237 id_type_contrat = models.IntegerField(primary_key=True)
238 nom_contrat = models.CharField(max_length=127)
239 categorie = models.CharField(max_length=1)
240 description_contrat = models.CharField(max_length=127)
241 actif_contrat = models.IntegerField()
242 class Meta:
243 db_table = u'type_contrat'
244 managed = False
245
246 class TypeRevalorisation(models.Model):
247 id_type_revalorisation = models.IntegerField(primary_key=True)
248 type_revalorisation = models.CharField(max_length=127)
249 actif = models.IntegerField()
250 class Meta:
251 db_table = u'type_revalorisation'
252 managed = False
253
254 class Statut(models.Model):
255 id_statut = models.IntegerField(primary_key=True)
256 statut_contractuel = models.CharField(max_length=127)
257 type_contrat = models.CharField(max_length=1)
258 description_statut_contractuel = models.CharField(max_length=127)
259 actif = models.IntegerField()
260 class Meta:
261 db_table = u'statut'
262 managed = False
263
264 class TypeRemuneration(models.Model):
265 id_type_remuneration = models.IntegerField(primary_key=True)
266 type_remuneration = models.CharField(max_length=127)
267 type_paiement = models.CharField(max_length=127)
268 nature_remuneration = models.CharField(max_length=127)
269 actif = models.IntegerField()
270 class Meta:
271 db_table = u'type_remuneration'
272 managed = False
273
274 class AyantDroit(models.Model):
275 id_ayant_droit = models.IntegerField(primary_key=True)
276 no_employe = models.IntegerField()
277 nom_ayant_droit = models.CharField(max_length=128)
278 prenom_ayant_droit = models.CharField(max_length=128)
279 commentaire_ayant_droit = models.CharField(max_length=512)
280 lien_parente = models.CharField(max_length=10)
281 actif = models.IntegerField()
282 class Meta:
283 db_table = u'ayant_droit'
284 managed = False
285