{"action":"created","comment":{"url":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/comments/204426898","pull_request_review_id":139505156,"id":204426898,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIwNDQyNjg5OA==","diff_hunk":"@@ -2875,6 +2875,19 @@ CREATE TABLE openchpl.listing_count_statistics (\n         ON DELETE RESTRICT ON UPDATE CASCADE\n         );\n \n+CREATE TABLE openchpl.summary_statistics\n+(\n+    summary_statistics_id bigserial NOT NULL,\n+    end_date timestamp without time zone NOT NULL,\n+    summary_statistics json,\n+    creation_date timestamp without time zone NOT NULL DEFAULT now(),\n+    last_modified_date timestamp without time zone NOT NULL DEFAULT now(),\n+    last_modified_user bigint NOT NULL,\n+    deleted boolean NOT NULL DEFAULT false,\n+    CONSTRAINT summary_statistics_pk PRIMARY KEY (summary_statistics_id)","path":"dev/openchpl_data-model.sql","position":13,"original_position":13,"commit_id":"0e1add3ea9f27a7be3f2ee07ae36dd10fe1f205a","original_commit_id":"0e1add3ea9f27a7be3f2ee07ae36dd10fe1f205a","user":{"login":"andlar","id":909012,"node_id":"MDQ6VXNlcjkwOTAxMg==","avatar_url":"https://avatars3.githubusercontent.com/u/909012?v=4","gravatar_id":"","url":"https://api.github.com/users/andlar","html_url":"https://github.com/andlar","followers_url":"https://api.github.com/users/andlar/followers","following_url":"https://api.github.com/users/andlar/following{/other_user}","gists_url":"https://api.github.com/users/andlar/gists{/gist_id}","starred_url":"https://api.github.com/users/andlar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andlar/subscriptions","organizations_url":"https://api.github.com/users/andlar/orgs","repos_url":"https://api.github.com/users/andlar/repos","events_url":"https://api.github.com/users/andlar/events{/privacy}","received_events_url":"https://api.github.com/users/andlar/received_events","type":"User","site_admin":false},"body":"Missing the addition of triggers in the audit file","created_at":"2018-07-23T14:41:16Z","updated_at":"2018-07-23T14:42:02Z","html_url":"https://github.com/chpladmin/chpl-data-model/pull/208#discussion_r204426898","pull_request_url":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/comments/204426898"},"html":{"href":"https://github.com/chpladmin/chpl-data-model/pull/208#discussion_r204426898"},"pull_request":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208"}}},"pull_request":{"url":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208","id":203238761,"node_id":"MDExOlB1bGxSZXF1ZXN0MjAzMjM4NzYx","html_url":"https://github.com/chpladmin/chpl-data-model/pull/208","diff_url":"https://github.com/chpladmin/chpl-data-model/pull/208.diff","patch_url":"https://github.com/chpladmin/chpl-data-model/pull/208.patch","issue_url":"https://api.github.com/repos/chpladmin/chpl-data-model/issues/208","number":208,"state":"open","locked":false,"title":"Updated data model with table and view to support OCD-2275","user":{"login":"tmy1313","id":24817202,"node_id":"MDQ6VXNlcjI0ODE3MjAy","avatar_url":"https://avatars2.githubusercontent.com/u/24817202?v=4","gravatar_id":"","url":"https://api.github.com/users/tmy1313","html_url":"https://github.com/tmy1313","followers_url":"https://api.github.com/users/tmy1313/followers","following_url":"https://api.github.com/users/tmy1313/following{/other_user}","gists_url":"https://api.github.com/users/tmy1313/gists{/gist_id}","starred_url":"https://api.github.com/users/tmy1313/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmy1313/subscriptions","organizations_url":"https://api.github.com/users/tmy1313/orgs","repos_url":"https://api.github.com/users/tmy1313/repos","events_url":"https://api.github.com/users/tmy1313/events{/privacy}","received_events_url":"https://api.github.com/users/tmy1313/received_events","type":"User","site_admin":false},"body":"OCD-2275","created_at":"2018-07-23T14:31:48Z","updated_at":"2018-07-23T14:42:02Z","closed_at":null,"merged_at":null,"merge_commit_sha":"5bbdfff0de8a6f14c33cff922462d7548f5b6e21","assignee":null,"assignees":[],"requested_reviewers":[{"login":"brianlindsy","id":5408079,"node_id":"MDQ6VXNlcjU0MDgwNzk=","avatar_url":"https://avatars3.githubusercontent.com/u/5408079?v=4","gravatar_id":"","url":"https://api.github.com/users/brianlindsy","html_url":"https://github.com/brianlindsy","followers_url":"https://api.github.com/users/brianlindsy/followers","following_url":"https://api.github.com/users/brianlindsy/following{/other_user}","gists_url":"https://api.github.com/users/brianlindsy/gists{/gist_id}","starred_url":"https://api.github.com/users/brianlindsy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brianlindsy/subscriptions","organizations_url":"https://api.github.com/users/brianlindsy/orgs","repos_url":"https://api.github.com/users/brianlindsy/repos","events_url":"https://api.github.com/users/brianlindsy/events{/privacy}","received_events_url":"https://api.github.com/users/brianlindsy/received_events","type":"User","site_admin":false},{"login":"kekey1","id":13735136,"node_id":"MDQ6VXNlcjEzNzM1MTM2","avatar_url":"https://avatars0.githubusercontent.com/u/13735136?v=4","gravatar_id":"","url":"https://api.github.com/users/kekey1","html_url":"https://github.com/kekey1","followers_url":"https://api.github.com/users/kekey1/followers","following_url":"https://api.github.com/users/kekey1/following{/other_user}","gists_url":"https://api.github.com/users/kekey1/gists{/gist_id}","starred_url":"https://api.github.com/users/kekey1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kekey1/subscriptions","organizations_url":"https://api.github.com/users/kekey1/orgs","repos_url":"https://api.github.com/users/kekey1/repos","events_url":"https://api.github.com/users/kekey1/events{/privacy}","received_events_url":"https://api.github.com/users/kekey1/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208/commits","review_comments_url":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208/comments","review_comment_url":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/comments{/number}","comments_url":"https://api.github.com/repos/chpladmin/chpl-data-model/issues/208/comments","statuses_url":"https://api.github.com/repos/chpladmin/chpl-data-model/statuses/0e1add3ea9f27a7be3f2ee07ae36dd10fe1f205a","head":{"label":"tmy1313:OCD-2275","ref":"OCD-2275","sha":"0e1add3ea9f27a7be3f2ee07ae36dd10fe1f205a","user":{"login":"tmy1313","id":24817202,"node_id":"MDQ6VXNlcjI0ODE3MjAy","avatar_url":"https://avatars2.githubusercontent.com/u/24817202?v=4","gravatar_id":"","url":"https://api.github.com/users/tmy1313","html_url":"https://github.com/tmy1313","followers_url":"https://api.github.com/users/tmy1313/followers","following_url":"https://api.github.com/users/tmy1313/following{/other_user}","gists_url":"https://api.github.com/users/tmy1313/gists{/gist_id}","starred_url":"https://api.github.com/users/tmy1313/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmy1313/subscriptions","organizations_url":"https://api.github.com/users/tmy1313/orgs","repos_url":"https://api.github.com/users/tmy1313/repos","events_url":"https://api.github.com/users/tmy1313/events{/privacy}","received_events_url":"https://api.github.com/users/tmy1313/received_events","type":"User","site_admin":false},"repo":{"id":124112710,"node_id":"MDEwOlJlcG9zaXRvcnkxMjQxMTI3MTA=","name":"chpl-data-model","full_name":"tmy1313/chpl-data-model","owner":{"login":"tmy1313","id":24817202,"node_id":"MDQ6VXNlcjI0ODE3MjAy","avatar_url":"https://avatars2.githubusercontent.com/u/24817202?v=4","gravatar_id":"","url":"https://api.github.com/users/tmy1313","html_url":"https://github.com/tmy1313","followers_url":"https://api.github.com/users/tmy1313/followers","following_url":"https://api.github.com/users/tmy1313/following{/other_user}","gists_url":"https://api.github.com/users/tmy1313/gists{/gist_id}","starred_url":"https://api.github.com/users/tmy1313/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tmy1313/subscriptions","organizations_url":"https://api.github.com/users/tmy1313/orgs","repos_url":"https://api.github.com/users/tmy1313/repos","events_url":"https://api.github.com/users/tmy1313/events{/privacy}","received_events_url":"https://api.github.com/users/tmy1313/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/tmy1313/chpl-data-model","description":"Data Model repository for OpenDataCHPL project","fork":true,"url":"https://api.github.com/repos/tmy1313/chpl-data-model","forks_url":"https://api.github.com/repos/tmy1313/chpl-data-model/forks","keys_url":"https://api.github.com/repos/tmy1313/chpl-data-model/keys{/key_id}","collaborators_url":"https://api.github.com/repos/tmy1313/chpl-data-model/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/tmy1313/chpl-data-model/teams","hooks_url":"https://api.github.com/repos/tmy1313/chpl-data-model/hooks","issue_events_url":"https://api.github.com/repos/tmy1313/chpl-data-model/issues/events{/number}","events_url":"https://api.github.com/repos/tmy1313/chpl-data-model/events","assignees_url":"https://api.github.com/repos/tmy1313/chpl-data-model/assignees{/user}","branches_url":"https://api.github.com/repos/tmy1313/chpl-data-model/branches{/branch}","tags_url":"https://api.github.com/repos/tmy1313/chpl-data-model/tags","blobs_url":"https://api.github.com/repos/tmy1313/chpl-data-model/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/tmy1313/chpl-data-model/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/tmy1313/chpl-data-model/git/refs{/sha}","trees_url":"https://api.github.com/repos/tmy1313/chpl-data-model/git/trees{/sha}","statuses_url":"https://api.github.com/repos/tmy1313/chpl-data-model/statuses/{sha}","languages_url":"https://api.github.com/repos/tmy1313/chpl-data-model/languages","stargazers_url":"https://api.github.com/repos/tmy1313/chpl-data-model/stargazers","contributors_url":"https://api.github.com/repos/tmy1313/chpl-data-model/contributors","subscribers_url":"https://api.github.com/repos/tmy1313/chpl-data-model/subscribers","subscription_url":"https://api.github.com/repos/tmy1313/chpl-data-model/subscription","commits_url":"https://api.github.com/repos/tmy1313/chpl-data-model/commits{/sha}","git_commits_url":"https://api.github.com/repos/tmy1313/chpl-data-model/git/commits{/sha}","comments_url":"https://api.github.com/repos/tmy1313/chpl-data-model/comments{/number}","issue_comment_url":"https://api.github.com/repos/tmy1313/chpl-data-model/issues/comments{/number}","contents_url":"https://api.github.com/repos/tmy1313/chpl-data-model/contents/{+path}","compare_url":"https://api.github.com/repos/tmy1313/chpl-data-model/compare/{base}...{head}","merges_url":"https://api.github.com/repos/tmy1313/chpl-data-model/merges","archive_url":"https://api.github.com/repos/tmy1313/chpl-data-model/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/tmy1313/chpl-data-model/downloads","issues_url":"https://api.github.com/repos/tmy1313/chpl-data-model/issues{/number}","pulls_url":"https://api.github.com/repos/tmy1313/chpl-data-model/pulls{/number}","milestones_url":"https://api.github.com/repos/tmy1313/chpl-data-model/milestones{/number}","notifications_url":"https://api.github.com/repos/tmy1313/chpl-data-model/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/tmy1313/chpl-data-model/labels{/name}","releases_url":"https://api.github.com/repos/tmy1313/chpl-data-model/releases{/id}","deployments_url":"https://api.github.com/repos/tmy1313/chpl-data-model/deployments","created_at":"2018-03-06T17:19:03Z","updated_at":"2018-06-21T18:07:34Z","pushed_at":"2018-07-23T14:25:43Z","git_url":"git://github.com/tmy1313/chpl-data-model.git","ssh_url":"git@github.com:tmy1313/chpl-data-model.git","clone_url":"https://github.com/tmy1313/chpl-data-model.git","svn_url":"https://github.com/tmy1313/chpl-data-model","homepage":"","size":23477,"stargazers_count":0,"watchers_count":0,"language":"PLpgSQL","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"development"}},"base":{"label":"chpladmin:development","ref":"development","sha":"281fff523b5fe725f34a1790ce89e7c1517bc64d","user":{"login":"chpladmin","id":11613790,"node_id":"MDEyOk9yZ2FuaXphdGlvbjExNjEzNzkw","avatar_url":"https://avatars2.githubusercontent.com/u/11613790?v=4","gravatar_id":"","url":"https://api.github.com/users/chpladmin","html_url":"https://github.com/chpladmin","followers_url":"https://api.github.com/users/chpladmin/followers","following_url":"https://api.github.com/users/chpladmin/following{/other_user}","gists_url":"https://api.github.com/users/chpladmin/gists{/gist_id}","starred_url":"https://api.github.com/users/chpladmin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chpladmin/subscriptions","organizations_url":"https://api.github.com/users/chpladmin/orgs","repos_url":"https://api.github.com/users/chpladmin/repos","events_url":"https://api.github.com/users/chpladmin/events{/privacy}","received_events_url":"https://api.github.com/users/chpladmin/received_events","type":"Organization","site_admin":false},"repo":{"id":44747349,"node_id":"MDEwOlJlcG9zaXRvcnk0NDc0NzM0OQ==","name":"chpl-data-model","full_name":"chpladmin/chpl-data-model","owner":{"login":"chpladmin","id":11613790,"node_id":"MDEyOk9yZ2FuaXphdGlvbjExNjEzNzkw","avatar_url":"https://avatars2.githubusercontent.com/u/11613790?v=4","gravatar_id":"","url":"https://api.github.com/users/chpladmin","html_url":"https://github.com/chpladmin","followers_url":"https://api.github.com/users/chpladmin/followers","following_url":"https://api.github.com/users/chpladmin/following{/other_user}","gists_url":"https://api.github.com/users/chpladmin/gists{/gist_id}","starred_url":"https://api.github.com/users/chpladmin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chpladmin/subscriptions","organizations_url":"https://api.github.com/users/chpladmin/orgs","repos_url":"https://api.github.com/users/chpladmin/repos","events_url":"https://api.github.com/users/chpladmin/events{/privacy}","received_events_url":"https://api.github.com/users/chpladmin/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/chpladmin/chpl-data-model","description":"Data Model repository for OpenDataCHPL project","fork":false,"url":"https://api.github.com/repos/chpladmin/chpl-data-model","forks_url":"https://api.github.com/repos/chpladmin/chpl-data-model/forks","keys_url":"https://api.github.com/repos/chpladmin/chpl-data-model/keys{/key_id}","collaborators_url":"https://api.github.com/repos/chpladmin/chpl-data-model/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/chpladmin/chpl-data-model/teams","hooks_url":"https://api.github.com/repos/chpladmin/chpl-data-model/hooks","issue_events_url":"https://api.github.com/repos/chpladmin/chpl-data-model/issues/events{/number}","events_url":"https://api.github.com/repos/chpladmin/chpl-data-model/events","assignees_url":"https://api.github.com/repos/chpladmin/chpl-data-model/assignees{/user}","branches_url":"https://api.github.com/repos/chpladmin/chpl-data-model/branches{/branch}","tags_url":"https://api.github.com/repos/chpladmin/chpl-data-model/tags","blobs_url":"https://api.github.com/repos/chpladmin/chpl-data-model/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/chpladmin/chpl-data-model/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/chpladmin/chpl-data-model/git/refs{/sha}","trees_url":"https://api.github.com/repos/chpladmin/chpl-data-model/git/trees{/sha}","statuses_url":"https://api.github.com/repos/chpladmin/chpl-data-model/statuses/{sha}","languages_url":"https://api.github.com/repos/chpladmin/chpl-data-model/languages","stargazers_url":"https://api.github.com/repos/chpladmin/chpl-data-model/stargazers","contributors_url":"https://api.github.com/repos/chpladmin/chpl-data-model/contributors","subscribers_url":"https://api.github.com/repos/chpladmin/chpl-data-model/subscribers","subscription_url":"https://api.github.com/repos/chpladmin/chpl-data-model/subscription","commits_url":"https://api.github.com/repos/chpladmin/chpl-data-model/commits{/sha}","git_commits_url":"https://api.github.com/repos/chpladmin/chpl-data-model/git/commits{/sha}","comments_url":"https://api.github.com/repos/chpladmin/chpl-data-model/comments{/number}","issue_comment_url":"https://api.github.com/repos/chpladmin/chpl-data-model/issues/comments{/number}","contents_url":"https://api.github.com/repos/chpladmin/chpl-data-model/contents/{+path}","compare_url":"https://api.github.com/repos/chpladmin/chpl-data-model/compare/{base}...{head}","merges_url":"https://api.github.com/repos/chpladmin/chpl-data-model/merges","archive_url":"https://api.github.com/repos/chpladmin/chpl-data-model/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/chpladmin/chpl-data-model/downloads","issues_url":"https://api.github.com/repos/chpladmin/chpl-data-model/issues{/number}","pulls_url":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls{/number}","milestones_url":"https://api.github.com/repos/chpladmin/chpl-data-model/milestones{/number}","notifications_url":"https://api.github.com/repos/chpladmin/chpl-data-model/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/chpladmin/chpl-data-model/labels{/name}","releases_url":"https://api.github.com/repos/chpladmin/chpl-data-model/releases{/id}","deployments_url":"https://api.github.com/repos/chpladmin/chpl-data-model/deployments","created_at":"2015-10-22T13:36:18Z","updated_at":"2018-07-19T15:00:38Z","pushed_at":"2018-07-23T14:31:49Z","git_url":"git://github.com/chpladmin/chpl-data-model.git","ssh_url":"git@github.com:chpladmin/chpl-data-model.git","clone_url":"https://github.com/chpladmin/chpl-data-model.git","svn_url":"https://github.com/chpladmin/chpl-data-model","homepage":"","size":23501,"stargazers_count":1,"watchers_count":1,"language":"PLpgSQL","has_issues":false,"has_projects":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":8,"mirror_url":null,"archived":false,"open_issues_count":1,"license":null,"forks":8,"open_issues":1,"watchers":1,"default_branch":"development"}},"_links":{"self":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208"},"html":{"href":"https://github.com/chpladmin/chpl-data-model/pull/208"},"issue":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/issues/208"},"comments":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/issues/208/comments"},"review_comments":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208/comments"},"review_comment":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/pulls/208/commits"},"statuses":{"href":"https://api.github.com/repos/chpladmin/chpl-data-model/statuses/0e1add3ea9f27a7be3f2ee07ae36dd10fe1f205a"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"andlar"}}