GroupMembers


Description

Users and Companies membership in groups.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
TalentHuntCandidateApplications.TalentHuntGroupMemberId TalentHuntCandidateApplications_TalentHuntGroupMemberId_fkey R
Talents.GroupMembershipId Implied Constraint R

Primary Key.
status enum_GroupMembers_status 2147483647 'PENDING'::"enum_GroupMembers_status"

Status of users or companies membership in the group.
approvalDate timestamptz 35,6 √ null

Date that user or company is approved in the group.
note text 2147483647 √ null

Note by admin about the membership.
GroupId uuid 2147483647 √ null
Groups.id GroupMembers_GroupId_fkey C

Foreign Key to Group Table.
AdminId uuid 2147483647 √ null
Users.id GroupMembers_AdminId_fkey C

Foreign Key to User Table, relating to Group Admin.
CompanyId uuid 2147483647 √ null
Companies.id GroupMembers_CompanyId_fkey R

Foreign Key to Company Table.
CandidateId uuid 2147483647 √ null
Users.id GroupMembers_CandidateId_fkey C

Foreign Key to Users Table, relating to Candidate .
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute

Indexes

Constraint Name Type Sort Column(s)
GroupMembers_pkey Primary key Asc id
GroupMembers_AdminId_GroupId_idx Must be unique Asc/Asc AdminId + GroupId
GroupMembers_CandidateId_GroupId_idx Must be unique Asc/Asc CandidateId + GroupId
GroupMembers_CandidateId_GroupId_status_idx Must be unique Asc/Asc/Asc CandidateId + GroupId + status
GroupMembers_CompanyId_GroupId_idx Must be unique Asc/Asc CompanyId + GroupId
GroupMembers_CompanyId_GroupId_status_idx Must be unique Asc/Asc/Asc CompanyId + GroupId + status

Relationships

Close relationships within degrees of separation