定义上:
innodb permits a foreign key to reference any index column or group of columns. However, in the referenced table, there must be an index where the referenced columns are listed as the first columns in the same order.
允许参照一个索引列或者一组列,一组列的第一个必须是索引。
InnoDB does not currently support foreign keys for tables with user-defined partitioning. This means that no user-partitioned InnoDB table may contain foreign key references or columns referenced by foreign keys.
innodb不支持用户定义的分区表,即分区的innodb表中不能有外键或者被其他键参照。
InnoDB allows a foreign key constraint to reference a non-unique key. This is an InnoDB extension to standard SQL.
innodb允许参照一个非唯一索引。
总的来说innodb的外键参照可以是主键、索引、非唯一索引<