{"action":"created","comment":{"url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/comments/275820070","pull_request_review_id":227222747,"id":275820070,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDI3NTgyMDA3MA==","diff_hunk":"@@ -23,10 +23,10 @@ create unlogged table if not exists ${BIODATA_SCHEMA_NAME}.biodata_site\n ,site_type_cd                   character varying(7)\n ,site_type_long_name            character varying(40)\n ,tz_cd                          character varying(6)\n-,local_time_fg                  boolean\n+,local_time_fg                  character varying(1)","path":"liquibase/changeLogs/biodata/tables/biodataSite/biodataSite.sql","position":5,"original_position":5,"commit_id":"695b9f7a6576061686223660919140cc0f745697","original_commit_id":"695b9f7a6576061686223660919140cc0f745697","user":{"login":"ssoper-usgs","id":22546918,"node_id":"MDQ6VXNlcjIyNTQ2OTE4","avatar_url":"https://avatars2.githubusercontent.com/u/22546918?v=4","gravatar_id":"","url":"https://api.github.com/users/ssoper-usgs","html_url":"https://github.com/ssoper-usgs","followers_url":"https://api.github.com/users/ssoper-usgs/followers","following_url":"https://api.github.com/users/ssoper-usgs/following{/other_user}","gists_url":"https://api.github.com/users/ssoper-usgs/gists{/gist_id}","starred_url":"https://api.github.com/users/ssoper-usgs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ssoper-usgs/subscriptions","organizations_url":"https://api.github.com/users/ssoper-usgs/orgs","repos_url":"https://api.github.com/users/ssoper-usgs/repos","events_url":"https://api.github.com/users/ssoper-usgs/events{/privacy}","received_events_url":"https://api.github.com/users/ssoper-usgs/received_events","type":"User","site_admin":false},"body":"Thanks for pointing out - this is a carryover from using Oracle source data for my test data files.  I needed to set these to something that wouldn't break my tests so I could keep moving forward (suppose I could have just set my source data to True or False too).  Now that we have biodata source data in postgres, I see we are now setting those values that used to be Y or N to True and False.  I will make the change!","created_at":"2019-04-16T14:15:00Z","updated_at":"2019-04-16T14:15:01Z","html_url":"https://github.com/NWQMC/schema-biodata/pull/4#discussion_r275820070","pull_request_url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4","author_association":"NONE","_links":{"self":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/comments/275820070"},"html":{"href":"https://github.com/NWQMC/schema-biodata/pull/4#discussion_r275820070"},"pull_request":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4"}},"in_reply_to_id":275784327},"pull_request":{"url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4","id":270660653,"node_id":"MDExOlB1bGxSZXF1ZXN0MjcwNjYwNjUz","html_url":"https://github.com/NWQMC/schema-biodata/pull/4","diff_url":"https://github.com/NWQMC/schema-biodata/pull/4.diff","patch_url":"https://github.com/NWQMC/schema-biodata/pull/4.patch","issue_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues/4","number":4,"state":"open","locked":false,"title":"Refactor Biodata ETL- postgres to postgres - MonitoringLocation","user":{"login":"ssoper-usgs","id":22546918,"node_id":"MDQ6VXNlcjIyNTQ2OTE4","avatar_url":"https://avatars2.githubusercontent.com/u/22546918?v=4","gravatar_id":"","url":"https://api.github.com/users/ssoper-usgs","html_url":"https://github.com/ssoper-usgs","followers_url":"https://api.github.com/users/ssoper-usgs/followers","following_url":"https://api.github.com/users/ssoper-usgs/following{/other_user}","gists_url":"https://api.github.com/users/ssoper-usgs/gists{/gist_id}","starred_url":"https://api.github.com/users/ssoper-usgs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ssoper-usgs/subscriptions","organizations_url":"https://api.github.com/users/ssoper-usgs/orgs","repos_url":"https://api.github.com/users/ssoper-usgs/repos","events_url":"https://api.github.com/users/ssoper-usgs/events{/privacy}","received_events_url":"https://api.github.com/users/ssoper-usgs/received_events","type":"User","site_admin":false},"body":"","created_at":"2019-04-15T20:27:53Z","updated_at":"2019-04-16T14:15:01Z","closed_at":null,"merged_at":null,"merge_commit_sha":"07af4ea06840e826997fc3000e891253f3fcc8d9","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4/commits","review_comments_url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4/comments","review_comment_url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/comments{/number}","comments_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues/4/comments","statuses_url":"https://api.github.com/repos/NWQMC/schema-biodata/statuses/695b9f7a6576061686223660919140cc0f745697","head":{"label":"NWQMC:postgres","ref":"postgres","sha":"695b9f7a6576061686223660919140cc0f745697","user":{"login":"NWQMC","id":34043503,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM0MDQzNTAz","avatar_url":"https://avatars2.githubusercontent.com/u/34043503?v=4","gravatar_id":"","url":"https://api.github.com/users/NWQMC","html_url":"https://github.com/NWQMC","followers_url":"https://api.github.com/users/NWQMC/followers","following_url":"https://api.github.com/users/NWQMC/following{/other_user}","gists_url":"https://api.github.com/users/NWQMC/gists{/gist_id}","starred_url":"https://api.github.com/users/NWQMC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NWQMC/subscriptions","organizations_url":"https://api.github.com/users/NWQMC/orgs","repos_url":"https://api.github.com/users/NWQMC/repos","events_url":"https://api.github.com/users/NWQMC/events{/privacy}","received_events_url":"https://api.github.com/users/NWQMC/received_events","type":"Organization","site_admin":false},"repo":{"id":112530671,"node_id":"MDEwOlJlcG9zaXRvcnkxMTI1MzA2NzE=","name":"schema-biodata","full_name":"NWQMC/schema-biodata","private":false,"owner":{"login":"NWQMC","id":34043503,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM0MDQzNTAz","avatar_url":"https://avatars2.githubusercontent.com/u/34043503?v=4","gravatar_id":"","url":"https://api.github.com/users/NWQMC","html_url":"https://github.com/NWQMC","followers_url":"https://api.github.com/users/NWQMC/followers","following_url":"https://api.github.com/users/NWQMC/following{/other_user}","gists_url":"https://api.github.com/users/NWQMC/gists{/gist_id}","starred_url":"https://api.github.com/users/NWQMC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NWQMC/subscriptions","organizations_url":"https://api.github.com/users/NWQMC/orgs","repos_url":"https://api.github.com/users/NWQMC/repos","events_url":"https://api.github.com/users/NWQMC/events{/privacy}","received_events_url":"https://api.github.com/users/NWQMC/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/NWQMC/schema-biodata","description":null,"fork":false,"url":"https://api.github.com/repos/NWQMC/schema-biodata","forks_url":"https://api.github.com/repos/NWQMC/schema-biodata/forks","keys_url":"https://api.github.com/repos/NWQMC/schema-biodata/keys{/key_id}","collaborators_url":"https://api.github.com/repos/NWQMC/schema-biodata/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/NWQMC/schema-biodata/teams","hooks_url":"https://api.github.com/repos/NWQMC/schema-biodata/hooks","issue_events_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues/events{/number}","events_url":"https://api.github.com/repos/NWQMC/schema-biodata/events","assignees_url":"https://api.github.com/repos/NWQMC/schema-biodata/assignees{/user}","branches_url":"https://api.github.com/repos/NWQMC/schema-biodata/branches{/branch}","tags_url":"https://api.github.com/repos/NWQMC/schema-biodata/tags","blobs_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/refs{/sha}","trees_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/trees{/sha}","statuses_url":"https://api.github.com/repos/NWQMC/schema-biodata/statuses/{sha}","languages_url":"https://api.github.com/repos/NWQMC/schema-biodata/languages","stargazers_url":"https://api.github.com/repos/NWQMC/schema-biodata/stargazers","contributors_url":"https://api.github.com/repos/NWQMC/schema-biodata/contributors","subscribers_url":"https://api.github.com/repos/NWQMC/schema-biodata/subscribers","subscription_url":"https://api.github.com/repos/NWQMC/schema-biodata/subscription","commits_url":"https://api.github.com/repos/NWQMC/schema-biodata/commits{/sha}","git_commits_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/commits{/sha}","comments_url":"https://api.github.com/repos/NWQMC/schema-biodata/comments{/number}","issue_comment_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues/comments{/number}","contents_url":"https://api.github.com/repos/NWQMC/schema-biodata/contents/{+path}","compare_url":"https://api.github.com/repos/NWQMC/schema-biodata/compare/{base}...{head}","merges_url":"https://api.github.com/repos/NWQMC/schema-biodata/merges","archive_url":"https://api.github.com/repos/NWQMC/schema-biodata/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/NWQMC/schema-biodata/downloads","issues_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues{/number}","pulls_url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls{/number}","milestones_url":"https://api.github.com/repos/NWQMC/schema-biodata/milestones{/number}","notifications_url":"https://api.github.com/repos/NWQMC/schema-biodata/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/NWQMC/schema-biodata/labels{/name}","releases_url":"https://api.github.com/repos/NWQMC/schema-biodata/releases{/id}","deployments_url":"https://api.github.com/repos/NWQMC/schema-biodata/deployments","created_at":"2017-11-29T21:37:08Z","updated_at":"2019-04-09T19:00:24Z","pushed_at":"2019-04-15T20:27:54Z","git_url":"git://github.com/NWQMC/schema-biodata.git","ssh_url":"git@github.com:NWQMC/schema-biodata.git","clone_url":"https://github.com/NWQMC/schema-biodata.git","svn_url":"https://github.com/NWQMC/schema-biodata","homepage":null,"size":41,"stargazers_count":0,"watchers_count":0,"language":"PLpgSQL","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":1,"license":null,"forks":4,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"NWQMC:master","ref":"master","sha":"c5360e6ccb8eac86a105ebb701c8ff64421c1ea2","user":{"login":"NWQMC","id":34043503,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM0MDQzNTAz","avatar_url":"https://avatars2.githubusercontent.com/u/34043503?v=4","gravatar_id":"","url":"https://api.github.com/users/NWQMC","html_url":"https://github.com/NWQMC","followers_url":"https://api.github.com/users/NWQMC/followers","following_url":"https://api.github.com/users/NWQMC/following{/other_user}","gists_url":"https://api.github.com/users/NWQMC/gists{/gist_id}","starred_url":"https://api.github.com/users/NWQMC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NWQMC/subscriptions","organizations_url":"https://api.github.com/users/NWQMC/orgs","repos_url":"https://api.github.com/users/NWQMC/repos","events_url":"https://api.github.com/users/NWQMC/events{/privacy}","received_events_url":"https://api.github.com/users/NWQMC/received_events","type":"Organization","site_admin":false},"repo":{"id":112530671,"node_id":"MDEwOlJlcG9zaXRvcnkxMTI1MzA2NzE=","name":"schema-biodata","full_name":"NWQMC/schema-biodata","private":false,"owner":{"login":"NWQMC","id":34043503,"node_id":"MDEyOk9yZ2FuaXphdGlvbjM0MDQzNTAz","avatar_url":"https://avatars2.githubusercontent.com/u/34043503?v=4","gravatar_id":"","url":"https://api.github.com/users/NWQMC","html_url":"https://github.com/NWQMC","followers_url":"https://api.github.com/users/NWQMC/followers","following_url":"https://api.github.com/users/NWQMC/following{/other_user}","gists_url":"https://api.github.com/users/NWQMC/gists{/gist_id}","starred_url":"https://api.github.com/users/NWQMC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NWQMC/subscriptions","organizations_url":"https://api.github.com/users/NWQMC/orgs","repos_url":"https://api.github.com/users/NWQMC/repos","events_url":"https://api.github.com/users/NWQMC/events{/privacy}","received_events_url":"https://api.github.com/users/NWQMC/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/NWQMC/schema-biodata","description":null,"fork":false,"url":"https://api.github.com/repos/NWQMC/schema-biodata","forks_url":"https://api.github.com/repos/NWQMC/schema-biodata/forks","keys_url":"https://api.github.com/repos/NWQMC/schema-biodata/keys{/key_id}","collaborators_url":"https://api.github.com/repos/NWQMC/schema-biodata/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/NWQMC/schema-biodata/teams","hooks_url":"https://api.github.com/repos/NWQMC/schema-biodata/hooks","issue_events_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues/events{/number}","events_url":"https://api.github.com/repos/NWQMC/schema-biodata/events","assignees_url":"https://api.github.com/repos/NWQMC/schema-biodata/assignees{/user}","branches_url":"https://api.github.com/repos/NWQMC/schema-biodata/branches{/branch}","tags_url":"https://api.github.com/repos/NWQMC/schema-biodata/tags","blobs_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/refs{/sha}","trees_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/trees{/sha}","statuses_url":"https://api.github.com/repos/NWQMC/schema-biodata/statuses/{sha}","languages_url":"https://api.github.com/repos/NWQMC/schema-biodata/languages","stargazers_url":"https://api.github.com/repos/NWQMC/schema-biodata/stargazers","contributors_url":"https://api.github.com/repos/NWQMC/schema-biodata/contributors","subscribers_url":"https://api.github.com/repos/NWQMC/schema-biodata/subscribers","subscription_url":"https://api.github.com/repos/NWQMC/schema-biodata/subscription","commits_url":"https://api.github.com/repos/NWQMC/schema-biodata/commits{/sha}","git_commits_url":"https://api.github.com/repos/NWQMC/schema-biodata/git/commits{/sha}","comments_url":"https://api.github.com/repos/NWQMC/schema-biodata/comments{/number}","issue_comment_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues/comments{/number}","contents_url":"https://api.github.com/repos/NWQMC/schema-biodata/contents/{+path}","compare_url":"https://api.github.com/repos/NWQMC/schema-biodata/compare/{base}...{head}","merges_url":"https://api.github.com/repos/NWQMC/schema-biodata/merges","archive_url":"https://api.github.com/repos/NWQMC/schema-biodata/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/NWQMC/schema-biodata/downloads","issues_url":"https://api.github.com/repos/NWQMC/schema-biodata/issues{/number}","pulls_url":"https://api.github.com/repos/NWQMC/schema-biodata/pulls{/number}","milestones_url":"https://api.github.com/repos/NWQMC/schema-biodata/milestones{/number}","notifications_url":"https://api.github.com/repos/NWQMC/schema-biodata/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/NWQMC/schema-biodata/labels{/name}","releases_url":"https://api.github.com/repos/NWQMC/schema-biodata/releases{/id}","deployments_url":"https://api.github.com/repos/NWQMC/schema-biodata/deployments","created_at":"2017-11-29T21:37:08Z","updated_at":"2019-04-09T19:00:24Z","pushed_at":"2019-04-15T20:27:54Z","git_url":"git://github.com/NWQMC/schema-biodata.git","ssh_url":"git@github.com:NWQMC/schema-biodata.git","clone_url":"https://github.com/NWQMC/schema-biodata.git","svn_url":"https://github.com/NWQMC/schema-biodata","homepage":null,"size":41,"stargazers_count":0,"watchers_count":0,"language":"PLpgSQL","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":1,"license":null,"forks":4,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4"},"html":{"href":"https://github.com/NWQMC/schema-biodata/pull/4"},"issue":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/issues/4"},"comments":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/issues/4/comments"},"review_comments":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4/comments"},"review_comment":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/pulls/4/commits"},"statuses":{"href":"https://api.github.com/repos/NWQMC/schema-biodata/statuses/695b9f7a6576061686223660919140cc0f745697"}},"author_association":"NONE"}}
{"actor":{"display_login":"ssoper-usgs"}}