Is there anything wrong with this query in terms of injecting a foreign key into this table?! For some reason Java DB can apply this query with a foreign key!!
CREATE TABLE data
data_ID INT not null primary key
GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
connect_id_FK INT constraint foreign key references portals,
user_name VARCHAR(50) not null,
password VARCHAR(50) not null,