Home Documentation
Download Report a Bug/Github About Contact

Exporting a database to RedDog’s built-in schema

Introduction

RedDog’s builtin schema is an ordinary relational database conceived in MySQL. Users that aim to implement Option 3: Using RedDog’s builtin schema, need to build a mechanism to populate this database and keep it updated.

The means through which the data is exported will depend on how the data is stored in the origin database, this documentation cannot fall into details on how to do it. Instead, this will serve as reference material for RedDog’s schema.

RedDog’s database contains 69 tables. Though the task of populating them might seem daunting, it is important to note that’s likely to need only a fraction of them. The main ones are autonomous_system_number, domain, entity, ip_network and nameserver. Pick only the ones needed and branch from there.

Full Schema definition

The script to generate the database is located here and the ER diagram here.

The following table shows the database tables, to see more detail of each table there’s a link to its creation script:

Table Description Table details
asn_entity_roles This table contains the role that an Entity has in relation to an ASN. View more
asn_events This table contains the relation between an ASN and its events. View more
asn_links This table contains the relation between an ASN and its links. View more
asn_remarks This table contains the relation between an ASN and its remarks. View more
asn_status This table contains the relation between an ASN and its status. View more
autonomous_system_number This table contains the information of the Autonomous system numbers (ASN). View more
country_code This table contains the catalog of the two-character country code. View more
domain This table contains the information about the domain registration. View more
domain_entity_roles This table contains the role that an Entity has in relation to a Domain. View more
domain_events This table contains the relation between a Domain and its events. View more
domain_links This table contains the relation between a Domain and its links. View more
domain_nameservers This table contains the relation between a Domain and its nameservers. View more
domain_networks This table contains the relation between a Domain and its ip networks. View more
domain_public_ids This table contains the relation between a Domain and its public ids. View more
domain_remarks This table contains the relation between a Domain and its remarks. View more
domain_status This table contains the relation between a Domain and its status. View more
ds_data This table contains the information of a secure DNS DS record. View more
ds_events This table contains the relation between a DS Data and its events. View more
ds_links This table contains the relation between a DS Data and its links. View more
entity This table contains the information of organizations, corporations, governments, non-profits, clubs, individual persons, and informal groups of people. View more
entity_contact This table contains the relation between an Entity and its contact VCard. View more
entity_entity_roles This table contains the role that an Entity has in relation to another Entity. View more
entity_events This table contains the relation between an Entity and its events. View more
entity_links This table contains the relation between an Entity and its links. View more
entity_public_ids This table contains the relation between an Entity and its public ids. View more
entity_remarks This table contains the relation between an Entity and its remarks. View more
entity_role This table contains the relation between an Entity and its role. View more
entity_status This table contains the relation between an Entity and its status. View more
event This table contains the information about events that have occurred on an object instance. View more
event_action This table contains the catalog of Events Actions. View more
event_links This table contains the relation between an Event and its links. View more
ip_address This table contains the information of a nameserver’s ip addresses. View more
ip_network This table contains the information about the network registration and entities related to an IP network. View more
ip_network_entity_roles This table contains the role that an Entity has in relation to an IP Network. View more
ip_network_events This table contains the relation between an IP Network and its events. View more
ip_network_links This table contains the relation between an IP Network and its links. View more
ip_network_parent_relation This table contains the relation between an IP Network and its parent network. View more
ip_network_remarks This table contains the relation between an IP Network and its remarks. View more
ip_network_status This table contains the relation between an IP Network and its status. View more
ip_version This table contains the catalog of ip version types. View more
key_data This table contains the information of the Key Data related to the Secure DNS information of a domain. View more
key_events This table contains the events related to a Key Data. View more
key_links This table contains the links related to a Key Data. View more
link This table contains the information about links. View more
link_lang This table contains the languages related to a link. View more
nameserver This table contains information regarding DNS nameservers used in both forward and reverse DNS. View more
nameserver_entity_roles This table contains the role that an Entity has in relation to a Nameserver. View more
nameserver_events This table contains the relation between a Nameserver and its events. View more
nameserver_links This table contains the relation between a Nameserver and its links. View more
nameserver_remarks This table contains the relation between a Nameserver and its remarks. View more
nameserver_status This table contains the relation between a Nameserver and its status. View more
public_id This table contains the information about Public IDs. View more
rdap_access_role This table contains a catalog of the access roles that a user could have. View more
rdap_user This table contains the information about the users. View more
rdap_user_role This table contains the Access Roles that a User has. View more
relation This table contains the catalog of Variant relations. View more
remark This table contains the information about the Remarks that denote information about an object. View more
remark_description This table contains the Remark’s descriptions. View more
remark_links This table contains the relation between a Remark and its links. View more
roles This table contains the catalog of Roles that an entity could have. View more
secure_dns This table contains the information about a domain Secure DNS. View more
status This table contains the Status catalog. View more
variant This table contains information about the domain’s variants. View more
variant_name This table contains the variants names. View more
variant_relation This table contains the type of relations of a Variant. View more
vcard This table contains the entities VCards. View more
vcard_contact_uri This table contains the contact uri for vCard View more
vcard_postal_info This table contains the VCards postal information. View more
zone This table contains the zones managed by the RDAP server owner. View more

Where to go next