issue_comments
Data license: AGPL · Data source: ACEmulator Project
2 rows where issue = 225268144
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | performed_via_github_app | issue |
---|---|---|---|---|---|---|---|---|---|---|---|
298181799 | https://github.com/ACEmulator/ACE/pull/306#issuecomment-298181799 | https://api.github.com/repos/ACEmulator/ACE/issues/306 | MDEyOklzc3VlQ29tbWVudDI5ODE4MTc5OQ== | ghost 10137 | 2017-04-29T17:15:29Z | 2017-04-29T17:15:29Z | NONE | The societyId field in the new table structure is currently a placeholder that can be changed, if needed, for when Societies and their bound portals are implemented. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Portal class changes 225268144 | |
298324824 | https://github.com/ACEmulator/ACE/pull/306#issuecomment-298324824 | https://api.github.com/repos/ACEmulator/ACE/issues/306 | MDEyOklzc3VlQ29tbWVudDI5ODMyNDgyNA== | Mogwai-TheFurry 25351661 | 2017-05-01T12:10:28Z | 2017-05-01T12:10:28Z | CONTRIBUTOR | Couple comments: * If you make the join a "LEFT OUTER JOIN", you won't break existing portals. In order to support this, the destination data properties will need to be nullable (to make an int nullable, change it to "int?"). * World data needs to go to the ACE-World repository. Table/View structures here, data there. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Portal class changes 225268144 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [issue_comments] ( [html_url] TEXT, [issue_url] TEXT, [id] INTEGER PRIMARY KEY, [node_id] TEXT, [user] INTEGER REFERENCES [users]([id]), [created_at] TEXT, [updated_at] TEXT, [author_association] TEXT, [body] TEXT, [reactions] TEXT, [performed_via_github_app] TEXT, [issue] INTEGER REFERENCES [issues]([id]) ); CREATE INDEX [idx_issue_comments_issue] ON [issue_comments] ([issue]); CREATE INDEX [idx_issue_comments_user] ON [issue_comments] ([user]);