---

This section details on the original issue you should resolve

<issue_title>Foreign key not detected in tables object</issue_title>
<issue_description>I'm having an issue with foreign key detection. I'm creating two tables, let's call them "Table1" and "Table2". Table1 has a primary key called "PK_Table1" on a column named "Column1". Table2 has a foreign key "FK_Table2_Column1" that references "Column1" in "Table1".

When I create the tables and inspect the resulting objects, "Table1" correctly shows "Column1" as having a primary key, but "Table2" does not show "Column1" as having a foreign key. Additionally, when I try to access the "foreignkey" property of "Column1" in "Table2", it doesn't exist.

I've checked the "checks" property of "Table2", and the foreign key constraint appears to be correctly detected and stored there (fk is equal to true and the name of the foreign key is printed, but not the columnid).

Could you please advise on how to properly detect and access foreign keys?

CREATETABLETable1 (    Column1NUMERIC(2,0)NOT NULL,    Column2VARCHAR(50)NOT NULL,    Column3 DATETIMENOT NULL,    Column4 DATETIMENOT NULL,    Column5VARCHAR(50)NOT NULL,    Column6 DATETIMENOT NULL,CONSTRAINT PK_Table1PRIMARY KEY (Column1),CONSTRAINT UC_Column1 UNIQUE (Column1),CONSTRAINT UC_Column3_Column4 UNIQUE (Column3, Column4));CREATETABLETable2 (    Column1NUMERIC(2,0)NOT NULL,    Column2NUMERIC(2,0)NOT NULL,    Column3VARCHAR(300)NOT NULL,    Column4VARCHAR(50)NOT NULL,    Column5 DATETIMENOT NULL,    Column6NUMERIC(4,0)NOT NULL,CONSTRAINT PK_Table2PRIMARY KEY (Column1, Column2),CONSTRAINT UC_PK_Table2 UNIQUE (Column1, Column2),CONSTRAINT FK_Table2_Column1FOREIGN KEY (Column1)REFERENCES Table1(Column1));

JSFiddle:https://jsfiddle.net/rcnv6gfs/</issue_description>

Comments on the Issue (you are@copilot in this section)

@mathiasrwLooks correct to me.@matndev Does this work?