Create
Query
sqlite.db
—
survey
__drizzle_migrations
account
activeIngredient
activeIngredientLocal...
campaign
jwks
session
survey
telegramIngredientApp...
unit
unitLocalization
user
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into survey
id
Primary key.
TEXT
user_id
TEXT
created_at
INTEGER (default CURRENT_TIMESTAMP)
updated_at
INTEGER (default CURRENT_TIMESTAMP)
completed_at
INTEGER
current_step
INTEGER (default 1)
name
TEXT
email
TEXT
sex
TEXT
birthdate
TEXT
exercise_level
INTEGER
country_code
TEXT
state_code
TEXT
city
TEXT
zip_code
TEXT
address
TEXT
active_ingredient_ids
TEXT NOT NULL (default '[]')
selected_amount_by_active_ingredient_id
TEXT NOT NULL (default '{}')
active_ingredient_spending_config
TEXT NOT NULL (default '{}')
spending_by_active_ingredient_id
TEXT NOT NULL (default '{}')
time_per_dose_by_active_ingredient_id
TEXT NOT NULL (default '{}')
step_time_spent_seconds_by_step
TEXT NOT NULL (default '{}')
completed_step_numbers
TEXT NOT NULL (default '[]')
requested_active_ingredients
TEXT NOT NULL (default '[]')
last_partial_update_at
INTEGER
consent_to_contact
INTEGER (default false)
Insert
Cancel