gistfile1.txt

                 Table "dashboard.gtfsfeed"
      Column      |            Type             | Modifiers 
------------------+-----------------------------+-----------
 id               | bigint                      | not null
 agencyname       | character varying(255)      | 
 agencyurl        | character varying(255)      | 
 areadescription  | character varying(255)      | 
 country          | character varying(255)      | 
 dataexchangeid   | character varying(255)      | 
 dataexchangeurl  | character varying(255)      | 
 dateadded        | timestamp without time zone | 
 dateupdated      | timestamp without time zone | 
 downloadurl      | character varying(255)      | 
 expirationdate   | timestamp without time zone | 
 feedbaseurl      | character varying(255)      | 
 licenseurl       | character varying(255)      | 
 official         | boolean                     | not null
 startdate        | timestamp without time zone | 
 state            | character varying(255)      | 
 storedid         | character varying(255)      | 
 the_geom         | geometry                    | 
 trips            | integer                     | not null
 tripspercalendar | integer                     | not null
 supersededby_id  | bigint                      | 
Indexes:
    "gtfsfeed_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "fk7c4a8358bb244849" FOREIGN KEY (supersededby_id) REFERENCES gtfsfeed(id)
Referenced by:
    TABLE "ntdagency_gtfsfeed" CONSTRAINT "fk34362f34888c161" FOREIGN KEY (feeds_id) REFERENCES gtfsfeed(id)
    TABLE "gtfsfeed" CONSTRAINT "fk7c4a8358bb244849" FOREIGN KEY (supersededby_id) REFERENCES gtfsfeed(id)

Index "dashboard.gtfsfeed_pkey"
 Column |  Type  | Definition 
--------+--------+------------
 id     | bigint | id
primary key, btree, for table "dashboard.gtfsfeed"

    Sequence "dashboard.hibernate_sequence"
    Column     |  Type   |        Value        
---------------+---------+---------------------
 sequence_name | name    | hibernate_sequence
 last_value    | bigint  | 4709
 start_value   | bigint  | 1
 increment_by  | bigint  | 1
 max_value     | bigint  | 9223372036854775807
 min_value     | bigint  | 1
 cache_value   | bigint  | 1
 log_cnt       | bigint  | 30
 is_cycled     | boolean | f
 is_called     | boolean | t

          Table "dashboard.metroarea"
  Column  |          Type          | Modifiers 
----------+------------------------+-----------
 id       | bigint                 | not null
 name     | character varying(255) | 
 the_geom | geometry               | 
Indexes:
    "metroarea_pkey" PRIMARY KEY, btree (id)
Referenced by:
    TABLE "ntdagency" CONSTRAINT "fk5d9754e34cb8ed76" FOREIGN KEY (metroarea_id) REFERENCES metroarea(id)

Index "dashboard.metroarea_pkey"
 Column |  Type  | Definition 
--------+--------+------------
 id     | bigint | id
primary key, btree, for table "dashboard.metroarea"

             Table "dashboard.ntdagency"
     Column     |          Type          | Modifiers 
----------------+------------------------+-----------
 id             | bigint                 | not null
 googlegtfs     | boolean                | not null
 name           | character varying(255) | 
 ntdid          | character varying(255) | 
 passengermiles | integer                | not null
 population     | integer                | not null
 ridership      | integer                | not null
 url            | character varying(255) | 
 metroarea_id   | bigint                 | 
Indexes:
    "ntdagency_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "fk5d9754e34cb8ed76" FOREIGN KEY (metroarea_id) REFERENCES metroarea(id)
Referenced by:
    TABLE "ntdagency_uzanames" CONSTRAINT "fk118c6628866df056" FOREIGN KEY (ntdagency_id) REFERENCES ntdagency(id)
    TABLE "ntdagency_gtfsfeed" CONSTRAINT "fk34362f34866df056" FOREIGN KEY (ntdagency_id) REFERENCES ntdagency(id)

Table "dashboard.ntdagency_gtfsfeed"
    Column    |  Type  | Modifiers 
--------------+--------+-----------
 ntdagency_id | bigint | not null
 feeds_id     | bigint | not null
Indexes:
    "ntdagency_gtfsfeed_pkey" PRIMARY KEY, btree (ntdagency_id, feeds_id)
Foreign-key constraints:
    "fk34362f34866df056" FOREIGN KEY (ntdagency_id) REFERENCES ntdagency(id)
    "fk34362f34888c161" FOREIGN KEY (feeds_id) REFERENCES gtfsfeed(id)

Index "dashboard.ntdagency_gtfsfeed_pkey"
    Column    |  Type  |  Definition  
--------------+--------+--------------
 ntdagency_id | bigint | ntdagency_id
 feeds_id     | bigint | feeds_id
primary key, btree, for table "dashboard.ntdagency_gtfsfeed"

Index "dashboard.ntdagency_pkey"
 Column |  Type  | Definition 
--------+--------+------------
 id     | bigint | id
primary key, btree, for table "dashboard.ntdagency"

       Table "dashboard.ntdagency_uzanames"
    Column    |          Type          | Modifiers 
--------------+------------------------+-----------
 ntdagency_id | bigint                 | not null
 uzanames     | character varying(255) | 
Foreign-key constraints:
    "fk118c6628866df056" FOREIGN KEY (ntdagency_id) REFERENCES ntdagency(id)