[PDB Tech] MySQL table description

Matt Griswold grizz at 20c.com
Wed Nov 2 20:10:46 PDT 2016


* 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


More information about the Pdb-tech mailing list