Table "enrichment.company_basic"

ColumnTypeNullableDefaultStorageDescription
"domain"textnot nullextended
"name"textextended
"yearFounded"smallintplain
"industry"textextended
"sizeRange"textextended
"locality"textextended
"country"textextended
"currentEmployeeEstimate"integerplain
"totalEmployeeEstimate"integerplain
"linkedinUrl"textextended
"twitterUrl"textextended
"facebookUrl"textextended
"crunchbaseUrl"textextended

Indexes:

"company_basic__idx__year_employees" UNIQUE, btree (domain) INCLUDE ("yearFounded", "sizeRange", "currentEmployeeEstimate", "totalEmployeeEstimate")

Access method:

heap
Last updated on by John Gracey