PotentialLeads


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
PotentialContacts.potentialLeadId PotentialContacts_potentialLeadId_fkey R
PotentialLeadDigitalFootprints.potentialLeadId PotentialLeadDigitalFootprints_potentialLeadId_fkey R
PotentialLeadIgnoreReasons.potentialLeadId PotentialLeadIgnoreReasons_potentialLeadId_fkey C
PotentialLeadStatusChangeLogs.potentialLeadId PotentialLeadStatusChangeLogs_potentialLeadId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
countryCode varchar 3 null
Countries.code PotentialLeads_countryCode_fkey R
name varchar 255 √ NULL::character varying
text 2147483647 √ null
tagline varchar 255 √ NULL::character varying
website text 2147483647 √ NULL::character varying
socialMediaSites jsonb 2147483647 √ null
industryId int4 10 √ null
descriptionRaw jsonb 2147483647 √ null
address text 2147483647 √ null
locationId uuid 2147483647 √ null
Locations.id PotentialLeads_locationId_fkey R
size enum_company_size_type 2147483647 √ null
leadStatus enum_PotentialLead_status 2147483647 null
glintsCompanyId uuid 2147483647 √ null
Companies.id PotentialLeads_glintsCompanyId_fkey R
note text 2147483647 √ null
funnel enum_PotentialLead_funnel 2147483647 null
leadAssigneeId uuid 2147483647 √ null
Users.id PotentialLeads_leadAssigneeId_fkey R
recruitmentLink text 2147483647 √ null
sourceLink text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PotentialLeads_pkey Primary key Asc id
PotentialLeads_glintsCompanyId_idx Performance Asc glintsCompanyId
PotentialLeads_leadAssigneeId_idx Performance Asc leadAssigneeId
PotentialLeads_leadStatus_idx Performance Asc leadStatus
PotentialLeads_locationId_idx Performance Asc locationId
PotentialLeads_name_trgm_idx Performance Asc name

Relationships

Close relationships within degrees of separation