Ctrl K

Back to Typeform

main

Data table

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

typeform.forms

Column	Type	Constraints
id	text	not nullprimary key
title	text	not null
description	text
thank_you_title	text	default 'Thanks!'::text
thank_you_message	text	default 'We''ll be in touch soon.'::text
accent_color	text	default '#0084ff'::text
created_at	timestamp with time zone	default now()

typeform.responses

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
form_id	text	not null→ forms
answers	jsonb	not null
submitted_at	timestamp with time zone	default now()
session_id	text

typeform.questions

Column	Type	Constraints
id	text	not nullprimary key
form_id	text	not nullprimary key→ forms
position	integer	not null
type	text	not null
question	text	not null
placeholder	text
choices	jsonb
required	boolean	default true