{"action":"created","issue":{"url":"https://api.github.com/repos/schemaspy/schemaspy/issues/140","repository_url":"https://api.github.com/repos/schemaspy/schemaspy","labels_url":"https://api.github.com/repos/schemaspy/schemaspy/issues/140/labels{/name}","comments_url":"https://api.github.com/repos/schemaspy/schemaspy/issues/140/comments","events_url":"https://api.github.com/repos/schemaspy/schemaspy/issues/140/events","html_url":"https://github.com/schemaspy/schemaspy/issues/140","id":252030676,"number":140,"title":"Different inclusions of Implied Relationships compared to SchemaSpy 5.","user":{"login":"juillen","id":31252244,"avatar_url":"https://avatars0.githubusercontent.com/u/31252244?v=4","gravatar_id":"","url":"https://api.github.com/users/juillen","html_url":"https://github.com/juillen","followers_url":"https://api.github.com/users/juillen/followers","following_url":"https://api.github.com/users/juillen/following{/other_user}","gists_url":"https://api.github.com/users/juillen/gists{/gist_id}","starred_url":"https://api.github.com/users/juillen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juillen/subscriptions","organizations_url":"https://api.github.com/users/juillen/orgs","repos_url":"https://api.github.com/users/juillen/repos","events_url":"https://api.github.com/users/juillen/events{/privacy}","received_events_url":"https://api.github.com/users/juillen/received_events","type":"User","site_admin":false},"labels":[{"id":502244353,"url":"https://api.github.com/repos/schemaspy/schemaspy/labels/needs%20investigation","name":"needs investigation","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-08-22T17:22:32Z","updated_at":"2017-10-14T19:12:11Z","closed_at":null,"author_association":"NONE","body":"When analysing the schema of a database (from the dark ages, just taking it over), two different results are obtained between SchemaSpy 5 and SchemaSpy 6 (SchemaSpy 6 is missing some tables).\r\nFrom the enclosed files, it can be seen that in V5, the table \"patient\" is correctly identified as an Implied Relationship.\r\nV6 however treats it as an Orphaned table.\r\nIncluding implied compact and large for examples.\r\n\r\n![relationships implied compact v5](https://user-images.githubusercontent.com/31252244/29578218-6f42f630-8766-11e7-8895-95c5ff6afe42.png)\r\n![relationships implied compact v6](https://user-images.githubusercontent.com/31252244/29578224-72cb644a-8766-11e7-8308-cee88e8097b8.png)\r\n![relationships implied large v5](https://user-images.githubusercontent.com/31252244/29578225-7573875e-8766-11e7-9ef2-14f4bf23cbe8.png)\r\n![relationships implied large v6](https://user-images.githubusercontent.com/31252244/29578231-783926a6-8766-11e7-8676-a63abe3b09d3.png)\r\n"},"comment":{"url":"https://api.github.com/repos/schemaspy/schemaspy/issues/comments/336659985","html_url":"https://github.com/schemaspy/schemaspy/issues/140#issuecomment-336659985","issue_url":"https://api.github.com/repos/schemaspy/schemaspy/issues/140","id":336659985,"user":{"login":"ismailsimsek","id":6005685,"avatar_url":"https://avatars3.githubusercontent.com/u/6005685?v=4","gravatar_id":"","url":"https://api.github.com/users/ismailsimsek","html_url":"https://github.com/ismailsimsek","followers_url":"https://api.github.com/users/ismailsimsek/followers","following_url":"https://api.github.com/users/ismailsimsek/following{/other_user}","gists_url":"https://api.github.com/users/ismailsimsek/gists{/gist_id}","starred_url":"https://api.github.com/users/ismailsimsek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ismailsimsek/subscriptions","organizations_url":"https://api.github.com/users/ismailsimsek/orgs","repos_url":"https://api.github.com/users/ismailsimsek/repos","events_url":"https://api.github.com/users/ismailsimsek/events{/privacy}","received_events_url":"https://api.github.com/users/ismailsimsek/received_events","type":"User","site_admin":false},"created_at":"2017-10-14T19:12:11Z","updated_at":"2017-10-14T19:12:11Z","author_association":"COLLABORATOR","body":"i believe this line is exluding PKs and FKs from being implied FK, that must be the reason.\r\n\r\nhttps://github.com/schemaspy/schemaspy/blob/7f9c7a3afd2850a00befc9cecb41ba278ef0f751/src/main/java/org/schemaspy/DbAnalyzer.java#L53"}}
{"actor":{"display_login":"ismailsimsek"}}