mysql> SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH AS SIZE,IS_NULLABLE, COLUMN_DEFAULT   FROM INFORMATION_SCHEMA.COLUMNS   WHERE table_name = 'fam_member';
+-------------+-----------+------+-------------+----------------+
| COLUMN_NAME | DATA_TYPE | SIZE | IS_NULLABLE | COLUMN_DEFAULT |
+-------------+-----------+------+-------------+----------------+
| fam_id      | varchar   |   16 | YES         | NULL           |
| IND_ID      | varchar   |   20 | YES         | NULL           |
| GIVEN       | varchar   |   40 | YES         | NULL           |
| MARRIED     | varchar   |   40 | YES         | NULL           |
| BORN        | date      | NULL | YES         | NULL           |
| DIED        | date      | NULL | YES         | NULL           |
| DECEASED    | char      |    1 | YES         | NULL           |
| MALE        | char      |    1 | YES         | NULL           |
| PHOTO       | varchar   |   50 | YES         | NULL           |
| OBIT        | varchar   |   50 | YES         | NULL           |
+-------------+-----------+------+-------------+----------------+
10 rows in set (0.73 sec)

mysql> SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH AS SIZE,IS_NULLABLE, COLUMN_DEFAULT   FROM INFORMATION_SCHEMA.COLUMNS   WHERE table_name = 'family';
+-------------+-----------+------+-------------+----------------+
| COLUMN_NAME | DATA_TYPE | SIZE | IS_NULLABLE | COLUMN_DEFAULT |
+-------------+-----------+------+-------------+----------------+
| fam_id      | varchar   |   16 | YES         | NULL           |
| SURNAME     | varchar   |   30 | YES         | NULL           |
| FATHER_ID   | varchar   |   20 | YES         | NULL           |
| FATHER      | varchar   |   40 | YES         | NULL           |
| MOTHER_ID   | varchar   |   20 | YES         | NULL           |
| MOTHER      | varchar   |   40 | YES         | NULL           |
| WED_DATE    | date      | NULL | YES         | NULL           |
| PHOTO       | varchar   |   50 | YES         | NULL           |
+-------------+-----------+------+-------------+----------------+
8 rows in set (0.72 sec)

mysql> select count(*) from family;
+----------+
| count(*) |
+----------+
|      238 |
+----------+
1 row in set (0.08 sec)

mysql> select count(*) from fam_member;
+----------+
| count(*) |
+----------+
|      778 |
+----------+
1 row in set (0.08 sec)

mysql> notee;