Ctrl K

Back to Lemlist

main

Data table

Migration run against the main data table when the project is imported.

lemlist.campaigns

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
name	text	not null
status	text	not nulldefault 'draft'::text
from_name	text
created_at	timestamp with time zone	default now()

lemlist.contacts

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
email	text	not null
first_name	text
last_name	text
company	text
created_at	timestamp with time zone	default now()

lemlist.enrollments

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
campaign_id	uuid	not null→ campaigns
contact_id	uuid	not null→ contacts
status	text	not nulldefault 'active'::text
current_step	integer	not nulldefault 0
next_send_at	timestamp with time zone
last_sent_at	timestamp with time zone
enrolled_at	timestamp with time zone	default now()

lemlist.events

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
enrollment_id	uuid	not null→ enrollments
step_position	integer
type	text	not null
created_at	timestamp with time zone	default now()

lemlist.steps

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
campaign_id	uuid	not null→ campaigns
position	integer	not null
subject	text	not null
body	text	not null
delay_days	integer	not nulldefault 0

lemlist.lists

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
name	text	not null
created_at	timestamp with time zone	default now()

lemlist.list_members

Column	Type	Constraints
list_id	uuid	not nullprimary key→ lists
contact_id	uuid	not nullprimary key→ contacts
added_at	timestamp with time zone	default now()