Skip Navigation

Federal Communications Commission

English Display Options

Postgresql Table Instantiation Sample - Measuring Broadband America Data April
2012

Author: 
James Miller
-- Table structure for table  curr_avail 
--
DROP TABLE IF EXISTS  curr_avail ;
CREATE TABLE  curr_avail  (
   unit_id  int  DEFAULT NULL,
   location_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL
) ;
--
-- Table structure for table  curr_availfail 
--
DROP TABLE IF EXISTS  curr_availfail ;
CREATE TABLE  curr_availfail  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   lasthop1  varchar  DEFAULT NULL,
   lasthop2  varchar  DEFAULT NULL,
   lasthop3  varchar  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_dlping 
--
DROP TABLE IF EXISTS  curr_dlping ;
CREATE TABLE  curr_dlping  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   rtt_avg  int  DEFAULT NULL,
   rtt_min  int  DEFAULT NULL,
   rtt_max  int  DEFAULT NULL,
   rtt_std  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_dns 
--
DROP TABLE IF EXISTS  curr_dns ;
CREATE TABLE  curr_dns  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   nameserver  varchar  DEFAULT NULL,
   lookup_host  varchar  DEFAULT NULL,
   response_ip  varchar  DEFAULT NULL,
   rtt  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_httpget 
--
DROP TABLE IF EXISTS  curr_httpget ;
CREATE TABLE  curr_httpget  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   address  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   bytes_sec_interval  int  DEFAULT NULL,
   warmup_time  int  DEFAULT NULL,
   warmup_bytes  int  DEFAULT NULL,
   sequence  int  DEFAULT NULL,
   threads  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_httpgetmt 
--
DROP TABLE IF EXISTS  curr_httpgetmt ;
CREATE TABLE  curr_httpgetmt  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   address  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   bytes_sec_interval  int  DEFAULT NULL,
   warmup_time  int  DEFAULT NULL,
   warmup_bytes  int  DEFAULT NULL,
   sequence  int  DEFAULT NULL,
   threads  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_httpgetmt6 
--
DROP TABLE IF EXISTS  curr_httpgetmt6 ;
CREATE TABLE  curr_httpgetmt6  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   address  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   bytes_sec_interval  int  DEFAULT NULL,
   warmup_time  int  DEFAULT NULL,
   warmup_bytes  int  DEFAULT NULL,
   sequence  int  DEFAULT NULL,
   threads  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_httppost 
--
DROP TABLE IF EXISTS  curr_httppost ;
CREATE TABLE  curr_httppost  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   address  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   bytes_sec_interval  int  DEFAULT NULL,
   warmup_time  int  DEFAULT NULL,
   warmup_bytes  int  DEFAULT NULL,
   sequence  int  DEFAULT NULL,
   threads  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_httppostmt 
--
DROP TABLE IF EXISTS  curr_httppostmt ;
CREATE TABLE  curr_httppostmt  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   address  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   bytes_sec_interval  int  DEFAULT NULL,
   warmup_time  int  DEFAULT NULL,
   warmup_bytes  int  DEFAULT NULL,
   sequence  int  DEFAULT NULL,
   threads  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_httppostmt6 
--
DROP TABLE IF EXISTS  curr_httppostmt6 ;
CREATE TABLE  curr_httppostmt6  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   address  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   bytes_sec_interval  int  DEFAULT NULL,
   warmup_time  int  DEFAULT NULL,
   warmup_bytes  int  DEFAULT NULL,
   sequence  int  DEFAULT NULL,
   threads  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_netusage 
--
DROP TABLE IF EXISTS  curr_netusage ;
CREATE TABLE  curr_netusage  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   wan_rx_bytes  bigint  DEFAULT NULL,
   wan_tx_bytes  bigint  DEFAULT NULL,
   sk_rx_bytes  bigint  DEFAULT NULL,
   sk_tx_bytes  bigint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_ping 
--
DROP TABLE IF EXISTS  curr_ping ;
CREATE TABLE  curr_ping  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   rtt_avg  int  DEFAULT NULL,
   rtt_min  int  DEFAULT NULL,
   rtt_max  int  DEFAULT NULL,
   rtt_std  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_ping6 
--
DROP TABLE IF EXISTS  curr_ping6 ;
CREATE TABLE  curr_ping6  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   rtt_avg  int  DEFAULT NULL,
   rtt_min  int  DEFAULT NULL,
   rtt_max  int  DEFAULT NULL,
   rtt_std  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_udpjitter 
--
DROP TABLE IF EXISTS  curr_udpjitter ;
CREATE TABLE  curr_udpjitter  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   packet_size  int  DEFAULT NULL,
   stream_rate  int  DEFAULT NULL,
   duration  int  DEFAULT NULL,
   packets_up_sent  int  DEFAULT NULL,
   packets_down_sent  int  DEFAULT NULL,
   packets_up_recv  int  DEFAULT NULL,
   packets_down_recv  int  DEFAULT NULL,
   jitter_up  int  DEFAULT NULL,
   jitter_down  int  DEFAULT NULL,
   latency  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_udplatency 
--
DROP TABLE IF EXISTS  curr_udplatency ;
CREATE TABLE  curr_udplatency  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   rtt_avg  int  DEFAULT NULL,
   rtt_min  int  DEFAULT NULL,
   rtt_max  int  DEFAULT NULL,
   rtt_std  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_ulping 
--
DROP TABLE IF EXISTS  curr_ulping ;
CREATE TABLE  curr_ulping  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   rtt_avg  int  DEFAULT NULL,
   rtt_min  int  DEFAULT NULL,
   rtt_max  int  DEFAULT NULL,
   rtt_std  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_videostream 
--
DROP TABLE IF EXISTS  curr_videostream ;
CREATE TABLE  curr_videostream  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   downthrpt  int  DEFAULT NULL,
   downjitter  int  DEFAULT NULL,
   latency  int  DEFAULT NULL,
   jitter  int  DEFAULT NULL,
   buffer_underruns  int  DEFAULT NULL,
   buffer_delay  int  DEFAULT NULL,
   buffer_filltime  int  DEFAULT NULL,
   duration  int  DEFAULT NULL,
   bitrate  int  DEFAULT NULL,
   buffer_size  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_webget 
--
DROP TABLE IF EXISTS  curr_webget ;
CREATE TABLE curr_webget (
  unit_id int NOT NULL DEFAULT '0',
  dtime timestamp DEFAULT NULL,
  target varchar(200) NOT NULL DEFAULT '',
  address varchar(45) DEFAULT NULL,
  fetch_time int DEFAULT NULL,
  bytes_total int DEFAULT NULL,
  bytes_sec int DEFAULT NULL,
  objects int DEFAULT NULL,
  threads int DEFAULT NULL,
  requests int DEFAULT NULL,
  connections int DEFAULT NULL,
  reused_connections int DEFAULT NULL,
  lookups int DEFAULT NULL,
  request_total_time int DEFAULT NULL,
  request_min_time int DEFAULT NULL,
  request_avg_time int DEFAULT NULL,
  request_max_time int DEFAULT NULL,
  ttfb_total int DEFAULT NULL,
  ttfb_min int DEFAULT NULL,
  ttfb_avg int DEFAULT NULL,
  ttfb_max int DEFAULT NULL,
  lookup_total_time int DEFAULT NULL,
  lookup_min_time int DEFAULT NULL,
  lookup_avg_time int DEFAULT NULL,
  lookup_max_time int DEFAULT NULL,
  successes smallint DEFAULT NULL,
  failures smallint DEFAULT NULL,
  location_id int NOT NULL DEFAULT '0'
) ;


--
-- Table structure for table  curr_webgetobjects 
--
DROP TABLE IF EXISTS  curr_webgetobjects ;
CREATE TABLE  curr_webgetobjects  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   referrer  varchar  DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;
--
-- Table structure for table  curr_www 
--
DROP TABLE IF EXISTS  curr_www ;
CREATE TABLE  curr_www  (
   unit_id  int  DEFAULT NULL,
   dtime  timestamp DEFAULT NULL,
   target  varchar  DEFAULT NULL,
   fetch_time  int  DEFAULT NULL,
   bytes_total  int  DEFAULT NULL,
   bytes_sec  int  DEFAULT NULL,
   successes  smallint  DEFAULT NULL,
   failures  smallint  DEFAULT NULL,
   location_id  int  DEFAULT NULL
) ;

close
FCC

You are leaving the FCC website

You are about to leave the FCC website and visit a third-party, non-governmental website that the FCC does not maintain or control. The FCC does not endorse any product or service, and is not responsible for, nor can it guarantee the validity or timeliness of the content on the page you are about to visit. Additionally, the privacy policies of this third-party page may differ from those of the FCC.