Table "enrichment.person_enrichment"

ColumnTypeNullableDefaultStorageDescription
"email"character varying(255)not nullextended
"details"jsonbextended
"createdAt"timestamp with time zonenow()plain
"updatedAt"timestamp with time zonenow()plain
first_namecharacter varying(255)extended
"name"character varying(255)extended
"verified"booleanplain
"avatar"character varying(255)extended
"gender"character varying(255)extended
"location"character varying(256)extended
"bio"character varying(1000)extended
"education"character varying(1000)extended
"employment"character varying(1000)extended
"website"character varying(255)extended
max_followersintegerplain
sum_followersintegerplain
"angellist"character varying(255)extended
angellist_biocharacter varying(1000)extended
angellist_followersintegerplain
"linkedin"character varying(255)extended
linkedin_biocharacter varying(2000)extended
linkedin_followersintegerplain
"xing"character varying(255)extended
"producthunt"character varying(255)extended
"facebook"character varying(255)extended
facebook_friendsintegerplain
facebook_followersintegerplain
facebook_engagementintegerplain
facebook_engagement_percentrealplain
"twitter"character varying(255)extended
twitter_verifiedbooleanplain
twitter_biocharacter varying(500)extended
twitter_followersintegerplain
twitter_postsintegerplain
twitter_engagementintegerplain
twitter_engagement_percentrealplain
"stackoverflow"character varying(255)extended
"dribbble"character varying(255)extended
dribbble_followersintegerplain
"pinterest"character varying(255)extended
pinterest_biocharacter varying(255)extended
pinterest_followersintegerplain
"instagram"character varying(255)extended
instagram_verifiedbooleanplain
instagram_biocharacter varying(255)extended
instagram_followersintegerplain
instagram_is_privatebooleanplain
instagram_postsintegerplain
instagram_engagementintegerplain
instagram_engagement_percentrealplain
instagram_posts_captionscharacter varying(255)extended
"github"character varying(255)extended
github_followersintegerplain
"youtube"character varying(255)extended
youtube_verifiedbooleanplain
youtube_followersintegerplain
youtube_postsintegerplain
youtube_engagementintegerplain
youtube_engagement_percentrealplain
"googleplus"character varying(255)extended
googleplus_followersintegerplain
"googleapps"character varying(255)extended
googleapps_ratedintegerplain
googleapps_averagerealplain
googleapps_sharedintegerplain
"klout"character varying(255)extended
klout_scoreintegerplain

Indexes:

"PersonEnrichment_pkey" PRIMARY KEY, btree (email)

Access method:

heap
Last updated on by John Gracey