[PDB Tech] MySQL table description

[Regivaldo Gomes Costa]

Hello Matt,
Thank you for your reply.
I dowloaded the data from https://peeringdb.com/v1/final_export.sql. This link is available from documentation page.
In these data I realized that something were strange because few months ago I dowloaded these data and the prefix tables beginning with "peeringdb".
I would like to use the recent data to do a statistics process and validation using real BGP updates from RIPE/RouteView.
Using the application from indicated link I can dowload the complete data? 
Thanks for any help.
Best regards, 
Regivaldo Costa
Doe Sangue. Doe Vida.

      De: Matt Griswold <grizz at 20c.com>
 Para: Regivaldo Gomes Costa <regivaldocosta at yahoo.com.br> 
Cc: "pdb-tech at lists.peeringdb.com" <pdb-tech at lists.peeringdb.com>
 Enviadas: Quinta-feira, 3 de Novembro de 2016 1:10
 Assunto: Re: [PDB Tech] MySQL table description
   
* Regivaldo Gomes Costa <regivaldocosta at yahoo.com.br> [161101 14:16 +0000]:
> Hello Guys,
> I have a newbie doubt about table/columns in MySQL structure.
> Please, somebody can help me in an specific information. My doubts
> are:
>
> 1. In table "peerParticipantsPublics", the column "public_id"
> matches with column "id" in table "mgmtPublics"? Recordds in table
> "mgmtPublics" are IXPs?
>
> 2. Regarding table "peerParticipantsPublics" and  the column
> "participant_id", i.e., are peers with the "public_id" objects (in
> this case IXPs... I think).
That is the old schema, where are you getting it from?

To get a local copy with the new schema, you can use
https://github.com/peeringdb/peeringdb-py

Cheers

   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.peeringdb.com/pipermail/pdb-tech/attachments/20161103/c2332fcb/attachment.html>