## System Information

generated by | SchemaCrawler 16.27.1
generated on | 2025-09-05 16:11:29
last flyway file | V197__poc_rlock_drop_not_null.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_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 |

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_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 |

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
|  | 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 |

public."BsaDomainRefresh" [table]
| job_id | bigserial not null
|  | default nextval('"BsaDomainRefresh_job_id_seq"'::regclass)
|  | auto-incremented
Primary Key
"BsaDomainRefresh_pkey" | [primary key]
| job_id |

public."BsaDownload" [table]
| 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 |

public."BsaLabel" [table]
| 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 |

public."BsaUnblockableDomain" [table]
| 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 |

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
|  | 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 |

public."ConsoleEppActionHistory" [table]
| 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 |

public."ConsoleUpdateHistory" [table]
| 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 |

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
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 |

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."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
|  | 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 |

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
|  | 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 |

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 |

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 |
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 |

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
|  | 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 |

public."FeatureFlag" [table]
| feature_name | text not null
Primary Key
"FeatureFlag_pkey" | [primary key]
| feature_name |

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 |

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_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 |

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_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 |

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
|  | default nextval('"Package_promotion_id_seq"'::regclass)
|  | auto-incremented
| token | text not null
Primary Key
"PackagePromotion_pkey" | [primary key]
| package_promotion_id |

public."PasswordResetRequest" [table]
| verification_code | text not null
Primary Key
"PasswordResetRequest_pkey" | [primary key]
| verification_code |

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_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
|  | 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 |

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 |
fkregistrarupdatehistoryregistrarid | [foreign key, with no action]
| registrar_id ←(0..many) public."RegistrarUpdateHistory".registrar_id |

public."RegistrarPoc" [table]
| 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 |

public."RegistrarPocUpdateHistory" [table]
| 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 |

public."RegistrarUpdateHistory" [table]
| 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 |

public."RegistryLock" [table]
| 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 |

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
|  | 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 |

public."ServerSecret" [table]
| id | int8 not null
|  | default 1
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
|  | 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 |

public."Spec11ThreatMatch" [table]
| 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 |

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
|  | default 1
Primary Key
"TmchCrl_pkey" | [primary key]
| id |

public."User" [table]
| 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 |

public."UserUpdateHistory" [table]
| 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 |