gistfile1.txt

mysql> desc doctors
    -> ;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | int(11)     | NO   | PRI | NULL    | auto_increment | 
| first_name | varchar(50) | YES  |     | NULL    |                | 
| last_name  | varchar(50) | YES  |     | NULL    |                | 
+------------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> desc patients
    -> ;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | int(11)     | NO   | PRI | NULL    | auto_increment | 
| first_name | varchar(50) | YES  |     | NULL    |                | 
| last_name  | varchar(50) | YES  |     | NULL    |                | 
+------------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> desc appointments;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | int(11)     | NO   | PRI | NULL    | auto_increment | 
| patient    | varchar(50) | YES  |     | NULL    |                | 
| doctor     | varchar(50) | YES  |     | NULL    |                | 
| patient_id | int(11)     | YES  |     | NULL    |                | 
| doctor_id  | int(11)     | YES  |     | NULL    |                | 
+------------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)