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
lol@lol.lol
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","143ad929-1b82-4146-8d5c-a7b4fe4b32b8","d39e5d26-cbe5-42bd-aa92-9447a65402e5"]
TEXT NOT NULL (default '[]'
selected_amount_by_active_ingredient_id
{"8ea49977-1aa8-4c64-b7bd-23acb740b346":"600","143ad929-1b82-4146-8d5c-a7b4fe4b32b8":"600","84bc97bd-9ff2-451e-9b64-8debaf7c925e":"300","d39e5d26-cbe5-42bd-aa92-9447a65402e5":"12"}
TEXT NOT NULL (default '{}'
active_ingredient_spending_config
{"8ea49977-1aa8-4c64-b7bd-23acb740b346":{"pillsPerBottle":90,"pillsPerDay":1,"pricePerBottle":29.99},"143ad929-1b82-4146-8d5c-a7b4fe4b32b8":{"pillsPerBottle":90,"pillsPerDay":1,"pricePerBottle":29.99},"84bc97bd-9ff2-451e-9b64-8debaf7c925e":{"pillsPerBottle":90,"pillsPerDay":1,"pricePerBottle":29.99},"d39e5d26-cbe5-42bd-aa92-9447a65402e5":{"pillsPerBottle":90,"pillsPerDay":1,"pricePerBottle":29.99}}
TEXT NOT NULL (default '{}'
spending_by_active_ingredient_id
{"8ea49977-1aa8-4c64-b7bd-23acb740b346":10,"143ad929-1b82-4146-8d5c-a7b4fe4b32b8":10,"84bc97bd-9ff2-451e-9b64-8debaf7c925e":10,"d39e5d26-cbe5-42bd-aa92-9447a65402e5":10}
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