2.2.12RC1 network sql query

mysql> select * from nics where instance_id='4'\G
*************************** 1. row ***************************
            id: 8
   instance_id: 4
   mac_address: 06:02:34:00:00:63
   ip4_address: 207.178.148.68
       netmask: 255.255.255.0
       gateway: 207.178.148.1
       ip_type: Ip4
 broadcast_uri: vlan://500
    network_id: 200
          mode: Static
         state: Reserved
      strategy: Managed
 reserver_name: PublicNetworkGuru
reservation_id: NULL
     device_id: 2
   update_time: 2011-09-28 10:55:36
 isolation_uri: vlan://500
   ip6_address: NULL
   default_nic: 1
       vm_type: DomainRouter
       created: 2011-08-14 03:07:11
       removed: NULL
*************************** 2. row ***************************
            id: 9
   instance_id: 4
   mac_address: 02:00:3c:8c:00:02
   ip4_address: 172.22.83.1
       netmask: 255.255.255.0
       gateway: NULL
       ip_type: Ip4
 broadcast_uri: vlan://911
    network_id: 204
          mode: Dhcp
         state: Reserved
      strategy: Start
 reserver_name: GuestNetworkGuru
reservation_id: b99c384a-6708-481f-991b-8c6821ed3e67
     device_id: 0
   update_time: 2011-09-22 11:08:24
 isolation_uri: vlan://911
   ip6_address: NULL
   default_nic: 0
       vm_type: DomainRouter
       created: 2011-08-14 03:07:11
       removed: NULL
*************************** 3. row ***************************
            id: 10
   instance_id: 4
   mac_address: 0e:00:a9:fe:00:5e
   ip4_address: 169.254.0.94
       netmask: 255.255.0.0
       gateway: 169.254.0.1
       ip_type: Ip4
 broadcast_uri: NULL
    network_id: 202
          mode: Static
         state: Reserved
      strategy: Start
 reserver_name: ControlNetworkGuru
reservation_id: b99c384a-6708-481f-991b-8c6821ed3e67
     device_id: 1
   update_time: 2011-09-22 11:08:24
 isolation_uri: NULL
   ip6_address: NULL
   default_nic: 0
       vm_type: DomainRouter
       created: 2011-08-14 03:07:11
       removed: NULL
3 rows in set (0.00 sec)




mysql> select * from networks where id='200'\G
*************************** 1. row ***************************
                       id: 200
                     name: NULL
             display_text: NULL
             traffic_type: Public
    broadcast_domain_type: Vlan
            broadcast_uri: NULL
                  gateway: NULL
                     cidr: NULL
                     mode: Static
      network_offering_id: 1
           data_center_id: 1
                guru_name: PublicNetworkGuru
                    state: Setup
                  related: 200
                domain_id: 1
               account_id: 1
                     dns1: NULL
                     dns2: NULL
                guru_data: NULL
               set_fields: 0
               guest_type: NULL
                   shared: 1
       is_domain_specific: 0
           network_domain: NULL
           reservation_id: NULL
               is_default: 0
                  created: 2011-08-14 02:31:30
                  removed: NULL
is_security_group_enabled: 0
1 row in set (0.00 sec)

mysql> select * from networks where id='202'\G
*************************** 1. row ***************************
                       id: 202
                     name: NULL
             display_text: NULL
             traffic_type: Control
    broadcast_domain_type: LinkLocal
            broadcast_uri: NULL
                  gateway: 169.254.0.1
                     cidr: 169.254.0.0/16
                     mode: Static
      network_offering_id: 3
           data_center_id: 1
                guru_name: ControlNetworkGuru
                    state: Setup
                  related: 202
                domain_id: 1
               account_id: 1
                     dns1: NULL
                     dns2: NULL
                guru_data: NULL
               set_fields: 0
               guest_type: NULL
                   shared: 1
       is_domain_specific: 0
           network_domain: NULL
           reservation_id: NULL
               is_default: 0
                  created: 2011-08-14 02:31:30
                  removed: NULL
is_security_group_enabled: 0
1 row in set (0.00 sec)

mysql> select * from networks where id='204'\G
*************************** 1. row ***************************
                       id: 204
                     name: Virtual Network
             display_text: A dedicated virtualized network for your account.  The broadcast domain is contained within a VLAN and all public network access is routed out by a virtual router.
             traffic_type: Guest
    broadcast_domain_type: Vlan
            broadcast_uri: vlan://911
                  gateway: 172.22.83.1
                     cidr: 172.22.83.0/24
                     mode: Dhcp
      network_offering_id: 6
           data_center_id: 1
                guru_name: GuestNetworkGuru
                    state: Implemented
                  related: 204
                domain_id: 1
               account_id: 2
                     dns1: NULL
                     dns2: NULL
                guru_data: NULL
               set_fields: 0
               guest_type: Virtual
                   shared: 0
       is_domain_specific: 0
           network_domain: cs2cloud.internal
           reservation_id: 5cd5a380-4f42-4499-9fb6-5d8758821182
               is_default: 1
                  created: 2011-08-14 03:06:51
                  removed: NULL
is_security_group_enabled: 0
1 row in set (0.00 sec)