{"action":"created","issue":{"url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/106","repository_url":"https://api.github.com/repos/OHDSI/CommonDataModel","labels_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/106/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/106/comments","events_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/106/events","html_url":"https://github.com/OHDSI/CommonDataModel/issues/106","id":251868107,"number":106,"title":"Comments in ddl tables & liquibase use","user":{"login":"parisni","id":9535350,"avatar_url":"https://avatars1.githubusercontent.com/u/9535350?v=4","gravatar_id":"","url":"https://api.github.com/users/parisni","html_url":"https://github.com/parisni","followers_url":"https://api.github.com/users/parisni/followers","following_url":"https://api.github.com/users/parisni/following{/other_user}","gists_url":"https://api.github.com/users/parisni/gists{/gist_id}","starred_url":"https://api.github.com/users/parisni/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/parisni/subscriptions","organizations_url":"https://api.github.com/users/parisni/orgs","repos_url":"https://api.github.com/users/parisni/repos","events_url":"https://api.github.com/users/parisni/events{/privacy}","received_events_url":"https://api.github.com/users/parisni/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-08-22T07:53:04Z","updated_at":"2017-10-05T21:05:02Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nI find useful to give table & field comment inside the ddl [here postgresql one](https://www.postgresql.org/docs/9.6/static/sql-comment.html). \r\nThis also helps the users to use the model.\r\n\r\nI know this represent a uge work to maintain the comment for each database.\r\nThat is why I recommend using [liquibase](http://www.liquibase.org/) this process to generate the ddl:\r\n\r\n1. maintain a main liquibase script\r\n2. generate each database ddl from the one\r\n3. create a special script  to translate from postgres to special databases (such impala)\r\n\r\n\r\nLiquibase has several advantages such:\r\n- maintaining only one main script\r\n- being able to generate other ddl such mysql, [and so on](http://www.liquibase.org/databases.html)\r\n- has it's one version control process\r\n\r\nthanks"},"comment":{"url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/comments/334591815","html_url":"https://github.com/OHDSI/CommonDataModel/issues/106#issuecomment-334591815","issue_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/106","id":334591815,"user":{"login":"vojtechhuser","id":7526119,"avatar_url":"https://avatars1.githubusercontent.com/u/7526119?v=4","gravatar_id":"","url":"https://api.github.com/users/vojtechhuser","html_url":"https://github.com/vojtechhuser","followers_url":"https://api.github.com/users/vojtechhuser/followers","following_url":"https://api.github.com/users/vojtechhuser/following{/other_user}","gists_url":"https://api.github.com/users/vojtechhuser/gists{/gist_id}","starred_url":"https://api.github.com/users/vojtechhuser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vojtechhuser/subscriptions","organizations_url":"https://api.github.com/users/vojtechhuser/orgs","repos_url":"https://api.github.com/users/vojtechhuser/repos","events_url":"https://api.github.com/users/vojtechhuser/events{/privacy}","received_events_url":"https://api.github.com/users/vojtechhuser/received_events","type":"User","site_admin":false},"created_at":"2017-10-05T21:05:02Z","updated_at":"2017-10-05T21:05:02Z","author_association":"COLLABORATOR","body":"I would like to try it for the metadata table. (try the whole process for one table)."}}
{"actor":{"display_login":"vojtechhuser"}}