{"action":"created","issue":{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/104","labels_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/104/labels{/name}","comments_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/104/comments","events_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/104/events","html_url":"https://github.com/ondras/wwwsqldesigner/issues/104","id":67106941,"number":104,"title":"SQLAlchemy issues & my improvement needs more test","user":{"login":"ondras","id":192172,"avatar_url":"https://avatars.githubusercontent.com/u/192172?v=3","gravatar_id":"","url":"https://api.github.com/users/ondras","html_url":"https://github.com/ondras","followers_url":"https://api.github.com/users/ondras/followers","following_url":"https://api.github.com/users/ondras/following{/other_user}","gists_url":"https://api.github.com/users/ondras/gists{/gist_id}","starred_url":"https://api.github.com/users/ondras/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ondras/subscriptions","organizations_url":"https://api.github.com/users/ondras/orgs","repos_url":"https://api.github.com/users/ondras/repos","events_url":"https://api.github.com/users/ondras/events{/privacy}","received_events_url":"https://api.github.com/users/ondras/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/labels/imported","name":"imported","color":"FFFFFF"},{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/labels/Priority-Medium","name":"Priority-Medium","color":"FFFFFF"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-08T11:21:06Z","updated_at":"2015-04-08T11:21:07Z","closed_at":null,"body":"_From [jobinso...@gmail.com](https://code.google.com/u/109624781134515916616/) on May 26, 2010 09:00:09_\n\nrecently, i have work hard for a complex database with sqlalchemy.\r\nand i make use of wwwsqldesigner.\r\nbut i found that the sqlalchemy db in wwwsqldesigner use old datatype and .\r\n\r\nso i rewrite the datatype.xml and the output.xsl  , anyone who would like\r\nit please test for it.\r\n\r\nneeds to do:\r\n1,the association table : at present, the wwwsqldesigner have too poor\r\nability to solve this problem. all the relation to table and the relation\r\nto column have the same xml output :\r\n\\<relation table=\"tablename\" row=\"tablerow\" />\r\n\r\nmore advice for wwwsqldesigner:\r\n1,comment is very important, even in the large database system. so maybe it\r\nneeds to appear in the main window.\r\n2,the datatype name may need local name for internationality.\n\n**Attachment:** [datatypes.xml output.xsl](http://code.google.com/p/wwwsqldesigner/issues/detail?id=97)\n\n_Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=97_"},"comment":{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/comments/90883105","html_url":"https://github.com/ondras/wwwsqldesigner/issues/104#issuecomment-90883105","issue_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/104","id":90883105,"user":{"login":"ondras","id":192172,"avatar_url":"https://avatars.githubusercontent.com/u/192172?v=3","gravatar_id":"","url":"https://api.github.com/users/ondras","html_url":"https://github.com/ondras","followers_url":"https://api.github.com/users/ondras/followers","following_url":"https://api.github.com/users/ondras/following{/other_user}","gists_url":"https://api.github.com/users/ondras/gists{/gist_id}","starred_url":"https://api.github.com/users/ondras/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ondras/subscriptions","organizations_url":"https://api.github.com/users/ondras/orgs","repos_url":"https://api.github.com/users/ondras/repos","events_url":"https://api.github.com/users/ondras/events{/privacy}","received_events_url":"https://api.github.com/users/ondras/received_events","type":"User","site_admin":false},"created_at":"2015-04-08T11:21:07Z","updated_at":"2015-04-08T11:21:07Z","body":"_From [ondrej.zara](https://code.google.com/u/ondrej.zara/) on May 26, 2010 03:31:23_\n\nI do not understand the point about \"the association table\". All DB relations (more\r\nprecisely: foreign key constraints) always connect a column to column, never column\r\nto table. What is the behaviour you would like to have?"}}