{"action":"created","issue":{"url":"https://api.github.com/repos/igordardani/trabalhoTCSC/issues/6","repository_url":"https://api.github.com/repos/igordardani/trabalhoTCSC","labels_url":"https://api.github.com/repos/igordardani/trabalhoTCSC/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/igordardani/trabalhoTCSC/issues/6/comments","events_url":"https://api.github.com/repos/igordardani/trabalhoTCSC/issues/6/events","html_url":"https://github.com/igordardani/trabalhoTCSC/issues/6","id":187469855,"number":6,"title":"BANCO SQL v1.2","user":{"login":"rmrogerio","id":23152103,"avatar_url":"https://avatars.githubusercontent.com/u/23152103?v=3","gravatar_id":"","url":"https://api.github.com/users/rmrogerio","html_url":"https://github.com/rmrogerio","followers_url":"https://api.github.com/users/rmrogerio/followers","following_url":"https://api.github.com/users/rmrogerio/following{/other_user}","gists_url":"https://api.github.com/users/rmrogerio/gists{/gist_id}","starred_url":"https://api.github.com/users/rmrogerio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmrogerio/subscriptions","organizations_url":"https://api.github.com/users/rmrogerio/orgs","repos_url":"https://api.github.com/users/rmrogerio/repos","events_url":"https://api.github.com/users/rmrogerio/events{/privacy}","received_events_url":"https://api.github.com/users/rmrogerio/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-11-05T01:51:00Z","updated_at":"2016-11-05T15:49:52Z","closed_at":null,"body":"create database TCSC_BD\r\n\r\nuse TCSC_BD\r\n\r\ncreate table Empregado(\r\nCPF int identity primary key not null,\r\nCodFunc int,\r\nNome varchar(15),\r\nSobrenome varchar(15),\r\nVencimento float\r\n);\r\n\r\ncreate table Comissionado(\r\nTotalVenda float,\r\nTaxaComissao float,\r\nVencimento float,\r\nCodFunc int\r\n);\r\n\r\ncreate table Horista(\r\nTotalVenda float,\r\nTaxaComissao float,\r\nVencimento float,\r\nCodFunc int\r\n);\r\n\r\n--float porque o SQL não aceita double"},"comment":{"url":"https://api.github.com/repos/igordardani/trabalhoTCSC/issues/comments/258620117","html_url":"https://github.com/igordardani/trabalhoTCSC/issues/6#issuecomment-258620117","issue_url":"https://api.github.com/repos/igordardani/trabalhoTCSC/issues/6","id":258620117,"user":{"login":"rmrogerio","id":23152103,"avatar_url":"https://avatars.githubusercontent.com/u/23152103?v=3","gravatar_id":"","url":"https://api.github.com/users/rmrogerio","html_url":"https://github.com/rmrogerio","followers_url":"https://api.github.com/users/rmrogerio/followers","following_url":"https://api.github.com/users/rmrogerio/following{/other_user}","gists_url":"https://api.github.com/users/rmrogerio/gists{/gist_id}","starred_url":"https://api.github.com/users/rmrogerio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmrogerio/subscriptions","organizations_url":"https://api.github.com/users/rmrogerio/orgs","repos_url":"https://api.github.com/users/rmrogerio/repos","events_url":"https://api.github.com/users/rmrogerio/events{/privacy}","received_events_url":"https://api.github.com/users/rmrogerio/received_events","type":"User","site_admin":false},"created_at":"2016-11-05T15:49:52Z","updated_at":"2016-11-05T15:49:52Z","body":"create database TCSC_BD\r\n\r\nuse TCSC_BD\r\n\r\ncreate table Empregado(\r\nCPF int not null,\r\nCodFunc int identity primary key not null,\r\nNome varchar(15) not null,\r\nSobrenome varchar(15)not null\r\n);\r\n\r\ncreate table Comissionado(\r\nTotalVenda float not null,\r\nTaxaComissao float not null,\r\nCodFunc int identity primary key not null\r\nforeign key(CodFunc) references Empregado (CodFunc)\r\n);\r\n\r\ncreate table Horista(\r\nTotalVenda float not null,\r\nTaxaComissao float not null,\r\nCodFunc int identity primary key not null,\r\nforeign key(CodFunc) references Empregado (CodFunc)\r\n);"}}
{"actor":{"display_login":"rmrogerio"}}