Companies


Description

Company Information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
AutomatedCSVExportLogs.companyId AutomatedCSVExportLogs_companyId_fkey N
CompanyBalanceExpiryDates.companyId CompanyBalanceExpiryDates_companyId_fkey C
CompanyJobSlotsSubscriptions.companyId CompanyJobSlotsSubscriptions_companyId_fkey N
EmployerBonusPointsAccounts.companyId EmployerBonusPointsAccounts_companyId_fkey N
EmployerPaidPointsAccounts.companyId EmployerPaidPointsAccounts_companyId_fkey N
ExpiryPointsAccounts.companyId ExpiryPointsAccounts_companyId_fkey N
JobPostExtensionPointsUsageAccounts.companyId JobPostExtensionPointsUsageAccounts_companyId_fkey N
JobPostPointsUsageAccounts.companyId JobPostPointsUsageAccounts_companyId_fkey N
Orders.companyId Orders_companyId_fkey N
PointsJournalEntries.companyId PointsJournalEntries_companyId_fkey N
PointsTopUpOrders.companyId PointsTopUpOrders_companyId_fkey N
ProductPurchaseAssistanceRequests.companyId ProductPurchaseAssistanceRequests_companyId_fkey C
SubscriptionPlanAssistanceRequests.companyId SubscriptionPlanAssistanceRequests_companyId_fkey C
TalentChatPointsAccounts.companyId TalentChatPointsAccounts_companyId_fkey N
CompanyCreditInventories.companyId CompanyCreditInventories_companyId_fkey C
CompanyCreditInventoryBreakdowns.companyId CompanyCreditInventoryBreakdowns_companyId_fkey C
CompanyCreditInventoryLogs.companyId CompanyCreditInventoryLogs_companyId_fkey N
CompanyProductFreeTrialOffers.companyId CompanyProductFreeTrialOffers_companyId_fkey C
CompanyProductInventories.companyId CompanyProductInventories_companyId_fkey C
CompanyProductInventoryLogs.companyId CompanyProductInventoryLogs_companyId_fkey C
CompanyProductSubscriptionFreeTrialOffers.companyId CompanyProductSubscriptionFreeTrialOffers_companyId_fkey C
CompanyProductSubscriptions.companyId CompanyProductSubscriptions_companyId_fkey N
CreditProductPurchaseOrders.companyId CreditProductPurchaseOrders_companyId_fkey N
CreditPurchaseOrders.companyId CreditPurchaseOrders_companyId_fkey N
OfflineSalesTransactions.companyId OfflineSalesTransactions_companyId_fkey N
PendingPurchaseOrders.companyId PendingPurchaseOrders_companyId_fkey N
PurchaseOrders.companyId PurchaseOrders_companyId_fkey N
RecurringCreditTopUp.companyId RecurringCreditTopUp_companyId_fkey C
AutomatedApplicationCSVExportLogs.companyId AutomatedApplicationCSVExportLogs_companyId_fkey N
Bookmarks.CompanyId Bookmarks_CompanyId_fkey R
Comments.CompanyId Comments_CompanyId_fkey R
CompaniesPageCarouselItems.CompanyId CompaniesPageCarouselItems_CompanyId_fkey R
CompanyAddresses.companyId CompanyAddresses_companyId_fkey C
CompanyApplicationCountAggregates.companyId CompanyApplicationCountAggregates_companyId_fkey C
CompanyCollectionItems.CompanyId CompanyCollectionItems_CompanyId_fkey R
CompanyDeletionRequests.companyId CompanyDeletionRequests_companyId_fkey N
CompanyFeaturesMaximum.companyId CompanyFeaturesMaximum_companyId_fkey C
CompanyIdentities.companyId CompanyIdentities_companyId_fkey C
CompanyStatusLog.companyId CompanyStatusLog_companyId_fkey C
CompanyVerificationRequests.companyId CompanyVerificationRequests_companyId_fkey N
DailyMetricsForJobs.CompanyId DailyMetricsForJobs_CompanyId_fkey R
EmployerCustomMessages.CompanyId EmployerCustomMessages_CompanyId_fkey C
EmployerVerifications.CompanyId EmployerVerifications_CompanyId_fkey N
FraudCaseFiles.CompanyId FraudCaseFiles_CompanyId_fkey C
FraudVerificationLists.sourceCompanyId FraudVerificationLists_sourceCompanyId_fkey N
GroupMembers.CompanyId GroupMembers_CompanyId_fkey R
HoustonCreateCompanyActionLogs.companyId HoustonCreateCompanyActionLogs_companyId_fkey C
HoustonInboundUpsellCompanyActionLogs.companyId HoustonInboundUpsellCompanyActionLogs_companyId_fkey N
HoustonOutboundUpsellCompanyActionLogs.companyId HoustonOutboundUpsellCompanyActionLogs_companyId_fkey N
HoustonReactivateCompanyActionLogs.companyId HoustonReactivateCompanyActionLogs_companyId_fkey C
HoustonTransferCompanyActionLogs.companyId HoustonTransferCompanyActionLogs_companyId_fkey C
HoustonTransferCompanyTaskLogs.companyId HoustonTransferCompanyTaskLogs_companyId_fkey C
JobBoostingTasks.CompanyId JobBoostingTasks_CompanyId_fkey C
JobDrafts.CompanyId JobDrafts_CompanyId_fkey R
JobFeaturesMaximum.companyId JobFeaturesMaximum_companyId_fkey C
Jobs.CompanyId Jobs_CompanyId_fkey R
LiveRooms.CompanyId LiveRooms_CompanyId_fkey C
PendingUserCompanies.CompanyId PendingUserCompanies_CompanyId_fkey R
PotentialLeads.glintsCompanyId PotentialLeads_glintsCompanyId_fkey R
ProfileCompletionScores.CompanyId Scores_CompanyId_fkey R
ReportedCandidates.companyId ReportedCandidates_companyId_fkey N
RevenueCatWebhookLogs.companyId RevenueCatWebhookLogs_companyId_fkey N
SourcedCompanies.GlintsCompanyId SourcedCompanies_GlintsCompanyId_fkey R
UnlockedTalents.companyId UnlockedTalents_companyId_fkey C
UserCompanies.CompanyId UserCompanies_CompanyId_fkey R
UserCompaniesOpsTeamDataBackup.CompanyId UserCompaniesOpsTeamDataBackup_CompanyId_fkey R
UserCompanyLogs.companyId UserCompanyLogs_companyId_fkey C
UserFeedbacks.CompanyId UserFeedbacks_CompanyId_fkey N

Primary Key.
name varchar 255 null

Company name.
varchar 255 √ null

Company logo.
tagline varchar 255 √ null

Company tagline.
video varchar 255 √ null

URL to their corporate video.
website varchar 255 √ null

URL to their corporate website.
socialMediaSites jsonb 2147483647 √ null

JSON object with key as the social media site, and value as the url of their social media profiles.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
CountryCode varchar 255 null
Countries.code Companies_CountryCode_fkey N

Country Code of country that this user reside in. Foreign Key references Countries.
IndustryId int4 10 √ null
Industries.id Companies_IndustryId_fkey N

Foreign Key to Industry Table.
bannerPic varchar 255 √ null

File name linking to their resumes in s3 bucket glints-dashboard/company-banner-pic.
isVerified bool 1 false

Verification status of the companies, unused as of 21st August 2018.
isHiring bool 1 false

Is this company hiring at the moment.
localOffice bool 1 true

hasLocalOffice: Boolean indicating the presence of an office in the country of CountryCode.
customAttributes jsonb 2147483647 √ null

Additional feature flags used primarily in Groups (whitelabel) context.
photos jsonb 2147483647 √ null

JSON array of file name linking to their uploaded company photos in s3 bucket glints-dashboard/company-photos.
descriptionRaw jsonb 2147483647 √ null
CityId int4 10 √ null
Cities.id Companies_CityId_fkey N

Foreign Key to Cities Table.
registrationCode varchar 255 √ null

Registration code of the legal entity in their country of incorporation. UEN in Singapore.
tsv tsvector 2147483647 √ null

Weight of every word in the title for full text search
cultureRaw jsonb 2147483647 √ null
address varchar 2048 √ null
size enum_company_size_type 2147483647 √ null
legalRegistrationNumber varchar 255 √ null

Legal registration number
legalDocument varchar 255 √ null

File name linking to their legal document in s3 bucket
status enum_Company_status 2147483647 'UNVERIFIED'::"enum_Company_status"

Status of the company
ReviewerId uuid 2147483647 √ null
Users.id Companies_ReviewerId_fkey R

Foreign Key to User Table, to relate to the operator who verified the company.
reviewedAt timestamptz 35,6 √ null

Time of reviewing
vnTaxCode text 2147483647 √ null

Tax code for VN companies
vnBusinessRegistrationCertDate text 2147483647 √ null

Business registration certification date for VN companies
vnBusinessRegistrationCertPlace text 2147483647 √ null

Place of business registration for VN companies
contactMethod text 2147483647 √ null

Contact method for VN companies
LocationId uuid 2147483647 √ null
Locations.id Companies_LocationId_fkey N

Foreign Key to Location Table.
acquisitionReferralCode text 2147483647 √ null

Company acquisition referral code
legalDocumentCreatedAt timestamptz 35,6 √ null
legalDocumentUpdatedAt timestamptz 35,6 √ null
EmployerServiceRepId uuid 2147483647 √ null
Users.id Companies_EmployerServiceRepId_fkey N

This represents who created this company
hubspotLink varchar 255 √ NULL::character varying

Hubspot Link. For internal use only.
recruitmentLink varchar 255 √ NULL::character varying

Recruitment Link. For internal use only.
houstonMediaLink varchar 255 √ NULL::character varying

Social Media Link via Houston. For internal use only.
lastVerificationSubmitted timestamptz 35,6 √ null

Timestamp of the last time verification documents were submitted via houston. For internal use only.
companyPICSelfies _varchar 255 √ NULL::character varying[]

Array of file names linking to company PIC selfie in s3 bucket. For internal use only.
chatTranscripts _varchar 255 √ NULL::character varying[]

Array of file names linking to chat transcript in s3 bucket. For internal use only.
acquiredByTeam enum_Acquisition_Team_type 2147483647 √ null

This column is used to check which team acquired the company.
employerServiceRepEndDate timestamptz 35,6 √ null
freeSubscriptionPlanGroupId uuid 2147483647 √ null
FreeSubscriptionPlanGroups.id Companies_freeSubscriptionPlanGroupId_fkey R
brandName varchar 255 √ NULL::character varying

Company’s brand name.

Indexes

Constraint Name Type Sort Column(s)
Companies_pkey Primary key Asc id
Companies_CityId_idx Performance Asc CityId
Companies_CountryCode_idx Performance Asc CountryCode
Companies_createdAt_idx Performance Asc createdAt
Companies_EmployerServiceRepId_idx Performance Asc EmployerServiceRepId
Companies_IndustryId_idx Performance Asc IndustryId
Companies_legalDocument_idx Performance Asc legalDocument
Companies_name_idx Performance Asc name
Companies_reviewedAt_idx Performance Asc reviewedAt
Companies_status_idx Performance Asc status
companies_tsv_idx Performance Asc tsv

Check Constraints

Constraint Name Constraint
check_chatTranscripts_length ((array_length("chatTranscripts", 1) <= 5))
check_companyPICSelfies_length ((array_length("companyPICSelfies", 1) <= 5))

Relationships

Close relationships within degrees of separation