- [name] TEXT NOT NULL,
- [quantity_id] INTEGER,
- [output_step_id] INTEGER NOT NULL,
- [input_step_id] INTEGER NOT NULL,
-
- FOREIGN KEY([quantity_id]) REFERENCES [Quantity]([id]) ON DELETE CASCADE,
- FOREIGN KEY([output_step_id]) REFERENCES [Step]([id]) ON DELETE CASCADE,
- FOREIGN KEY([input_step_id]) REFERENCES [Step]([id]) ON DELETE CASCADE
-);
+ [name] TEXT NOT NULL DEFAULT '',
+ [quantity_value] REAL,
+ [quantity_unit] TEXT NOT NULL DEFAULT '',
+ [output_group_id] INTEGER NOT NULL,
+ [input_group_id] INTEGER NOT NULL,
+
+ FOREIGN KEY([output_group_id]) REFERENCES [group]([id]) ON DELETE CASCADE,
+ FOREIGN KEY([input_group_id]) REFERENCES [group]([id]) ON DELETE CASCADE
+) STRICT;