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 |
| user_consent_by_attributes | Table for user consent by attribute to publish his contact information. | View more |
| user_global_consent | TTable for user global consent to publish his contact information. | View more |
