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
Update row 8a81049e-c54e-4da2-a607-11982f345212 in survey
id
8a81049e-c54e-4da2-a607-11982f345212
Primary key.
TEXT
user_id
3c8f0673-f005-4a9e-a4a1-c63eca171b9c
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
country_code
AT
TEXT
state_code
TEXT
city
TEXT
zip_code
TEXT
address
TEXT
active_ingredient_ids
["8ea49977-1aa8-4c64-b7bd-23acb740b346","84bc97bd-9ff2-451e-9b64-8debaf7c925e"]
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
market_key
dachl
TEXT
subscription_markup_percent
INTEGER
subscription_price_per_month
INTEGER
purchase_clicked_at
INTEGER
Update
Cancel