您可以与 Symfony 建立关系（使用 Doctrine）吗？

Question

目前，如果我执行以下操作，它只会生成 schema.yml：

./symfony 学说：构建模式

但这并不会生成关系。

我是否必须手动将它们添加到 schema.yml 中，还是有办法生成它们？如果我必须手动输入它，那么下次我执行 doctrine:build-schema（用新表刷新架构等）时它们不会被覆盖吗？

这是 schema.yml：

Companies:
  connection: doctrine
  tableName: companies
  columns:
    company_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    company_name:
      type: string(100)
      fixed: false
          unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    company_logo:
      type: string(100)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    company_date_added:
      type: timestamp(25)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
Credentials:
  connection: doctrine
  tableName: credentials
  columns:
    credential_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    credential_name:
      type: string(100)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    company_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    credential_date_added:
      type: timestamp(25)
      fixed: false
      unsigned: false
      primary: false
      default: '0000-00-00 00:00:00'
      notnull: true
      autoincrement: false
Groups:
  connection: doctrine
  tableName: groups
  columns:
    group_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    group_name:
      type: string(100)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    company_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    group_date_added:
      type: timestamp(25)
      fixed: false
      unsigned: false
      primary: false
      default: '0000-00-00 00:00:00'
      notnull: true
      autoincrement: false
GroupsCredentials:
  connection: doctrine
  tableName: groups_credentials
  columns:
    group_credential_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    group_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    credential_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    group_credential_date_added:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
Users:
  connection: doctrine
  tableName: users
  columns:
    user_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    user_username:
      type: string(100)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    user_password:
      type: string(100)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    user_email:
      type: string(100)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    company_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    user_date_added:
      type: timestamp(25)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
UsersCredentials:
  connection: doctrine
  tableName: users_credentials
  columns:
    user_credential_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    user_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    credential_id:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    user_credential_date_added:
      type: timestamp(25)
      fixed: false
      unsigned: false
      primary: false
      default: '0000-00-00 00:00:00'
      notnull: true
      autoincrement: false

Answer 1

我最终解决了这个问题。

MySQL 数据库中的关系没有正确设置 - 我犯了一个愚蠢的错误。