Table: Global Offerer

The mrt_global__user_offerer table provides a detailed view of user accounts affiliated to or managing a cultural offerer (identified by an offerer_id). We thus have one row per user and offerer affiliation. Those accounts enable them to manage the said offerer (by creating and updating offers, managing bookings etc).

Multiple users can be affiliated to the same offerer (for example, when a cultural offerer has various staff members) and a single user can be affiliated to multiple offerers. Only validated user - offerer affiliations are stored in this model (pending / rejected affiliations are excluded).

Table description

name	data_type	description
offerer_id		Unique identifier of the offerer.
user_id		Unique identifier for a user.
user_affiliation_rank		This column assigns a ranking to each user based on the order of their account creation date within each offerer's group. If user_affiliation_rank equals 1, it means this user was the first registered user for a said offerer.
user_creation_date		Date when the user account was created.
user_department_code		Department code associated with the user's registered address.
user_postal_code		Postal code of the user's registered address.
user_role		Role assigned to the user (GRANT_18, GRANT_15_17, PRO, ADMIN).
user_address		User's registered address. Registered at first grant deposit and updated when the user applies for its GRANT_18.
user_city		City associated with the user's registered address.
user_last_connection_date		Date of the user's last connection.
user_is_email_validated		Boolean. Indicates if the user's email is validated.
user_is_active		Boolean. Indicates if the user's account is currently active (the user can access it, irrespective of grant status).
user_has_seen_pro_tutorials		Boolean. Indicates if the user has seen professional tutorials.
user_phone_validation_status		Status of the user's phone validation step.
user_has_validated_email		Indicates if the user has validated their email.
user_has_enabled_marketing_push		Indicates if the user has accepted to received marketing push.
user_has_enabled_marketing_email		Indicates if the user has accepted to receive marketing emails.