SQL

CREATE TABLE `activeIngredientLocalization`  (
  `id` text PRIMARY KEY,
  `active_ingredient_id` text NOT NULL UNIQUE,
  `validated_at` integer,
  `name_de` text,
  `name_en` text,
  `name_fr` text,
  `name_it` text,
  `name_ru` text,
  `name_ua` text,
  `name_ar` text,
  `name_cs` text,
  `name_es` text,
  `name_hr` text,
  `name_hu` text,
  `name_pl` text,
  `name_pt` text,
  `description_de` text,
  `description_en` text,
  `description_fr` text,
  `description_it` text,
  `description_ru` text,
  `description_ua` text,
  `description_ar` text,
  `description_cs` text,
  `description_es` text,
  `description_hr` text,
  `description_hu` text,
  `description_pl` text,
  `description_pt` text,
  CONSTRAINT `fk_activeIngredientLocalization_active_ingredient_id_activeIngredient_id_fk` FOREIGN KEY (`active_ingredient_id`) REFERENCES `activeIngredient`(`id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT Rename | Drop
active_ingredient_id TEXT Rename | Drop
validated_at INTEGER Rename | Drop
name_de TEXT Rename | Drop
name_en TEXT Rename | Drop
name_fr TEXT Rename | Drop
name_it TEXT Rename | Drop
name_ru TEXT Rename | Drop
name_ua TEXT Rename | Drop
name_ar TEXT Rename | Drop
name_cs TEXT Rename | Drop
name_es TEXT Rename | Drop
name_hr TEXT Rename | Drop
name_hu TEXT Rename | Drop
name_pl TEXT Rename | Drop
name_pt TEXT Rename | Drop
description_de TEXT Rename | Drop
description_en TEXT Rename | Drop
description_fr TEXT Rename | Drop
description_it TEXT Rename | Drop
description_ru TEXT Rename | Drop
description_ua TEXT Rename | Drop
description_ar TEXT Rename | Drop
description_cs TEXT Rename | Drop
description_es TEXT Rename | Drop
description_hr TEXT Rename | Drop
description_hu TEXT Rename | Drop
description_pl TEXT Rename | Drop
description_pt TEXT Rename | Drop

Foreign Keys

Column Destination
active_ingredient_id activeIngredient.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_activeIngredientLocalization_1 id SQL
-- no sql found --
Drop
sqlite_autoindex_activeIngredientLocalization_2 active_ingredient_id SQL
-- no sql found --
Drop