company_users
In short
This table contains information about the users associated to a company. It allows to easily retrieve their ids, role and permissions in the data sharing.
In Pennylane, it is possible to give access to a companyβs data to multiple users. Each user is associated to a role that gives them permissions to access and perform actions on the different modules and features of the application.
This table contains the list of users that have access to a company, as well as their role and their eligibility to use data sharing feature.
Available Columns
user_id
bigint
ID of the user in the Pennylane app. This ID is used to identify the user in the other data models.
company_id
bigint
Unique ID of the company on Pennylane, referring to companies.id
.
company_name
character varying
Company's display name on Pennylane. This name may differ from the legal registration name. This name is used for display and search in the application.
user_email
character varying
Email address of the user.
user_first_name
character varying
First name of the user.
user_last_name
character varying
Last name of the user.
user_last_activity
date
NEW
Last date of activity of the user on Pennylane. In case a user has never logged in, the value is NULL. In case a user belongs to several companies, the value is the last activity date related to any of the companies.
role
character varying
Role of the user when accessing a company. This role determines the permissions the user has in the data sharing.
Examples: "employee", "internal_accountant", "purchasing_manager"
firm_id
bigint
ID of the accounting firm the company belongs to. When the accounting is managed internally and not by an accounting firm, the value is NULL.
firm_name
character varying
Name of the accounting firm the company belongs to. When the accounting is managed internally and not by an accounting firm, the value is NULL.
eligible_to_data_sharing
boolean
true
the user has the right to activate and use the data sharing feature. false
the user does not have the right to activate and use the data sharing feature. This is determined by the user's role. The feature must be activated for the user to be able to use it.
created_at
timestamp without time zone
NEW
Date and time when the user was created on Pennylane.
updated_at
timestamp without time zone
NEW
Date and time when the user was last updated on Pennylane.