Diff for "FfiiMembership"

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

Some useful queries

• select count(*) from mail, padr, pnom, teln where padr.land = 'be' and padr.uid = mail.uid and pnom.uid = mail.uid and mail.uid = teln.uid ;

correction: replace this by an outer join in order not to remove members whose data is not complete

export to text file: Select * from table1 limit 100 \o /home/phatcher/test.txt