wl_config_database 1 WL_Antennas id INTEGER 1 interfaces_id INTEGER 1 antenna_id INTEGER 1 cable_length INTEGER 0 connectors INTEGER 0 hor_angle INTEGER 0 vert_angle INTEGER 0 polarization TEXT 0 PRIMARY 1 id WL_antennas_prefab antenna_id INTEGER 1 name TEXT 0 freq_range TEXT 0 gain INTEGER 0 VSWR TEXT 0 impedance INTEGER 0 inputPower INTEGER 0 operatingTemp TEXT 0 azimutBeam INTEGER 0 elevationBeam INTEGER 0 picture TEXT http://monitor.wirelessleiden.net/img/antenna_def.jpg 0 PRIMARY 1 antenna_id WL_dhcp_pools dhcp_pool_id INTEGER 1 interfaces_id INTEGER 1 ip TEXT 0 subnet INTEGER 0 start_ip TEXT 0 end_ip TEXT 0 PRIMARY 1 dhcp_pool_id WL_downtimes downtime_id INTEGER 1 host_id INTEGER 1 post_id INTEGER 1 start_date TIMESTAMP 1 end_date TIMESTAMP 1 PRIMARY 1 downtime_id WL_gateway gateway_id INTEGER 1 interfaces_id INTEGER 1 name TEXT 0 mac TEXT 0 ip TEXT 0 subnet INTEGER 0 description TEXT 0 PRIMARY 1 gateway_id WL_hostgroups hostgroup_id INTEGER 1 usergroup_id INTEGER 1 name TEXT 0 description TEXT 0 PRIMARY 1 hostgroup_id WL_hostgroup_members host_id INTEGER 1 hostgroup_id INTEGER 1 PRIMARY 1 host_id hostgroup_id WL_hosts host_id INTEGER 1 usergroup_id INTEGER 1 operating_system_id INTEGER 1 hostname TEXT 0 address TEXT 0 config_release TEXT 0 host_status TEXT 0 GPSlat TEXT 0 GPSlong TEXT 0 PRIMARY 1 host_id WL_interfaces interfaces_id INTEGER 1 host_id INTEGER 1 interface_type_prefab_id INTEGER 1 interface_media TEXT 0 interface_mediaopt TEXT 0 interface_name TEXT 0 interface_active BOOLEAN 0 interface_mac TEXT 0 interface_ssid TEXT 0 interface_channel INTEGER 0 PRIMARY 1 interfaces_id WL_interfaces_operating_systems driver_name TEXT 1 interface_type_prefab_id INTEGER 1 operating_system_id INTEGER 1 PRIMARY 1 driver_name interface_type_prefab_id operating_system_id WL_interface_media interface_media_id INTEGER 1 media TEXT 0 PRIMARY 1 interface_media_id WL_interface_mediaopt interface_mediaopt_id INTEGER 1 mediaopt TEXT 0 PRIMARY 1 interface_mediaopt_id WL_interface_type_prefab interface_type_prefab_id INTEGER 1 name TEXT 0 chipset TEXT 0 operationTemp TEXT 0 receiveSensetivity INTEGER 0 transmitPower INTEGER 0 PRIMARY 1 interface_type_prefab_id WL_interface_type_prefab_media interface_media_id INTEGER 1 interface_type_prefab_id INTEGER 1 PRIMARY 1 interface_media_id interface_type_prefab_id WL_interface_type_prefab_mediaopt interface_mediaopt_id INTEGER 1 interface_type_prefab_id INTEGER 1 PRIMARY 1 interface_mediaopt_id interface_type_prefab_id WL_ipaddresses ipaddress_id TEXT 1 ip_pool_id INTEGER 1 PRIMARY 1 ipaddress_id ip_pool_id WL_known_clients known_clients_id INTEGER 1 dhcp_pool_id INTEGER 1 user_id INTEGER 1 mac INTEGER 0 ip INTEGER 0 PRIMARY 1 known_clients_id WL_links link_id INTEGER 1 interfaces_id INTEGER 1 masterIP TEXT 1 clientIP TEXT 1 subnet INTEGER 1 PRIMARY 1 link_id WL_logs log_id INTEGER 1 host_id INTEGER 1 name TEXT 1 WL_posts INTEGER 0 updated_at INTEGER 0 PRIMARY 1 log_id WL_operating_systems operating_system_id INTEGER 1 name INTEGER 0 description INTEGER 0 PRIMARY 1 operating_system_id WL_posts post_id INTEGER 1 log_id INTEGER 1 topic_id INTEGER 1 user_id INTEGER 1 title TEXT 0 body CLOB 0 created_at TIMESTAMP 0 updated_at TIMESTAMP 0 PRIMARY 1 post_id WL_services service_id INTEGER 1 hostgroup_id INTEGER 1 host_id INTEGER 1 naam TEXT 0 PRIMARY 1 service_id WL_topics topic_id INTEGER 1 name TEXT 0 description TEXT 0 PRIMARY 1 topic_id WL_usergroups usergroup_id INTEGER 1 name TEXT 0 level INTEGER 0 1 PRIMARY 1 usergroup_id WL_usergroup_members user_id INTEGER 1 usergroup_id INTEGER 1 PRIMARY 1 user_id usergroup_id WL_users user_id INTEGER 1 username TEXT 1 passwd TEXT 1 firstname TEXT 1 lastname TEXT 1 email TEXT 1 PRIMARY 1 user_id