I hope this helps anyone facing the same problem.
Go to vendor website Adminer Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Note that the syntax of the command is different and that the data type is no longer INTEGER, but BIGINT UNSIGNED.Īfter doing these changes, my problem was solved. SchemaSpy is a Java-based free and open source tool that generates interactive entity-relationship diagrams to HTML from database schema metadata analysis. I had to change the last command of the query as follow: CREATE TABLE account_job(įOREIGN KEY (user_id) REFERENCES account(user_id),įOREIGN KEY (job_id) REFERENCES job(job_id), It will generate the whole DDL for the database/schema with several available options. This query executes without errors while using PostgresSQL and MYSQL, but for MYSQL, the relation between the tables won't display or won't work. User_id INTEGER REFERENCES account(user_id), Created Ap01:17 Comment actions I don't know what was the version of DataGrip but it was the latest on the site. Lets look at a diagram that shows the workflow of a git branch and merge.
# now a table which connects the two above The queries I used to create the tables in postgresSQL are: CREATE TABLE account(
#DATAGRIP GENERATE DIAGRAM SERIAL#
Then I compared the data types of the tables between my two databases: postgresSQL and MYSQL, I then realized that at the moment when creating my primary key, I used the SERIAL data type, and postgresSQL sets it as INTEGER data type, while MYSQL sets it as BIGINT UNSIGNED. I used the Diagramm tool from DataGrip to visualize it.
For me, everything worked when using postgresSQL as a database, but when I switched to MYSQL, and after executing the same queries to create the tables in postgresSQL, the relation between the tables weren't showing any more.
0 kommentar(er)
