## System Information

generated by | SchemaCrawler 16.10.1
generated on | 2023-03-28 19:28:38.164363
last flyway file | V143__idn_per_tld.sql

## Tables

public.AllocationToken [table]
| token | text not null
| domain_name | text
| redemption_domain_repo_id | text
| token_type | text
Primary Key
AllocationToken_pkey | [primary key]
| token |
Foreign Keys
fk_billing_event_allocation_token | [foreign key, with no action]
| token ←(0..many) public.BillingEvent.allocation_token |
fk_domain_current_package_token | [foreign key, with no action]
| token ←(0..many) public.Domain.current_package_token |
fk_domain_history_current_package_token | [foreign key, with no action]
| token ←(0..many) public.DomainHistory.current_package_token |

public.BillingCancellation [table]
| billing_cancellation_id | int8 not null
| registrar_id | text not null
| domain_history_revision_id | int8 not null
| domain_repo_id | text not null
| event_time | timestamptz not null
| billing_time | timestamptz
| billing_event_id | int8
| billing_recurrence_id | int8
Primary Key
BillingCancellation_pkey | [primary key]
| billing_cancellation_id |
Foreign Keys
fk_domain_transfer_billing_cancellation_id | [foreign key, with no action]
| billing_cancellation_id ←(0..many) public.Domain.transfer_billing_cancellation_id |
fk_billing_cancellation_billing_event_id | [foreign key, with no action]
| billing_event_id (0..many)→ public.BillingEvent.billing_event_id |
fk_billing_cancellation_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id (0..many)→ public.BillingRecurrence.billing_recurrence_id |
fk_billing_cancellation_registrar_id | [foreign key, with no action]
| registrar_id (0..many)→ public.Registrar.registrar_id |
fk_billing_cancellation_domain_history | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| domain_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |

public.BillingEvent [table]
| billing_event_id | int8 not null
| registrar_id | text not null
| domain_history_revision_id | int8 not null
| domain_repo_id | text not null
| event_time | timestamptz not null
| allocation_token | text
| billing_time | timestamptz
| cancellation_matching_billing_recurrence_id | int8
| synthetic_creation_time | timestamptz
| recurrence_history_revision_id | int8
Primary Key
BillingEvent_pkey | [primary key]
| billing_event_id |
Foreign Keys
fk_billing_event_allocation_token | [foreign key, with no action]
| allocation_token (0..many)→ public.AllocationToken.token |
fk_billing_cancellation_billing_event_id | [foreign key, with no action]
| billing_event_id ←(0..many) public.BillingCancellation.billing_event_id |
fk_domain_transfer_billing_event_id | [foreign key, with no action]
| billing_event_id ←(0..many) public.Domain.transfer_billing_event_id |
fk_grace_period_billing_event_id | [foreign key, with no action]
| billing_event_id ←(0..many) public.GracePeriod.billing_event_id |
fk_billing_event_cancellation_matching_billing_recurrence_id | [foreign key, with no action]
| cancellation_matching_billing_recurrence_id (0..many)→ public.BillingRecurrence.billing_recurrence_id |
fk_billing_event_registrar_id | [foreign key, with no action]
| registrar_id (0..many)→ public.Registrar.registrar_id |
fk_billing_event_domain_history | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| domain_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |
fk_billing_event_recurrence_history | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| recurrence_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |

public.BillingRecurrence [table]
| billing_recurrence_id | int8 not null
| registrar_id | text not null
| domain_history_revision_id | int8 not null
| domain_repo_id | text not null
| event_time | timestamptz not null
| recurrence_end_time | timestamptz
| recurrence_time_of_year | text
| recurrence_last_expansion | timestamptz not null
Primary Key
BillingRecurrence_pkey | [primary key]
| billing_recurrence_id |
Foreign Keys
fk_billing_cancellation_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public.BillingCancellation.billing_recurrence_id |
fk_billing_event_cancellation_matching_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public.BillingEvent.cancellation_matching_billing_recurrence_id |
fk_domain_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public.Domain.billing_recurrence_id |
fk_domain_transfer_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public.Domain.transfer_billing_recurrence_id |
fk_grace_period_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public.GracePeriod.billing_recurrence_id |
fk_billing_recurrence_registrar_id | [foreign key, with no action]
| registrar_id (0..many)→ public.Registrar.registrar_id |
fk_billing_recurrence_domain_history | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| domain_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |

public.ClaimsEntry [table]
| revision_id | int8 not null
| domain_label | text not null
Primary Key
ClaimsEntry_pkey | [primary key]
| revision_id |
| domain_label |
Foreign Keys
fk6sc6at5hedffc0nhdcab6ivuq | [foreign key, with no action]
| revision_id (0..many)→ public.ClaimsList.revision_id |

public.ClaimsList [table]
| revision_id | bigserial not null
|  | auto-incremented
Primary Key
ClaimsList_pkey | [primary key]
| revision_id |
Foreign Keys
fk6sc6at5hedffc0nhdcab6ivuq | [foreign key, with no action]
| revision_id ←(0..many) public.ClaimsEntry.revision_id |

public.Contact [table]
| repo_id | text not null
| creation_registrar_id | text not null
| creation_time | timestamptz not null
| current_sponsor_registrar_id | text not null
| deletion_time | timestamptz
| last_epp_update_registrar_id | text
| contact_id | text
| search_name | text
| transfer_gaining_registrar_id | text
| transfer_losing_registrar_id | text
Primary Key
Contact_pkey | [primary key]
| repo_id |
Foreign Keys
fk_contact_history_contact_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public.ContactHistory.contact_repo_id |
fk_domain_admin_contact | [foreign key, with no action]
| repo_id ←(0..many) public.Domain.admin_contact |
fk_domain_billing_contact | [foreign key, with no action]
| repo_id ←(0..many) public.Domain.billing_contact |
fk_domain_registrant_contact | [foreign key, with no action]
| repo_id ←(0..many) public.Domain.registrant_contact |
fk_domain_tech_contact | [foreign key, with no action]
| repo_id ←(0..many) public.Domain.tech_contact |
fk_poll_message_contact_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public.PollMessage.contact_repo_id |
fk1sfyj7o7954prbn1exk7lpnoe | [foreign key, with no action]
| creation_registrar_id (0..many)→ public.Registrar.registrar_id |
fk93c185fx7chn68uv7nl6uv2s0 | [foreign key, with no action]
| current_sponsor_registrar_id (0..many)→ public.Registrar.registrar_id |
fkmb7tdiv85863134w1wogtxrb2 | [foreign key, with no action]
| last_epp_update_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_contact_transfer_gaining_registrar_id | [foreign key, with no action]
| transfer_gaining_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_contact_transfer_losing_registrar_id | [foreign key, with no action]
| transfer_losing_registrar_id (0..many)→ public.Registrar.registrar_id |

public.ContactHistory [table]
| history_revision_id | int8 not null
| history_registrar_id | text
| history_modification_time | timestamptz not null
| history_type | text not null
| creation_time | timestamptz
| contact_repo_id | text not null
Primary Key
ContactHistory_pkey | [primary key]
| contact_repo_id |
| history_revision_id |
Foreign Keys
fk_contact_history_contact_repo_id | [foreign key, with no action]
| contact_repo_id (0..many)→ public.Contact.repo_id |
fk_contact_history_registrar_id | [foreign key, with no action]
| history_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_poll_message_contact_history | [foreign key, with no action]
| contact_repo_id ←(0..many) public.PollMessage.contact_repo_id |
| history_revision_id ←(0..many) public.PollMessage.contact_history_revision_id |

public."Cursor" [table]
| "scope" | text not null
| type | text not null
Primary Key
Cursor_pkey | [primary key]
| "scope" |
| type |

public.DatabaseMigrationStateSchedule [table]
| id | int8 not null
Primary Key
DatabaseMigrationStateSchedule_pkey | [primary key]
| id |

public.DelegationSignerData [table]
| domain_repo_id | text not null
| key_tag | int4 not null
| algorithm | int4 not null
| digest | bytea not null
| digest_type | int4 not null
Primary Key
DelegationSignerData_pkey | [primary key]
| domain_repo_id |
| key_tag |
| algorithm |
| digest_type |
| digest |
Foreign Keys
fktr24j9v14ph2mfuw2gsmt12kq | [foreign key, with no action]
| domain_repo_id (0..many)→ public.Domain.repo_id |

public.DnsRefreshRequest [table]
| id | bigserial not null
|  | auto-incremented
| request_time | timestamptz not null
| last_process_time | timestamptz not null
Primary Key
DnsRefreshRequest_pkey | [primary key]
| id |

public.Domain [table]
| repo_id | text not null
| creation_registrar_id | text not null
| creation_time | timestamptz not null
| current_sponsor_registrar_id | text not null
| deletion_time | timestamptz
| last_epp_update_registrar_id | text
| domain_name | text
| tld | text
| admin_contact | text
| billing_contact | text
| registrant_contact | text
| tech_contact | text
| transfer_billing_cancellation_id | int8
| transfer_billing_event_id | int8
| transfer_billing_recurrence_id | int8
| transfer_gaining_registrar_id | text
| transfer_losing_registrar_id | text
| billing_recurrence_id | int8
| autorenew_end_time | timestamptz
| current_package_token | text
| lordn_phase | text not null
Primary Key
Domain_pkey | [primary key]
| repo_id |
Foreign Keys
fk_domain_current_package_token | [foreign key, with no action]
| current_package_token (0..many)→ public.AllocationToken.token |
fk_domain_transfer_billing_cancellation_id | [foreign key, with no action]
| transfer_billing_cancellation_id (0..many)→ public.BillingCancellation.billing_cancellation_id |
fk_domain_transfer_billing_event_id | [foreign key, with no action]
| transfer_billing_event_id (0..many)→ public.BillingEvent.billing_event_id |
fk_domain_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id (0..many)→ public.BillingRecurrence.billing_recurrence_id |
fk_domain_transfer_billing_recurrence_id | [foreign key, with no action]
| transfer_billing_recurrence_id (0..many)→ public.BillingRecurrence.billing_recurrence_id |
fk_domain_admin_contact | [foreign key, with no action]
| admin_contact (0..many)→ public.Contact.repo_id |
fk_domain_billing_contact | [foreign key, with no action]
| billing_contact (0..many)→ public.Contact.repo_id |
fk_domain_registrant_contact | [foreign key, with no action]
| registrant_contact (0..many)→ public.Contact.repo_id |
fk_domain_tech_contact | [foreign key, with no action]
| tech_contact (0..many)→ public.Contact.repo_id |
fktr24j9v14ph2mfuw2gsmt12kq | [foreign key, with no action]
| repo_id ←(0..many) public.DelegationSignerData.domain_repo_id |
fk_domain_history_domain_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public.DomainHistory.domain_repo_id |
fkfmi7bdink53swivs390m2btxg | [foreign key, with no action]
| repo_id ←(0..many) public.DomainHost.domain_repo_id |
fk_grace_period_domain_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public.GracePeriod.domain_repo_id |
fk_host_superordinate_domain | [foreign key, with no action]
| repo_id ←(0..many) public.Host.superordinate_domain |
fk_poll_message_domain_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public.PollMessage.domain_repo_id |
fk2jc69qyg2tv9hhnmif6oa1cx1 | [foreign key, with no action]
| creation_registrar_id (0..many)→ public.Registrar.registrar_id |
fk2u3srsfbei272093m3b3xwj23 | [foreign key, with no action]
| current_sponsor_registrar_id (0..many)→ public.Registrar.registrar_id |
fkjc0r9r5y1lfbt4gpbqw4wsuvq | [foreign key, with no action]
| last_epp_update_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_domain_transfer_gaining_registrar_id | [foreign key, with no action]
| transfer_gaining_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_domain_transfer_losing_registrar_id | [foreign key, with no action]
| transfer_losing_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_domain_tld | [foreign key, with no action]
| tld (0..many)→ public.Tld.tld_name |

public.DomainDsDataHistory [table]
| ds_data_history_revision_id | int8 not null
| domain_history_revision_id | int8 not null
| domain_repo_id | text
Primary Key
DomainDsDataHistory_pkey | [primary key]
| ds_data_history_revision_id |
Foreign Keys
fko4ilgyyfnvppbpuivus565i0j | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| domain_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |

public.DomainHistory [table]
| history_revision_id | int8 not null
| history_registrar_id | text
| history_modification_time | timestamptz not null
| history_type | text not null
| creation_time | timestamptz
| domain_repo_id | text not null
| current_package_token | text
Primary Key
DomainHistory_pkey | [primary key]
| domain_repo_id |
| history_revision_id |
Foreign Keys
fk_domain_history_current_package_token | [foreign key, with no action]
| current_package_token (0..many)→ public.AllocationToken.token |
fk_domain_history_domain_repo_id | [foreign key, with no action]
| domain_repo_id (0..many)→ public.Domain.repo_id |
fk_domain_history_registrar_id | [foreign key, with no action]
| history_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_billing_cancellation_domain_history | [foreign key, with no action]
| domain_repo_id ←(0..many) public.BillingCancellation.domain_repo_id |
| history_revision_id ←(0..many) public.BillingCancellation.domain_history_revision_id |
fk_billing_event_domain_history | [foreign key, with no action]
| domain_repo_id ←(0..many) public.BillingEvent.domain_repo_id |
| history_revision_id ←(0..many) public.BillingEvent.domain_history_revision_id |
fk_billing_event_recurrence_history | [foreign key, with no action]
| domain_repo_id ←(0..many) public.BillingEvent.domain_repo_id |
| history_revision_id ←(0..many) public.BillingEvent.recurrence_history_revision_id |
fk_billing_recurrence_domain_history | [foreign key, with no action]
| domain_repo_id ←(0..many) public.BillingRecurrence.domain_repo_id |
| history_revision_id ←(0..many) public.BillingRecurrence.domain_history_revision_id |
fko4ilgyyfnvppbpuivus565i0j | [foreign key, with no action]
| domain_repo_id ←(0..many) public.DomainDsDataHistory.domain_repo_id |
| history_revision_id ←(0..many) public.DomainDsDataHistory.domain_history_revision_id |
fka9woh3hu8gx5x0vly6bai327n | [foreign key, with no action]
| domain_repo_id ←(0..many) public.DomainHistoryHost.domain_history_domain_repo_id |
| history_revision_id ←(0..many) public.DomainHistoryHost.domain_history_history_revision_id |
fkcjqe54u72kha71vkibvxhjye7 | [foreign key, with no action]
| domain_repo_id ←(0..many) public.DomainTransactionRecord.domain_repo_id |
| history_revision_id ←(0..many) public.DomainTransactionRecord.history_revision_id |
fk7w3cx8d55q8bln80e716tr7b8 | [foreign key, with no action]
| domain_repo_id ←(0..many) public.GracePeriodHistory.domain_repo_id |
| history_revision_id ←(0..many) public.GracePeriodHistory.domain_history_revision_id |
fk_poll_message_domain_history | [foreign key, with no action]
| domain_repo_id ←(0..many) public.PollMessage.domain_repo_id |
| history_revision_id ←(0..many) public.PollMessage.domain_history_revision_id |

public.DomainHistoryHost [table]
| domain_history_history_revision_id | int8 not null
| host_repo_id | text
| domain_history_domain_repo_id | text not null
Foreign Keys
fka9woh3hu8gx5x0vly6bai327n | [foreign key, with no action]
| domain_history_domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| domain_history_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |

public.DomainHost [table]
| domain_repo_id | text not null
| host_repo_id | text
Foreign Keys
fkfmi7bdink53swivs390m2btxg | [foreign key, with no action]
| domain_repo_id (0..many)→ public.Domain.repo_id |
fk_domainhost_host_valid | [foreign key, with no action]
| host_repo_id (0..many)→ public.Host.repo_id |

public.DomainTransactionRecord [table]
| id | bigserial not null
|  | auto-incremented
| tld | text not null
| domain_repo_id | text
| history_revision_id | int8
Primary Key
DomainTransactionRecord_pkey | [primary key]
| id |
Foreign Keys
fk_domain_transaction_record_tld | [foreign key, with no action]
| tld (0..many)→ public.Tld.tld_name |
fkcjqe54u72kha71vkibvxhjye7 | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| history_revision_id (0..many)→ public.DomainHistory.history_revision_id |

public.GracePeriod [table]
| grace_period_id | int8 not null
| billing_event_id | int8
| billing_recurrence_id | int8
| registrar_id | text not null
| domain_repo_id | text not null
Primary Key
GracePeriod_pkey | [primary key]
| grace_period_id |
Foreign Keys
fk_grace_period_billing_event_id | [foreign key, with no action]
| billing_event_id (0..many)→ public.BillingEvent.billing_event_id |
fk_grace_period_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id (0..many)→ public.BillingRecurrence.billing_recurrence_id |
fk_grace_period_domain_repo_id | [foreign key, with no action]
| domain_repo_id (0..many)→ public.Domain.repo_id |
fk_grace_period_registrar_id | [foreign key, with no action]
| registrar_id (0..many)→ public.Registrar.registrar_id |

public.GracePeriodHistory [table]
| grace_period_history_revision_id | int8 not null
| domain_repo_id | text not null
| domain_history_revision_id | int8
Primary Key
GracePeriodHistory_pkey | [primary key]
| grace_period_history_revision_id |
Foreign Keys
fk7w3cx8d55q8bln80e716tr7b8 | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| domain_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |

public.Host [table]
| repo_id | text not null
| creation_registrar_id | text
| creation_time | timestamptz
| current_sponsor_registrar_id | text
| deletion_time | timestamptz
| last_epp_update_registrar_id | text
| host_name | text
| superordinate_domain | text
| inet_addresses | _text
Primary Key
Host_pkey | [primary key]
| repo_id |
Foreign Keys
fk_host_superordinate_domain | [foreign key, with no action]
| superordinate_domain (0..many)→ public.Domain.repo_id |
fk_domainhost_host_valid | [foreign key, with no action]
| repo_id ←(0..many) public.DomainHost.host_repo_id |
fk_hosthistory_host | [foreign key, with no action]
| repo_id ←(0..many) public.HostHistory.host_repo_id |
fk_poll_message_host_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public.PollMessage.host_repo_id |
fk_host_creation_registrar_id | [foreign key, with no action]
| creation_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_host_current_sponsor_registrar_id | [foreign key, with no action]
| current_sponsor_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_host_last_epp_update_registrar_id | [foreign key, with no action]
| last_epp_update_registrar_id (0..many)→ public.Registrar.registrar_id |

public.HostHistory [table]
| history_revision_id | int8 not null
| history_registrar_id | text not null
| history_modification_time | timestamptz not null
| history_type | text not null
| host_name | text
| creation_time | timestamptz
| host_repo_id | text not null
Primary Key
HostHistory_pkey | [primary key]
| host_repo_id |
| history_revision_id |
Foreign Keys
fk_hosthistory_host | [foreign key, with no action]
| host_repo_id (0..many)→ public.Host.repo_id |
fk_history_registrar_id | [foreign key, with no action]
| history_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_poll_message_host_history | [foreign key, with no action]
| host_repo_id ←(0..many) public.PollMessage.host_repo_id |
| history_revision_id ←(0..many) public.PollMessage.host_history_revision_id |

public.Lock [table]
| resource_name | text not null
| "scope" | text not null
Primary Key
Lock_pkey | [primary key]
| resource_name |
| "scope" |

public.PackagePromotion [table]
| package_promotion_id | bigserial not null
|  | auto-incremented
| token | text not null
Primary Key
PackagePromotion_pkey | [primary key]
| package_promotion_id |

public.PollMessage [table]
| poll_message_id | int8 not null
| registrar_id | text not null
| contact_repo_id | text
| contact_history_revision_id | int8
| domain_repo_id | text
| domain_history_revision_id | int8
| event_time | timestamptz not null
| host_repo_id | text
| host_history_revision_id | int8
| transfer_response_gaining_registrar_id | text
| transfer_response_losing_registrar_id | text
Primary Key
PollMessage_pkey | [primary key]
| poll_message_id |
Foreign Keys
fk_poll_message_contact_repo_id | [foreign key, with no action]
| contact_repo_id (0..many)→ public.Contact.repo_id |
fk_poll_message_domain_repo_id | [foreign key, with no action]
| domain_repo_id (0..many)→ public.Domain.repo_id |
fk_poll_message_host_repo_id | [foreign key, with no action]
| host_repo_id (0..many)→ public.Host.repo_id |
fk_poll_message_registrar_id | [foreign key, with no action]
| registrar_id (0..many)→ public.Registrar.registrar_id |
fk_poll_message_transfer_response_gaining_registrar_id | [foreign key, with no action]
| transfer_response_gaining_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_poll_message_transfer_response_losing_registrar_id | [foreign key, with no action]
| transfer_response_losing_registrar_id (0..many)→ public.Registrar.registrar_id |
fk_poll_message_contact_history | [foreign key, with no action]
| contact_repo_id (0..many)→ public.ContactHistory.contact_repo_id |
| contact_history_revision_id (0..many)→ public.ContactHistory.history_revision_id |
fk_poll_message_domain_history | [foreign key, with no action]
| domain_repo_id (0..many)→ public.DomainHistory.domain_repo_id |
| domain_history_revision_id (0..many)→ public.DomainHistory.history_revision_id |
fk_poll_message_host_history | [foreign key, with no action]
| host_repo_id (0..many)→ public.HostHistory.host_repo_id |
| host_history_revision_id (0..many)→ public.HostHistory.history_revision_id |

public.PremiumEntry [table]
| revision_id | int8 not null
| domain_label | text not null
Primary Key
PremiumEntry_pkey | [primary key]
| revision_id |
| domain_label |
Foreign Keys
fko0gw90lpo1tuee56l0nb6y6g5 | [foreign key, with no action]
| revision_id (0..many)→ public.PremiumList.revision_id |

public.PremiumList [table]
| revision_id | bigserial not null
|  | auto-incremented
| name | text not null
Primary Key
PremiumList_pkey | [primary key]
| revision_id |
Foreign Keys
fko0gw90lpo1tuee56l0nb6y6g5 | [foreign key, with no action]
| revision_id ←(0..many) public.PremiumEntry.revision_id |

public.RdeRevision [table]
| tld | text not null
| mode | text not null
| "date" | date not null
Primary Key
RdeRevision_pkey | [primary key]
| tld |
| mode |
| "date" |

public.Registrar [table]
| registrar_id | text not null
| iana_identifier | int8
| registrar_name | text not null
Primary Key
Registrar_pkey | [primary key]
| registrar_id |
Foreign Keys
fk_billing_cancellation_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.BillingCancellation.registrar_id |
fk_billing_event_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.BillingEvent.registrar_id |
fk_billing_recurrence_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.BillingRecurrence.registrar_id |
fk1sfyj7o7954prbn1exk7lpnoe | [foreign key, with no action]
| registrar_id ←(0..many) public.Contact.creation_registrar_id |
fk93c185fx7chn68uv7nl6uv2s0 | [foreign key, with no action]
| registrar_id ←(0..many) public.Contact.current_sponsor_registrar_id |
fkmb7tdiv85863134w1wogtxrb2 | [foreign key, with no action]
| registrar_id ←(0..many) public.Contact.last_epp_update_registrar_id |
fk_contact_transfer_gaining_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.Contact.transfer_gaining_registrar_id |
fk_contact_transfer_losing_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.Contact.transfer_losing_registrar_id |
fk_contact_history_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.ContactHistory.history_registrar_id |
fk2jc69qyg2tv9hhnmif6oa1cx1 | [foreign key, with no action]
| registrar_id ←(0..many) public.Domain.creation_registrar_id |
fk2u3srsfbei272093m3b3xwj23 | [foreign key, with no action]
| registrar_id ←(0..many) public.Domain.current_sponsor_registrar_id |
fkjc0r9r5y1lfbt4gpbqw4wsuvq | [foreign key, with no action]
| registrar_id ←(0..many) public.Domain.last_epp_update_registrar_id |
fk_domain_transfer_gaining_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.Domain.transfer_gaining_registrar_id |
fk_domain_transfer_losing_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.Domain.transfer_losing_registrar_id |
fk_domain_history_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.DomainHistory.history_registrar_id |
fk_grace_period_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.GracePeriod.registrar_id |
fk_host_creation_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.Host.creation_registrar_id |
fk_host_current_sponsor_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.Host.current_sponsor_registrar_id |
fk_host_last_epp_update_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.Host.last_epp_update_registrar_id |
fk_history_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.HostHistory.history_registrar_id |
fk_poll_message_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.PollMessage.registrar_id |
fk_poll_message_transfer_response_gaining_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.PollMessage.transfer_response_gaining_registrar_id |
fk_poll_message_transfer_response_losing_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.PollMessage.transfer_response_losing_registrar_id |
fk_registrar_poc_registrar_id | [foreign key, with no action]
| registrar_id ←(0..many) public.RegistrarPoc.registrar_id |

public.RegistrarPoc [table]
| email_address | text not null
| registrar_id | text not null
| login_email_address | text
Primary Key
RegistrarPoc_pkey | [primary key]
| registrar_id |
| email_address |
Foreign Keys
fk_registrar_poc_registrar_id | [foreign key, with no action]
| registrar_id (0..many)→ public.Registrar.registrar_id |

public.RegistryLock [table]
| revision_id | bigserial not null
|  | auto-incremented
| registrar_id | text not null
| repo_id | text not null
| verification_code | text not null
| relock_revision_id | int8
Primary Key
RegistryLock_pkey | [primary key]
| revision_id |
Foreign Keys
fk2lhcwpxlnqijr96irylrh1707 | [foreign key, with no action]
| revision_id ←(0..many) relock_revision_id |

public.ReservedEntry [table]
| revision_id | int8 not null
| domain_label | text not null
Primary Key
ReservedEntry_pkey | [primary key]
| revision_id |
| domain_label |
Foreign Keys
fkgq03rk0bt1hb915dnyvd3vnfc | [foreign key, with no action]
| revision_id (0..many)→ public.ReservedList.revision_id |

public.ReservedList [table]
| revision_id | bigserial not null
|  | auto-incremented
| name | text not null
Primary Key
ReservedList_pkey | [primary key]
| revision_id |
Foreign Keys
fkgq03rk0bt1hb915dnyvd3vnfc | [foreign key, with no action]
| revision_id ←(0..many) public.ReservedEntry.revision_id |

public.ServerSecret [table]
| id | int8 not null
Primary Key
ServerSecret_pkey | [primary key]
| id |

public.SignedMarkRevocationEntry [table]
| revision_id | int8 not null
| smd_id | text not null
Primary Key
SignedMarkRevocationEntry_pkey | [primary key]
| revision_id |
| smd_id |
Foreign Keys
fk5ivlhvs3121yx2li5tqh54u4 | [foreign key, with no action]
| revision_id (0..many)→ public.SignedMarkRevocationList.revision_id |

public.SignedMarkRevocationList [table]
| revision_id | bigserial not null
|  | auto-incremented
Primary Key
SignedMarkRevocationList_pkey | [primary key]
| revision_id |
Foreign Keys
fk5ivlhvs3121yx2li5tqh54u4 | [foreign key, with no action]
| revision_id ←(0..many) public.SignedMarkRevocationEntry.revision_id |

public.Spec11ThreatMatch [table]
| id | bigserial not null
|  | auto-incremented
| check_date | date not null
| registrar_id | text not null
| tld | text not null
Primary Key
SafeBrowsingThreat_pkey | [primary key]
| id |

public.Tld [table]
| tld_name | text not null
Primary Key
Tld_pkey | [primary key]
| tld_name |
Foreign Keys
fk_domain_tld | [foreign key, with no action]
| tld_name ←(0..many) public.Domain.tld |
fk_domain_transaction_record_tld | [foreign key, with no action]
| tld_name ←(0..many) public.DomainTransactionRecord.tld |

public.TmchCrl [table]
| id | int8 not null
Primary Key
TmchCrl_pkey | [primary key]
| id |

public."User" [table]
| id | bigserial not null
|  | auto-incremented
| email_address | text not null
| gaia_id | text
Primary Key
User_pkey | [primary key]
| id |