Database normalization - Mailing list pgsql-sql

propel:
  client:
    client_id: {type: integer}

  foo:
    client_id: {type: integer, foreignTable: client, foreignReference: client_id}
    foo_id: {type: integer}

  bar:
    client_id: {type: integer, foreignTable: client, foreignReference: client_id}
    bar_id: {type: integer}

  foobar:
    client_id: {type: integer}
    foo_id: {type: integer}
    bar_id: {type: integer}
    _foreignKeys:
      fk_foo:
        foreignTable: foo
        references:
          - { local: client_id, foreign: client_id }
          - { local: foo_id, foreign: foo_id }
      fk_bar:
        foreignTable: bar
        references:
          - { local: client_id, foreign: client_id }
          - { local: bar_id, foreign: bar_id }