Commit | Line | Data |
---|---|---|
46709b63 NI |
1 | # This is an auto-generated Django model module. |
2 | # You'll have to do the following manually to clean this up: | |
3 | # * Rearrange models' order | |
4 | # * Make sure each model has one field with primary_key=True | |
5 | # * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table | |
6 | # Feel free to rename the models, but don't rename db_table values or field names. | |
7 | # | |
8 | # Also note: You'll have to insert the output of 'django-admin sqlcustom [app_label]' | |
9 | # into your database. | |
10 | from __future__ import unicode_literals | |
11 | ||
12 | from django.db import models | |
13 | ||
14 | ||
15 | class AccountAuthOpenid(models.Model): | |
16 | uid = models.ForeignKey('Accounts', db_column='uid', blank=True, null=True) | |
17 | url = models.CharField(max_length=256) | |
18 | ||
19 | class Meta: | |
20 | managed = False | |
21 | db_table = 'account_auth_openid' | |
22 | ||
23 | ||
24 | class AccountLostPasswords(models.Model): | |
25 | certificat = models.CharField(primary_key=True, max_length=32) | |
26 | uid = models.ForeignKey('Accounts', db_column='uid', blank=True, null=True) | |
27 | created = models.DateTimeField(blank=True, null=True) | |
28 | ||
29 | class Meta: | |
30 | managed = False | |
31 | db_table = 'account_lost_passwords' | |
32 | ||
33 | ||
34 | class AccountProfiles(models.Model): | |
35 | uid = models.ForeignKey('Accounts', db_column='uid') | |
36 | pid = models.ForeignKey('Profiles', db_column='pid') | |
37 | perms = models.CharField(max_length=5) | |
38 | ||
39 | class Meta: | |
40 | managed = False | |
41 | db_table = 'account_profiles' | |
42 | ||
43 | ||
44 | class AccountTypes(models.Model): | |
45 | type = models.CharField(primary_key=True, max_length=16) | |
46 | perms = models.CharField(max_length=124) | |
47 | description = models.TextField(blank=True, null=True) | |
48 | ||
49 | class Meta: | |
50 | managed = False | |
51 | db_table = 'account_types' | |
52 | ||
53 | ||
54 | class AccountXnetLostPasswords(models.Model): | |
55 | uid = models.ForeignKey('Accounts', db_column='uid', primary_key=True) | |
56 | date = models.DateTimeField(blank=True, null=True) | |
57 | hash = models.CharField(max_length=32) | |
58 | ||
59 | class Meta: | |
60 | managed = False | |
61 | db_table = 'account_xnet_lost_passwords' | |
62 | ||
63 | ||
64 | class Accounts(models.Model): | |
65 | uid = models.AutoField(primary_key=True) | |
66 | hruid = models.CharField(unique=True, max_length=255) | |
67 | type = models.ForeignKey(AccountTypes, db_column='type', blank=True, null=True) | |
68 | user_perms = models.CharField(max_length=96, blank=True, null=True) | |
69 | is_admin = models.IntegerField(blank=True, null=True) | |
70 | state = models.CharField(max_length=8) | |
71 | password = models.CharField(max_length=40, blank=True, null=True) | |
72 | token = models.CharField(max_length=32, blank=True, null=True) | |
73 | weak_password = models.CharField(max_length=256, blank=True, null=True) | |
74 | registration_date = models.DateTimeField() | |
75 | flags = models.CharField(max_length=5) | |
76 | comment = models.CharField(max_length=255, blank=True, null=True) | |
77 | email = models.CharField(max_length=255, blank=True, null=True) | |
78 | firstname = models.CharField(max_length=255, blank=True, null=True) | |
79 | lastname = models.CharField(max_length=255, blank=True, null=True) | |
80 | full_name = models.CharField(max_length=255, blank=True, null=True) | |
81 | directory_name = models.CharField(max_length=255, blank=True, null=True) | |
82 | sort_name = models.CharField(max_length=255, blank=True, null=True) | |
83 | display_name = models.CharField(max_length=255, blank=True, null=True) | |
84 | sex = models.CharField(max_length=6) | |
85 | email_format = models.CharField(max_length=4) | |
86 | skin = models.ForeignKey('Skins', db_column='skin', blank=True, null=True) | |
87 | last_version = models.CharField(max_length=16) | |
88 | best_domain = models.ForeignKey('EmailVirtualDomains', db_column='best_domain', blank=True, null=True) | |
89 | from_email = models.CharField(max_length=255) | |
90 | from_format = models.CharField(max_length=4) | |
91 | ||
92 | class Meta: | |
93 | managed = False | |
94 | db_table = 'accounts' | |
95 | ||
96 | ||
97 | class AnnouncePhotos(models.Model): | |
98 | eid = models.ForeignKey('Announces', db_column='eid', primary_key=True) | |
99 | attachmime = models.CharField(max_length=4) | |
100 | attach = models.TextField() | |
101 | x = models.SmallIntegerField() | |
102 | y = models.SmallIntegerField() | |
103 | ||
104 | class Meta: | |
105 | managed = False | |
106 | db_table = 'announce_photos' | |
107 | ||
108 | ||
109 | class AnnounceRead(models.Model): | |
110 | evt = models.ForeignKey('Announces') | |
111 | uid = models.ForeignKey(Accounts, db_column='uid') | |
112 | ||
113 | class Meta: | |
114 | managed = False | |
115 | db_table = 'announce_read' | |
116 | ||
117 | ||
118 | class Announces(models.Model): | |
119 | id = models.SmallIntegerField(primary_key=True) | |
120 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
121 | creation_date = models.DateTimeField() | |
122 | titre = models.CharField(max_length=255) | |
123 | texte = models.TextField() | |
124 | expiration = models.DateField() | |
125 | promo_min = models.SmallIntegerField() | |
126 | promo_max = models.SmallIntegerField() | |
127 | flags = models.CharField(max_length=29) | |
128 | noinvite = models.IntegerField() | |
129 | post_id = models.SmallIntegerField(blank=True, null=True) | |
130 | ||
131 | class Meta: | |
132 | managed = False | |
133 | db_table = 'announces' | |
134 | ||
135 | ||
136 | class Axletter(models.Model): | |
137 | short_name = models.CharField(unique=True, max_length=16, blank=True, null=True) | |
138 | subject = models.CharField(max_length=255) | |
139 | title = models.CharField(max_length=255) | |
140 | body = models.TextField() | |
141 | signature = models.TextField() | |
142 | promo_min = models.SmallIntegerField() | |
143 | promo_max = models.SmallIntegerField() | |
144 | subset = models.TextField(blank=True, null=True) | |
145 | subset_rm = models.IntegerField(blank=True, null=True) | |
146 | echeance = models.DateTimeField() | |
147 | date = models.DateField() | |
148 | bits = models.CharField(max_length=16) | |
149 | ||
150 | class Meta: | |
151 | managed = False | |
152 | db_table = 'axletter' | |
153 | ||
154 | ||
155 | class Carvas(models.Model): | |
156 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
157 | url = models.CharField(max_length=255) | |
158 | ||
159 | class Meta: | |
160 | managed = False | |
161 | db_table = 'carvas' | |
162 | ||
163 | ||
164 | class Contacts(models.Model): | |
165 | uid = models.ForeignKey(Accounts, db_column='uid') | |
166 | contact = models.ForeignKey('Profiles', db_column='contact') | |
167 | ||
168 | class Meta: | |
169 | managed = False | |
170 | db_table = 'contacts' | |
171 | ||
172 | ||
173 | class Downtimes(models.Model): | |
174 | id = models.SmallIntegerField(primary_key=True) | |
175 | debut = models.DateTimeField() | |
176 | duree = models.TimeField() | |
177 | resume = models.CharField(max_length=255) | |
178 | description = models.TextField() | |
179 | services = models.CharField(max_length=18) | |
180 | ||
181 | class Meta: | |
182 | managed = False | |
183 | db_table = 'downtimes' | |
184 | ||
185 | ||
186 | class EmailListModerate(models.Model): | |
187 | ml = models.CharField(max_length=64) | |
188 | domain = models.CharField(max_length=64) | |
189 | mid = models.IntegerField() | |
190 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
191 | action = models.CharField(max_length=6) | |
192 | ts = models.DateTimeField() | |
193 | message = models.TextField(blank=True, null=True) | |
194 | handler = models.IntegerField(blank=True, null=True) | |
195 | ||
196 | class Meta: | |
197 | managed = False | |
198 | db_table = 'email_list_moderate' | |
199 | ||
200 | ||
201 | class EmailRedirectAccount(models.Model): | |
202 | uid = models.ForeignKey(Accounts, db_column='uid') | |
203 | redirect = models.CharField(max_length=255) | |
204 | rewrite = models.CharField(max_length=255) | |
205 | type = models.CharField(max_length=10) | |
206 | action = models.CharField(max_length=18) | |
207 | broken_date = models.DateField() | |
208 | broken_level = models.IntegerField() | |
209 | last = models.DateField() | |
210 | flags = models.CharField(max_length=8) | |
211 | hash = models.CharField(max_length=32, blank=True, null=True) | |
212 | allow_rewrite = models.IntegerField(blank=True, null=True) | |
213 | ||
214 | class Meta: | |
215 | managed = False | |
216 | db_table = 'email_redirect_account' | |
217 | ||
218 | ||
219 | class EmailRedirectOther(models.Model): | |
220 | hrmid = models.ForeignKey('EmailSourceOther', db_column='hrmid') | |
221 | redirect = models.CharField(max_length=255) | |
222 | type = models.CharField(max_length=10) | |
223 | action = models.CharField(max_length=18) | |
224 | ||
225 | class Meta: | |
226 | managed = False | |
227 | db_table = 'email_redirect_other' | |
228 | ||
229 | ||
230 | class EmailSendSave(models.Model): | |
231 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
232 | data = models.TextField() | |
233 | ||
234 | class Meta: | |
235 | managed = False | |
236 | db_table = 'email_send_save' | |
237 | ||
238 | ||
239 | class EmailSourceAccount(models.Model): | |
240 | email = models.CharField(max_length=255) | |
241 | domain = models.ForeignKey('EmailVirtualDomains', db_column='domain') | |
242 | uid = models.ForeignKey(Accounts, db_column='uid') | |
243 | type = models.CharField(max_length=9) | |
244 | flags = models.CharField(max_length=23) | |
245 | expire = models.DateField(blank=True, null=True) | |
246 | ||
247 | class Meta: | |
248 | managed = False | |
249 | db_table = 'email_source_account' | |
250 | ||
251 | ||
252 | class EmailSourceOther(models.Model): | |
253 | email = models.CharField(max_length=255) | |
254 | domain = models.ForeignKey('EmailVirtualDomains', db_column='domain') | |
255 | hrmid = models.CharField(max_length=255) | |
256 | type = models.CharField(max_length=8, blank=True, null=True) | |
257 | expire = models.DateField(blank=True, null=True) | |
258 | ||
259 | class Meta: | |
260 | managed = False | |
261 | db_table = 'email_source_other' | |
262 | ||
263 | ||
264 | class EmailVirtual(models.Model): | |
265 | email = models.CharField(max_length=255) | |
266 | domain = models.ForeignKey('EmailVirtualDomains', db_column='domain') | |
267 | redirect = models.CharField(max_length=255) | |
268 | type = models.CharField(max_length=7, blank=True, null=True) | |
269 | expire = models.DateField() | |
270 | ||
271 | class Meta: | |
272 | managed = False | |
273 | db_table = 'email_virtual' | |
274 | ||
275 | ||
276 | class EmailVirtualDomains(models.Model): | |
277 | id = models.SmallIntegerField(primary_key=True) | |
278 | name = models.CharField(max_length=255) | |
279 | aliasing = models.ForeignKey('self', db_column='aliasing') | |
280 | ||
281 | class Meta: | |
282 | managed = False | |
283 | db_table = 'email_virtual_domains' | |
284 | ||
285 | ||
286 | class EmailWatch(models.Model): | |
287 | email = models.CharField(primary_key=True, max_length=60) | |
288 | state = models.CharField(max_length=9) | |
289 | detection = models.DateField(blank=True, null=True) | |
290 | last = models.DateTimeField() | |
291 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
292 | description = models.TextField() | |
293 | ||
294 | class Meta: | |
295 | managed = False | |
296 | db_table = 'email_watch' | |
297 | ||
298 | ||
299 | class ForumInnd(models.Model): | |
300 | id_innd = models.AutoField(primary_key=True) | |
301 | ipmin = models.IntegerField(blank=True, null=True) | |
302 | ipmax = models.IntegerField(blank=True, null=True) | |
303 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
304 | read_perm = models.CharField(max_length=100, blank=True, null=True) | |
305 | write_perm = models.CharField(max_length=100, blank=True, null=True) | |
306 | priority = models.IntegerField(blank=True, null=True) | |
307 | comment = models.TextField(blank=True, null=True) | |
308 | ||
309 | class Meta: | |
310 | managed = False | |
311 | db_table = 'forum_innd' | |
312 | ||
313 | ||
314 | class ForumProfiles(models.Model): | |
315 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
316 | name = models.CharField(max_length=64) | |
317 | mail = models.CharField(max_length=70) | |
318 | sig = models.TextField() | |
319 | flags = models.CharField(max_length=21) | |
320 | tree_unread = models.CharField(max_length=8) | |
321 | tree_read = models.CharField(max_length=8) | |
322 | last_seen = models.DateTimeField() | |
323 | ||
324 | class Meta: | |
325 | managed = False | |
326 | db_table = 'forum_profiles' | |
327 | ||
328 | ||
329 | class ForumSubs(models.Model): | |
330 | fid = models.ForeignKey('Forums', db_column='fid') | |
331 | uid = models.ForeignKey(Accounts, db_column='uid') | |
332 | ||
333 | class Meta: | |
334 | managed = False | |
335 | db_table = 'forum_subs' | |
336 | ||
337 | ||
338 | class Forums(models.Model): | |
339 | fid = models.AutoField(primary_key=True) | |
340 | name = models.CharField(max_length=64) | |
341 | ||
342 | class Meta: | |
343 | managed = False | |
344 | db_table = 'forums' | |
345 | ||
346 | ||
347 | class FusionaxActivites(models.Model): | |
348 | ac = models.CharField(db_column='AC', max_length=2) # Field name made lowercase. | |
349 | ax_id = models.CharField(max_length=8) | |
350 | code_etab = models.BigIntegerField(db_column='Code_etab') # Field name made lowercase. | |
351 | raison_sociale = models.CharField(db_column='Raison_sociale', max_length=255) # Field name made lowercase. | |
352 | libelle_fonctio = models.CharField(db_column='Libelle_fonctio', max_length=255) # Field name made lowercase. | |
353 | annuaire = models.IntegerField(db_column='Annuaire') # Field name made lowercase. | |
354 | date_maj = models.DateField(db_column='Date_maj') # Field name made lowercase. | |
355 | pid = models.IntegerField(blank=True, null=True) | |
356 | jobid = models.IntegerField(blank=True, null=True) | |
357 | description = models.CharField(max_length=255, blank=True, null=True) | |
358 | ||
359 | class Meta: | |
360 | managed = False | |
361 | db_table = 'fusionax_activites' | |
362 | ||
363 | ||
364 | class FusionaxAdresses(models.Model): | |
365 | provenance = models.CharField(max_length=2) | |
366 | ax_id = models.CharField(max_length=8) | |
367 | type_adr = models.CharField(db_column='Type_adr', max_length=1) # Field name made lowercase. | |
368 | ligne1 = models.CharField(db_column='Ligne1', max_length=90) # Field name made lowercase. | |
369 | ligne2 = models.CharField(db_column='Ligne2', max_length=90) # Field name made lowercase. | |
370 | ligne3 = models.CharField(db_column='Ligne3', max_length=90) # Field name made lowercase. | |
371 | code_postal = models.CharField(max_length=20) | |
372 | ville = models.CharField(max_length=80) | |
373 | zip_cedex = models.CharField(max_length=20) | |
374 | etat_distr = models.CharField(max_length=20) | |
375 | pays = models.CharField(max_length=50) | |
376 | tel = models.CharField(max_length=30) | |
377 | fax = models.CharField(max_length=30) | |
378 | date_maj = models.DateField(db_column='Date_maj') # Field name made lowercase. | |
379 | code_etab = models.BigIntegerField(db_column='Code_etab', blank=True, null=True) # Field name made lowercase. | |
380 | pid = models.IntegerField(blank=True, null=True) | |
381 | jobid = models.IntegerField(blank=True, null=True) | |
382 | text = models.TextField(blank=True, null=True) | |
383 | ||
384 | class Meta: | |
385 | managed = False | |
386 | db_table = 'fusionax_adresses' | |
387 | ||
388 | ||
389 | class FusionaxAnciens(models.Model): | |
390 | an = models.CharField(db_column='AN', max_length=2) # Field name made lowercase. | |
391 | ax_id = models.CharField(primary_key=True, max_length=8) | |
392 | promotion_etude = models.SmallIntegerField() | |
393 | groupe_promo = models.CharField(max_length=1) | |
394 | nom_patronymique = models.CharField(db_column='Nom_patronymique', max_length=255) # Field name made lowercase. | |
395 | partic_patro = models.CharField(max_length=5) | |
396 | prenom = models.CharField(max_length=30) | |
397 | nom_usuel = models.CharField(db_column='Nom_usuel', max_length=255) # Field name made lowercase. | |
398 | partic_nom = models.CharField(max_length=5) | |
399 | nom_complet = models.CharField(db_column='Nom_complet', max_length=255) # Field name made lowercase. | |
400 | civilite = models.CharField(db_column='Civilite', max_length=4) # Field name made lowercase. | |
401 | code_nationalite = models.CharField(db_column='Code_nationalite', max_length=4) # Field name made lowercase. | |
402 | corps_sortie = models.CharField(max_length=50) | |
403 | date_deces = models.DateField(db_column='Date_deces', blank=True, null=True) # Field name made lowercase. | |
404 | grade = models.CharField(max_length=50) | |
405 | mel_usage = models.CharField(db_column='Mel_usage', max_length=255) # Field name made lowercase. | |
406 | mel_publiable = models.IntegerField(db_column='Mel_publiable') # Field name made lowercase. | |
407 | mob_publiable = models.IntegerField(db_column='Mob_publiable') # Field name made lowercase. | |
408 | tel_mobile = models.CharField(max_length=30) | |
409 | date_maj = models.DateField(db_column='Date_maj') # Field name made lowercase. | |
410 | pid = models.IntegerField(blank=True, null=True) | |
411 | ||
412 | class Meta: | |
413 | managed = False | |
414 | db_table = 'fusionax_anciens' | |
415 | ||
416 | ||
417 | class FusionaxEntreprises(models.Model): | |
418 | en = models.CharField(db_column='EN', max_length=2) # Field name made lowercase. | |
419 | code_etab = models.BigIntegerField(db_column='Code_etab', primary_key=True) # Field name made lowercase. | |
420 | raison_sociale = models.CharField(db_column='Raison_sociale', max_length=255) # Field name made lowercase. | |
421 | sigle = models.CharField(db_column='Sigle', max_length=50) # Field name made lowercase. | |
422 | ||
423 | class Meta: | |
424 | managed = False | |
425 | db_table = 'fusionax_entreprises' | |
426 | ||
427 | ||
428 | class FusionaxFormations(models.Model): | |
429 | date_maj = models.DateField(db_column='Date_maj') # Field name made lowercase. | |
430 | fo = models.CharField(db_column='FO', max_length=2) # Field name made lowercase. | |
431 | ax_id = models.CharField(max_length=8) | |
432 | intitule_formation = models.CharField(db_column='Intitule_formation', max_length=255) # Field name made lowercase. | |
433 | intitule_diplome = models.CharField(db_column='Intitule_diplome', max_length=255) # Field name made lowercase. | |
434 | descr_formation = models.CharField(db_column='Descr_formation', max_length=255) # Field name made lowercase. | |
435 | pid = models.IntegerField(blank=True, null=True) | |
436 | eduid = models.IntegerField(blank=True, null=True) | |
437 | degreeid = models.IntegerField(blank=True, null=True) | |
438 | fieldid = models.IntegerField(blank=True, null=True) | |
439 | ||
440 | class Meta: | |
441 | managed = False | |
442 | db_table = 'fusionax_formations' | |
443 | ||
444 | ||
445 | class FusionaxFormationsMd(models.Model): | |
446 | fo = models.CharField(db_column='FO', max_length=2) # Field name made lowercase. | |
447 | ax_id = models.CharField(primary_key=True, max_length=8) | |
448 | field = models.CharField(max_length=255, blank=True, null=True) | |
449 | pid = models.IntegerField(blank=True, null=True) | |
450 | fieldid = models.IntegerField(blank=True, null=True) | |
451 | ||
452 | class Meta: | |
453 | managed = False | |
454 | db_table = 'fusionax_formations_md' | |
455 | ||
456 | ||
457 | class FusionaxImport(models.Model): | |
458 | ax_id = models.CharField(primary_key=True, max_length=8) | |
459 | pid = models.IntegerField(blank=True, null=True) | |
460 | date_match_id = models.DateTimeField(blank=True, null=True) | |
461 | ||
462 | class Meta: | |
463 | managed = False | |
464 | db_table = 'fusionax_import' | |
465 | ||
466 | ||
467 | class GappsAccounts(models.Model): | |
468 | l_userid = models.ForeignKey(Accounts, db_column='l_userid', blank=True, null=True) | |
469 | l_sync_password = models.IntegerField(blank=True, null=True) | |
470 | l_activate_mail_redirection = models.IntegerField(blank=True, null=True) | |
471 | g_account_id = models.CharField(max_length=16, blank=True, null=True) | |
472 | g_account_name = models.CharField(primary_key=True, max_length=256) | |
473 | g_domain = models.CharField(max_length=40, blank=True, null=True) | |
474 | g_first_name = models.CharField(max_length=40) | |
475 | g_last_name = models.CharField(max_length=40) | |
476 | g_status = models.CharField(max_length=13, blank=True, null=True) | |
477 | g_admin = models.IntegerField(blank=True, null=True) | |
478 | g_suspension = models.CharField(max_length=256, blank=True, null=True) | |
479 | r_disk_usage = models.BigIntegerField(blank=True, null=True) | |
480 | r_creation = models.DateField(blank=True, null=True) | |
481 | r_last_login = models.DateField(blank=True, null=True) | |
482 | r_last_webmail = models.DateField(blank=True, null=True) | |
483 | ||
484 | class Meta: | |
485 | managed = False | |
486 | db_table = 'gapps_accounts' | |
487 | ||
488 | ||
489 | class GappsNicknames(models.Model): | |
490 | l_userid = models.ForeignKey(Accounts, db_column='l_userid', blank=True, null=True) | |
491 | g_account_name = models.CharField(max_length=256) | |
492 | g_nickname = models.CharField(primary_key=True, max_length=256) | |
493 | ||
494 | class Meta: | |
495 | managed = False | |
496 | db_table = 'gapps_nicknames' | |
497 | ||
498 | ||
499 | class GappsQueue(models.Model): | |
500 | q_id = models.AutoField(primary_key=True) | |
501 | q_owner = models.ForeignKey(Accounts, blank=True, null=True) | |
502 | q_recipient = models.ForeignKey(Accounts, blank=True, null=True) | |
503 | p_entry_date = models.DateTimeField() | |
504 | p_notbefore_date = models.DateTimeField() | |
505 | p_start_date = models.DateTimeField(blank=True, null=True) | |
506 | p_end_date = models.DateTimeField(blank=True, null=True) | |
507 | p_status = models.CharField(max_length=8) | |
508 | p_priority = models.CharField(max_length=9) | |
509 | p_admin_request = models.IntegerField() | |
510 | j_type = models.CharField(max_length=10) | |
511 | j_parameters = models.TextField(blank=True, null=True) | |
512 | r_softfail_date = models.DateTimeField(blank=True, null=True) | |
513 | r_softfail_count = models.SmallIntegerField() | |
514 | r_result = models.CharField(max_length=256, blank=True, null=True) | |
515 | ||
516 | class Meta: | |
517 | managed = False | |
518 | db_table = 'gapps_queue' | |
519 | ||
520 | ||
521 | class GappsReporting(models.Model): | |
522 | date = models.DateField(primary_key=True) | |
523 | num_accounts = models.IntegerField(blank=True, null=True) | |
524 | count_1_day_actives = models.IntegerField(blank=True, null=True) | |
525 | count_7_day_actives = models.IntegerField(blank=True, null=True) | |
526 | count_14_day_actives = models.IntegerField(blank=True, null=True) | |
527 | count_30_day_actives = models.IntegerField(blank=True, null=True) | |
528 | count_30_day_idle = models.IntegerField(blank=True, null=True) | |
529 | count_60_day_idle = models.IntegerField(blank=True, null=True) | |
530 | count_90_day_idle = models.IntegerField(blank=True, null=True) | |
531 | usage_in_bytes = models.BigIntegerField(blank=True, null=True) | |
532 | quota_in_mb = models.IntegerField(blank=True, null=True) | |
533 | ||
534 | class Meta: | |
535 | managed = False | |
536 | db_table = 'gapps_reporting' | |
537 | ||
538 | ||
539 | class GeolocCountries(models.Model): | |
540 | iso_3166_1_a2 = models.CharField(primary_key=True, max_length=2) | |
541 | iso_3166_1_a3 = models.CharField(unique=True, max_length=3) | |
542 | iso_3166_1_num = models.SmallIntegerField(unique=True) | |
543 | worldregion = models.CharField(db_column='worldRegion', max_length=2, blank=True, null=True) # Field name made lowercase. | |
544 | country = models.CharField(max_length=255, blank=True, null=True) | |
545 | countryen = models.CharField(db_column='countryEn', max_length=255, blank=True, null=True) # Field name made lowercase. | |
546 | capital = models.CharField(max_length=255) | |
547 | nationality = models.CharField(max_length=255, blank=True, null=True) | |
548 | nationalityen = models.CharField(db_column='nationalityEn', max_length=255, blank=True, null=True) # Field name made lowercase. | |
549 | phoneprefix = models.SmallIntegerField(db_column='phonePrefix', blank=True, null=True) # Field name made lowercase. | |
550 | phoneformat = models.CharField(db_column='phoneFormat', max_length=255) # Field name made lowercase. | |
551 | licenseplate = models.CharField(db_column='licensePlate', max_length=4, blank=True, null=True) # Field name made lowercase. | |
552 | belongsto = models.ForeignKey('self', db_column='belongsTo', blank=True, null=True) # Field name made lowercase. | |
553 | countryplain = models.CharField(db_column='countryPlain', max_length=255, blank=True, null=True) # Field name made lowercase. | |
554 | ||
555 | class Meta: | |
556 | managed = False | |
557 | db_table = 'geoloc_countries' | |
558 | ||
559 | ||
560 | class GeolocLanguages(models.Model): | |
561 | iso_3166_1_a2 = models.ForeignKey(GeolocCountries, db_column='iso_3166_1_a2') | |
562 | language = models.CharField(max_length=5) | |
563 | country = models.CharField(max_length=255, blank=True, null=True) | |
564 | countryplain = models.CharField(db_column='countryPlain', max_length=255, blank=True, null=True) # Field name made lowercase. | |
565 | ||
566 | class Meta: | |
567 | managed = False | |
568 | db_table = 'geoloc_languages' | |
569 | ||
570 | ||
571 | class GroupAnnounces(models.Model): | |
572 | id = models.SmallIntegerField(primary_key=True) | |
573 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
574 | asso = models.ForeignKey('Groups') | |
575 | create_date = models.DateTimeField() | |
576 | titre = models.CharField(max_length=255) | |
577 | texte = models.TextField() | |
578 | contacts = models.TextField() | |
579 | expiration = models.DateField() | |
580 | promo_min = models.SmallIntegerField() | |
581 | promo_max = models.SmallIntegerField() | |
582 | flags = models.CharField(max_length=12) | |
583 | post_id = models.SmallIntegerField(blank=True, null=True) | |
584 | ||
585 | class Meta: | |
586 | managed = False | |
587 | db_table = 'group_announces' | |
588 | ||
589 | ||
590 | class GroupAnnouncesPhoto(models.Model): | |
591 | eid = models.ForeignKey(GroupAnnounces, db_column='eid', primary_key=True) | |
592 | attachmime = models.CharField(max_length=4) | |
593 | attach = models.TextField() | |
594 | x = models.SmallIntegerField() | |
595 | y = models.SmallIntegerField() | |
596 | ||
597 | class Meta: | |
598 | managed = False | |
599 | db_table = 'group_announces_photo' | |
600 | ||
601 | ||
602 | class GroupAnnouncesRead(models.Model): | |
603 | announce = models.ForeignKey(GroupAnnounces) | |
604 | uid = models.ForeignKey(Accounts, db_column='uid') | |
605 | ||
606 | class Meta: | |
607 | managed = False | |
608 | db_table = 'group_announces_read' | |
609 | ||
610 | ||
611 | class GroupAuth(models.Model): | |
612 | id = models.SmallIntegerField(primary_key=True) | |
613 | privkey = models.CharField(unique=True, max_length=40) | |
614 | name = models.CharField(max_length=32) | |
615 | datafields = models.CharField(max_length=255) | |
616 | returnurls = models.CharField(max_length=255) | |
617 | last_used = models.DateField(blank=True, null=True) | |
618 | group_id = models.SmallIntegerField(blank=True, null=True) | |
619 | flags = models.CharField(max_length=21, blank=True, null=True) | |
620 | ||
621 | class Meta: | |
622 | managed = False | |
623 | db_table = 'group_auth' | |
624 | ||
625 | ||
626 | class GroupDom(models.Model): | |
627 | id = models.SmallIntegerField(primary_key=True) | |
628 | nom = models.TextField() | |
629 | cat = models.CharField(max_length=39) | |
630 | ||
631 | class Meta: | |
632 | managed = False | |
633 | db_table = 'group_dom' | |
634 | ||
635 | ||
636 | class GroupEventItems(models.Model): | |
637 | eid = models.ForeignKey('GroupEvents', db_column='eid') | |
638 | item_id = models.IntegerField() | |
639 | titre = models.CharField(max_length=100) | |
640 | details = models.TextField() | |
641 | montant = models.DecimalField(max_digits=10, decimal_places=2) | |
642 | ||
643 | class Meta: | |
644 | managed = False | |
645 | db_table = 'group_event_items' | |
646 | ||
647 | ||
648 | class GroupEventParticipants(models.Model): | |
649 | eid = models.ForeignKey(GroupEventItems, db_column='eid') | |
650 | uid = models.ForeignKey(Accounts, db_column='uid') | |
651 | item = models.ForeignKey(GroupEventItems) | |
652 | nb = models.IntegerField() | |
653 | flags = models.CharField(max_length=14) | |
654 | paid = models.FloatField() | |
655 | ||
656 | class Meta: | |
657 | managed = False | |
658 | db_table = 'group_event_participants' | |
659 | ||
660 | ||
661 | class GroupEvents(models.Model): | |
662 | eid = models.AutoField(primary_key=True) | |
663 | asso = models.ForeignKey('Groups', blank=True, null=True) | |
664 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
665 | intitule = models.CharField(max_length=100) | |
666 | short_name = models.CharField(max_length=30) | |
667 | paiement = models.ForeignKey('Payments', blank=True, null=True) | |
668 | descriptif = models.TextField() | |
669 | debut = models.DateTimeField() | |
670 | fin = models.DateTimeField(blank=True, null=True) | |
671 | show_participants = models.IntegerField() | |
672 | deadline_inscription = models.DateField(blank=True, null=True) | |
673 | noinvite = models.IntegerField() | |
674 | accept_nonmembre = models.IntegerField() | |
675 | archive = models.IntegerField() | |
676 | subscription_notification = models.CharField(max_length=8) | |
677 | ||
678 | class Meta: | |
679 | managed = False | |
680 | db_table = 'group_events' | |
681 | ||
682 | ||
683 | class GroupFormerMembers(models.Model): | |
684 | asso = models.ForeignKey('Groups') | |
685 | uid = models.ForeignKey(Accounts, db_column='uid') | |
686 | remember = models.IntegerField() | |
687 | unsubsciption_date = models.DateField() | |
688 | ||
689 | class Meta: | |
690 | managed = False | |
691 | db_table = 'group_former_members' | |
692 | ||
693 | ||
694 | class GroupMemberSubRequests(models.Model): | |
695 | asso = models.ForeignKey('Groups') | |
696 | uid = models.ForeignKey(Accounts, db_column='uid') | |
697 | ts = models.DateTimeField() | |
698 | reason = models.TextField(blank=True, null=True) | |
699 | ||
700 | class Meta: | |
701 | managed = False | |
702 | db_table = 'group_member_sub_requests' | |
703 | ||
704 | ||
705 | class GroupMembers(models.Model): | |
706 | asso = models.ForeignKey('Groups') | |
707 | uid = models.ForeignKey(Accounts, db_column='uid') | |
708 | perms = models.CharField(max_length=6) | |
709 | comm = models.CharField(max_length=255, blank=True, null=True) | |
710 | position = models.CharField(max_length=18, blank=True, null=True) | |
711 | flags = models.CharField(max_length=6) | |
712 | ||
713 | class Meta: | |
714 | managed = False | |
715 | db_table = 'group_members' | |
716 | ||
717 | ||
718 | class Groups(models.Model): | |
719 | id = models.SmallIntegerField(primary_key=True) | |
720 | nom = models.CharField(max_length=255) | |
721 | diminutif = models.CharField(unique=True, max_length=64) | |
722 | cat = models.CharField(max_length=39) | |
723 | dom = models.ForeignKey(GroupDom, db_column='dom', blank=True, null=True) | |
724 | descr = models.TextField() | |
725 | logo = models.TextField(blank=True, null=True) | |
726 | logo_mime = models.TextField(blank=True, null=True) | |
727 | site = models.CharField(max_length=255) | |
728 | mail = models.CharField(max_length=255) | |
729 | resp = models.CharField(max_length=255) | |
730 | forum = models.CharField(max_length=255) | |
731 | mail_domain = models.CharField(max_length=255) | |
732 | ax = models.IntegerField() | |
733 | pub = models.CharField(max_length=7) | |
734 | sub_url = models.CharField(max_length=255) | |
735 | inscriptible = models.IntegerField() | |
736 | unsub_url = models.CharField(max_length=255) | |
737 | flags = models.CharField(max_length=39) | |
738 | axdate = models.DateField(db_column='axDate', blank=True, null=True) # Field name made lowercase. | |
739 | welcome_msg = models.TextField(blank=True, null=True) | |
740 | event_order = models.CharField(max_length=8) | |
741 | disable_mails = models.IntegerField() | |
742 | status = models.CharField(max_length=20) | |
743 | ||
744 | class Meta: | |
745 | managed = False | |
746 | db_table = 'groups' | |
747 | ||
748 | ||
749 | class HomonymsList(models.Model): | |
750 | hrmid = models.CharField(max_length=255) | |
751 | uid = models.ForeignKey(Accounts, db_column='uid') | |
752 | ||
753 | class Meta: | |
754 | managed = False | |
755 | db_table = 'homonyms_list' | |
756 | ||
757 | ||
758 | class IpWatch(models.Model): | |
759 | state = models.CharField(max_length=9) | |
760 | detection = models.DateField(blank=True, null=True) | |
761 | last = models.DateTimeField() | |
762 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
763 | description = models.TextField() | |
764 | ip = models.IntegerField(primary_key=True) | |
765 | mask = models.IntegerField() | |
766 | ||
767 | class Meta: | |
768 | managed = False | |
769 | db_table = 'ip_watch' | |
770 | ||
771 | ||
772 | class LogActions(models.Model): | |
773 | text = models.CharField(max_length=32) | |
774 | description = models.CharField(max_length=255) | |
775 | ||
776 | class Meta: | |
777 | managed = False | |
778 | db_table = 'log_actions' | |
779 | ||
780 | ||
781 | class LogEvents(models.Model): | |
782 | stamp = models.DateTimeField() | |
783 | session = models.ForeignKey('LogSessions', db_column='session') | |
784 | action = models.ForeignKey(LogActions, db_column='action') | |
785 | data = models.TextField(blank=True, null=True) | |
786 | ||
787 | class Meta: | |
788 | managed = False | |
789 | db_table = 'log_events' | |
790 | ||
791 | ||
792 | class LogLastSessions(models.Model): | |
793 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
794 | id = models.ForeignKey('LogSessions', db_column='id') | |
795 | ||
796 | class Meta: | |
797 | managed = False | |
798 | db_table = 'log_last_sessions' | |
799 | ||
800 | ||
801 | class LogSessions(models.Model): | |
802 | auth = models.CharField(max_length=6) | |
803 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
804 | start = models.DateTimeField() | |
805 | host = models.CharField(max_length=128) | |
806 | sauth = models.CharField(max_length=6) | |
807 | suid = models.ForeignKey(Accounts, db_column='suid', blank=True, null=True) | |
808 | browser = models.CharField(max_length=255) | |
809 | forward_host = models.CharField(max_length=128, blank=True, null=True) | |
810 | flags = models.CharField(max_length=5) | |
811 | ip = models.IntegerField() | |
812 | forward_ip = models.IntegerField(blank=True, null=True) | |
813 | ||
814 | class Meta: | |
815 | managed = False | |
816 | db_table = 'log_sessions' | |
817 | ||
818 | ||
819 | class MxWatch(models.Model): | |
820 | host = models.CharField(primary_key=True, max_length=64) | |
821 | state = models.CharField(max_length=7, blank=True, null=True) | |
822 | text = models.TextField() | |
823 | ||
824 | class Meta: | |
825 | managed = False | |
826 | db_table = 'mx_watch' | |
827 | ||
828 | ||
829 | class NewsletterArt(models.Model): | |
830 | id = models.ForeignKey('NewsletterIssues', db_column='id') | |
831 | aid = models.SmallIntegerField() | |
832 | cid = models.ForeignKey('NewsletterCat', db_column='cid', blank=True, null=True) | |
833 | pos = models.IntegerField() | |
834 | title = models.TextField() | |
835 | body = models.TextField() | |
836 | append = models.TextField() | |
837 | ||
838 | class Meta: | |
839 | managed = False | |
840 | db_table = 'newsletter_art' | |
841 | ||
842 | ||
843 | class NewsletterCat(models.Model): | |
844 | cid = models.AutoField(primary_key=True) | |
845 | nlid = models.ForeignKey('Newsletters', db_column='nlid') | |
846 | pos = models.IntegerField() | |
847 | title = models.CharField(max_length=128) | |
848 | ||
849 | class Meta: | |
850 | managed = False | |
851 | db_table = 'newsletter_cat' | |
852 | ||
853 | ||
854 | class NewsletterIns(models.Model): | |
855 | uid = models.ForeignKey(Accounts, db_column='uid') | |
856 | nlid = models.ForeignKey('Newsletters', db_column='nlid') | |
857 | last = models.ForeignKey('NewsletterIssues', db_column='last', blank=True, null=True) | |
858 | hash = models.CharField(max_length=32, blank=True, null=True) | |
859 | ||
860 | class Meta: | |
861 | managed = False | |
862 | db_table = 'newsletter_ins' | |
863 | ||
864 | ||
865 | class NewsletterIssues(models.Model): | |
866 | nlid = models.ForeignKey('Newsletters', db_column='nlid') | |
867 | date = models.DateField() | |
868 | send_before = models.DateTimeField(blank=True, null=True) | |
869 | state = models.CharField(max_length=7) | |
870 | sufb_json = models.TextField(blank=True, null=True) | |
871 | title = models.CharField(max_length=255) | |
872 | head = models.TextField() | |
873 | signature = models.TextField() | |
874 | short_name = models.CharField(max_length=16, blank=True, null=True) | |
875 | mail_title = models.CharField(max_length=255) | |
876 | unsubscribe = models.IntegerField() | |
877 | reply_to = models.CharField(max_length=255) | |
878 | ||
879 | class Meta: | |
880 | managed = False | |
881 | db_table = 'newsletter_issues' | |
882 | ||
883 | ||
884 | class Newsletters(models.Model): | |
885 | group = models.ForeignKey(Groups, unique=True) | |
886 | name = models.CharField(max_length=255) | |
887 | criteria = models.CharField(max_length=14, blank=True, null=True) | |
888 | ||
889 | class Meta: | |
890 | managed = False | |
891 | db_table = 'newsletters' | |
892 | ||
893 | ||
894 | class PaymentBankaccounts(models.Model): | |
895 | asso_id = models.IntegerField() | |
896 | iban = models.CharField(max_length=33) | |
897 | bic = models.CharField(max_length=11) | |
898 | owner = models.CharField(max_length=100) | |
899 | status = models.CharField(max_length=12) | |
900 | ||
901 | class Meta: | |
902 | managed = False | |
903 | db_table = 'payment_bankaccounts' | |
904 | ||
905 | ||
906 | class PaymentCodec(models.Model): | |
907 | id = models.SmallIntegerField(primary_key=True) | |
908 | text = models.CharField(max_length=64) | |
909 | ||
910 | class Meta: | |
911 | managed = False | |
912 | db_table = 'payment_codeC' | |
913 | ||
914 | ||
915 | class PaymentCodercb(models.Model): | |
916 | id = models.SmallIntegerField(primary_key=True) | |
917 | text = models.CharField(max_length=64) | |
918 | codec = models.IntegerField(db_column='codeC') # Field name made lowercase. | |
919 | ||
920 | class Meta: | |
921 | managed = False | |
922 | db_table = 'payment_codeRCB' | |
923 | ||
924 | ||
925 | class PaymentMethods(models.Model): | |
926 | id = models.IntegerField() | |
927 | text = models.CharField(max_length=32) | |
928 | include = models.CharField(max_length=32) | |
929 | short_name = models.CharField(max_length=10) | |
930 | flags = models.CharField(max_length=12, blank=True, null=True) | |
931 | ||
932 | class Meta: | |
933 | managed = False | |
934 | db_table = 'payment_methods' | |
935 | ||
936 | ||
937 | class PaymentReconcilations(models.Model): | |
938 | method_id = models.IntegerField() | |
939 | period_start = models.DateField() | |
940 | period_end = models.DateField() | |
941 | status = models.CharField(max_length=11) | |
942 | payment_count = models.IntegerField() | |
943 | sum_amounts = models.DecimalField(max_digits=9, decimal_places=2) | |
944 | sum_commissions = models.DecimalField(max_digits=9, decimal_places=2) | |
945 | comments = models.TextField() | |
946 | recongroup_id = models.IntegerField(blank=True, null=True) | |
947 | ||
948 | class Meta: | |
949 | managed = False | |
950 | db_table = 'payment_reconcilations' | |
951 | ||
952 | ||
953 | class PaymentTransactions(models.Model): | |
954 | id = models.CharField(primary_key=True, max_length=64) | |
955 | method_id = models.IntegerField(blank=True, null=True) | |
956 | uid = models.IntegerField() | |
957 | ref = models.IntegerField() | |
958 | fullref = models.CharField(max_length=15) | |
959 | ts_confirmed = models.DateTimeField(blank=True, null=True) | |
960 | ts_initiated = models.DateTimeField(blank=True, null=True) | |
961 | amount = models.DecimalField(max_digits=9, decimal_places=2) | |
962 | commission = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True) | |
963 | pkey = models.CharField(max_length=5) | |
964 | comment = models.CharField(max_length=255) | |
965 | status = models.CharField(max_length=9) | |
966 | recon_id = models.IntegerField(blank=True, null=True) | |
967 | display = models.IntegerField() | |
968 | ||
969 | class Meta: | |
970 | managed = False | |
971 | db_table = 'payment_transactions' | |
972 | ||
973 | ||
974 | class PaymentTransfers(models.Model): | |
975 | recongroup_id = models.IntegerField() | |
976 | payment_id = models.IntegerField() | |
977 | amount = models.DecimalField(max_digits=9, decimal_places=2) | |
978 | account_id = models.IntegerField(blank=True, null=True) | |
979 | message = models.CharField(max_length=255) | |
980 | date = models.DateField(blank=True, null=True) | |
981 | ||
982 | class Meta: | |
983 | managed = False | |
984 | db_table = 'payment_transfers' | |
985 | ||
986 | ||
987 | class Payments(models.Model): | |
988 | text = models.CharField(max_length=255) | |
989 | url = models.CharField(max_length=128) | |
990 | flags = models.CharField(max_length=17) | |
991 | amount_def = models.DecimalField(max_digits=10, decimal_places=2) | |
992 | amount_min = models.DecimalField(max_digits=10, decimal_places=2) | |
993 | amount_max = models.DecimalField(max_digits=10, decimal_places=2) | |
994 | mail = models.CharField(max_length=64) | |
995 | confirmation = models.TextField() | |
996 | asso = models.ForeignKey(Groups, blank=True, null=True) | |
997 | rib = models.ForeignKey(PaymentBankaccounts) | |
998 | ||
999 | class Meta: | |
1000 | managed = False | |
1001 | db_table = 'payments' | |
1002 | ||
1003 | ||
1004 | class PostfixBlacklist(models.Model): | |
1005 | email = models.CharField(primary_key=True, max_length=150) | |
1006 | reject_text = models.CharField(max_length=64) | |
1007 | ||
1008 | class Meta: | |
1009 | managed = False | |
1010 | db_table = 'postfix_blacklist' | |
1011 | ||
1012 | ||
1013 | class PostfixMailseen(models.Model): | |
1014 | crc = models.CharField(primary_key=True, max_length=8) | |
1015 | nb = models.SmallIntegerField() | |
1016 | update_time = models.DateTimeField() | |
1017 | create_time = models.DateTimeField() | |
1018 | release = models.CharField(max_length=6) | |
1019 | ||
1020 | class Meta: | |
1021 | managed = False | |
1022 | db_table = 'postfix_mailseen' | |
1023 | ||
1024 | ||
1025 | class PostfixWhitelist(models.Model): | |
1026 | email = models.CharField(primary_key=True, max_length=150) | |
1027 | ||
1028 | class Meta: | |
1029 | managed = False | |
1030 | db_table = 'postfix_whitelist' | |
1031 | ||
1032 | ||
1033 | class ProfileAddresses(models.Model): | |
1034 | pid = models.IntegerField() | |
1035 | jobid = models.IntegerField() | |
1036 | groupid = models.SmallIntegerField() | |
1037 | type = models.CharField(max_length=5) | |
1038 | id = models.IntegerField() | |
1039 | flags = models.CharField(max_length=65, blank=True, null=True) | |
1040 | text = models.TextField() | |
1041 | postaltext = models.TextField(db_column='postalText') # Field name made lowercase. | |
1042 | formatted_address = models.TextField() | |
1043 | types = models.CharField(max_length=297) | |
1044 | latitude = models.FloatField(blank=True, null=True) | |
1045 | longitude = models.FloatField(blank=True, null=True) | |
1046 | southwest_latitude = models.FloatField(blank=True, null=True) | |
1047 | southwest_longitude = models.FloatField(blank=True, null=True) | |
1048 | northeast_latitude = models.FloatField(blank=True, null=True) | |
1049 | northeast_longitude = models.FloatField(blank=True, null=True) | |
1050 | location_type = models.CharField(max_length=18, blank=True, null=True) | |
1051 | partial_match = models.IntegerField() | |
1052 | pub = models.CharField(max_length=7) | |
1053 | comment = models.CharField(max_length=255, blank=True, null=True) | |
1054 | geocoding_date = models.DateField(blank=True, null=True) | |
1055 | geocoding_calls = models.IntegerField() | |
1056 | postal_code_fr = models.CharField(max_length=5, blank=True, null=True) | |
1057 | ||
1058 | class Meta: | |
1059 | managed = False | |
1060 | db_table = 'profile_addresses' | |
1061 | ||
1062 | ||
1063 | class ProfileAddressesComponents(models.Model): | |
1064 | pid = models.ForeignKey(ProfileAddresses, db_column='pid') | |
1065 | jobid = models.ForeignKey(ProfileAddresses, db_column='jobid') | |
1066 | groupid = models.ForeignKey(ProfileAddresses, db_column='groupid') | |
1067 | type = models.ForeignKey(ProfileAddresses, db_column='type') | |
1068 | id = models.ForeignKey(ProfileAddresses, db_column='id') | |
1069 | component = models.ForeignKey('ProfileAddressesComponentsEnum') | |
1070 | ||
1071 | class Meta: | |
1072 | managed = False | |
1073 | db_table = 'profile_addresses_components' | |
1074 | ||
1075 | ||
1076 | class ProfileAddressesComponentsEnum(models.Model): | |
1077 | id = models.BigIntegerField(primary_key=True) | |
1078 | short_name = models.CharField(max_length=255) | |
1079 | long_name = models.CharField(max_length=255) | |
1080 | types = models.CharField(max_length=297) | |
1081 | ||
1082 | class Meta: | |
1083 | managed = False | |
1084 | db_table = 'profile_addresses_components_enum' | |
1085 | ||
1086 | ||
1087 | class ProfileBinetEnum(models.Model): | |
1088 | text = models.CharField(max_length=50) | |
1089 | url = models.CharField(max_length=255) | |
1090 | ||
1091 | class Meta: | |
1092 | managed = False | |
1093 | db_table = 'profile_binet_enum' | |
1094 | ||
1095 | ||
1096 | class ProfileBinets(models.Model): | |
1097 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1098 | binet = models.ForeignKey(ProfileBinetEnum) | |
1099 | ||
1100 | class Meta: | |
1101 | managed = False | |
1102 | db_table = 'profile_binets' | |
1103 | ||
1104 | ||
1105 | class ProfileCorps(models.Model): | |
1106 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1107 | original_corpsid = models.ForeignKey('ProfileCorpsEnum', db_column='original_corpsid') | |
1108 | current_corpsid = models.ForeignKey('ProfileCorpsEnum', db_column='current_corpsid') | |
1109 | rankid = models.ForeignKey('ProfileCorpsRankEnum', db_column='rankid') | |
1110 | corps_pub = models.CharField(max_length=7) | |
1111 | ||
1112 | class Meta: | |
1113 | managed = False | |
1114 | db_table = 'profile_corps' | |
1115 | ||
1116 | ||
1117 | class ProfileCorpsEnum(models.Model): | |
1118 | name = models.CharField(unique=True, max_length=255) | |
1119 | abbreviation = models.CharField(unique=True, max_length=5) | |
1120 | still_exists = models.IntegerField() | |
1121 | ||
1122 | class Meta: | |
1123 | managed = False | |
1124 | db_table = 'profile_corps_enum' | |
1125 | ||
1126 | ||
1127 | class ProfileCorpsRankEnum(models.Model): | |
1128 | name = models.CharField(unique=True, max_length=255) | |
1129 | abbreviation = models.CharField(unique=True, max_length=5) | |
1130 | ||
1131 | class Meta: | |
1132 | managed = False | |
1133 | db_table = 'profile_corps_rank_enum' | |
1134 | ||
1135 | ||
1136 | class ProfileDeltaten(models.Model): | |
1137 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1138 | message = models.TextField() | |
1139 | ||
1140 | class Meta: | |
1141 | managed = False | |
1142 | db_table = 'profile_deltaten' | |
1143 | ||
1144 | ||
1145 | class ProfileDisplay(models.Model): | |
1146 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1147 | yourself = models.CharField(max_length=255) | |
1148 | public_name = models.CharField(max_length=255) | |
1149 | private_name = models.CharField(max_length=255) | |
1150 | directory_name = models.CharField(max_length=255) | |
1151 | short_name = models.CharField(max_length=255) | |
1152 | sort_name = models.CharField(max_length=255) | |
1153 | promo = models.CharField(max_length=255) | |
1154 | ||
1155 | class Meta: | |
1156 | managed = False | |
1157 | db_table = 'profile_display' | |
1158 | ||
1159 | ||
1160 | class ProfileEducation(models.Model): | |
1161 | id = models.IntegerField() | |
1162 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1163 | eduid = models.ForeignKey('ProfileEducationEnum', db_column='eduid', blank=True, null=True) | |
1164 | degreeid = models.ForeignKey('ProfileEducationDegreeEnum', db_column='degreeid', blank=True, null=True) | |
1165 | fieldid = models.ForeignKey('ProfileEducationFieldEnum', db_column='fieldid', blank=True, null=True) | |
1166 | entry_year = models.IntegerField(blank=True, null=True) | |
1167 | grad_year = models.IntegerField(blank=True, null=True) | |
1168 | promo_year = models.IntegerField(blank=True, null=True) | |
1169 | program = models.CharField(max_length=255, blank=True, null=True) | |
1170 | flags = models.CharField(max_length=27) | |
1171 | ||
1172 | class Meta: | |
1173 | managed = False | |
1174 | db_table = 'profile_education' | |
1175 | ||
1176 | ||
1177 | class ProfileEducationDegree(models.Model): | |
1178 | eduid = models.ForeignKey('ProfileEducationEnum', db_column='eduid') | |
1179 | degreeid = models.ForeignKey('ProfileEducationDegreeEnum', db_column='degreeid') | |
1180 | ||
1181 | class Meta: | |
1182 | managed = False | |
1183 | db_table = 'profile_education_degree' | |
1184 | ||
1185 | ||
1186 | class ProfileEducationDegreeEnum(models.Model): | |
1187 | degree = models.CharField(unique=True, max_length=255, blank=True, null=True) | |
1188 | abbreviation = models.CharField(max_length=255) | |
1189 | level = models.IntegerField() | |
1190 | ||
1191 | class Meta: | |
1192 | managed = False | |
1193 | db_table = 'profile_education_degree_enum' | |
1194 | ||
1195 | ||
1196 | class ProfileEducationEnum(models.Model): | |
1197 | name = models.CharField(unique=True, max_length=255, blank=True, null=True) | |
1198 | abbreviation = models.CharField(max_length=255) | |
1199 | url = models.CharField(max_length=255, blank=True, null=True) | |
1200 | country = models.ForeignKey(GeolocCountries, db_column='country', blank=True, null=True) | |
1201 | ||
1202 | class Meta: | |
1203 | managed = False | |
1204 | db_table = 'profile_education_enum' | |
1205 | ||
1206 | ||
1207 | class ProfileEducationFieldEnum(models.Model): | |
1208 | field = models.CharField(unique=True, max_length=255, blank=True, null=True) | |
1209 | ||
1210 | class Meta: | |
1211 | managed = False | |
1212 | db_table = 'profile_education_field_enum' | |
1213 | ||
1214 | ||
1215 | class ProfileHobby(models.Model): | |
1216 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1217 | id = models.IntegerField() | |
1218 | type = models.CharField(max_length=6) | |
1219 | text = models.CharField(max_length=255) | |
1220 | pub = models.CharField(max_length=7) | |
1221 | ||
1222 | class Meta: | |
1223 | managed = False | |
1224 | db_table = 'profile_hobby' | |
1225 | ||
1226 | ||
1227 | class ProfileJob(models.Model): | |
1228 | id = models.IntegerField() | |
1229 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1230 | jobid = models.ForeignKey('ProfileJobEnum', db_column='jobid', blank=True, null=True) | |
1231 | description = models.CharField(max_length=255) | |
1232 | url = models.CharField(max_length=255) | |
1233 | email = models.CharField(max_length=255) | |
1234 | pub = models.CharField(max_length=7) | |
1235 | email_pub = models.CharField(max_length=7) | |
1236 | entry_year = models.CharField(max_length=4, blank=True, null=True) | |
1237 | ||
1238 | class Meta: | |
1239 | managed = False | |
1240 | db_table = 'profile_job' | |
1241 | ||
1242 | ||
1243 | class ProfileJobEntrepriseTerm(models.Model): | |
1244 | eid = models.ForeignKey('ProfileJobEnum', db_column='eid') | |
1245 | jtid = models.ForeignKey('ProfileJobTermEnum', db_column='jtid') | |
1246 | ||
1247 | class Meta: | |
1248 | managed = False | |
1249 | db_table = 'profile_job_entreprise_term' | |
1250 | ||
1251 | ||
1252 | class ProfileJobEnum(models.Model): | |
1253 | name = models.CharField(unique=True, max_length=255) | |
1254 | acronym = models.CharField(max_length=255, blank=True, null=True) | |
1255 | url = models.CharField(max_length=255, blank=True, null=True) | |
1256 | email = models.CharField(max_length=255, blank=True, null=True) | |
1257 | holdingid = models.ForeignKey('self', db_column='holdingid', blank=True, null=True) | |
1258 | siren_code = models.CharField(db_column='SIREN_code', max_length=9, blank=True, null=True) # Field name made lowercase. | |
1259 | naf_code = models.CharField(db_column='NAF_code', max_length=5, blank=True, null=True) # Field name made lowercase. | |
1260 | ax_code = models.BigIntegerField(db_column='AX_code', blank=True, null=True) # Field name made lowercase. | |
1261 | ||
1262 | class Meta: | |
1263 | managed = False | |
1264 | db_table = 'profile_job_enum' | |
1265 | ||
1266 | ||
1267 | class ProfileJobTerm(models.Model): | |
1268 | pid = models.ForeignKey(ProfileJob, db_column='pid') | |
1269 | jid = models.ForeignKey(ProfileJob, db_column='jid') | |
1270 | jtid = models.ForeignKey('ProfileJobTermEnum', db_column='jtid') | |
1271 | computed = models.CharField(max_length=8) | |
1272 | ||
1273 | class Meta: | |
1274 | managed = False | |
1275 | db_table = 'profile_job_term' | |
1276 | ||
1277 | ||
1278 | class ProfileJobTermEnum(models.Model): | |
1279 | jtid = models.AutoField(primary_key=True) | |
1280 | name = models.CharField(max_length=255) | |
1281 | full_name = models.CharField(max_length=255) | |
1282 | ||
1283 | class Meta: | |
1284 | managed = False | |
1285 | db_table = 'profile_job_term_enum' | |
1286 | ||
1287 | ||
1288 | class ProfileJobTermRelation(models.Model): | |
1289 | jtid_1 = models.ForeignKey(ProfileJobTermEnum, db_column='jtid_1') | |
1290 | jtid_2 = models.ForeignKey(ProfileJobTermEnum, db_column='jtid_2') | |
1291 | rel = models.CharField(max_length=8) | |
1292 | computed = models.CharField(max_length=8) | |
1293 | ||
1294 | class Meta: | |
1295 | managed = False | |
1296 | db_table = 'profile_job_term_relation' | |
1297 | ||
1298 | ||
1299 | class ProfileJobTermSearch(models.Model): | |
1300 | search = models.CharField(max_length=50) | |
1301 | jtid = models.ForeignKey(ProfileJobTermEnum, db_column='jtid') | |
1302 | ||
1303 | class Meta: | |
1304 | managed = False | |
1305 | db_table = 'profile_job_term_search' | |
1306 | ||
1307 | ||
1308 | class ProfileLangskillEnum(models.Model): | |
1309 | iso_639_2b = models.CharField(primary_key=True, max_length=3) | |
1310 | language = models.CharField(max_length=255) | |
1311 | language_en = models.CharField(max_length=255) | |
1312 | iso_639_2t = models.CharField(max_length=3) | |
1313 | iso_639_1 = models.CharField(max_length=2, blank=True, null=True) | |
1314 | ||
1315 | class Meta: | |
1316 | managed = False | |
1317 | db_table = 'profile_langskill_enum' | |
1318 | ||
1319 | ||
1320 | class ProfileLangskills(models.Model): | |
1321 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1322 | lid = models.ForeignKey(ProfileLangskillEnum, db_column='lid') | |
1323 | level = models.SmallIntegerField(blank=True, null=True) | |
1324 | ||
1325 | class Meta: | |
1326 | managed = False | |
1327 | db_table = 'profile_langskills' | |
1328 | ||
1329 | ||
1330 | class ProfileManageurs(models.Model): | |
1331 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1332 | title = models.CharField(max_length=255) | |
1333 | entry_year = models.IntegerField(blank=True, null=True) | |
1334 | project = models.TextField(blank=True, null=True) | |
1335 | anonymity = models.IntegerField() | |
1336 | visibility = models.CharField(max_length=18) | |
1337 | email = models.CharField(max_length=255) | |
1338 | communication = models.CharField(max_length=17) | |
1339 | push = models.CharField(max_length=6) | |
1340 | network = models.IntegerField() | |
1341 | ||
1342 | class Meta: | |
1343 | managed = False | |
1344 | db_table = 'profile_manageurs' | |
1345 | ||
1346 | ||
1347 | class ProfileMedalEnum(models.Model): | |
1348 | type = models.CharField(max_length=10) | |
1349 | text = models.CharField(max_length=255, blank=True, null=True) | |
1350 | img = models.CharField(max_length=255, blank=True, null=True) | |
1351 | flags = models.CharField(max_length=21) | |
1352 | ||
1353 | class Meta: | |
1354 | managed = False | |
1355 | db_table = 'profile_medal_enum' | |
1356 | ||
1357 | ||
1358 | class ProfileMedalGradeEnum(models.Model): | |
1359 | mid = models.ForeignKey(ProfileMedalEnum, db_column='mid') | |
1360 | gid = models.IntegerField() | |
1361 | text = models.CharField(max_length=255, blank=True, null=True) | |
1362 | pos = models.IntegerField() | |
1363 | ||
1364 | class Meta: | |
1365 | managed = False | |
1366 | db_table = 'profile_medal_grade_enum' | |
1367 | ||
1368 | ||
1369 | class ProfileMedals(models.Model): | |
1370 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1371 | mid = models.IntegerField() | |
1372 | gid = models.IntegerField() | |
1373 | level = models.CharField(max_length=6) | |
1374 | ||
1375 | class Meta: | |
1376 | managed = False | |
1377 | db_table = 'profile_medals' | |
1378 | ||
1379 | ||
1380 | class ProfileMentor(models.Model): | |
1381 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1382 | expertise = models.TextField() | |
1383 | ||
1384 | class Meta: | |
1385 | managed = False | |
1386 | db_table = 'profile_mentor' | |
1387 | ||
1388 | ||
1389 | class ProfileMentorCountry(models.Model): | |
1390 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1391 | country = models.ForeignKey(GeolocCountries, db_column='country') | |
1392 | ||
1393 | class Meta: | |
1394 | managed = False | |
1395 | db_table = 'profile_mentor_country' | |
1396 | ||
1397 | ||
1398 | class ProfileMentorTerm(models.Model): | |
1399 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1400 | jtid = models.ForeignKey(ProfileJobTermEnum, db_column='jtid') | |
1401 | ||
1402 | class Meta: | |
1403 | managed = False | |
1404 | db_table = 'profile_mentor_term' | |
1405 | ||
1406 | ||
1407 | class ProfileMergeIssues(models.Model): | |
1408 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1409 | issues = models.CharField(max_length=48, blank=True, null=True) | |
1410 | entry_year_ax = models.IntegerField(blank=True, null=True) | |
1411 | deathdate_ax = models.DateField(blank=True, null=True) | |
1412 | name = models.CharField(max_length=255, blank=True, null=True) | |
1413 | name_type = models.IntegerField(blank=True, null=True) | |
1414 | ||
1415 | class Meta: | |
1416 | managed = False | |
1417 | db_table = 'profile_merge_issues' | |
1418 | ||
1419 | ||
1420 | class ProfileModifications(models.Model): | |
1421 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1422 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1423 | field = models.CharField(max_length=60) | |
1424 | oldtext = models.TextField(db_column='oldText') # Field name made lowercase. | |
1425 | newtext = models.TextField(db_column='newText') # Field name made lowercase. | |
1426 | type = models.CharField(max_length=11) | |
1427 | timestamp = models.DateTimeField() | |
1428 | ||
1429 | class Meta: | |
1430 | managed = False | |
1431 | db_table = 'profile_modifications' | |
1432 | ||
1433 | ||
1434 | class ProfileNetworking(models.Model): | |
1435 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1436 | id = models.IntegerField() | |
1437 | nwid = models.ForeignKey('ProfileNetworkingEnum', db_column='nwid') | |
1438 | address = models.CharField(max_length=255) | |
1439 | pub = models.CharField(max_length=7) | |
1440 | ||
1441 | class Meta: | |
1442 | managed = False | |
1443 | db_table = 'profile_networking' | |
1444 | ||
1445 | ||
1446 | class ProfileNetworkingEnum(models.Model): | |
1447 | nwid = models.IntegerField(primary_key=True) | |
1448 | name = models.CharField(max_length=30) | |
1449 | icon = models.CharField(max_length=50) | |
1450 | filter = models.CharField(max_length=6) | |
1451 | network_type = models.CharField(max_length=6) | |
1452 | link = models.CharField(max_length=255) | |
1453 | ||
1454 | class Meta: | |
1455 | managed = False | |
1456 | db_table = 'profile_networking_enum' | |
1457 | ||
1458 | ||
1459 | class ProfilePartnersharingEnum(models.Model): | |
1460 | id = models.IntegerField(primary_key=True) | |
1461 | api_uid = models.ForeignKey(Accounts, db_column='api_uid', blank=True, null=True) | |
1462 | shortname = models.CharField(max_length=64) | |
1463 | name = models.CharField(max_length=255) | |
1464 | url = models.CharField(max_length=255) | |
1465 | default_sharing_level = models.CharField(max_length=7, blank=True, null=True) | |
1466 | has_directory = models.IntegerField() | |
1467 | has_bulkmail = models.IntegerField() | |
1468 | ||
1469 | class Meta: | |
1470 | managed = False | |
1471 | db_table = 'profile_partnersharing_enum' | |
1472 | ||
1473 | ||
1474 | class ProfilePartnersharingSettings(models.Model): | |
1475 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1476 | partner = models.ForeignKey(ProfilePartnersharingEnum) | |
1477 | exposed_uid = models.CharField(max_length=255) | |
1478 | sharing_level = models.CharField(max_length=7, blank=True, null=True) | |
1479 | allow_email = models.CharField(max_length=6, blank=True, null=True) | |
1480 | last_connection = models.DateTimeField(blank=True, null=True) | |
1481 | ||
1482 | class Meta: | |
1483 | managed = False | |
1484 | db_table = 'profile_partnersharing_settings' | |
1485 | ||
1486 | ||
1487 | class ProfilePhones(models.Model): | |
1488 | pid = models.IntegerField() | |
1489 | link_type = models.CharField(max_length=7) | |
1490 | link_id = models.IntegerField() | |
1491 | tel_id = models.IntegerField() | |
1492 | tel_type = models.CharField(max_length=6) | |
1493 | search_tel = models.CharField(max_length=25) | |
1494 | display_tel = models.CharField(max_length=30) | |
1495 | pub = models.CharField(max_length=7) | |
1496 | comment = models.CharField(max_length=80) | |
1497 | ||
1498 | class Meta: | |
1499 | managed = False | |
1500 | db_table = 'profile_phones' | |
1501 | ||
1502 | ||
1503 | class ProfilePhotoTokens(models.Model): | |
1504 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1505 | token = models.CharField(max_length=255) | |
1506 | expires = models.DateTimeField() | |
1507 | ||
1508 | class Meta: | |
1509 | managed = False | |
1510 | db_table = 'profile_photo_tokens' | |
1511 | ||
1512 | ||
1513 | class ProfilePhotos(models.Model): | |
1514 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1515 | attachmime = models.CharField(max_length=4) | |
1516 | attach = models.TextField() | |
1517 | x = models.SmallIntegerField() | |
1518 | y = models.SmallIntegerField() | |
1519 | pub = models.CharField(max_length=7) | |
1520 | last_update = models.DateTimeField() | |
1521 | ||
1522 | class Meta: | |
1523 | managed = False | |
1524 | db_table = 'profile_photos' | |
1525 | ||
1526 | ||
1527 | class ProfilePrivateNames(models.Model): | |
1528 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1529 | type = models.CharField(max_length=9) | |
1530 | id = models.IntegerField() | |
1531 | name = models.CharField(max_length=255) | |
1532 | ||
1533 | class Meta: | |
1534 | managed = False | |
1535 | db_table = 'profile_private_names' | |
1536 | ||
1537 | ||
1538 | class ProfilePublicNames(models.Model): | |
1539 | pid = models.ForeignKey('Profiles', db_column='pid', primary_key=True) | |
1540 | lastname_initial = models.CharField(max_length=255) | |
1541 | lastname_main = models.CharField(max_length=255) | |
1542 | lastname_marital = models.CharField(max_length=255) | |
1543 | lastname_ordinary = models.CharField(max_length=255) | |
1544 | firstname_initial = models.CharField(max_length=255) | |
1545 | firstname_main = models.CharField(max_length=255) | |
1546 | firstname_ordinary = models.CharField(max_length=255) | |
1547 | pseudonym = models.CharField(max_length=255) | |
1548 | ||
1549 | class Meta: | |
1550 | managed = False | |
1551 | db_table = 'profile_public_names' | |
1552 | ||
1553 | ||
1554 | class ProfileSectionEnum(models.Model): | |
1555 | id = models.IntegerField(primary_key=True) | |
1556 | text = models.CharField(unique=True, max_length=50) | |
1557 | ||
1558 | class Meta: | |
1559 | managed = False | |
1560 | db_table = 'profile_section_enum' | |
1561 | ||
1562 | ||
1563 | class ProfileSkillEnum(models.Model): | |
1564 | id = models.CharField(primary_key=True, max_length=3) | |
1565 | text_fr = models.CharField(max_length=110) | |
1566 | text_en = models.CharField(max_length=110) | |
1567 | flags = models.CharField(max_length=5) | |
1568 | ||
1569 | class Meta: | |
1570 | managed = False | |
1571 | db_table = 'profile_skill_enum' | |
1572 | ||
1573 | ||
1574 | class ProfileSkills(models.Model): | |
1575 | pid = models.ForeignKey('Profiles', db_column='pid') | |
1576 | cid = models.ForeignKey(ProfileSkillEnum, db_column='cid') | |
1577 | level = models.CharField(max_length=18) | |
1578 | ||
1579 | class Meta: | |
1580 | managed = False | |
1581 | db_table = 'profile_skills' | |
1582 | ||
1583 | ||
1584 | class ProfileVisibilityEnum(models.Model): | |
1585 | access_level = models.CharField(max_length=7, blank=True, null=True) | |
1586 | best_display_level = models.CharField(max_length=7, blank=True, null=True) | |
1587 | display_levels = models.CharField(max_length=24, blank=True, null=True) | |
1588 | ||
1589 | class Meta: | |
1590 | managed = False | |
1591 | db_table = 'profile_visibility_enum' | |
1592 | ||
1593 | ||
1594 | class Profiles(models.Model): | |
1595 | pid = models.AutoField(primary_key=True) | |
1596 | hrpid = models.CharField(unique=True, max_length=255) | |
1597 | xorg_id = models.IntegerField() | |
1598 | ax_id = models.CharField(max_length=8, blank=True, null=True) | |
1599 | birthdate = models.DateField(blank=True, null=True) | |
1600 | birthdate_ref = models.DateField(blank=True, null=True) | |
1601 | next_birthday = models.DateField(blank=True, null=True) | |
1602 | deathdate = models.DateField(blank=True, null=True) | |
1603 | deathdate_rec = models.DateField(blank=True, null=True) | |
1604 | sex = models.CharField(max_length=6) | |
1605 | section = models.ForeignKey(ProfileSectionEnum, db_column='section', blank=True, null=True) | |
1606 | cv = models.TextField(blank=True, null=True) | |
1607 | freetext = models.TextField(blank=True, null=True) | |
1608 | freetext_pub = models.CharField(max_length=7) | |
1609 | axfreetext = models.TextField(blank=True, null=True) | |
1610 | medals_pub = models.CharField(max_length=7) | |
1611 | alias_pub = models.CharField(max_length=7) | |
1612 | nationality1 = models.ForeignKey(GeolocCountries, db_column='nationality1', blank=True, null=True) | |
1613 | nationality2 = models.ForeignKey(GeolocCountries, db_column='nationality2', blank=True, null=True) | |
1614 | nationality3 = models.ForeignKey(GeolocCountries, db_column='nationality3', blank=True, null=True) | |
1615 | email_directory = models.CharField(max_length=255, blank=True, null=True) | |
1616 | last_change = models.DateField() | |
1617 | title = models.CharField(max_length=4) | |
1618 | ||
1619 | class Meta: | |
1620 | managed = False | |
1621 | db_table = 'profiles' | |
1622 | ||
1623 | ||
1624 | class RegisterMarketing(models.Model): | |
1625 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1626 | sender = models.ForeignKey(Accounts, db_column='sender', blank=True, null=True) | |
1627 | email = models.CharField(max_length=255) | |
1628 | date = models.DateField() | |
1629 | last = models.DateField() | |
1630 | nb = models.IntegerField() | |
1631 | type = models.CharField(max_length=5, blank=True, null=True) | |
1632 | hash = models.CharField(max_length=32) | |
1633 | message = models.CharField(max_length=16) | |
1634 | message_data = models.CharField(max_length=64, blank=True, null=True) | |
1635 | personal_notes = models.TextField(blank=True, null=True) | |
1636 | ||
1637 | class Meta: | |
1638 | managed = False | |
1639 | db_table = 'register_marketing' | |
1640 | ||
1641 | ||
1642 | class RegisterMstats(models.Model): | |
1643 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
1644 | sender = models.ForeignKey(Accounts, db_column='sender', blank=True, null=True) | |
1645 | success = models.DateField() | |
1646 | ||
1647 | class Meta: | |
1648 | managed = False | |
1649 | db_table = 'register_mstats' | |
1650 | ||
1651 | ||
1652 | class RegisterPending(models.Model): | |
1653 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
1654 | forlife = models.CharField(unique=True, max_length=255) | |
1655 | bestalias = models.CharField(unique=True, max_length=255) | |
1656 | mailorg2 = models.CharField(max_length=255, blank=True, null=True) | |
1657 | password = models.CharField(max_length=40) | |
1658 | email = models.CharField(max_length=255) | |
1659 | date = models.DateField() | |
1660 | relance = models.DateField() | |
1661 | naissance = models.DateField() | |
1662 | hash = models.CharField(max_length=12) | |
1663 | services = models.CharField(max_length=38) | |
1664 | ||
1665 | class Meta: | |
1666 | managed = False | |
1667 | db_table = 'register_pending' | |
1668 | ||
1669 | ||
1670 | class RegisterPendingXnet(models.Model): | |
1671 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
1672 | hruid = models.ForeignKey(Accounts, db_column='hruid', unique=True) | |
1673 | email = models.CharField(max_length=255) | |
1674 | date = models.DateField() | |
1675 | last_date = models.DateField(blank=True, null=True) | |
1676 | hash = models.CharField(max_length=12) | |
1677 | sender_name = models.CharField(max_length=255) | |
1678 | group_name = models.CharField(max_length=255) | |
1679 | ||
1680 | class Meta: | |
1681 | managed = False | |
1682 | db_table = 'register_pending_xnet' | |
1683 | ||
1684 | ||
1685 | class RegisterSubs(models.Model): | |
1686 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1687 | type = models.CharField(max_length=5) | |
1688 | sub = models.CharField(max_length=32) | |
1689 | domain = models.CharField(max_length=64) | |
1690 | ||
1691 | class Meta: | |
1692 | managed = False | |
1693 | db_table = 'register_subs' | |
1694 | ||
1695 | ||
1696 | class Reminder(models.Model): | |
1697 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1698 | type = models.ForeignKey('ReminderType') | |
1699 | status = models.CharField(max_length=7) | |
1700 | remind_last = models.DateTimeField() | |
1701 | remind_next = models.DateTimeField(blank=True, null=True) | |
1702 | ||
1703 | class Meta: | |
1704 | managed = False | |
1705 | db_table = 'reminder' | |
1706 | ||
1707 | ||
1708 | class ReminderTips(models.Model): | |
1709 | id = models.SmallIntegerField(primary_key=True) | |
1710 | title = models.CharField(max_length=64) | |
1711 | text = models.TextField() | |
1712 | priority = models.IntegerField() | |
1713 | expiration = models.DateField() | |
1714 | promo_min = models.SmallIntegerField() | |
1715 | promo_max = models.SmallIntegerField() | |
1716 | state = models.CharField(max_length=6) | |
1717 | ||
1718 | class Meta: | |
1719 | managed = False | |
1720 | db_table = 'reminder_tips' | |
1721 | ||
1722 | ||
1723 | class ReminderType(models.Model): | |
1724 | type_id = models.AutoField(primary_key=True) | |
1725 | name = models.CharField(unique=True, max_length=255) | |
1726 | weight = models.IntegerField() | |
1727 | remind_delay_yes = models.IntegerField() | |
1728 | remind_delay_no = models.IntegerField() | |
1729 | remind_delay_dismiss = models.IntegerField() | |
1730 | ||
1731 | class Meta: | |
1732 | managed = False | |
1733 | db_table = 'reminder_type' | |
1734 | ||
1735 | ||
1736 | class Requests(models.Model): | |
1737 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1738 | type = models.CharField(max_length=16) | |
1739 | data = models.TextField() | |
1740 | stamp = models.DateTimeField() | |
1741 | pid = models.ForeignKey(Profiles, db_column='pid', blank=True, null=True) | |
1742 | ||
1743 | class Meta: | |
1744 | managed = False | |
1745 | db_table = 'requests' | |
1746 | ||
1747 | ||
1748 | class RequestsAnswers(models.Model): | |
1749 | category = models.CharField(max_length=16) | |
1750 | title = models.CharField(max_length=50) | |
1751 | answer = models.TextField() | |
1752 | ||
1753 | class Meta: | |
1754 | managed = False | |
1755 | db_table = 'requests_answers' | |
1756 | ||
1757 | ||
1758 | class RequestsHidden(models.Model): | |
1759 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
1760 | hidden_requests = models.TextField() | |
1761 | ||
1762 | class Meta: | |
1763 | managed = False | |
1764 | db_table = 'requests_hidden' | |
1765 | ||
1766 | ||
1767 | class SearchAutocomplete(models.Model): | |
1768 | name = models.CharField(max_length=20) | |
1769 | query = models.CharField(max_length=100) | |
1770 | result = models.TextField() | |
1771 | generated = models.DateTimeField() | |
1772 | ||
1773 | class Meta: | |
1774 | managed = False | |
1775 | db_table = 'search_autocomplete' | |
1776 | ||
1777 | ||
1778 | class SearchName(models.Model): | |
1779 | pid = models.ForeignKey(Profiles, db_column='pid') | |
1780 | token = models.CharField(max_length=255) | |
1781 | score = models.IntegerField() | |
1782 | soundex = models.CharField(max_length=4) | |
1783 | flags = models.CharField(max_length=6) | |
1784 | general_type = models.CharField(max_length=9) | |
1785 | ||
1786 | class Meta: | |
1787 | managed = False | |
1788 | db_table = 'search_name' | |
1789 | ||
1790 | ||
1791 | class Skins(models.Model): | |
1792 | id = models.IntegerField(primary_key=True) | |
1793 | name = models.CharField(max_length=32) | |
1794 | date = models.DateField() | |
1795 | comment = models.CharField(max_length=255) | |
1796 | auteur = models.CharField(max_length=30) | |
1797 | skin_tpl = models.CharField(max_length=32) | |
1798 | ext = models.CharField(max_length=3) | |
1799 | ||
1800 | class Meta: | |
1801 | managed = False | |
1802 | db_table = 'skins' | |
1803 | ||
1804 | ||
1805 | class SurveyAnswers(models.Model): | |
1806 | vote = models.ForeignKey('SurveyVotes') | |
1807 | question_id = models.SmallIntegerField() | |
1808 | answer = models.TextField() | |
1809 | ||
1810 | class Meta: | |
1811 | managed = False | |
1812 | db_table = 'survey_answers' | |
1813 | ||
1814 | ||
1815 | class SurveyVotes(models.Model): | |
1816 | id = models.SmallIntegerField(primary_key=True) | |
1817 | survey = models.ForeignKey('Surveys') | |
1818 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
1819 | ||
1820 | class Meta: | |
1821 | managed = False | |
1822 | db_table = 'survey_votes' | |
1823 | ||
1824 | ||
1825 | class Surveys(models.Model): | |
1826 | id = models.SmallIntegerField(primary_key=True) | |
1827 | questions = models.TextField() | |
1828 | title = models.CharField(max_length=255) | |
1829 | description = models.TextField() | |
1830 | uid = models.ForeignKey(Accounts, db_column='uid', blank=True, null=True) | |
1831 | end = models.DateField() | |
1832 | mode = models.IntegerField() | |
1833 | promos = models.CharField(max_length=255) | |
1834 | ||
1835 | class Meta: | |
1836 | managed = False | |
1837 | db_table = 'surveys' | |
1838 | ||
1839 | ||
1840 | class T(models.Model): | |
1841 | a = models.IntegerField() | |
1842 | ||
1843 | class Meta: | |
1844 | managed = False | |
1845 | db_table = 't' | |
1846 | ||
1847 | ||
1848 | class UrlShortener(models.Model): | |
1849 | alias = models.CharField(primary_key=True, max_length=255) | |
1850 | url = models.TextField() | |
1851 | ||
1852 | class Meta: | |
1853 | managed = False | |
1854 | db_table = 'url_shortener' | |
1855 | ||
1856 | ||
1857 | class Watch(models.Model): | |
1858 | uid = models.ForeignKey(Accounts, db_column='uid', primary_key=True) | |
1859 | flags = models.CharField(max_length=13) | |
1860 | actions = models.CharField(max_length=35) | |
1861 | last = models.DateTimeField() | |
1862 | ||
1863 | class Meta: | |
1864 | managed = False | |
1865 | db_table = 'watch' | |
1866 | ||
1867 | ||
1868 | class WatchGroup(models.Model): | |
1869 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1870 | groupid = models.ForeignKey(Groups, db_column='groupid') | |
1871 | ||
1872 | class Meta: | |
1873 | managed = False | |
1874 | db_table = 'watch_group' | |
1875 | ||
1876 | ||
1877 | class WatchNonins(models.Model): | |
1878 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1879 | ni = models.ForeignKey(Accounts) | |
1880 | ||
1881 | class Meta: | |
1882 | managed = False | |
1883 | db_table = 'watch_nonins' | |
1884 | ||
1885 | ||
1886 | class WatchProfile(models.Model): | |
1887 | pid = models.ForeignKey(Profiles, db_column='pid') | |
1888 | ts = models.DateTimeField() | |
1889 | field = models.CharField(max_length=12) | |
1890 | ||
1891 | class Meta: | |
1892 | managed = False | |
1893 | db_table = 'watch_profile' | |
1894 | ||
1895 | ||
1896 | class WatchPromo(models.Model): | |
1897 | uid = models.ForeignKey(Accounts, db_column='uid') | |
1898 | promo = models.IntegerField() | |
1899 | ||
1900 | class Meta: | |
1901 | managed = False | |
1902 | db_table = 'watch_promo' |