{"action":"created","issue":{"url":"https://api.github.com/repos/SEED-platform/seed/issues/921","repository_url":"https://api.github.com/repos/SEED-platform/seed","labels_url":"https://api.github.com/repos/SEED-platform/seed/issues/921/labels{/name}","comments_url":"https://api.github.com/repos/SEED-platform/seed/issues/921/comments","events_url":"https://api.github.com/repos/SEED-platform/seed/issues/921/events","html_url":"https://github.com/SEED-platform/seed/issues/921","id":150209860,"number":921,"title":"Make django project with new DB models to test queries","user":{"login":"RDmitchell","id":6314950,"avatar_url":"https://avatars.githubusercontent.com/u/6314950?v=3","gravatar_id":"","url":"https://api.github.com/users/RDmitchell","html_url":"https://github.com/RDmitchell","followers_url":"https://api.github.com/users/RDmitchell/followers","following_url":"https://api.github.com/users/RDmitchell/following{/other_user}","gists_url":"https://api.github.com/users/RDmitchell/gists{/gist_id}","starred_url":"https://api.github.com/users/RDmitchell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RDmitchell/subscriptions","organizations_url":"https://api.github.com/users/RDmitchell/orgs","repos_url":"https://api.github.com/users/RDmitchell/repos","events_url":"https://api.github.com/users/RDmitchell/events{/privacy}","received_events_url":"https://api.github.com/users/RDmitchell/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/SEED-platform/seed/labels/1","name":"1","color":"f7c6c7"},{"url":"https://api.github.com/repos/SEED-platform/seed/labels/Database%20Refactoring","name":"Database Refactoring","color":"f21c8e"}],"state":"open","locked":false,"assignee":{"login":"nicholasserra","id":512288,"avatar_url":"https://avatars.githubusercontent.com/u/512288?v=3","gravatar_id":"","url":"https://api.github.com/users/nicholasserra","html_url":"https://github.com/nicholasserra","followers_url":"https://api.github.com/users/nicholasserra/followers","following_url":"https://api.github.com/users/nicholasserra/following{/other_user}","gists_url":"https://api.github.com/users/nicholasserra/gists{/gist_id}","starred_url":"https://api.github.com/users/nicholasserra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nicholasserra/subscriptions","organizations_url":"https://api.github.com/users/nicholasserra/orgs","repos_url":"https://api.github.com/users/nicholasserra/repos","events_url":"https://api.github.com/users/nicholasserra/events{/privacy}","received_events_url":"https://api.github.com/users/nicholasserra/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/SEED-platform/seed/milestones/38","html_url":"https://github.com/SEED-platform/seed/milestones/Sprint%202%20-%20May%209%20-%2020","labels_url":"https://api.github.com/repos/SEED-platform/seed/milestones/38/labels","id":1750528,"number":38,"title":"Sprint 2 - May 9 - 20","description":"","creator":{"login":"RDmitchell","id":6314950,"avatar_url":"https://avatars.githubusercontent.com/u/6314950?v=3","gravatar_id":"","url":"https://api.github.com/users/RDmitchell","html_url":"https://github.com/RDmitchell","followers_url":"https://api.github.com/users/RDmitchell/followers","following_url":"https://api.github.com/users/RDmitchell/following{/other_user}","gists_url":"https://api.github.com/users/RDmitchell/gists{/gist_id}","starred_url":"https://api.github.com/users/RDmitchell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RDmitchell/subscriptions","organizations_url":"https://api.github.com/users/RDmitchell/orgs","repos_url":"https://api.github.com/users/RDmitchell/repos","events_url":"https://api.github.com/users/RDmitchell/events{/privacy}","received_events_url":"https://api.github.com/users/RDmitchell/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":1,"state":"open","created_at":"2016-05-05T21:43:53Z","updated_at":"2016-05-09T15:36:34Z","due_on":"2016-05-20T07:00:00Z","closed_at":null},"comments":9,"created_at":"2016-04-21T22:32:52Z","updated_at":"2016-05-09T21:17:46Z","closed_at":null,"body":"Implement the new db refactoring data schema into a fresh Django project in order to test out queries. "},"comment":{"url":"https://api.github.com/repos/SEED-platform/seed/issues/comments/217992823","html_url":"https://github.com/SEED-platform/seed/issues/921#issuecomment-217992823","issue_url":"https://api.github.com/repos/SEED-platform/seed/issues/921","id":217992823,"user":{"login":"RDmitchell","id":6314950,"avatar_url":"https://avatars.githubusercontent.com/u/6314950?v=3","gravatar_id":"","url":"https://api.github.com/users/RDmitchell","html_url":"https://github.com/RDmitchell","followers_url":"https://api.github.com/users/RDmitchell/followers","following_url":"https://api.github.com/users/RDmitchell/following{/other_user}","gists_url":"https://api.github.com/users/RDmitchell/gists{/gist_id}","starred_url":"https://api.github.com/users/RDmitchell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RDmitchell/subscriptions","organizations_url":"https://api.github.com/users/RDmitchell/orgs","repos_url":"https://api.github.com/users/RDmitchell/repos","events_url":"https://api.github.com/users/RDmitchell/events{/privacy}","received_events_url":"https://api.github.com/users/RDmitchell/received_events","type":"User","site_admin":false},"created_at":"2016-05-09T21:17:46Z","updated_at":"2016-05-09T21:17:46Z","body":"Yes. Do you want a sample PM file with the large number of fields? We know what the PM fields are and can basically make them all (or the majority of them) into named fields in the Property table if that seems like the right thing to do. \r\n\r\nIf we do that, I wonder if we really want all that information in the Property Table, and might instead want to make another table with Portfolio Manager data in it that has a 1:1 relationship to a record in the Property. I suggested this at one point and I think it was voted down, but at some point the Property table is going to get very large, with fields from various known file types. Right now it is just Portfolio Manager, but we may also want to include Home Energy Score fields which again are known fields (that one of the SEED user imports) but different from the Portfolio Manager fields (although there is probably some overlap -- that data could be put into the Property table). So the HES fields:data would all end up in the extra_data field at this point (which is what it does now).\r\n"}}