WOCAT » QCAT

h1. 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)

h2. 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...

h2. 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.