Introduction¶

In typo3 there are three entities which are linked to each other. I think it makes sense to further look at them as three different entities:

• the application users (username , password)
• addresses (all address details of the users)
• Institutions (Inst. name, country)

1. The users¶

typo3 mysql table: fe_users

definition: Those are application users. The table holds username and passwords. user groups connected are hold in fe_groups added are only CMS inherent groups: (e.g. 'web user confirmed' meaning: confirmed user registration) or the roles inside an application (CMS editor / reviewer etc. or UNCCD focal point, etc...)

h2 2. Addresses"

typo3 mysql table: tt_address

This holds all the address informations and is linked to the user table as well as the institution it is member of. The cause that there are two tables: In future it would allow to have addresses with no login. The way addresses where collected in past time, that would make sense...

Institutions¶

typo3 mysql table: tx_wocataddress_domain_model_institution

definition: The institutions are very simple now: two important fields: name (simple string) and country. It would be good to add a field for abbreviation!
Furthermore it holds a foreign_key field which points to the contact address (cr_user_id).

h2 groups

typo3 mysql table: tx_wocataddress_domain_model_usergroup

definition: This table holds groups which are NOT typo3 inherent, but are used in qcat then to separate groups of users with different priviledges.