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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31071 | (30820) | 0 | (d47cb361-8ae1-4d8b-b92d-c72baa82ab74) | Zhang Jiazhen | By the battle of Red Cliffs in the year 208, the Wu kingdom controlled more than seven thousand warships on the Yangtze. | {4}{U} | 5.00 | Red Cliffs Armada | Red Cliffs Armada can't attack unless defending player controls an Island. | 5 | 4 | Creature — Human Soldier | black | https://c1.scryfall.com/file/scryfall-cards/art_crop/front/d/0/d0391b4f-e819-409a-9e81-1bff932808e7.jpg?1562870490 | NULL | https://c1.scryfall.com/file/scryfall-cards/small/front/d/0/d0391b4f-e819-409a-9e81-1bff932808e7.jpg?1562870490 | https://c1.scryfall.com/file/scryfall-cards/normal/front/d/0/d0391b4f-e819-409a-9e81-1bff932808e7.jpg?1562870490 | https://c1.scryfall.com/file/scryfall-cards/large/front/d/0/d0391b4f-e819-409a-9e81-1bff932808e7.jpg?1562870490 | https://c1.scryfall.com/file/scryfall-cards/png/front/d/0/d0391b4f-e819-409a-9e81-1bff932808e7.png?1562870490 | https://c1.scryfall.com/file/scryfall-cards/border_crop/front/d/0/d0391b4f-e819-409a-9e81-1bff932808e7.jpg?1562870490 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | Red Cliffs Armada Red Cliffs Armada can t attack unless defending player controls an Island By the battle of Red Cliffs in the year 208 the Wu kingdom controlled more than seven thousand warships on the Yangtze Creature Human Soldier Zhang Jiazhen | 2020-06-09 01:00:56 | 2020-09-28 16:08:00 |