foreign method

ColumnDefinition foreign(String column, { required String references, required String on, String onDelete = 'CASCADE', String onUpdate = 'CASCADE', })

Adds a foreign key column referencing another table.

table.foreign('user_id', references: 'id', on: 'users');

Implementation

ColumnDefinition foreign(String column, {
  required String references,
  required String on,
  String onDelete = 'CASCADE',
  String onUpdate = 'CASCADE',
}) {
  final col = integer(column);
  _constraints.add(
    'FOREIGN KEY ("${Schema._sanitize(column)}") '
    'REFERENCES "${Schema._sanitize(on)}" ("${Schema._sanitize(references)}") '
    'ON DELETE $onDelete ON UPDATE $onUpdate'
  );
  return col;
}