{"action":"created","comment":{"url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/comments/235064341","pull_request_review_id":176843803,"id":235064341,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIzNTA2NDM0MQ==","diff_hunk":"@@ -1,5 +1,30 @@\n-\"\"\"Stub file for respective models.\n+from sqlalchemy import Column, Integer, String, ForeignKey\n+from .database import Base, session\n+from sqlalchemy.exc import IntegrityError\n+from .users import Users\n \n-Delete the contents of this file and complete it with your solution.\n-\"\"\"\n-from .vitals_solution import VitalsMeasurement\n+class Vitals(Base):\n+    __tablename__ = 'vitals'\n+\n+    id = Column(Integer, primary_key=True)\n+    user_id = Column(String, ForeignKey('user.id'))\n+    height = Column(String)\n+    weight = Column(String)","path":"rdbms/models/vitals.py","position":16,"original_position":16,"commit_id":"5a8c6c0c8e6e5cc96f3844955c28f38acca0b0a8","original_commit_id":"5a8c6c0c8e6e5cc96f3844955c28f38acca0b0a8","user":{"login":"infosmith","id":3581457,"node_id":"MDQ6VXNlcjM1ODE0NTc=","avatar_url":"https://avatars0.githubusercontent.com/u/3581457?v=4","gravatar_id":"","url":"https://api.github.com/users/infosmith","html_url":"https://github.com/infosmith","followers_url":"https://api.github.com/users/infosmith/followers","following_url":"https://api.github.com/users/infosmith/following{/other_user}","gists_url":"https://api.github.com/users/infosmith/gists{/gist_id}","starred_url":"https://api.github.com/users/infosmith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/infosmith/subscriptions","organizations_url":"https://api.github.com/users/infosmith/orgs","repos_url":"https://api.github.com/users/infosmith/repos","events_url":"https://api.github.com/users/infosmith/events{/privacy}","received_events_url":"https://api.github.com/users/infosmith/received_events","type":"User","site_admin":false},"body":"data type should be float","created_at":"2018-11-20T16:03:46Z","updated_at":"2018-11-20T16:03:46Z","html_url":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction/pull/15#discussion_r235064341","pull_request_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15","author_association":"COLLABORATOR","_links":{"self":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/comments/235064341"},"html":{"href":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction/pull/15#discussion_r235064341"},"pull_request":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15"}}},"pull_request":{"url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15","id":231313530,"node_id":"MDExOlB1bGxSZXF1ZXN0MjMxMzEzNTMw","html_url":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction/pull/15","diff_url":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction/pull/15.diff","patch_url":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction/pull/15.patch","issue_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/issues/15","number":15,"state":"open","locked":false,"title":"Sprint b","user":{"login":"jakeberg","id":19676818,"node_id":"MDQ6VXNlcjE5Njc2ODE4","avatar_url":"https://avatars0.githubusercontent.com/u/19676818?v=4","gravatar_id":"","url":"https://api.github.com/users/jakeberg","html_url":"https://github.com/jakeberg","followers_url":"https://api.github.com/users/jakeberg/followers","following_url":"https://api.github.com/users/jakeberg/following{/other_user}","gists_url":"https://api.github.com/users/jakeberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jakeberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakeberg/subscriptions","organizations_url":"https://api.github.com/users/jakeberg/orgs","repos_url":"https://api.github.com/users/jakeberg/repos","events_url":"https://api.github.com/users/jakeberg/events{/privacy}","received_events_url":"https://api.github.com/users/jakeberg/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-11-15T19:48:57Z","updated_at":"2018-11-20T16:03:46Z","closed_at":null,"merged_at":null,"merge_commit_sha":"c20a9d195a64867b293b3b9780f4b4395f411f38","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15/commits","review_comments_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15/comments","review_comment_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/comments{/number}","comments_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/issues/15/comments","statuses_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/statuses/5a8c6c0c8e6e5cc96f3844955c28f38acca0b0a8","head":{"label":"jakeberg:sprint-b","ref":"sprint-b","sha":"5a8c6c0c8e6e5cc96f3844955c28f38acca0b0a8","user":{"login":"jakeberg","id":19676818,"node_id":"MDQ6VXNlcjE5Njc2ODE4","avatar_url":"https://avatars0.githubusercontent.com/u/19676818?v=4","gravatar_id":"","url":"https://api.github.com/users/jakeberg","html_url":"https://github.com/jakeberg","followers_url":"https://api.github.com/users/jakeberg/followers","following_url":"https://api.github.com/users/jakeberg/following{/other_user}","gists_url":"https://api.github.com/users/jakeberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jakeberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakeberg/subscriptions","organizations_url":"https://api.github.com/users/jakeberg/orgs","repos_url":"https://api.github.com/users/jakeberg/repos","events_url":"https://api.github.com/users/jakeberg/events{/privacy}","received_events_url":"https://api.github.com/users/jakeberg/received_events","type":"User","site_admin":false},"repo":{"id":156408142,"node_id":"MDEwOlJlcG9zaXRvcnkxNTY0MDgxNDI=","name":"backend-sqlalchemy-introduction","full_name":"jakeberg/backend-sqlalchemy-introduction","private":false,"owner":{"login":"jakeberg","id":19676818,"node_id":"MDQ6VXNlcjE5Njc2ODE4","avatar_url":"https://avatars0.githubusercontent.com/u/19676818?v=4","gravatar_id":"","url":"https://api.github.com/users/jakeberg","html_url":"https://github.com/jakeberg","followers_url":"https://api.github.com/users/jakeberg/followers","following_url":"https://api.github.com/users/jakeberg/following{/other_user}","gists_url":"https://api.github.com/users/jakeberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jakeberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakeberg/subscriptions","organizations_url":"https://api.github.com/users/jakeberg/orgs","repos_url":"https://api.github.com/users/jakeberg/repos","events_url":"https://api.github.com/users/jakeberg/events{/privacy}","received_events_url":"https://api.github.com/users/jakeberg/received_events","type":"User","site_admin":false},"html_url":"https://github.com/jakeberg/backend-sqlalchemy-introduction","description":null,"fork":true,"url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction","forks_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/forks","keys_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/teams","hooks_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/hooks","issue_events_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/issues/events{/number}","events_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/events","assignees_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/assignees{/user}","branches_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/branches{/branch}","tags_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/tags","blobs_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/git/refs{/sha}","trees_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/statuses/{sha}","languages_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/languages","stargazers_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/stargazers","contributors_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/contributors","subscribers_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/subscribers","subscription_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/subscription","commits_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/commits{/sha}","git_commits_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/git/commits{/sha}","comments_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/comments{/number}","issue_comment_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/issues/comments{/number}","contents_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/contents/{+path}","compare_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/merges","archive_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/downloads","issues_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/issues{/number}","pulls_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/pulls{/number}","milestones_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/milestones{/number}","notifications_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/labels{/name}","releases_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/releases{/id}","deployments_url":"https://api.github.com/repos/jakeberg/backend-sqlalchemy-introduction/deployments","created_at":"2018-11-06T15:51:15Z","updated_at":"2018-11-15T19:47:39Z","pushed_at":"2018-11-15T19:47:37Z","git_url":"git://github.com/jakeberg/backend-sqlalchemy-introduction.git","ssh_url":"git@github.com:jakeberg/backend-sqlalchemy-introduction.git","clone_url":"https://github.com/jakeberg/backend-sqlalchemy-introduction.git","svn_url":"https://github.com/jakeberg/backend-sqlalchemy-introduction","homepage":null,"size":56,"stargazers_count":0,"watchers_count":0,"language":"Python","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":"master"}},"base":{"label":"KenzieAcademy:sprint-b","ref":"sprint-b","sha":"664bf935025d98897eef28d17a0d50b44a0f23ac","user":{"login":"KenzieAcademy","id":33695470,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMzNjk1NDcw","avatar_url":"https://avatars2.githubusercontent.com/u/33695470?v=4","gravatar_id":"","url":"https://api.github.com/users/KenzieAcademy","html_url":"https://github.com/KenzieAcademy","followers_url":"https://api.github.com/users/KenzieAcademy/followers","following_url":"https://api.github.com/users/KenzieAcademy/following{/other_user}","gists_url":"https://api.github.com/users/KenzieAcademy/gists{/gist_id}","starred_url":"https://api.github.com/users/KenzieAcademy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KenzieAcademy/subscriptions","organizations_url":"https://api.github.com/users/KenzieAcademy/orgs","repos_url":"https://api.github.com/users/KenzieAcademy/repos","events_url":"https://api.github.com/users/KenzieAcademy/events{/privacy}","received_events_url":"https://api.github.com/users/KenzieAcademy/received_events","type":"Organization","site_admin":false},"repo":{"id":155507936,"node_id":"MDEwOlJlcG9zaXRvcnkxNTU1MDc5MzY=","name":"backend-sqlalchemy-introduction","full_name":"KenzieAcademy/backend-sqlalchemy-introduction","private":false,"owner":{"login":"KenzieAcademy","id":33695470,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMzNjk1NDcw","avatar_url":"https://avatars2.githubusercontent.com/u/33695470?v=4","gravatar_id":"","url":"https://api.github.com/users/KenzieAcademy","html_url":"https://github.com/KenzieAcademy","followers_url":"https://api.github.com/users/KenzieAcademy/followers","following_url":"https://api.github.com/users/KenzieAcademy/following{/other_user}","gists_url":"https://api.github.com/users/KenzieAcademy/gists{/gist_id}","starred_url":"https://api.github.com/users/KenzieAcademy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KenzieAcademy/subscriptions","organizations_url":"https://api.github.com/users/KenzieAcademy/orgs","repos_url":"https://api.github.com/users/KenzieAcademy/repos","events_url":"https://api.github.com/users/KenzieAcademy/events{/privacy}","received_events_url":"https://api.github.com/users/KenzieAcademy/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction","description":null,"fork":false,"url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction","forks_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/forks","keys_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/keys{/key_id}","collaborators_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/teams","hooks_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/hooks","issue_events_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/issues/events{/number}","events_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/events","assignees_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/assignees{/user}","branches_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/branches{/branch}","tags_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/tags","blobs_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/git/refs{/sha}","trees_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/git/trees{/sha}","statuses_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/statuses/{sha}","languages_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/languages","stargazers_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/stargazers","contributors_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/contributors","subscribers_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/subscribers","subscription_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/subscription","commits_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/commits{/sha}","git_commits_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/git/commits{/sha}","comments_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/comments{/number}","issue_comment_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/issues/comments{/number}","contents_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/contents/{+path}","compare_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/compare/{base}...{head}","merges_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/merges","archive_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/downloads","issues_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/issues{/number}","pulls_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls{/number}","milestones_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/milestones{/number}","notifications_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/labels{/name}","releases_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/releases{/id}","deployments_url":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/deployments","created_at":"2018-10-31T06:12:29Z","updated_at":"2018-11-05T19:55:34Z","pushed_at":"2018-11-19T21:03:17Z","git_url":"git://github.com/KenzieAcademy/backend-sqlalchemy-introduction.git","ssh_url":"git@github.com:KenzieAcademy/backend-sqlalchemy-introduction.git","clone_url":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction.git","svn_url":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction","homepage":null,"size":43,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":10,"mirror_url":null,"archived":false,"open_issues_count":17,"license":null,"forks":10,"open_issues":17,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15"},"html":{"href":"https://github.com/KenzieAcademy/backend-sqlalchemy-introduction/pull/15"},"issue":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/issues/15"},"comments":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/issues/15/comments"},"review_comments":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15/comments"},"review_comment":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/pulls/15/commits"},"statuses":{"href":"https://api.github.com/repos/KenzieAcademy/backend-sqlalchemy-introduction/statuses/5a8c6c0c8e6e5cc96f3844955c28f38acca0b0a8"}},"author_association":"NONE"}}
{"actor":{"display_login":"infosmith"}}