analyst

-1 rows


Description

Table containing list of analysts

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
application_analyst_lead.analyst_id application_analyst_lead_analyst_id_fkey R

Unique ID for the analyst
given_name varchar 1000 √ null

Analyst’s first name
family_name varchar 1000 √ null

Analyst’s last name
created_by int4 10 √ null
ccbc_user.id analyst_created_by_fkey R

created by user id
created_at timestamptz 35,6 now()

created at timestamp
updated_by int4 10 √ null
ccbc_user.id analyst_updated_by_fkey R

updated by user id
updated_at timestamptz 35,6 now()

updated at timestamp
archived_by int4 10 √ null
ccbc_user.id analyst_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp
active bool 1 √ true

Boolean column indicating whether the analyst is active or not.
email varchar 100 √ null

Analyst’s email address

Indexes

Constraint Name Type Sort Column(s)
analyst_pkey Primary key Asc id
ccbc_public_analyst_archived_by_foreign_key Performance Asc archived_by
ccbc_public_analyst_created_by_foreign_key Performance Asc created_by
ccbc_public_analyst_updated_by_foreign_key Performance Asc updated_by

Relationships

Close relationships within degrees of separation