Regressed drag-and-drop experience when creating relationships

[croblesm]

The current drag-and-drop interaction for building relationships between tables in Schema Designer has regressed in usability compared to the previous version.

Previously, dragging from a column that was intended to be a foreign key would visually display an arrow, making the interaction more intuitive and accurate.

In the current experience:

• Users must drag from tiny circular dots with minimal affordance.
• A cross symbol appears, but the interaction target is too small, requiring excessive precision.
• It is easy to misplace or fail to connect the relationship due to the reduced hitbox and lack of clear visual feedback.

This makes the relationship-building process cumbersome, especially when working with multiple tables or complex schemas.

Screen.Recording.2025-04-08.at.9.37.47.PM.mov

Expected Behavior:

• Drag-and-drop affordance should be more user-friendly and forgiving.
• Visual indicators such as arrows or connection previews should be restored to guide the relationship creation process more intuitively.
• Hitboxes for connection points should be larger.

cc @yoleichen

[yoleichen]

changing this to P1 since it requires more work on the UX library side