Belongs To Relationships
cardface ( see all )
| id | card_id | cardface_index | illustration_id | artist | color | color_identity | flavor_text | image_uri | mana_cost | cmc | name | oracle_text | power | toughness | type_line | border_color | image_uri_art_crop | image_hash_art_crop | image_uri_small | image_hash_small | image_uri_normal | image_hash_normal | image_uri_large | image_hash_large | image_uri_png | image_hash_png | image_uri_border_crop | image_hash_border_crop | is_foil | is_nonfoil | is_oversized | is_color_green | is_color_red | is_color_blue | is_color_black | is_color_white | is_colorless | color_count | is_color_identity_green | is_color_identity_red | is_color_identity_blue | is_color_identity_black | is_color_identity_white | color_identity_count | is_snow | has_phyrexian_mana | for_fulltext_search | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24801 | (24454) | 0 | (158c484f-b962-4829-add7-eab8d41401d8) | Tyler Jacobson | The flaming fist of Boros holds the promise of both protection and destruction in its grasp. | https://img.scryfall.com/cards/art_crop/front/c/c/ccbc2f22-4500-4c74-a1a2-51d8238c1d16.jpg?1561846241 | {1}{R} | 2.00 | Firefist Striker | Battalion — Whenever Firefist Striker and at least two other creatures attack, target creature can't block this turn. | 2 | 1 | Creature — Human Soldier | black | https://img.scryfall.com/cards/art_crop/front/c/c/ccbc2f22-4500-4c74-a1a2-51d8238c1d16.jpg?1561846241 | NULL | https://img.scryfall.com/cards/small/front/c/c/ccbc2f22-4500-4c74-a1a2-51d8238c1d16.jpg?1561846241 | https://img.scryfall.com/cards/normal/front/c/c/ccbc2f22-4500-4c74-a1a2-51d8238c1d16.jpg?1561846241 | https://img.scryfall.com/cards/large/front/c/c/ccbc2f22-4500-4c74-a1a2-51d8238c1d16.jpg?1561846241 | https://img.scryfall.com/cards/png/front/c/c/ccbc2f22-4500-4c74-a1a2-51d8238c1d16.png?1561846241 | https://img.scryfall.com/cards/border_crop/front/c/c/ccbc2f22-4500-4c74-a1a2-51d8238c1d16.jpg?1561846241 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | Firefist Striker Battalion Whenever Firefist Striker and at least two other creatures attack target creature can t block this turn The flaming fist of Boros holds the promise of both protection and destruction in its grasp Creature Human Soldier Tyler Jacobson | 2020-07-24 17:39:26 | 2020-07-24 17:39:26 |