A project member is a user that is associated to a specific project.
gitlab_project_member table can be used to query information members of a specific project.
However, you must specify a
project_id in the where or join clause.
List all members for a specific project
select*fromgitlab_project_memberwhere project_id = 123;
Project Members for a GitLab Project
|access_desc||text||The descriptive of the access level held by the project member.|
|access_level||bigint||The access level the project member holds within the project.|
|avatar_url||text||The url of the project members avatar.|
|expires_at||timestamp without time zone||The date of expiration of access to the project.|
|id||bigint||The id of the project member - link to `gitlab_user.id`|
|name||text||The name of the project member.|
|project_id||bigint||The project id - link to gitlab_project.id`.|
|state||text||The state of the project member active, blocked, etc|
|username||text||The username of the project member - link to `gitlab_user.username`.|
|web_url||text||The url for profile of the project member.|