Query

sqlite.db — survey

SQL

CREATE TABLE `survey`  (
  `id` text PRIMARY KEY,
  `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 DEFAULT '[]' NOT NULL,
  `selected_amount_by_active_ingredient_id` text DEFAULT '{}' NOT NULL,
  `active_ingredient_spending_config` text DEFAULT '{}' NOT NULL,
  `spending_by_active_ingredient_id` text DEFAULT '{}' NOT NULL,
  `time_per_dose_by_active_ingredient_id` text DEFAULT '{}' NOT NULL,
  `step_time_spent_seconds_by_step` text DEFAULT '{}' NOT NULL,
  `completed_step_numbers` text DEFAULT '[]' NOT NULL,
  `requested_active_ingredients` text DEFAULT '[]' NOT NULL,
  `last_partial_update_at` integer,
  `consent_to_contact` integer DEFAULT false,
  CONSTRAINT `fk_survey_user_id_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
user_id TEXT ✓ Rename | Drop
created_at INTEGER ✓ Rename | Drop
updated_at INTEGER ✓ Rename | Drop
completed_at INTEGER ✓ Rename | Drop
current_step INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
email TEXT ✓ Rename | Drop
sex TEXT ✓ Rename | Drop
birthdate TEXT ✓ Rename | Drop
exercise_level INTEGER ✓ Rename | Drop
country_code TEXT ✓ Rename | Drop
state_code TEXT ✓ Rename | Drop
city TEXT ✓ Rename | Drop
zip_code TEXT ✓ Rename | Drop
address TEXT ✓ Rename | Drop
active_ingredient_ids TEXT Rename | Drop
selected_amount_by_active_ingredient_id TEXT Rename | Drop
active_ingredient_spending_config TEXT Rename | Drop
spending_by_active_ingredient_id TEXT Rename | Drop
time_per_dose_by_active_ingredient_id TEXT Rename | Drop
step_time_spent_seconds_by_step TEXT Rename | Drop
completed_step_numbers TEXT Rename | Drop
requested_active_ingredients TEXT Rename | Drop
last_partial_update_at INTEGER ✓ Rename | Drop
consent_to_contact INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
user_id user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_survey_1 id ✓ SQL
-- no sql found --
 Drop
survey_user_id_idx user_id SQL 
CREATE INDEX `survey_user_id_idx`
ON `survey` (`user_id`)
Drop