{"action":"created","issue":{"url":"https://api.github.com/repos/jonBarcus/SoIaF_GM_Tools/issues/1","labels_url":"https://api.github.com/repos/jonBarcus/SoIaF_GM_Tools/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/jonBarcus/SoIaF_GM_Tools/issues/1/comments","events_url":"https://api.github.com/repos/jonBarcus/SoIaF_GM_Tools/issues/1/events","html_url":"https://github.com/jonBarcus/SoIaF_GM_Tools/issues/1","id":63441690,"number":1,"title":"Database Question","user":{"login":"jonBarcus","id":1728745,"avatar_url":"https://avatars.githubusercontent.com/u/1728745?v=3","gravatar_id":"","url":"https://api.github.com/users/jonBarcus","html_url":"https://github.com/jonBarcus","followers_url":"https://api.github.com/users/jonBarcus/followers","following_url":"https://api.github.com/users/jonBarcus/following{/other_user}","gists_url":"https://api.github.com/users/jonBarcus/gists{/gist_id}","starred_url":"https://api.github.com/users/jonBarcus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jonBarcus/subscriptions","organizations_url":"https://api.github.com/users/jonBarcus/orgs","repos_url":"https://api.github.com/users/jonBarcus/repos","events_url":"https://api.github.com/users/jonBarcus/events{/privacy}","received_events_url":"https://api.github.com/users/jonBarcus/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jonBarcus/SoIaF_GM_Tools/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"drumsetz","id":3749888,"avatar_url":"https://avatars.githubusercontent.com/u/3749888?v=3","gravatar_id":"","url":"https://api.github.com/users/drumsetz","html_url":"https://github.com/drumsetz","followers_url":"https://api.github.com/users/drumsetz/followers","following_url":"https://api.github.com/users/drumsetz/following{/other_user}","gists_url":"https://api.github.com/users/drumsetz/gists{/gist_id}","starred_url":"https://api.github.com/users/drumsetz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drumsetz/subscriptions","organizations_url":"https://api.github.com/users/drumsetz/orgs","repos_url":"https://api.github.com/users/drumsetz/repos","events_url":"https://api.github.com/users/drumsetz/events{/privacy}","received_events_url":"https://api.github.com/users/drumsetz/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2015-03-21T19:00:45Z","updated_at":"2015-03-22T15:37:18Z","closed_at":null,"body":"Okay, so I need your guys input and some expertise.\r\n\r\nThe basic question is about using an array in the Character table for \"Abilities.\"  Then, do we have the \"Specialties\" connected to a Character or to Abilities?  There are a few ways we can do things, I believe, and I think to answer that question you'll both need to have a little better understanding of ActiveRecord in Rails."},"comment":{"url":"https://api.github.com/repos/jonBarcus/SoIaF_GM_Tools/issues/comments/84633889","html_url":"https://github.com/jonBarcus/SoIaF_GM_Tools/issues/1#issuecomment-84633889","issue_url":"https://api.github.com/repos/jonBarcus/SoIaF_GM_Tools/issues/1","id":84633889,"user":{"login":"jonBarcus","id":1728745,"avatar_url":"https://avatars.githubusercontent.com/u/1728745?v=3","gravatar_id":"","url":"https://api.github.com/users/jonBarcus","html_url":"https://github.com/jonBarcus","followers_url":"https://api.github.com/users/jonBarcus/followers","following_url":"https://api.github.com/users/jonBarcus/following{/other_user}","gists_url":"https://api.github.com/users/jonBarcus/gists{/gist_id}","starred_url":"https://api.github.com/users/jonBarcus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jonBarcus/subscriptions","organizations_url":"https://api.github.com/users/jonBarcus/orgs","repos_url":"https://api.github.com/users/jonBarcus/repos","events_url":"https://api.github.com/users/jonBarcus/events{/privacy}","received_events_url":"https://api.github.com/users/jonBarcus/received_events","type":"User","site_admin":false},"created_at":"2015-03-22T15:37:18Z","updated_at":"2015-03-22T15:37:18Z","body":"I think it has to do with ActiveRecord and Postgresql.  If you take a look at (this project)[https://github.com/jonBarcus/Pup-Promenade/blob/master/db/schema.rb] and scroll all the day to the bottom of the schema, you'll see we used an integer, setting array as true, which then allowed us to store multiple integers in that column.\r\n\r\nI'll make a test app today or tomorrow to do a test of concept again.\r\n\r\nAnother possibility is using the postgresql datatype of hstore.  Though from my quick looks at hstore, that seems to store key/value pairs, which I'm not sure is something that is preferable."}}