mysql> status
--------------

Connection id:		32969624
Current database:	familygps
Current user:		gaff@ps104003.dreamhostps.com
SSL:			Not in use
Current pager:		stdout
Using outfile:		'familygps_dd.txt'
Using delimiter:	;
Server version:		5.7.29-log Source distribution
Protocol version:	10
Connection:		mysql.gystdoit.com via TCP/IP
Server characterset:	latin1
Db     characterset:	utf8
Client characterset:	latin1
Conn.  characterset:	latin1
TCP port:		3306
Uptime:			131 days 1 hour 21 min 54 sec

Threads: 6  Questions: 5636472716  Slow queries: 59720080  Opens: 171114125  Flush tables: 1  Open tables: 2048  Queries per second avg: 497.775
--------------

mysql> show columns from family;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| 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        | YES  |     | NULL    |       |
| PHOTO     | varchar(50) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
8 rows in set (0.07 sec)

mysql> show columns from fam_member;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| fam_id   | varchar(16) | YES  |     | NULL    |       |
| IND_ID   | varchar(20) | YES  |     | NULL    |       |
| GIVEN    | varchar(40) | YES  |     | NULL    |       |
| MARRIED  | varchar(40) | YES  |     | NULL    |       |
| BORN     | date        | YES  |     | NULL    |       |
| DIED     | date        | 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.07 sec)

mysql> show tables;
+---------------------+
| Tables_in_familygps |
+---------------------+
| cropdates           |
| fam_member          |
| fam_member3         |
| family              |
| famload             |
| famprod             |
| flanbook            |
| fmload              |
| fmprod              |
+---------------------+
9 rows in set (0.07 sec)

mysql> show columns from famload;
+-----------+-----------------------+------+-----+---------+-------+
| Field     | Type                  | Null | Key | Default | Extra |
+-----------+-----------------------+------+-----+---------+-------+
| fam_id    | mediumint(8) unsigned | 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                  | YES  |     | NULL    |       |
| wed_place | varchar(50)           | YES  |     | NULL    |       |
| photo     | varchar(50)           | YES  |     | NULL    |       |
+-----------+-----------------------+------+-----+---------+-------+
9 rows in set (0.07 sec)

mysql> show columns from famprod;
+--------+-----------------------+------+-----+---------+-------+
| Field  | Type                  | Null | Key | Default | Extra |
+--------+-----------------------+------+-----+---------+-------+
| FAM_ID | mediumint(8) unsigned | YES  |     | NULL    |       |
+--------+-----------------------+------+-----+---------+-------+
1 row in set (0.07 sec)

mysql> \t