Symfony 1.4 Propel:我定义了，但外键不是'；t在表中定义 - Symfony 1.4 Propel: I defined, but foreign keys isn't defined in tables

Symfony 1.4 Propel: I defined, but foreign keys isn't defined in tables

本文关键字：定义 Propel Symfony | 更新日期: 2023-09-27

让我们看看这个模式：

  orders:
    _attributes:    { phpName: Orders, default_table_charset: utf8, default_table_collate: utf8_general_ci }
    id:             ~
    category_id:    { type: integer, size: '10', required: true, defaultvalue: '0', foreigntable: categories, foreignreference: id }
    whatisthis:     { type: longvarchar, required: false }
  categories:
    _attributes: { phpName: Categories }
    id:          ~
    name:        { type: varchar, size: '255', required: true, defaultvalue: '' }
    _uniques:    { index_name: [name] }

我发现表中没有定义外键。Im使用innoDB，因此PKs是可能的。或者Propel不应该设置外键？

"foreigntable"answers"foreignreference。category_id的大小应该等于类别的id的大小。

  orders:
    _attributes:    { phpName: Orders, default_table_charset: utf8, default_table_collate: utf8_general_ci }
    id:             ~
    category_id:    { type: integer, size: '10', required: true, defaultvalue: '0', foreignTable: categories, foreignreRerence: id }
    whatisthis:     { type: longvarchar, required: false }
  categories:
    _attributes: { phpName: Categories }
    id:          ~
    name:        { type: varchar, size: '255', required: true, defaultvalue: '' }
    _uniques:    { index_name: [name] }

您使用的是哪种符号和推进版本？

假设使用Propel 1.x，这里有一个一对多关系的例子：


  musician:
    _attributes: { phpName: Musician }
    id: { phpName: Id, type: INTEGER, size: '9', primaryKey: true, autoIncrement: true, required: true }
    #other fields
  musician_album:
    _attributes: { phpName: MusicianAlbum }
    id: { phpName: Id, type: INTEGER, size: '9', primaryKey: true, autoIncrement: true, required: true }
    musician_id: { phpName: MusicianId, type: INTEGER, size: '9', required: true, foreignTable: musician, foreignReference: id, onDelete: CASCADE, onUpdate: CASCADE }
    #other fields
    _indexes: { musician_id: [musician_id] }

老实说，我更喜欢手动创建数据库表（设置、索引、外键等），然后使用symfony（假设您使用的是symfony 1.x）任务来创建模式：

symfony propel:build-schema