{"issue":{"state":"open","pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"user":{"avatar_url":"https://secure.gravatar.com/avatar/f9a68577b9237c2c6329b0d61967e27e?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"f9a68577b9237c2c6329b0d61967e27e","url":"https://api.github.com/users/Drobek","login":"Drobek","id":40193},"milestone":null,"assignee":null,"labels":[],"updated_at":"2011-11-02T14:14:14Z","comments":0,"closed_at":null,"url":"https://api.github.com/repos/Drobek/yach-log/issues/1","body":"# Databáze\r\n\r\n## Cards\r\n * id - int, NN\r\n * name - string, NN\r\n * value - int, NN\r\n * value_type.id -> value_types.id, NN\r\n * menace - int\r\n * intellect - int\r\n * vitality - int\r\n * karma - int\r\n * fraction_id -> fraction.id, NN\r\n * first_ability_id -> abilities.id\r\n * second_ability_id -> abilities.id\r\n * third_ability_id -> abilities.id\r\n * fourth_ability_id -> abilities.id\r\n\r\nAbility jsou výčtem protože jich je vždy přesný pevný maximální počet. \r\nNávaznost na tabulku subtypes bude přes cards_subtypes protože jedna karta může mít 0,1 nebo víc subtypů (nejspíš max 2 ale není to jisté takže lepší mít to obecněji)\r\nvalue_type je kvuli trikum (karty mají points)\r\n\r\n## Abilities\r\n * id - int, NN\r\n * cost - string, NN\r\n * effect - string, NN\r\n * ability_type_id -> ability_types.id, NN\r\nčasem možná rozšířit aby se s tím líp počítalo\r\n\r\n## Fractions\r\n * id - int, NN\r\n * name - string, NN\r\n\r\n## Subtypes\r\n * id - int, NN\r\n * name - string, NN\r\n\r\n## Cards_subtypes\r\n * id - int, NN\r\n * card_id -> cards.id, NN\r\n * subtype_id -> subtypes.id, NN\r\n\r\n## Value_types\r\n * id - int, NN\r\n * name - string, NN","html_url":"https://github.com/Drobek/yach-log/issues/1","number":1,"title":"Udelat db strukturu","id":2121736,"created_at":"2011-11-02T14:14:14Z"},"action":"opened"}