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.
8 # Also note: You'll have to insert the output of 'django-admin sqlcustom [app_label]'
10 from __future__
import unicode_literals
12 from django
.db
import models
15 class AccountAuthOpenid(models
.Model
):
16 uid
= models
.ForeignKey('Accounts', db_column
='uid', blank
=True, null
=True)
17 url
= models
.CharField(max_length
=256)
21 db_table
= 'account_auth_openid'
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)
31 db_table
= 'account_lost_passwords'
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)
41 db_table
= 'account_profiles'
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)
51 db_table
= 'account_types'
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)
61 db_table
= 'account_xnet_lost_passwords'
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)
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()
106 db_table
= 'announce_photos'
109 class AnnounceRead(models
.Model
):
110 evt
= models
.ForeignKey('Announces')
111 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
115 db_table
= 'announce_read'
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)
133 db_table
= 'announces'
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)
152 db_table
= 'axletter'
155 class Carvas(models
.Model
):
156 uid
= models
.ForeignKey(Accounts
, db_column
='uid', primary_key
=True)
157 url
= models
.CharField(max_length
=255)
164 class Contacts(models
.Model
):
165 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
166 contact
= models
.ForeignKey('Profiles', db_column
='contact')
170 db_table
= 'contacts'
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)
183 db_table
= 'downtimes'
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)
198 db_table
= 'email_list_moderate'
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)
216 db_table
= 'email_redirect_account'
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)
227 db_table
= 'email_redirect_other'
230 class EmailSendSave(models
.Model
):
231 uid
= models
.ForeignKey(Accounts
, db_column
='uid', primary_key
=True)
232 data
= models
.TextField()
236 db_table
= 'email_send_save'
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)
249 db_table
= 'email_source_account'
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)
261 db_table
= 'email_source_other'
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()
273 db_table
= 'email_virtual'
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')
283 db_table
= 'email_virtual_domains'
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()
296 db_table
= 'email_watch'
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)
311 db_table
= 'forum_innd'
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()
326 db_table
= 'forum_profiles'
329 class ForumSubs(models
.Model
):
330 fid
= models
.ForeignKey('Forums', db_column
='fid')
331 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
335 db_table
= 'forum_subs'
338 class Forums(models
.Model
):
339 fid
= models
.AutoField(primary_key
=True)
340 name
= models
.CharField(max_length
=64)
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)
361 db_table
= 'fusionax_activites'
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)
386 db_table
= 'fusionax_adresses'
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)
414 db_table
= 'fusionax_anciens'
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.
425 db_table
= 'fusionax_entreprises'
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)
442 db_table
= 'fusionax_formations'
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)
454 db_table
= 'fusionax_formations_md'
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)
464 db_table
= 'fusionax_import'
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)
486 db_table
= 'gapps_accounts'
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)
496 db_table
= 'gapps_nicknames'
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)
518 db_table
= 'gapps_queue'
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)
536 db_table
= 'gapps_reporting'
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.
557 db_table
= 'geoloc_countries'
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.
568 db_table
= 'geoloc_languages'
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)
587 db_table
= 'group_announces'
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()
599 db_table
= 'group_announces_photo'
602 class GroupAnnouncesRead(models
.Model
):
603 announce
= models
.ForeignKey(GroupAnnounces
)
604 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
608 db_table
= 'group_announces_read'
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)
623 db_table
= 'group_auth'
626 class GroupDom(models
.Model
):
627 id = models
.SmallIntegerField(primary_key
=True)
628 nom
= models
.TextField()
629 cat
= models
.CharField(max_length
=39)
633 db_table
= 'group_dom'
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)
645 db_table
= 'group_event_items'
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()
658 db_table
= 'group_event_participants'
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)
680 db_table
= 'group_events'
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()
691 db_table
= 'group_former_members'
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)
702 db_table
= 'group_member_sub_requests'
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)
715 db_table
= 'group_members'
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)
749 class HomonymsList(models
.Model
):
750 hrmid
= models
.CharField(max_length
=255)
751 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
755 db_table
= 'homonyms_list'
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()
769 db_table
= 'ip_watch'
772 class LogActions(models
.Model
):
773 text
= models
.CharField(max_length
=32)
774 description
= models
.CharField(max_length
=255)
778 db_table
= 'log_actions'
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)
789 db_table
= 'log_events'
792 class LogLastSessions(models
.Model
):
793 uid
= models
.ForeignKey(Accounts
, db_column
='uid', primary_key
=True)
794 id = models
.ForeignKey('LogSessions', db_column
='id')
798 db_table
= 'log_last_sessions'
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)
816 db_table
= 'log_sessions'
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()
826 db_table
= 'mx_watch'
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()
840 db_table
= 'newsletter_art'
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)
851 db_table
= 'newsletter_cat'
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)
862 db_table
= 'newsletter_ins'
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)
881 db_table
= 'newsletter_issues'
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)
891 db_table
= 'newsletters'
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)
903 db_table
= 'payment_bankaccounts'
906 class PaymentCodec(models
.Model
):
907 id = models
.SmallIntegerField(primary_key
=True)
908 text
= models
.CharField(max_length
=64)
912 db_table
= 'payment_codeC'
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.
922 db_table
= 'payment_codeRCB'
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)
934 db_table
= 'payment_methods'
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)
950 db_table
= 'payment_reconcilations'
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()
971 db_table
= 'payment_transactions'
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)
984 db_table
= 'payment_transfers'
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
)
1001 db_table
= 'payments'
1004 class PostfixBlacklist(models
.Model
):
1005 email
= models
.CharField(primary_key
=True, max_length
=150)
1006 reject_text
= models
.CharField(max_length
=64)
1010 db_table
= 'postfix_blacklist'
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)
1022 db_table
= 'postfix_mailseen'
1025 class PostfixWhitelist(models
.Model
):
1026 email
= models
.CharField(primary_key
=True, max_length
=150)
1030 db_table
= 'postfix_whitelist'
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)
1060 db_table
= 'profile_addresses'
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')
1073 db_table
= 'profile_addresses_components'
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)
1084 db_table
= 'profile_addresses_components_enum'
1087 class ProfileBinetEnum(models
.Model
):
1088 text
= models
.CharField(max_length
=50)
1089 url
= models
.CharField(max_length
=255)
1093 db_table
= 'profile_binet_enum'
1096 class ProfileBinets(models
.Model
):
1097 pid
= models
.ForeignKey('Profiles', db_column
='pid')
1098 binet
= models
.ForeignKey(ProfileBinetEnum
)
1102 db_table
= 'profile_binets'
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)
1114 db_table
= 'profile_corps'
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()
1124 db_table
= 'profile_corps_enum'
1127 class ProfileCorpsRankEnum(models
.Model
):
1128 name
= models
.CharField(unique
=True, max_length
=255)
1129 abbreviation
= models
.CharField(unique
=True, max_length
=5)
1133 db_table
= 'profile_corps_rank_enum'
1136 class ProfileDeltaten(models
.Model
):
1137 pid
= models
.ForeignKey('Profiles', db_column
='pid', primary_key
=True)
1138 message
= models
.TextField()
1142 db_table
= 'profile_deltaten'
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)
1157 db_table
= 'profile_display'
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)
1174 db_table
= 'profile_education'
1177 class ProfileEducationDegree(models
.Model
):
1178 eduid
= models
.ForeignKey('ProfileEducationEnum', db_column
='eduid')
1179 degreeid
= models
.ForeignKey('ProfileEducationDegreeEnum', db_column
='degreeid')
1183 db_table
= 'profile_education_degree'
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()
1193 db_table
= 'profile_education_degree_enum'
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)
1204 db_table
= 'profile_education_enum'
1207 class ProfileEducationFieldEnum(models
.Model
):
1208 field
= models
.CharField(unique
=True, max_length
=255, blank
=True, null
=True)
1212 db_table
= 'profile_education_field_enum'
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)
1224 db_table
= 'profile_hobby'
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)
1240 db_table
= 'profile_job'
1243 class ProfileJobEntrepriseTerm(models
.Model
):
1244 eid
= models
.ForeignKey('ProfileJobEnum', db_column
='eid')
1245 jtid
= models
.ForeignKey('ProfileJobTermEnum', db_column
='jtid')
1249 db_table
= 'profile_job_entreprise_term'
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.
1264 db_table
= 'profile_job_enum'
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)
1275 db_table
= 'profile_job_term'
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)
1285 db_table
= 'profile_job_term_enum'
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)
1296 db_table
= 'profile_job_term_relation'
1299 class ProfileJobTermSearch(models
.Model
):
1300 search
= models
.CharField(max_length
=50)
1301 jtid
= models
.ForeignKey(ProfileJobTermEnum
, db_column
='jtid')
1305 db_table
= 'profile_job_term_search'
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)
1317 db_table
= 'profile_langskill_enum'
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)
1327 db_table
= 'profile_langskills'
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()
1344 db_table
= 'profile_manageurs'
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)
1355 db_table
= 'profile_medal_enum'
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()
1366 db_table
= 'profile_medal_grade_enum'
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)
1377 db_table
= 'profile_medals'
1380 class ProfileMentor(models
.Model
):
1381 pid
= models
.ForeignKey('Profiles', db_column
='pid', primary_key
=True)
1382 expertise
= models
.TextField()
1386 db_table
= 'profile_mentor'
1389 class ProfileMentorCountry(models
.Model
):
1390 pid
= models
.ForeignKey('Profiles', db_column
='pid')
1391 country
= models
.ForeignKey(GeolocCountries
, db_column
='country')
1395 db_table
= 'profile_mentor_country'
1398 class ProfileMentorTerm(models
.Model
):
1399 pid
= models
.ForeignKey('Profiles', db_column
='pid')
1400 jtid
= models
.ForeignKey(ProfileJobTermEnum
, db_column
='jtid')
1404 db_table
= 'profile_mentor_term'
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)
1417 db_table
= 'profile_merge_issues'
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()
1431 db_table
= 'profile_modifications'
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)
1443 db_table
= 'profile_networking'
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)
1456 db_table
= 'profile_networking_enum'
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()
1471 db_table
= 'profile_partnersharing_enum'
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)
1484 db_table
= 'profile_partnersharing_settings'
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)
1500 db_table
= 'profile_phones'
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()
1510 db_table
= 'profile_photo_tokens'
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()
1524 db_table
= 'profile_photos'
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)
1535 db_table
= 'profile_private_names'
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)
1551 db_table
= 'profile_public_names'
1554 class ProfileSectionEnum(models
.Model
):
1555 id = models
.IntegerField(primary_key
=True)
1556 text
= models
.CharField(unique
=True, max_length
=50)
1560 db_table
= 'profile_section_enum'
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)
1571 db_table
= 'profile_skill_enum'
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)
1581 db_table
= 'profile_skills'
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)
1591 db_table
= 'profile_visibility_enum'
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)
1621 db_table
= 'profiles'
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)
1639 db_table
= 'register_marketing'
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()
1649 db_table
= 'register_mstats'
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)
1667 db_table
= 'register_pending'
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)
1682 db_table
= 'register_pending_xnet'
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)
1693 db_table
= 'register_subs'
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)
1705 db_table
= 'reminder'
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)
1720 db_table
= 'reminder_tips'
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()
1733 db_table
= 'reminder_type'
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)
1745 db_table
= 'requests'
1748 class RequestsAnswers(models
.Model
):
1749 category
= models
.CharField(max_length
=16)
1750 title
= models
.CharField(max_length
=50)
1751 answer
= models
.TextField()
1755 db_table
= 'requests_answers'
1758 class RequestsHidden(models
.Model
):
1759 uid
= models
.ForeignKey(Accounts
, db_column
='uid', primary_key
=True)
1760 hidden_requests
= models
.TextField()
1764 db_table
= 'requests_hidden'
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()
1775 db_table
= 'search_autocomplete'
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)
1788 db_table
= 'search_name'
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)
1805 class SurveyAnswers(models
.Model
):
1806 vote
= models
.ForeignKey('SurveyVotes')
1807 question_id
= models
.SmallIntegerField()
1808 answer
= models
.TextField()
1812 db_table
= 'survey_answers'
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)
1822 db_table
= 'survey_votes'
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)
1837 db_table
= 'surveys'
1840 class T(models
.Model
):
1841 a
= models
.IntegerField()
1848 class UrlShortener(models
.Model
):
1849 alias
= models
.CharField(primary_key
=True, max_length
=255)
1850 url
= models
.TextField()
1854 db_table
= 'url_shortener'
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()
1868 class WatchGroup(models
.Model
):
1869 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
1870 groupid
= models
.ForeignKey(Groups
, db_column
='groupid')
1874 db_table
= 'watch_group'
1877 class WatchNonins(models
.Model
):
1878 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
1879 ni
= models
.ForeignKey(Accounts
)
1883 db_table
= 'watch_nonins'
1886 class WatchProfile(models
.Model
):
1887 pid
= models
.ForeignKey(Profiles
, db_column
='pid')
1888 ts
= models
.DateTimeField()
1889 field
= models
.CharField(max_length
=12)
1893 db_table
= 'watch_profile'
1896 class WatchPromo(models
.Model
):
1897 uid
= models
.ForeignKey(Accounts
, db_column
='uid')
1898 promo
= models
.IntegerField()
1902 db_table
= 'watch_promo'