Consider the bellowing case:
- at you define a
relationship on a MS Office Visio database model, you select
the same column from a table as the primary key column and the same column as the foreign key column. - You extract the database
schema from the database by using reverse engineering. - You valitime the
database schema on MS Visio for Enterprise Architects.
In the case, you receive the
bellowing unrecoverable error symptoms on the output pane:
unrecoverable error
L3022: Self-referencing foreign key column
'Table_name.Column_name' cannot exist as both a
parent and a child on the same relationship.
error message: error