*** Tables Used ***


artist
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id_artist | int(10) unsigned |      | PRI | NULL    | auto_increment |
| artist    | varchar(30)      | YES  |     | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+

attribute
+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| id_attribute | int(10) unsigned |      | PRI | NULL    | auto_increment |
| attribute    | varchar(40)      | YES  |     | NULL    |                |
+--------------+------------------+------+-----+---------+----------------+

card_attribute
+--------------+------------------+------+-----+---------+-------+
| Field        | Type             | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| id_card      | int(10) unsigned | YES  |     | NULL    |       |
| id_attribute | int(10) unsigned | YES  |     | NULL    |       |
+--------------+------------------+------+-----+---------+-------+

card_subtype
+------------+------------------+------+-----+---------+-------+
| Field      | Type             | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| id_card    | int(10) unsigned | YES  |     | NULL    |       |
| id_subtype | int(10) unsigned | YES  |     | NULL    |       |
+------------+------------------+------+-----+---------+-------+

cards
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id_card    | int(10) unsigned |      | PRI | NULL    | auto_increment |
| id_rarity  | int(10) unsigned | YES  |     | NULL    |                |
| id_distro  | int(10) unsigned | YES  |     | NULL    |                |
| id_type    | int(10) unsigned | YES  |     | NULL    |                |
| id_artist  | int(10) unsigned | YES  |     | NULL    |                |
| quantity   | int(10) unsigned | YES  |     | NULL    |                |
| cardnum    | varchar(4)       | YES  |     | NULL    |                |
| name       | varchar(30)      | YES  |     | NULL    |                |
| effect     | text             | YES  |     | NULL    |                |
| lore       | text             | YES  |     | NULL    |                |
| p_ability  | int(10) unsigned | YES  |     | NULL    |                |
| i_ability  | int(10) unsigned | YES  |     | NULL    |                |
| op_ability | int(10) unsigned | YES  |     | NULL    |                |
| c_ability  | int(10) unsigned | YES  |     | NULL    |                |
| p_cost     | int(10) unsigned | YES  |     | NULL    |                |
| i_cost     | int(10) unsigned | YES  |     | NULL    |                |
| op_cost    | int(10) unsigned | YES  |     | NULL    |                |
| c_cost     | int(10) unsigned | YES  |     | NULL    |                |
| errata     | text             | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

distribution
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id_distro | int(10) unsigned |      | PRI | NULL    | auto_increment |
| distro    | varchar(30)      | YES  |     | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+

rarity
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id_rarity | int(10) unsigned |      | PRI | NULL    | auto_increment |
| rarity    | varchar(15)      | YES  |     | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+

subtype
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id_subtype | int(10) unsigned |      | PRI | NULL    | auto_increment |
| subtype    | varchar(30)      | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

type
+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| id_type | int(10) unsigned |      | PRI | NULL    | auto_increment |
| type    | varchar(10)      | YES  |     | NULL    |                |
+---------+------------------+------+-----+---------+----------------+