lsserver:
+-----------------+------------------------------+------+-----+---------+----------------+
| Field           | Type                         | Null | Key | Default |Extra          |
+-----------------+------------------------------+------+-----+---------+----------------+
| host            | varchar(255)                 | YES  |     | NULL    |
|
| id              | int(11)                      |      | PRI | NULL    |
auto_increment |
| locpref         | int(11)                      | YES  |     | NULL    |
|
| metric          | int(11)                      | YES  |     | NULL    |
|
| multiexitdisc   | enum('true','false')         | YES  |     | NULL    |
|
| port            | int(11)                      | YES  |     | NULL    |
|
| capability      | enum('send','rec','sendrec') | YES  |     | sendrec |
|
| itad            | int(11)                      | YES  |     | NULL    |
|
| HoldTimer       | int(11)                      | YES  |     | 90000   |
|
| RestartTimer    | int(11)                      | YES  |     | 60000   |
|
| MaxRestartTimer | int(11)                      | YES  |     | 240000  |
|
| ConnectTimer    | int(11)                      | YES  |     | 120000  |
|
| MaxConnectTimer | int(11)                      | YES  |     | 240000  |
|
| AdvertiseTimer  | int(11)                      | YES  |     | 30000   |
|
+-----------------+------------------------------+------+-----+---------+----------------+

peers:
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| lsserver | int(11)      | YES  |     | NULL    |                |
| id       | int(11)      |      | PRI | NULL    | auto_increment |
| hostport | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

protocol:
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| lsserver | int(11)      | YES  |     | NULL    |                |
| id       | int(11)      |      | PRI | NULL    | auto_increment |
| protocol | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

addrfamily:
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| lsserver   | int(11)      | YES  |     | NULL    |       |
| addrfamily | varchar(255) | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+

localpolicy:
+----------+----------------------------+------+-----+---------+---------
+
| Field    | Type                       | Null | Key | Default | Extra
|
+----------+----------------------------+------+-----+---------+---------
+
| lsserver | int(11)                    | YES  |     | NULL    |
|
| id       | int(11)                    |      | PRI | NULL    |
auto_increment |
| type     | enum('noexport','discard') | YES  |     | NULL    |
|
| value    | varchar(255)               | YES  |     | NULL    |
|
+----------+----------------------------+------+-----+---------+---------
+

localroutes:
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| lsserver  | int(11)      | YES  |     | NULL    |                |
| id        | int(11)      |      | PRI | NULL    | auto_increment |
| RouteAddr | varchar(255) | YES  |     | NULL    |                |
| Proto     | varchar(255) | YES  |     | NULL    |                |
| Prefix    | varchar(255) | YES  |     | NULL    |                |
| Next      | varchar(255) | YES  |     | NULL    |                |
| NextPort  | int(11)      | YES  |     | NULL    |                |
| NextITAD  | int(11)      | YES  |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+

The tables are linked for the LS with the primary key of the lsserver table, id. This key is incremented as the database is populated with LSs. Here is an example of how the lsserver table for the host berlin might look:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|host	|id 	|metric	|multiexitdisc	|port	|capability	|itad	|HoldTimer	|RestartTimer	|MaxRestartTimer	|ConnectTimer	|MaxConnectTimer	|AdvertiseTimer	| 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|berlin	|1	|30	|true		|7004	|sendrec	|20	|240000		|300000		|400000			|200000		|250000		        |300000		|	
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------