Query

sqlite.db — activeIngredient

SQL

CREATE TABLE `activeIngredient`  (
  `id` text PRIMARY KEY,
  `created_at` integer DEFAULT (CURRENT_TIMESTAMP),
  `validated_at` integer,
  `duplicates_id` text,
  `name` text,
  `unit_id` text,
  `available_amounts` text,
  `popularity` integer,
  CONSTRAINT `fk_activeIngredient_duplicates_id_activeIngredient_id_fk` FOREIGN KEY (`duplicates_id`) REFERENCES `activeIngredient`(`id`),
  CONSTRAINT `fk_activeIngredient_unit_id_unit_id_fk` FOREIGN KEY (`unit_id`) REFERENCES `unit`(`id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
created_at INTEGER ✓ Rename | Drop
validated_at INTEGER ✓ Rename | Drop
duplicates_id TEXT ✓ Rename | Drop
name TEXT ✓ Rename | Drop
unit_id TEXT ✓ Rename | Drop
available_amounts TEXT ✓ Rename | Drop
popularity INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
unit_id unit.id
duplicates_id activeIngredient.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_activeIngredient_1 id ✓ SQL
-- no sql found --
 Drop