{"action":"created","issue":{"url":"https://api.github.com/repos/DoSomething/quasar/issues/37","repository_url":"https://api.github.com/repos/DoSomething/quasar","labels_url":"https://api.github.com/repos/DoSomething/quasar/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/DoSomething/quasar/issues/37/comments","events_url":"https://api.github.com/repos/DoSomething/quasar/issues/37/events","html_url":"https://github.com/DoSomething/quasar/issues/37","id":132477027,"number":37,"title":"Create opt-in ID (unique), MCID, NID, RID Table","user":{"login":"namimody","id":12396076,"avatar_url":"https://avatars.githubusercontent.com/u/12396076?v=3","gravatar_id":"","url":"https://api.github.com/users/namimody","html_url":"https://github.com/namimody","followers_url":"https://api.github.com/users/namimody/followers","following_url":"https://api.github.com/users/namimody/following{/other_user}","gists_url":"https://api.github.com/users/namimody/gists{/gist_id}","starred_url":"https://api.github.com/users/namimody/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/namimody/subscriptions","organizations_url":"https://api.github.com/users/namimody/orgs","repos_url":"https://api.github.com/users/namimody/repos","events_url":"https://api.github.com/users/namimody/events{/privacy}","received_events_url":"https://api.github.com/users/namimody/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/DoSomething/quasar/labels/%23learn","name":"#learn","color":"009800"},{"url":"https://api.github.com/repos/DoSomething/quasar/labels/%23sena-learning","name":"#sena-learning","color":"009800"},{"url":"https://api.github.com/repos/DoSomething/quasar/labels/medium","name":"medium","color":"d4c5f9"}],"state":"open","locked":false,"assignee":{"login":"sheyd","id":4562565,"avatar_url":"https://avatars.githubusercontent.com/u/4562565?v=3","gravatar_id":"","url":"https://api.github.com/users/sheyd","html_url":"https://github.com/sheyd","followers_url":"https://api.github.com/users/sheyd/followers","following_url":"https://api.github.com/users/sheyd/following{/other_user}","gists_url":"https://api.github.com/users/sheyd/gists{/gist_id}","starred_url":"https://api.github.com/users/sheyd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sheyd/subscriptions","organizations_url":"https://api.github.com/users/sheyd/orgs","repos_url":"https://api.github.com/users/sheyd/repos","events_url":"https://api.github.com/users/sheyd/events{/privacy}","received_events_url":"https://api.github.com/users/sheyd/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/DoSomething/quasar/milestones/7","html_url":"https://github.com/DoSomething/quasar/milestones/%233:%20Thor%20Gets%20a%20Friend%20(2/16%20-%202/26)","labels_url":"https://api.github.com/repos/DoSomething/quasar/milestones/7/labels","id":1586597,"number":7,"title":"#3: Thor Gets a Friend (2/16 - 2/26)","description":"Creating a data test environment, documentation of the creation of the environment, and query writing to automate the daily CSV of campaign data.","creator":{"login":"namimody","id":12396076,"avatar_url":"https://avatars.githubusercontent.com/u/12396076?v=3","gravatar_id":"","url":"https://api.github.com/users/namimody","html_url":"https://github.com/namimody","followers_url":"https://api.github.com/users/namimody/followers","following_url":"https://api.github.com/users/namimody/following{/other_user}","gists_url":"https://api.github.com/users/namimody/gists{/gist_id}","starred_url":"https://api.github.com/users/namimody/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/namimody/subscriptions","organizations_url":"https://api.github.com/users/namimody/orgs","repos_url":"https://api.github.com/users/namimody/repos","events_url":"https://api.github.com/users/namimody/events{/privacy}","received_events_url":"https://api.github.com/users/namimody/received_events","type":"User","site_admin":false},"open_issues":13,"closed_issues":3,"state":"open","created_at":"2016-02-16T19:09:48Z","updated_at":"2016-02-24T20:10:36Z","due_on":"2016-02-26T05:00:00Z","closed_at":null},"comments":3,"created_at":"2016-02-09T17:14:14Z","updated_at":"2016-02-25T19:48:47Z","closed_at":null,"body":"After https://github.com/DoSomething/quasar/issues/9 is finished, create a table to display associations between opt-in ID, MCID, NID, and RID. Unique key: opt-in ID."},"comment":{"url":"https://api.github.com/repos/DoSomething/quasar/issues/comments/188949530","html_url":"https://github.com/DoSomething/quasar/issues/37#issuecomment-188949530","issue_url":"https://api.github.com/repos/DoSomething/quasar/issues/37","id":188949530,"user":{"login":"sheyd","id":4562565,"avatar_url":"https://avatars.githubusercontent.com/u/4562565?v=3","gravatar_id":"","url":"https://api.github.com/users/sheyd","html_url":"https://github.com/sheyd","followers_url":"https://api.github.com/users/sheyd/followers","following_url":"https://api.github.com/users/sheyd/following{/other_user}","gists_url":"https://api.github.com/users/sheyd/gists{/gist_id}","starred_url":"https://api.github.com/users/sheyd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sheyd/subscriptions","organizations_url":"https://api.github.com/users/sheyd/orgs","repos_url":"https://api.github.com/users/sheyd/repos","events_url":"https://api.github.com/users/sheyd/events{/privacy}","received_events_url":"https://api.github.com/users/sheyd/received_events","type":"User","site_admin":false},"created_at":"2016-02-25T19:48:47Z","updated_at":"2016-02-25T19:48:47Z","body":"@namimody table created successfully. In consultation with @Bladt we added a few more columns to reflect `opt_in_path`  and `mobile_campaign_id` names that we get back from Mobile Commons that are useful to query on. \r\n\r\nNext questions:\r\n\r\n1. Do we wait till we have MC test data to see if populating things makes sense from the MC database or use API scraping which is a known quantity right now.\r\n2. If we go with the latter approach, I'll have to write a script to populate the data fields. "}}