Skip to content

[BUG] Not Correctly Altering Tables For FKs #749

@Troglodyteio

Description

@Troglodyteio

Describe the bug
The Junction Table should have the Many of the Many-to-One. The screen shot shows the Manys (n) around the junction table. But when I export, 14 of the 16 had the Many's on the opposite side.

To Reproduce
Steps to reproduce the behavior:

  1. Started off with Blank slate
  2. Added Junction Tables and Regular Tables
  3. The dragged primary key of Regular Tables To Field that will function as foreign key. (And Vice Versa). Usually the relationship was one to one but fixed to many on the junction table via the references tab.
  4. AI helped me figure out why i couldn't import that which i just exported.

Expected behavior
FK schema should update

Screenshots

BeforeFKFix.sql
ForeignKeyTossUp.sql
Image

Desktop (please complete the following information):

  • OS: Windows 11 Pro Windows Feature Experience Pack 1000.26100.265.0
  • Browser Edge Version 142.0.3595.53 (Official build) (64-bit)

Additional context
Add any other context about the problem here. If the bug involves the import feature, please, attach the imported file.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions