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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43725 | (43469) | 0 | (d47cb361-8ae1-4d8b-b92d-c72baa82ab74) | Zhang Jiazhen | By the battle of Red Cliffs in the year 208, the Wu kingdom controlled more than 7,000 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 | white | https://c1.scryfall.com/file/scryfall-cards/art_crop/front/c/8/c8fe0f33-35c7-439b-bece-4a9461b92352.jpg?1562257535 | NULL | https://c1.scryfall.com/file/scryfall-cards/small/front/c/8/c8fe0f33-35c7-439b-bece-4a9461b92352.jpg?1562257535 | https://c1.scryfall.com/file/scryfall-cards/normal/front/c/8/c8fe0f33-35c7-439b-bece-4a9461b92352.jpg?1562257535 | https://c1.scryfall.com/file/scryfall-cards/large/front/c/8/c8fe0f33-35c7-439b-bece-4a9461b92352.jpg?1562257535 | https://c1.scryfall.com/file/scryfall-cards/png/front/c/8/c8fe0f33-35c7-439b-bece-4a9461b92352.png?1562257535 | https://c1.scryfall.com/file/scryfall-cards/border_crop/front/c/8/c8fe0f33-35c7-439b-bece-4a9461b92352.jpg?1562257535 | 0 | 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 7 000 warships on the Yangtze Creature Human Soldier Zhang Jiazhen | 2020-06-09 05:03:45 | 2020-09-28 01:42:26 |