Structure	public.campaigns	public.email_templates	public.emails	public.generated_emails	public.generated_leads	public.leads	public.search_terms
Table	campaigns	email_templates	emails	generated_emails	generated_leads	leads	search_terms
Table Name	campaigns	email_templates	emails	generated_emails	generated_leads	leads	search_terms
Object ID	30892	30883	30683	30706	30929	30906	31003
Row Count Estimate	-1	-1	-1	-1	-1	-1	-1
Has Oids	false	false	false	false	false	false	false
Has Row-Level Security	false	false	false	false	false	false	false
Partitions	false	false	false	false	false	false	false
Columns
Column	id	id	id	id	id	id	id
Column Name	id	id	id	id	id	id	id
#	1	1	1	1	1	1	1
Data type	int8	int8	int8	int8	int8	int8	int8
Identity	Always	Always	Always	Always	Always	Always	Always
Local	true	true	true	true	true	true	true
Not Null	true	true	true	true	true	true	true
Column	campaign_name	N/A	N/A	N/A	N/A	N/A	N/A
Column	template_id	N/A	N/A	N/A	N/A	N/A	N/A
Column	created_at	created_at	N/A	N/A	N/A	N/A	N/A
Column Name	created_at	created_at
#	4	5
Data type	timestamptz	timestamptz
Local	true	true
Not Null	false	false
Default	CURRENT_TIMESTAMP	CURRENT_TIMESTAMP
Column	N/A	template_name	N/A	N/A	N/A	N/A	N/A
Column	N/A	subject	N/A	N/A	N/A	N/A	N/A
Column	N/A	body_html	N/A	N/A	N/A	N/A	N/A
Column	N/A	N/A	search_query	N/A	N/A	search_query	N/A
Column Name			search_query			search_query
#			2			2
Data type			text			text
Local			true			true
Not Null			false			false
Column	N/A	N/A	email	N/A	N/A	email	N/A
Column Name			email			email
#			3			3
Data type			text			text
Local			true			true
Not Null			false			false
Column	N/A	N/A	page_title	N/A	N/A	page_title	N/A
Column Name			page_title			page_title
#			4			4
Data type			text			text
Local			true			true
Not Null			false			false
Column	N/A	N/A	url	N/A	N/A	url	N/A
Column Name			url			url
#			5			5
Data type			text			text
Local			true			true
Not Null			false			false
Column	N/A	N/A	meta_description	N/A	N/A	meta_description	N/A
Column Name			meta_description			meta_description
#			6			6
Data type			text			text
Local			true			true
Not Null			false			false
Column	N/A	N/A	http_status	N/A	N/A	http_status	N/A
Column Name			http_status			http_status
#			7			7
Data type			int4			int4
Local			true			true
Not Null			false			false
Column	N/A	N/A	scrape_duration	N/A	N/A	scrape_duration	N/A
Column Name			scrape_duration			scrape_duration
#			8			8
Data type			text			text
Local			true			true
Not Null			false			false
Column	N/A	N/A	campaign_id	N/A	N/A	campaign_id	N/A
Column Name			campaign_id			campaign_id
#			9			9
Data type			int8			int8
Local			true			true
Not Null			false			false
Column	N/A	N/A	N/A	email_id	N/A	N/A	N/A
Column	N/A	N/A	N/A	generated_email	generated_email	N/A	N/A
Column Name				generated_email	generated_email
#				3	3
Data type				text	text
Local				true	true
Not Null				false	false
Column	N/A	N/A	N/A	email_sent	email_sent	N/A	N/A
Column Name				email_sent	email_sent
#				4	4
Data type				int4	int4
Local				true	true
Not Null				false	false
Default				0	0
Column	N/A	N/A	N/A	sent_at	sent_at	N/A	N/A
Column Name				sent_at	sent_at
#				5	5
Data type				timestamptz	timestamptz
Local				true	true
Not Null				false	false
Column	N/A	N/A	N/A	N/A	lead_id	N/A	N/A
Column	N/A	N/A	N/A	N/A	N/A	N/A	term
Column	N/A	N/A	N/A	N/A	N/A	N/A	status
Column	N/A	N/A	N/A	N/A	N/A	N/A	fetched_emails
Column	N/A	N/A	N/A	N/A	N/A	N/A	last_processed_at
Constraints
Constraint	campaigns_pkey	N/A	N/A	N/A	N/A	N/A	N/A
Constraint	N/A	email_templates_pkey	N/A	N/A	N/A	N/A	N/A
Constraint	N/A	N/A	emails_pkey	N/A	N/A	N/A	N/A
Constraint	N/A	N/A	N/A	generated_emails_pkey	N/A	N/A	N/A
Constraint	N/A	N/A	N/A	N/A	generated_leads_pkey	N/A	N/A
Constraint	N/A	N/A	N/A	N/A	N/A	leads_pkey	N/A
Constraint	N/A	N/A	N/A	N/A	N/A	N/A	search_terms_pkey
Foreign Keys
Foreign Key	campaigns_template_id_fkey	N/A	N/A	N/A	N/A	N/A	N/A
Foreign Key	fk_template_id	N/A	N/A	N/A	N/A	N/A	N/A
Foreign Key	N/A	N/A	N/A	fk_email_id	N/A	N/A	N/A
Foreign Key	N/A	N/A	N/A	generated_emails_email_id_fkey	N/A	N/A	N/A
Foreign Key	N/A	N/A	N/A	N/A	fk_lead_id	N/A	N/A
Foreign Key	N/A	N/A	N/A	N/A	generated_leads_lead_id_fkey	N/A	N/A
Foreign Key	N/A	N/A	N/A	N/A	N/A	fk_campaign_id	N/A
Foreign Key	N/A	N/A	N/A	N/A	N/A	leads_campaign_id_fkey	N/A
Indexes
Index	campaigns_pkey	N/A	N/A	N/A	N/A	N/A	N/A
Index	N/A	email_templates_pkey	N/A	N/A	N/A	N/A	N/A
Index	N/A	N/A	emails_pkey	N/A	N/A	N/A	N/A
Index	N/A	N/A	N/A	generated_emails_pkey	N/A	N/A	N/A
Index	N/A	N/A	N/A	N/A	generated_leads_pkey	N/A	N/A
Index	N/A	N/A	N/A	N/A	N/A	leads_pkey	N/A
Index	N/A	N/A	N/A	N/A	N/A	N/A	search_terms_pkey
55 objects compared