A TableIndex can be created directly from a Blueprint or from a existing Column. The TableIndex includes methods for further configuring the index which is required when defining foreign keys.
references
Set the referencing column for a foreign key relationship. For example, id for a country_id column.
CREATETABLE `users` (`country_id`INTEGER UNSIGNED NOT NULL, CONSTRAINT `fk_users_country_id` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
onTable
Sets the referencing table for a foreign key relationship. For example, countries for a country_id column.
CREATETABLE `users` (`country_id`INTEGER UNSIGNED NOT NULL, CONSTRAINT `fk_users_country_id` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
onUpdate
Set the strategy for updating foreign keys when the parent key is updated.
CREATETABLE `users` (`country_id`INTEGER UNSIGNED NOT NULL, CONSTRAINT `fk_users_country_id` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON UPDATE NO ACTION ON DELETE SET NULL
)