gistfile1.txt

mysql> explain parent_load_balancers;
+------------------+---------+------+-----+---------+-------+
| Field            | Type    | Null | Key | Default | Extra |
+------------------+---------+------+-----+---------+-------+
| load_balancer_id | int(11) | NO   | PRI | NULL    |       |
| virtual_ip_id    | int(11) | NO   |     | NULL    |       |
+------------------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

child_load_balancers
+-------------------------+-----------+------+-----+---------+-------+
| Field                   | Type      | Null | Key | Default | Extra |
+-------------------------+-----------+------+-----+---------+-------+
| id                      | char(36)  | NO   | PRI | NULL    |       |
| load_balancer_id        | int(11)   | YES  |     | NULL    |       |
| parent_load_balancer_id | int(11)   | NO   | MUL | NULL    |       |
| port                    | int(11)   | NO   |     | NULL    |       |
| datastore_type          | char(16)  | YES  |     | NULL    |       |
| state                   | char(20)  | YES  |     | NULL    |       |
| dns_name                | char(255) | YES  |     | NULL    |       |
+-------------------------+-----------+------+-----+---------+-------+
7 rows in set (0.00 sec)

mysql> explain load_balancer_nodes;
+------------------------+------------+------+-----+---------+-------+
| Field                  | Type       | Null | Key | Default | Extra |
+------------------------+------------+------+-----+---------+-------+
| id                     | char(36)   | NO   | PRI |         |       |
| child_load_balancer_id | char(36)   | YES  |     | NULL    |       |
| dns_name               | char(255)  | YES  |     | NULL    |       |
| primary_node           | tinyint(1) | YES  |     | 0       |       |
| private_ip             | char(15)   | YES  |     | NULL    |       |
+------------------------+------------+------+-----+---------+-------+
5 rows in set (0.00 sec)