generated by | SchemaCrawler 16.25.2 |
generated on | 2025-06-04 18:53:06 |
last flyway file | V195__registrar_poc_id.sql |
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 |
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_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_domain_transfer_billing_cancellation_id | [foreign key, with no action] | |
billing_cancellation_id ←(0..many) public."Domain".transfer_billing_cancellation_id |
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_cancellation_billing_event_id | [foreign key, with no action] | |
billing_event_id ←(0..many) public."BillingCancellation".billing_event_id | ||
fk_billing_event_allocation_token | [foreign key, with no action] | |
allocation_token (0..many)→ public."AllocationToken".token | ||
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_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 |
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 | |
default '2021-05-31 20:00:00-04'::timestamp with time zone | ||
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_billing_recurrence_registrar_id | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_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 |
job_id | bigserial not null | |
default nextval('"BsaDomainRefresh_job_id_seq"'::regclass) | ||
auto-incremented | ||
Primary Key | ||
"BsaDomainRefresh_pkey" | [primary key] | |
job_id |
job_id | bigserial not null | |
default nextval('"BsaDownload_job_id_seq"'::regclass) | ||
auto-incremented | ||
creation_time | timestamptz not null | |
Primary Key | ||
"BsaDownload_pkey" | [primary key] | |
job_id |
label | text not null | |
Primary Key | ||
"BsaLabel_pkey" | [primary key] | |
label | ||
Foreign Keys | ||
fkbsaunblockabledomainlabel | [foreign key, on update no action, on delete cascade] | |
label ←(0..many) public."BsaUnblockableDomain".label |
label | text not null | |
tld | text not null | |
Primary Key | ||
"BsaUnblockableDomain_pkey" | [primary key] | |
label | ||
tld | ||
Foreign Keys | ||
fkbsaunblockabledomainlabel | [foreign key, on update no action, on delete cascade] | |
label (0..many)→ public."BsaLabel".label |
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 |
revision_id | bigserial not null | |
default nextval('"ClaimsList_revision_id_seq"'::regclass) | ||
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 |
history_revision_id | int8 not null | |
repo_id | text not null | |
revision_id | int8 not null | |
history_acting_user | text not null | |
Primary Key | ||
"ConsoleEppActionHistory_pkey" | [primary key] | |
history_revision_id |
revision_id | int8 not null | |
modification_time | timestamptz not null | |
type | text not null | |
acting_user | text not null | |
Primary Key | ||
"ConsoleUpdateHistory_pkey" | [primary key] | |
revision_id | ||
Foreign Keys | ||
fk_console_update_history_acting_user | [foreign key, with no action] | |
acting_user (0..many)→ public."User".email_address |
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 | ||
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 | ||
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 |
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 |
"scope" | text not null | |
type | text not null | |
Primary Key | ||
"Cursor_pkey" | [primary key] | |
"scope" | ||
type |
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 |
id | bigserial not null | |
default nextval('"DnsRefreshRequest_id_seq"'::regclass) | ||
auto-incremented | ||
request_time | timestamptz not null | |
last_process_time | timestamptz not null | |
Primary Key | ||
"DnsRefreshRequest_pkey" | [primary key] | |
id |
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 | |
default 'NONE'::text | ||
Primary Key | ||
"Domain_pkey" | [primary key] | |
repo_id | ||
Foreign Keys | ||
fktr24j9v14ph2mfuw2gsmt12kq | [foreign key, with no action] | |
repo_id ←(0..many) public."DelegationSignerData".domain_repo_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_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id | ||
fk2jc69qyg2tv9hhnmif6oa1cx1 | [foreign key, with no action] | |
creation_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_current_package_token | [foreign key, with no action] | |
current_package_token (0..many)→ public."AllocationToken".token | ||
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_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 | ||
fk_domain_tld | [foreign key, with no action] | |
tld (0..many)→ public."Tld".tld_name | ||
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_transfer_billing_recurrence_id | [foreign key, with no action] | |
transfer_billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_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_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 |
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 |
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 | ||
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 |
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 |
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 |
id | bigserial not null | |
default nextval('"DomainTransactionRecord_id_seq"'::regclass) | ||
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 |
feature_name | text not null | |
Primary Key | ||
"FeatureFlag_pkey" | [primary key] | |
feature_name |
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 |
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 |
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_domainhost_host_valid | [foreign key, with no action] | |
repo_id ←(0..many) public."DomainHost".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 | ||
fk_host_superordinate_domain | [foreign key, with no action] | |
superordinate_domain (0..many)→ public."Domain".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 |
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_history_registrar_id | [foreign key, with no action] | |
history_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_hosthistory_host | [foreign key, with no action] | |
host_repo_id (0..many)→ public."Host".repo_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 |
resource_name | text not null | |
"scope" | text not null | |
Primary Key | ||
"Lock_pkey" | [primary key] | |
resource_name | ||
"scope" |
package_promotion_id | bigserial not null | |
default nextval('"Package_promotion_id_seq"'::regclass) | ||
auto-incremented | ||
token | text not null | |
Primary Key | ||
"PackagePromotion_pkey" | [primary key] | |
package_promotion_id |
verification_code | text not null | |
Primary Key | ||
"PasswordResetRequest_pkey" | [primary key] | |
verification_code |
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_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 |
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 |
revision_id | bigserial not null | |
default nextval('"PremiumList_revision_id_seq"'::regclass) | ||
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 |
tld | text not null | |
mode | text not null | |
"date" | date not null | |
Primary Key | ||
"RdeRevision_pkey" | [primary key] | |
tld | ||
mode | ||
"date" |
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 | ||
fkregistrarupdatehistoryregistrarid | [foreign key, with no action] | |
registrar_id ←(0..many) public."RegistrarUpdateHistory".registrar_id |
email_address | text not null | |
registrar_id | text not null | |
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 | ||
fkregistrarpocupdatehistoryemailaddress | [foreign key, with no action] | |
email_address ←(0..many) public."RegistrarPocUpdateHistory".email_address | ||
registrar_id ←(0..many) public."RegistrarPocUpdateHistory".registrar_id |
history_revision_id | int8 not null | |
email_address | text not null | |
registrar_id | text not null | |
history_acting_user | text not null | |
Primary Key | ||
"RegistrarPocUpdateHistory_pkey" | [primary key] | |
history_revision_id | ||
Foreign Keys | ||
fkregistrarpocupdatehistoryemailaddress | [foreign key, with no action] | |
email_address (0..many)→ public."RegistrarPoc".email_address | ||
registrar_id (0..many)→ public."RegistrarPoc".registrar_id |
history_revision_id | int8 not null | |
registrar_id | text not null | |
history_acting_user | text not null | |
Primary Key | ||
"RegistrarUpdateHistory_pkey" | [primary key] | |
history_revision_id | ||
Foreign Keys | ||
fkregistrarupdatehistoryregistrarid | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_id |
revision_id | bigserial not null | |
default nextval('"RegistryLock_revision_id_seq"'::regclass) | ||
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 |
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 |
revision_id | bigserial not null | |
default nextval('"ReservedList_revision_id_seq"'::regclass) | ||
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 |
id | int8 not null | |
default 1 | ||
Primary Key | ||
"ServerSecret_pkey" | [primary key] | |
id |
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 |
revision_id | bigserial not null | |
default nextval('"SignedMarkRevocationList_revision_id_seq"'::regclass) | ||
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 |
id | bigserial not null | |
default nextval('"SafeBrowsingThreat_id_seq"'::regclass) | ||
auto-incremented | ||
check_date | date not null | |
registrar_id | text not null | |
tld | text not null | |
Primary Key | ||
"SafeBrowsingThreat_pkey" | [primary key] | |
id |
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 |
id | int8 not null | |
default 1 | ||
Primary Key | ||
"TmchCrl_pkey" | [primary key] | |
id |
email_address | text not null | |
Primary Key | ||
"User_pkey" | [primary key] | |
email_address | ||
Foreign Keys | ||
fk_console_update_history_acting_user | [foreign key, with no action] | |
email_address ←(0..many) public."ConsoleUpdateHistory".acting_user |
history_revision_id | int8 not null | |
email_address | text not null | |
history_acting_user | text not null | |
Primary Key | ||
"UserUpdateHistory_pkey" | [primary key] | |
history_revision_id |