Comments


Description

Notes that employers can leave on any candidates, and can be shared with their fellow admins in the company.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()

Primary Key.
note varchar 66000 √ null

Comment.
commenterEmail varchar 255 √ null

Commenter Email.
commenterLastName varchar 255 √ null

Commenter Last Name.
commenterFirstName varchar 255 √ null

Commenter First Name.
CommenterId uuid 2147483647 √ null
Users.id Comments_CommenterId_fkey C

Foreign Key to User Table, to relate to Employer commenting.
CandidateId uuid 2147483647 √ null
Users.id Comments_CandidateId_fkey C

Foreign Key to User Table, to relate to candidate being commented on.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
CompanyId uuid 2147483647 √ null
Companies.id Comments_CompanyId_fkey R
JobId uuid 2147483647 √ null
Jobs.id Comments_JobId_fkey R

Indexes

Constraint Name Type Sort Column(s)
Comments_pkey Primary key Asc id
Comments_CandidateId_idx Performance Asc CandidateId
Comments_CommenterId_idx Performance Asc CommenterId
Comments_CompanyId_idx Performance Asc CompanyId
Comments_JobId_idx Performance Asc JobId

Relationships

Close relationships within degrees of separation