mysql> show tables; +-------------------+ | Tables_in_bgpdata | +-------------------+ | AggrTable | | BGPVersion | | CollectedFrom | | Community | | DataSet | | IPTable | | Message | | MsgPath | | OriginTable | +-------------------+ 9 rows in set (0.00 sec) mysql> desc AggrTable; +-------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------+------+-----+---------+----------------+ | id | tinyint(3) unsigned | | PRI | NULL | auto_increment | | aggr | char(3) | | | | | +-------+---------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec) mysql> desc BGPVersion; +----------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------------+------+-----+---------+----------------+ | id | tinyint(3) unsigned | | PRI | NULL | auto_increment | | protocol | varchar(5) | YES | | NULL | | +----------+---------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec) mysql> desc CollectedFrom; +---------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+----------------+ | id | tinyint(3) unsigned | | PRI | NULL | auto_increment | | CollectedFrom | varchar(16) | | | | | +---------------+---------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec) mysql> desc Community; +-------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-----------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | CommunityID | int(10) unsigned | | MUL | 0 | | | PathOrder | tinyint(4) | | MUL | 0 | | | CommunityAS | mediumint(8) unsigned | | MUL | 0 | | | LocalPref | mediumint(8) unsigned | YES | | NULL | | +-------------+-----------------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) mysql> desc DataSet; +-----------------+------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------------------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | FromFile | varchar(255) | | | | | | Descr | tinyblob | YES | | NULL | | | ImportDate | datetime | | | 0000-00-00 00:00:00 | | | CollectDate | datetime | | MUL | 0000-00-00 00:00:00 | | | CollectedFromID | tinyint(4) | | | 0 | | +-----------------+------------------+------+-----+---------------------+----------------+ 6 rows in set (0.00 sec) mysql> desc IPTable; +-------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | ipval | bigint(20) unsigned | YES | | NULL | | | IP | varchar(16) | YES | MUL | NULL | | +-------+---------------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> desc Message; +---------------+-----------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-----------------------+------+-----+---------------------+----------------+ | MsgID | int(10) unsigned | | PRI | NULL | auto_increment | | DataSetID | int(11) | | MUL | 0 | | | BGPVersionID | tinyint(4) | | | 0 | | | MsgType | char(1) | | MUL | | | | MsgTime | datetime | | | 0000-00-00 00:00:00 | | | PeerIPID | mediumint(8) unsigned | YES | | NULL | | | PeerAS | mediumint(8) unsigned | YES | | NULL | | | PrefixID | mediumint(8) unsigned | YES | | NULL | | | PrefixMask | tinyint(3) unsigned | YES | | NULL | | | MsgPathID | int(10) unsigned | YES | MUL | NULL | | | OriginID | tinyint(4) | YES | | NULL | | | NextHopID | mediumint(8) unsigned | YES | | NULL | | | Med | int(10) unsigned | YES | | NULL | | | CommunityID | int(10) unsigned | YES | MUL | NULL | | | AggregateID | tinyint(4) | YES | | NULL | | | AggregateIPID | mediumint(8) unsigned | YES | | NULL | | +---------------+-----------------------+------+-----+---------------------+----------------+ 16 rows in set (0.00 sec) mysql> desc MsgPath; +-------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-----------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | MsgPathID | int(10) unsigned | | MUL | 0 | | | PathOrder | tinyint(4) | | MUL | 0 | | | ASN | mediumint(8) unsigned | YES | MUL | NULL | | | Alternative | tinyint(1) | | | 0 | | +-------------+-----------------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) mysql> desc OriginTable; +--------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+---------------------+------+-----+---------+----------------+ | id | tinyint(3) unsigned | | PRI | NULL | auto_increment | | origin | varchar(10) | | | | | +--------+---------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec)