Node:Database, Next:, Previous:Misc modules, Up:Top



Database

Database Organisation

We have placed the datas in the different bases in nine different tables.

                             --------------
                             |  port_info |
                             --------------
                             | id         |
                             | port       |
                             | bw         |
                             --------------
 ---------------                    |                 -------------
 | vlan_config |\              id_computer            |  type     |
 --------------- \                = id               /-------------
 | id          |  \                 |               / | id        |
 | port        |    id_computer     |          type   | nom       |
 | vlan        |     = id           |          = id   -------------
 ---------------        \           |         /
                         \          |        /
 ---------------          \  ----------------             -------------
 | remote      |           \ |  computer    |             | vlan_list |
 ---------------             ----------------             -------------
 | host_id     | id_computer | id_computer  | id_computer | id        |
 | port        |---- = ----- | type         | ---- = ---  | vlan      |
 | remote_mac  |   host_id   | flag         |     id      -------------
 | vlan        |             | last_up_date |
 ---------------             | tested       |
                             | constructor  |
                             ----------------
 ---------------                   |        \          ------------
 | tree        |                   |         \         | vlan_tag |
 ---------------    id_computer     |      id_computer  ------------
 | id_father   |   > id_father      |          = id  \  | id       |
 | father_port |   > id_son         |                 \ | vlan     |
 | id_son      |              id_computer              ------------
 | son_port    |                 = id
 | vlan        |                    |
 ---------------                    |
                             ---------------
                             | asso_mac_ip |
                             ---------------
                             | id          |
                             | mac         |
                             | ip          |
                             ---------------