Diff for "FfiiMembership"

Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2006-02-19 16:43:30 →
Size: 506
Editor: DieterVanUytvanck
Comment:
← Revision 2 as of 2006-02-19 16:59:16 → ⇥
Size: 1250
Editor: DieterVanUytvanck
Comment:
Deletions are marked like this. Additions are marked like this.
Line 13: Line 13:
??, no permissions
Line 15: Line 17:
 * uid, character varying(8)
 * mailref, ??
 * mailuser, part of email before @
 * mailhost, part of email after @
Line 16: Line 23:
 * uid, character varying(8)
 * adrref, character varying(8), ??
 * land, character varying(2), 2 letter code for country (belgium = be, netherlands = nl)
 * plz, text, zip code
 * urb, text, city
 * str, text, street name and number
Line 18: Line 31:
 * uid | character varying(8)
 * pntyp | character varying(2) | ??
 * pnom, full name
Line 20: Line 36:
 * uid | character varying(8) |
 * telref | character varying(8) | ??
 * tel | text | telephone number
 * telrem | text | ??
Line 22: Line 42:
 * uid | character varying(8) |
 * pass | character varying(16) | hash (what kind of?) of password

The membership data is stored in multiple tables within the database "ffii" on genba (postgresql):

asoc

  • uid, character varying(8): aktiv id
  • org, character varying(8): organisation, default 'ffii'
  • asolvl, numeric(1,0): membership status, -1 (unsubscribed) to 3 (active member), not necessarily correct
  • asorem , text, ???
  • asolack, character varying(16), acknowledgement code of membership

asolack

??, no permissions

mail

  • uid, character varying(8)
  • mailref, ??
  • mailuser, part of email before @
  • mailhost, part of email after @

padr

  • uid, character varying(8)
  • adrref, character varying(8), ??
  • land, character varying(2), 2 letter code for country (belgium = be, netherlands = nl)
  • plz, text, zip code
  • urb, text, city
  • str, text, street name and number

pnom

  • uid | character varying(8)
  • pntyp | character varying(2) | ??
  • pnom, full name

teln

  • uid | character varying(8) |
  • telref | character varying(8) | ??
  • tel | text | telephone number
  • telrem | text | ??

pass

  • uid | character varying(8) |
  • pass | character varying(16) | hash (what kind of?) of password

De inhoud van deze site is zonder enige vorm van garantie beschikbaar onder zowel de GNU Free Documentation License als de Creative Commons Naamsvermelding-Gelijk delen-licentie