System Information

generated by SchemaCrawler 16.25.2
generated on 2025-06-04 18:53:03
last flyway file V195__registrar_poc_id.sql

 

 

SchemaCrawler_Diagram generated by SchemaCrawler 16.25.2 generated on 2025-06-04 18:53:03 allocationtoken_a08ccbef public."AllocationToken" [table] token text not null update_timestamp timestamptz allowed_registrar_ids _text allowed_tlds _text creation_time timestamptz not null discount_fraction float8(17, 17) not null discount_premiums bool not null discount_years int4 not null domain_name text redemption_domain_repo_id text token_status_transitions hstore token_type text redemption_domain_history_id int8 renewal_price_behavior text not null registration_behavior text not null allowed_epp_actions _text renewal_price_amount numeric(19, 2) renewal_price_currency text discount_price_amount numeric(19, 2) discount_price_currency text billingevent_a57d1815 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 flags _text reason text not null domain_name text not null allocation_token text billing_time timestamptz cancellation_matching_billing_recurrence_id int8 cost_amount numeric(19, 2) cost_currency text period_years int4 synthetic_creation_time timestamptz recurrence_history_revision_id int8 billingevent_a57d1815:w->allocationtoken_a08ccbef:e fk_billing_event_allocation_token billingrecurrence_5fa2cb01 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 flags _text reason text not null domain_name text not null recurrence_end_time timestamptz recurrence_time_of_year text renewal_price_behavior text not null renewal_price_currency text renewal_price_amount numeric(19, 2) recurrence_last_expansion timestamptz not null billingevent_a57d1815:w->billingrecurrence_5fa2cb01:e fk_billing_event_cancellation_matching_billing_recurrence_id registrar_6e1503e3 public."Registrar" [table] registrar_id text not null allowed_tlds _text billing_account_map hstore block_premium_names bool not null client_certificate text client_certificate_hash text contacts_require_syncing bool not null creation_time timestamptz not null drive_folder_id text email_address text failover_client_certificate text failover_client_certificate_hash text fax_number text iana_identifier int8 icann_referral_email text i18n_address_city text i18n_address_country_code text i18n_address_state text i18n_address_street_line1 text i18n_address_street_line2 text i18n_address_street_line3 text i18n_address_zip text ip_address_allow_list _text last_certificate_update_time timestamptz last_update_time timestamptz not null localized_address_city text localized_address_country_code text localized_address_state text localized_address_street_line1 text localized_address_street_line2 text localized_address_street_line3 text localized_address_zip text password_hash text phone_number text phone_passcode text po_number text rdap_base_urls _text registrar_name text not null registry_lock_allowed bool not null password_salt text state text type text not null url text whois_server text last_expiring_cert_notification_sent_date timestamptz last_expiring_failover_cert_notification_sent_date timestamptz last_poc_verification_date timestamptz billingevent_a57d1815:w->registrar_6e1503e3:e fk_billing_event_registrar_id domain_6c51cffa 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 last_epp_update_time timestamptz statuses _text auth_info_repo_id text auth_info_value text domain_name text idn_table_name text last_transfer_time timestamptz launch_notice_accepted_time timestamptz launch_notice_expiration_time timestamptz launch_notice_tcn_id text launch_notice_validator_id text registration_expiration_time timestamptz smd_id text subordinate_hosts _text tld text admin_contact text billing_contact text registrant_contact text tech_contact text transfer_poll_message_id_1 int8 transfer_poll_message_id_2 int8 transfer_billing_cancellation_id int8 transfer_billing_event_id int8 transfer_billing_recurrence_id int8 transfer_autorenew_poll_message_id int8 transfer_renew_period_unit text transfer_renew_period_value int4 transfer_client_txn_id text transfer_server_txn_id text transfer_registration_expiration_time timestamptz transfer_gaining_registrar_id text transfer_losing_registrar_id text transfer_pending_expiration_time timestamptz transfer_request_time timestamptz transfer_status text update_timestamp timestamptz billing_recurrence_id int8 autorenew_poll_message_id int8 deletion_poll_message_id int8 autorenew_end_time timestamptz transfer_autorenew_poll_message_history_id int8 transfer_history_entry_id int8 transfer_repo_id text transfer_poll_message_id_3 int8 current_package_token text lordn_phase text not null last_update_time_via_epp timestamptz domain_6c51cffa:w->allocationtoken_a08ccbef:e fk_domain_current_package_token domain_6c51cffa:w->billingevent_a57d1815:e fk_domain_transfer_billing_event_id billingcancellation_6eedf614 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 flags _text reason text not null domain_name text not null billing_time timestamptz billing_event_id int8 billing_recurrence_id int8 domain_6c51cffa:w->billingcancellation_6eedf614:e fk_domain_transfer_billing_cancellation_id domain_6c51cffa:w->billingrecurrence_5fa2cb01:e fk_domain_billing_recurrence_id domain_6c51cffa:w->billingrecurrence_5fa2cb01:e fk_domain_transfer_billing_recurrence_id contact_8de8cb16 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 last_epp_update_time timestamptz statuses _text auth_info_repo_id text auth_info_value text contact_id text disclose_types_addr _text disclose_show_email bool disclose_show_fax bool disclose_mode_flag bool disclose_types_name _text disclose_types_org _text disclose_show_voice bool email text fax_phone_extension text fax_phone_number text addr_i18n_city text addr_i18n_country_code text addr_i18n_state text addr_i18n_street_line1 text addr_i18n_street_line2 text addr_i18n_street_line3 text addr_i18n_zip text addr_i18n_name text addr_i18n_org text addr_i18n_type text last_transfer_time timestamptz addr_local_city text addr_local_country_code text addr_local_state text addr_local_street_line1 text addr_local_street_line2 text addr_local_street_line3 text addr_local_zip text addr_local_name text addr_local_org text addr_local_type text search_name text voice_phone_extension text voice_phone_number text transfer_poll_message_id_1 int8 transfer_poll_message_id_2 int8 transfer_client_txn_id text transfer_server_txn_id text transfer_gaining_registrar_id text transfer_losing_registrar_id text transfer_pending_expiration_time timestamptz transfer_request_time timestamptz transfer_status text update_timestamp timestamptz transfer_history_entry_id int8 transfer_repo_id text transfer_poll_message_id_3 int8 last_update_time_via_epp timestamptz domain_6c51cffa:w->contact_8de8cb16:e fk_domain_admin_contact domain_6c51cffa:w->contact_8de8cb16:e fk_domain_billing_contact domain_6c51cffa:w->contact_8de8cb16:e fk_domain_registrant_contact domain_6c51cffa:w->contact_8de8cb16:e fk_domain_tech_contact domain_6c51cffa:w->registrar_6e1503e3:e fk2jc69qyg2tv9hhnmif6oa1cx1 domain_6c51cffa:w->registrar_6e1503e3:e fk2u3srsfbei272093m3b3xwj23 domain_6c51cffa:w->registrar_6e1503e3:e fkjc0r9r5y1lfbt4gpbqw4wsuvq domain_6c51cffa:w->registrar_6e1503e3:e fk_domain_transfer_gaining_registrar_id domain_6c51cffa:w->registrar_6e1503e3:e fk_domain_transfer_losing_registrar_id tld_f1fa57e2 public."Tld" [table] tld_name text not null add_grace_period_length interval not null allowed_fully_qualified_host_names _text allowed_registrant_contact_ids _text anchor_tenant_add_grace_period_length interval not null auto_renew_grace_period_length interval not null automatic_transfer_length interval not null claims_period_end timestamptz not null creation_time timestamptz not null currency text not null dns_paused bool not null dns_writers _text not null drive_folder_id text eap_fee_schedule hstore not null escrow_enabled bool not null invoicing_enabled bool not null lordn_username text num_dns_publish_locks int4 not null pending_delete_length interval not null premium_list_name text pricing_engine_class_name text redemption_grace_period_length interval not null registry_lock_or_unlock_cost_amount numeric(19, 2) registry_lock_or_unlock_cost_currency text renew_billing_cost_transitions hstore not null renew_grace_period_length interval not null reserved_list_names _text restore_billing_cost_amount numeric(19, 2) restore_billing_cost_currency text roid_suffix text server_status_change_billing_cost_amount numeric(19, 2) server_status_change_billing_cost_currency text tld_state_transitions hstore not null tld_type text not null tld_unicode text not null transfer_grace_period_length interval not null default_promo_tokens _text dns_a_plus_aaaa_ttl interval dns_ds_ttl interval dns_ns_ttl interval idn_tables _text breakglass_mode bool not null bsa_enroll_start_time timestamptz create_billing_cost_transitions hstore not null domain_6c51cffa:w->tld_f1fa57e2:e fk_domain_tld domainhistory_a54cc226 public."DomainHistory" [table] history_revision_id int8 not null history_by_superuser bool not null history_registrar_id text history_modification_time timestamptz not null history_reason text history_requested_by_registrar bool history_client_transaction_id text history_server_transaction_id text history_type text not null history_xml_bytes bytea admin_contact text auth_info_repo_id text auth_info_value text billing_recurrence_id int8 autorenew_poll_message_id int8 billing_contact text deletion_poll_message_id int8 domain_name text idn_table_name text last_transfer_time timestamptz launch_notice_accepted_time timestamptz launch_notice_expiration_time timestamptz launch_notice_tcn_id text launch_notice_validator_id text registrant_contact text registration_expiration_time timestamptz smd_id text subordinate_hosts _text tech_contact text tld text transfer_billing_cancellation_id int8 transfer_billing_recurrence_id int8 transfer_autorenew_poll_message_id int8 transfer_billing_event_id int8 transfer_renew_period_unit text transfer_renew_period_value int4 transfer_registration_expiration_time timestamptz transfer_poll_message_id_1 int8 transfer_poll_message_id_2 int8 transfer_client_txn_id text transfer_server_txn_id text transfer_gaining_registrar_id text transfer_losing_registrar_id text transfer_pending_expiration_time timestamptz transfer_request_time timestamptz transfer_status text creation_registrar_id text creation_time timestamptz current_sponsor_registrar_id text deletion_time timestamptz last_epp_update_registrar_id text last_epp_update_time timestamptz statuses _text update_timestamp timestamptz domain_repo_id text not null autorenew_end_time timestamptz history_other_registrar_id text history_period_unit text history_period_value int4 autorenew_poll_message_history_id int8 transfer_autorenew_poll_message_history_id int8 transfer_history_entry_id int8 transfer_repo_id text transfer_poll_message_id_3 int8 current_package_token text lordn_phase text not null last_update_time_via_epp timestamptz domainhistory_a54cc226:w->allocationtoken_a08ccbef:e fk_domain_history_current_package_token domainhistory_a54cc226:w->domain_6c51cffa:e fk_domain_history_domain_repo_id domainhistory_a54cc226:w->registrar_6e1503e3:e fk_domain_history_registrar_id billingcancellation_6eedf614:w->billingevent_a57d1815:e fk_billing_cancellation_billing_event_id billingcancellation_6eedf614:w->billingrecurrence_5fa2cb01:e fk_billing_cancellation_billing_recurrence_id billingcancellation_6eedf614:w->registrar_6e1503e3:e fk_billing_cancellation_registrar_id graceperiod_cd3b2e8f 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 expiration_time timestamptz not null type text not null graceperiod_cd3b2e8f:w->billingevent_a57d1815:e fk_grace_period_billing_event_id graceperiod_cd3b2e8f:w->domain_6c51cffa:e fk_grace_period_domain_repo_id graceperiod_cd3b2e8f:w->billingrecurrence_5fa2cb01:e fk_grace_period_billing_recurrence_id graceperiod_cd3b2e8f:w->registrar_6e1503e3:e fk_grace_period_registrar_id billingrecurrence_5fa2cb01:w->registrar_6e1503e3:e fk_billing_recurrence_registrar_id bsadomainrefresh_c8f4c45d public."BsaDomainRefresh" [table] job_id bigserial not null auto-incremented creation_time timestamptz not null stage text not null update_timestamp timestamptz bsadownload_98d031ce public."BsaDownload" [table] job_id bigserial not null auto-incremented block_list_checksums text not null creation_time timestamptz not null stage text not null update_timestamp timestamptz bsalabel_2755e1da public."BsaLabel" [table] label text not null creation_time timestamptz not null bsaunblockabledomain_b739a38 public."BsaUnblockableDomain" [table] label text not null tld text not null creation_time timestamptz not null reason text not null bsaunblockabledomain_b739a38:w->bsalabel_2755e1da:e fkbsaunblockabledomainlabel claimsentry_105da9f1 public."ClaimsEntry" [table] revision_id int8 not null claim_key text not null domain_label text not null claimslist_3d49bc2b public."ClaimsList" [table] revision_id bigserial not null auto-incremented creation_timestamp timestamptz not null tmdb_generation_time timestamptz not null claimsentry_105da9f1:w->claimslist_3d49bc2b:e fk6sc6at5hedffc0nhdcab6ivuq consoleeppactionhistory_bcc2a2c6 public."ConsoleEppActionHistory" [table] history_revision_id int8 not null history_modification_time timestamptz not null history_method text not null history_request_body text history_type text not null history_url text not null history_entry_class text not null repo_id text not null revision_id int8 not null history_acting_user text not null consoleupdatehistory_5237b2aa public."ConsoleUpdateHistory" [table] revision_id int8 not null modification_time timestamptz not null "method" text not null type text not null url text not null description text acting_user text not null user_f2216f01 public."User" [table] email_address text not null registry_lock_password_hash text registry_lock_password_salt text global_role text not null is_admin bool not null registrar_roles hstore not null update_timestamp timestamptz registry_lock_email_address text consoleupdatehistory_5237b2aa:w->user_f2216f01:e fk_console_update_history_acting_user contact_8de8cb16:w->registrar_6e1503e3:e fk1sfyj7o7954prbn1exk7lpnoe contact_8de8cb16:w->registrar_6e1503e3:e fk93c185fx7chn68uv7nl6uv2s0 contact_8de8cb16:w->registrar_6e1503e3:e fkmb7tdiv85863134w1wogtxrb2 contact_8de8cb16:w->registrar_6e1503e3:e fk_contact_transfer_gaining_registrar_id contact_8de8cb16:w->registrar_6e1503e3:e fk_contact_transfer_losing_registrar_id contacthistory_d2964f8a public."ContactHistory" [table] history_revision_id int8 not null history_by_superuser bool not null history_registrar_id text history_modification_time timestamptz not null history_reason text history_requested_by_registrar bool history_client_transaction_id text history_server_transaction_id text history_type text not null history_xml_bytes bytea auth_info_repo_id text auth_info_value text contact_id text disclose_types_addr _text disclose_show_email bool disclose_show_fax bool disclose_mode_flag bool disclose_types_name _text disclose_types_org _text disclose_show_voice bool email text fax_phone_extension text fax_phone_number text addr_i18n_city text addr_i18n_country_code text addr_i18n_state text addr_i18n_street_line1 text addr_i18n_street_line2 text addr_i18n_street_line3 text addr_i18n_zip text addr_i18n_name text addr_i18n_org text addr_i18n_type text last_transfer_time timestamptz addr_local_city text addr_local_country_code text addr_local_state text addr_local_street_line1 text addr_local_street_line2 text addr_local_street_line3 text addr_local_zip text addr_local_name text addr_local_org text addr_local_type text search_name text transfer_poll_message_id_1 int8 transfer_poll_message_id_2 int8 transfer_client_txn_id text transfer_server_txn_id text transfer_gaining_registrar_id text transfer_losing_registrar_id text transfer_pending_expiration_time timestamptz transfer_request_time timestamptz transfer_status text voice_phone_extension text voice_phone_number text creation_registrar_id text creation_time timestamptz current_sponsor_registrar_id text deletion_time timestamptz last_epp_update_registrar_id text last_epp_update_time timestamptz statuses _text contact_repo_id text not null update_timestamp timestamptz transfer_history_entry_id int8 transfer_repo_id text transfer_poll_message_id_3 int8 last_update_time_via_epp timestamptz contacthistory_d2964f8a:w->contact_8de8cb16:e fk_contact_history_contact_repo_id contacthistory_d2964f8a:w->registrar_6e1503e3:e fk_contact_history_registrar_id pollmessage_614a523e public."PollMessage" [table] type text not null 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 message text transfer_response_contact_id text transfer_response_domain_expiration_time timestamptz transfer_response_domain_name text pending_action_response_action_result bool pending_action_response_name_or_id text pending_action_response_processed_date timestamptz pending_action_response_client_txn_id text pending_action_response_server_txn_id text transfer_response_gaining_registrar_id text transfer_response_losing_registrar_id text transfer_response_pending_transfer_expiration_time timestamptz transfer_response_transfer_request_time timestamptz transfer_response_transfer_status text autorenew_end_time timestamptz autorenew_domain_name text transfer_response_host_id text pollmessage_614a523e:w->domain_6c51cffa:e fk_poll_message_domain_repo_id pollmessage_614a523e:w->contact_8de8cb16:e fk_poll_message_contact_repo_id pollmessage_614a523e:w->contacthistory_d2964f8a:e fk_poll_message_contact_history pollmessage_614a523e:w->contacthistory_d2964f8a:e fk_poll_message_contact_history host_f21b78de 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 last_epp_update_time timestamptz statuses _text host_name text last_superordinate_change timestamptz last_transfer_time timestamptz superordinate_domain text inet_addresses _text update_timestamp timestamptz transfer_poll_message_id_3 int8 last_update_time_via_epp timestamptz pollmessage_614a523e:w->host_f21b78de:e fk_poll_message_host_repo_id hosthistory_56210c2 public."HostHistory" [table] history_revision_id int8 not null history_by_superuser bool not null history_registrar_id text not null history_modification_time timestamptz not null history_reason text history_requested_by_registrar bool history_client_transaction_id text history_server_transaction_id text history_type text not null history_xml_bytes bytea host_name text inet_addresses _text last_superordinate_change timestamptz last_transfer_time timestamptz superordinate_domain text creation_registrar_id text creation_time timestamptz current_sponsor_registrar_id text deletion_time timestamptz last_epp_update_registrar_id text last_epp_update_time timestamptz statuses _text host_repo_id text not null update_timestamp timestamptz transfer_poll_message_id_3 int8 last_update_time_via_epp timestamptz pollmessage_614a523e:w->hosthistory_56210c2:e fk_poll_message_host_history pollmessage_614a523e:w->hosthistory_56210c2:e fk_poll_message_host_history pollmessage_614a523e:w->registrar_6e1503e3:e fk_poll_message_registrar_id pollmessage_614a523e:w->registrar_6e1503e3:e fk_poll_message_transfer_response_gaining_registrar_id pollmessage_614a523e:w->registrar_6e1503e3:e fk_poll_message_transfer_response_losing_registrar_id cursor_6af40e8c public."Cursor" [table] "scope" text not null type text not null cursor_time timestamptz not null last_update_time timestamptz not null delegationsignerdata_e542a872 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 delegationsignerdata_e542a872:w->domain_6c51cffa:e fktr24j9v14ph2mfuw2gsmt12kq dnsrefreshrequest_4e6affb3 public."DnsRefreshRequest" [table] id bigserial not null auto-incremented name text not null request_time timestamptz not null tld text not null type text not null last_process_time timestamptz not null domainhost_1ea127c2 public."DomainHost" [table] domain_repo_id text not null host_repo_id text domainhost_1ea127c2:w->domain_6c51cffa:e fkfmi7bdink53swivs390m2btxg domainhost_1ea127c2:w->host_f21b78de:e fk_domainhost_host_valid host_f21b78de:w->domain_6c51cffa:e fk_host_superordinate_domain host_f21b78de:w->registrar_6e1503e3:e fk_host_creation_registrar_id host_f21b78de:w->registrar_6e1503e3:e fk_host_current_sponsor_registrar_id host_f21b78de:w->registrar_6e1503e3:e fk_host_last_epp_update_registrar_id domaindsdatahistory_995b060d public."DomainDsDataHistory" [table] ds_data_history_revision_id int8 not null algorithm int4 not null digest bytea not null digest_type int4 not null domain_history_revision_id int8 not null key_tag int4 not null domain_repo_id text domainhistoryhost_9f3f23ee public."DomainHistoryHost" [table] domain_history_history_revision_id int8 not null host_repo_id text domain_history_domain_repo_id text not null domainhistoryhost_9f3f23ee:w->domainhistory_a54cc226:e fka9woh3hu8gx5x0vly6bai327n domainhistoryhost_9f3f23ee:w->domainhistory_a54cc226:e fka9woh3hu8gx5x0vly6bai327n domaintransactionrecord_6e77ff61 public."DomainTransactionRecord" [table] id bigserial not null auto-incremented report_amount int4 not null report_field text not null reporting_time timestamptz not null tld text not null domain_repo_id text history_revision_id int8 domaintransactionrecord_6e77ff61:w->tld_f1fa57e2:e fk_domain_transaction_record_tld featureflag_3ee43a78 public."FeatureFlag" [table] feature_name text not null status hstore not null graceperiodhistory_40ccc1f1 public."GracePeriodHistory" [table] grace_period_history_revision_id int8 not null billing_event_id int8 billing_recurrence_id int8 registrar_id text not null domain_repo_id text not null expiration_time timestamptz not null type text not null domain_history_revision_id int8 grace_period_id int8 not null hosthistory_56210c2:w->host_f21b78de:e fk_hosthistory_host hosthistory_56210c2:w->registrar_6e1503e3:e fk_history_registrar_id lock_f21d4861 public."Lock" [table] resource_name text not null "scope" text not null acquired_time timestamptz not null expiration_time timestamptz not null packagepromotion_56aa33 public."PackagePromotion" [table] package_promotion_id bigserial not null auto-incremented last_notification_sent timestamptz max_creates int4 not null max_domains int4 not null next_billing_date timestamptz not null package_price_amount numeric(19, 2) not null package_price_currency text not null token text not null passwordresetrequest_8484e7b1 public."PasswordResetRequest" [table] type text not null request_time timestamptz not null requester text not null fulfillment_time timestamptz destination_email text not null verification_code text not null registrar_id text not null premiumentry_b0060b91 public."PremiumEntry" [table] revision_id int8 not null price numeric(19, 2) not null domain_label text not null premiumlist_7c3ea68b public."PremiumList" [table] revision_id bigserial not null auto-incremented creation_timestamp timestamptz name text not null bloom_filter bytea not null currency text not null premiumentry_b0060b91:w->premiumlist_7c3ea68b:e fko0gw90lpo1tuee56l0nb6y6g5 rderevision_83396864 public."RdeRevision" [table] tld text not null mode text not null "date" date not null update_timestamp timestamptz revision int4 not null registrarpoc_ab47054d public."RegistrarPoc" [table] email_address text not null allowed_to_set_registry_lock_password bool not null fax_number text name text phone_number text registry_lock_password_hash text registry_lock_password_salt text types _text visible_in_domain_whois_as_abuse bool not null visible_in_whois_as_admin bool not null visible_in_whois_as_tech bool not null registry_lock_email_address text registrar_id text not null id bigserial not null auto-incremented registrarpoc_ab47054d:w->registrar_6e1503e3:e fk_registrar_poc_registrar_id registrarupdatehistory_8a38bed4 public."RegistrarUpdateHistory" [table] history_revision_id int8 not null history_modification_time timestamptz not null history_method text not null history_request_body text history_type text not null history_url text not null allowed_tlds _text billing_account_map hstore block_premium_names bool not null client_certificate text client_certificate_hash text contacts_require_syncing bool not null creation_time timestamptz not null drive_folder_id text email_address text failover_client_certificate text failover_client_certificate_hash text fax_number text iana_identifier int8 icann_referral_email text i18n_address_city text i18n_address_country_code text i18n_address_state text i18n_address_street_line1 text i18n_address_street_line2 text i18n_address_street_line3 text i18n_address_zip text ip_address_allow_list _text last_certificate_update_time timestamptz last_expiring_cert_notification_sent_date timestamptz last_expiring_failover_cert_notification_sent_date timestamptz localized_address_city text localized_address_country_code text localized_address_state text localized_address_street_line1 text localized_address_street_line2 text localized_address_street_line3 text localized_address_zip text password_hash text phone_number text phone_passcode text po_number text rdap_base_urls _text registrar_name text not null registry_lock_allowed bool not null password_salt text state text type text not null url text whois_server text update_timestamp timestamptz registrar_id text not null history_acting_user text not null registrarupdatehistory_8a38bed4:w->registrar_6e1503e3:e fkregistrarupdatehistoryregistrarid registrarpocupdatehistory_31e5d9aa public."RegistrarPocUpdateHistory" [table] history_revision_id int8 not null history_modification_time timestamptz not null history_method text not null history_request_body text history_type text not null history_url text not null email_address text not null registrar_id text not null allowed_to_set_registry_lock_password bool not null fax_number text login_email_address text name text phone_number text registry_lock_email_address text registry_lock_password_hash text registry_lock_password_salt text types _text visible_in_domain_whois_as_abuse bool not null visible_in_whois_as_admin bool not null visible_in_whois_as_tech bool not null history_acting_user text not null registrarpocupdatehistory_31e5d9aa:w->registrarpoc_ab47054d:e fkregistrarpocupdatehistoryemailaddress registrarpocupdatehistory_31e5d9aa:w->registrarpoc_ab47054d:e fkregistrarpocupdatehistoryemailaddress registrylock_ac88663e public."RegistryLock" [table] revision_id bigserial not null auto-incremented lock_completion_time timestamptz lock_request_time timestamptz not null domain_name text not null is_superuser bool not null registrar_id text not null registrar_poc_id text repo_id text not null verification_code text not null unlock_request_time timestamptz unlock_completion_time timestamptz last_update_time timestamptz not null relock_revision_id int8 relock_duration interval registrylock_ac88663e:w->registrylock_ac88663e:e fk2lhcwpxlnqijr96irylrh1707 reservedentry_1a7b8520 public."ReservedEntry" [table] revision_id int8 not null comment text reservation_type int4 not null domain_label text not null reservedlist_b97c3f1c public."ReservedList" [table] revision_id bigserial not null auto-incremented creation_timestamp timestamptz not null name text not null reservedentry_1a7b8520:w->reservedlist_b97c3f1c:e fkgq03rk0bt1hb915dnyvd3vnfc serversecret_6cc90f09 public."ServerSecret" [table] secret uuid not null id int8 not null signedmarkrevocationentry_99c39721 public."SignedMarkRevocationEntry" [table] revision_id int8 not null revocation_time timestamptz not null smd_id text not null signedmarkrevocationlist_c5d968fb public."SignedMarkRevocationList" [table] revision_id bigserial not null auto-incremented creation_time timestamptz signedmarkrevocationentry_99c39721:w->signedmarkrevocationlist_c5d968fb:e fk5ivlhvs3121yx2li5tqh54u4 spec11threatmatch_a61228a6 public."Spec11ThreatMatch" [table] id bigserial not null auto-incremented check_date date not null domain_name text not null domain_repo_id text not null registrar_id text not null threat_types _text not null tld text not null tmchcrl_d282355 public."TmchCrl" [table] certificate_revocations text not null update_timestamp timestamptz not null url text not null id int8 not null userupdatehistory_24efd476 public."UserUpdateHistory" [table] history_revision_id int8 not null history_modification_time timestamptz not null history_method text not null history_request_body text history_type text not null history_url text not null email_address text not null registry_lock_password_hash text registry_lock_password_salt text global_role text not null is_admin bool not null registrar_roles hstore update_timestamp timestamptz history_acting_user text not null registry_lock_email_address text

Tables

public."AllocationToken" [table]
token text not null
update_timestamp timestamptz
allowed_registrar_ids _text
allowed_tlds _text
creation_time timestamptz not null
discount_fraction float8(17, 17) not null
discount_premiums bool not null
discount_years int4 not null
domain_name text
redemption_domain_repo_id text
token_status_transitions hstore
token_type text
redemption_domain_history_id int8
renewal_price_behavior text not null
default 'DEFAULT'::text
registration_behavior text not null
default 'DEFAULT'::text
allowed_epp_actions _text
renewal_price_amount numeric(19, 2)
renewal_price_currency text
discount_price_amount numeric(19, 2)
discount_price_currency 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
Indexes
allocation_token_domain_name_idx [non-unique index]
domain_name ascending
idxtmlqd31dpvvd2g1h9i7erw6aj [non-unique index]
redemption_domain_repo_id ascending
"AllocationToken_pkey" [unique index]
token ascending
idx9g3s7mjv1yn4t06nqid39whss [non-unique index]
token_type ascending

 

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
flags _text
reason text not null
domain_name text 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
Indexes
"BillingCancellation_pkey" [unique index]
billing_cancellation_id ascending
idx4ytbe5f3b39trsd4okx5ijhs4 [non-unique index]
billing_event_id ascending
idxku0fopwyvd57ebo8bf0jg9xo2 [non-unique index]
billing_recurrence_id ascending
idxl8vobbecsd32k4ksavdfx8st6 [non-unique index]
domain_repo_id ascending
idxeokttmxtpq2hohcioe5t2242b [non-unique index]
registrar_id ascending
idxqa3g92jc17e8dtiaviy4fet4x [non-unique index]
billing_time ascending
idx2exdfbx6oiiwnhr8j6gjpqt2j [non-unique index]
event_time ascending
idx7v75e535c47mxfb2rk9o843bn [non-unique index]
domain_repo_id ascending
domain_history_revision_id ascending

 

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
flags _text
reason text not null
domain_name text not null
allocation_token text
billing_time timestamptz
cancellation_matching_billing_recurrence_id int8
cost_amount numeric(19, 2)
cost_currency text
period_years int4
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
Indexes
"BillingEvent_pkey" [unique index]
billing_event_id ascending
idx6ebt3nwk5ocvnremnhnlkl6ff [non-unique index]
cancellation_matching_billing_recurrence_id ascending
idxhmv411mdqo5ibn4vy7ykxpmlv [non-unique index]
allocation_token ascending
idxbgfmveqa7e5hn689koikwn70r [non-unique index]
domain_repo_id ascending
idx73l103vc5900ig3p4odf0cngt [non-unique index]
registrar_id ascending
idx6py6ocrab0ivr76srcd2okpnq [non-unique index]
billing_time ascending
idx5yfbr88439pxw0v3j86c74fp8 [non-unique index]
event_time ascending
idxplxf9v56p0wg8ws6qsvd082hk [non-unique index]
synthetic_creation_time ascending
idx77ceolnf7rok8ui957msmo6en [non-unique index]
domain_repo_id ascending
domain_history_revision_id ascending
idxehp8ejwpbsooar0e8k32847m3 [non-unique index]
domain_repo_id ascending
recurrence_history_revision_id ascending

 

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
flags _text
reason text not null
domain_name text not null
recurrence_end_time timestamptz
recurrence_time_of_year text
renewal_price_behavior text not null
default 'DEFAULT'::text
renewal_price_currency text
renewal_price_amount numeric(19, 2)
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
Indexes
"BillingRecurrence_pkey" [unique index]
billing_recurrence_id ascending
idxoqttafcywwdn41um6kwlt0n8b [non-unique index]
domain_repo_id ascending
idxjny8wuot75b5e6p38r47wdawu [non-unique index]
recurrence_time_of_year ascending
idxn898pb9mwcg359cdwvolb11ck [non-unique index]
registrar_id ascending
idx6syykou4nkc7hqa5p8r92cpch [non-unique index]
event_time ascending
idxp3usbtvk0v1m14i5tdp4xnxgc [non-unique index]
recurrence_end_time ascending
idxp0pxi708hlu4n40qhbtihge8x [non-unique index]
recurrence_last_expansion ascending
idxlh9lvmxb2dj3ti83buauwvbil [non-unique index]
domain_repo_id ascending
domain_history_revision_id ascending

 

public."BsaDomainRefresh" [table]
job_id bigserial not null
default nextval('"BsaDomainRefresh_job_id_seq"'::regclass)
auto-incremented
creation_time timestamptz not null
stage text not null
update_timestamp timestamptz
Primary Key
"BsaDomainRefresh_pkey" [primary key]
job_id
Indexes
"BsaDomainRefresh_pkey" [unique index]
job_id ascending

 

public."BsaDownload" [table]
job_id bigserial not null
default nextval('"BsaDownload_job_id_seq"'::regclass)
auto-incremented
block_list_checksums text not null
creation_time timestamptz not null
stage text not null
update_timestamp timestamptz
Primary Key
"BsaDownload_pkey" [primary key]
job_id
Indexes
"BsaDownload_pkey" [unique index]
job_id ascending
idxj874kw19bgdnkxo1rue45jwlw [non-unique index]
creation_time ascending

 

public."BsaLabel" [table]
label text not null
creation_time timestamptz 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
Indexes
"BsaLabel_pkey" [unique index]
label ascending

 

public."BsaUnblockableDomain" [table]
label text not null
tld text not null
creation_time timestamptz not null
reason 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
Indexes
"BsaUnblockableDomain_pkey" [unique index]
label ascending
tld ascending

 

public."ClaimsEntry" [table]
revision_id int8 not null
claim_key text 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
Indexes
"ClaimsEntry_pkey" [unique index]
revision_id ascending
domain_label ascending

 

public."ClaimsList" [table]
revision_id bigserial not null
default nextval('"ClaimsList_revision_id_seq"'::regclass)
auto-incremented
creation_timestamp timestamptz not null
tmdb_generation_time timestamptz not null
Primary Key
"ClaimsList_pkey" [primary key]
revision_id
Foreign Keys
fk6sc6at5hedffc0nhdcab6ivuq [foreign key, with no action]
revision_id ←(0..many) public."ClaimsEntry".revision_id
Indexes
"ClaimsList_pkey" [unique index]
revision_id ascending

 

public."ConsoleEppActionHistory" [table]
history_revision_id int8 not null
history_modification_time timestamptz not null
history_method text not null
history_request_body text
history_type text not null
history_url text not null
history_entry_class text 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
Indexes
"ConsoleEppActionHistory_pkey" [unique index]
history_revision_id ascending
idxiahqo1d1fqdfknywmj2xbxl7t [non-unique index]
revision_id ascending
idxcclyb3n5gbex8u8m9fjlujitw [non-unique index]
history_acting_user ascending
idx6y67d6wsffmr6jcxax5ghwqhd [non-unique index]
repo_id ascending

 

public."ConsoleUpdateHistory" [table]
revision_id int8 not null
modification_time timestamptz not null
"method" text not null
type text not null
url text not null
description text
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
Indexes
"ConsoleUpdateHistory_pkey" [unique index]
revision_id ascending
idx_console_update_history_acting_user [non-unique index]
acting_user ascending
idx_console_update_history_type [non-unique index]
type ascending
idx_console_update_history_modification_time [non-unique index]
modification_time ascending

 

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
last_epp_update_time timestamptz
statuses _text
auth_info_repo_id text
auth_info_value text
contact_id text
disclose_types_addr _text
disclose_show_email bool
disclose_show_fax bool
disclose_mode_flag bool
disclose_types_name _text
disclose_types_org _text
disclose_show_voice bool
email text
fax_phone_extension text
fax_phone_number text
addr_i18n_city text
addr_i18n_country_code text
addr_i18n_state text
addr_i18n_street_line1 text
addr_i18n_street_line2 text
addr_i18n_street_line3 text
addr_i18n_zip text
addr_i18n_name text
addr_i18n_org text
addr_i18n_type text
last_transfer_time timestamptz
addr_local_city text
addr_local_country_code text
addr_local_state text
addr_local_street_line1 text
addr_local_street_line2 text
addr_local_street_line3 text
addr_local_zip text
addr_local_name text
addr_local_org text
addr_local_type text
search_name text
voice_phone_extension text
voice_phone_number text
transfer_poll_message_id_1 int8
transfer_poll_message_id_2 int8
transfer_client_txn_id text
transfer_server_txn_id text
transfer_gaining_registrar_id text
transfer_losing_registrar_id text
transfer_pending_expiration_time timestamptz
transfer_request_time timestamptz
transfer_status text
update_timestamp timestamptz
transfer_history_entry_id int8
transfer_repo_id text
transfer_poll_message_id_3 int8
last_update_time_via_epp timestamptz
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
Indexes
idxoqd7n4hbx86hvlgkilq75olas [non-unique index]
contact_id ascending
idxbn8t4wp85fgxjl8q4ctlscx55 [non-unique index]
current_sponsor_registrar_id ascending
"Contact_pkey" [unique index]
repo_id ascending
idx1p3esngcwwu6hstyua6itn6ff [non-unique index]
search_name ascending
idx3y752kr9uh4kh6uig54vemx0l [non-unique index]
creation_time ascending
idxn1f711wicdnooa2mqb7g1m55o [non-unique index]
deletion_time ascending

 

public."ContactHistory" [table]
history_revision_id int8 not null
history_by_superuser bool not null
history_registrar_id text
history_modification_time timestamptz not null
history_reason text
history_requested_by_registrar bool
history_client_transaction_id text
history_server_transaction_id text
history_type text not null
history_xml_bytes bytea
auth_info_repo_id text
auth_info_value text
contact_id text
disclose_types_addr _text
disclose_show_email bool
disclose_show_fax bool
disclose_mode_flag bool
disclose_types_name _text
disclose_types_org _text
disclose_show_voice bool
email text
fax_phone_extension text
fax_phone_number text
addr_i18n_city text
addr_i18n_country_code text
addr_i18n_state text
addr_i18n_street_line1 text
addr_i18n_street_line2 text
addr_i18n_street_line3 text
addr_i18n_zip text
addr_i18n_name text
addr_i18n_org text
addr_i18n_type text
last_transfer_time timestamptz
addr_local_city text
addr_local_country_code text
addr_local_state text
addr_local_street_line1 text
addr_local_street_line2 text
addr_local_street_line3 text
addr_local_zip text
addr_local_name text
addr_local_org text
addr_local_type text
search_name text
transfer_poll_message_id_1 int8
transfer_poll_message_id_2 int8
transfer_client_txn_id text
transfer_server_txn_id text
transfer_gaining_registrar_id text
transfer_losing_registrar_id text
transfer_pending_expiration_time timestamptz
transfer_request_time timestamptz
transfer_status text
voice_phone_extension text
voice_phone_number text
creation_registrar_id text
creation_time timestamptz
current_sponsor_registrar_id text
deletion_time timestamptz
last_epp_update_registrar_id text
last_epp_update_time timestamptz
statuses _text
contact_repo_id text not null
update_timestamp timestamptz
transfer_history_entry_id int8
transfer_repo_id text
transfer_poll_message_id_3 int8
last_update_time_via_epp timestamptz
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
Indexes
idxhp33wybmb6tbpr1bq7ttwk8je [non-unique index]
history_registrar_id ascending
idx9q53px6r302ftgisqifmc6put [non-unique index]
history_type ascending
idxo1xdtpij2yryh0skxe9v91sep [non-unique index]
creation_time ascending
idxsudwswtwqnfnx2o1hx4s0k0g5 [non-unique index]
history_modification_time ascending
"ContactHistory_pkey" [unique index]
contact_repo_id ascending
history_revision_id ascending

 

public."Cursor" [table]
"scope" text not null
type text not null
cursor_time timestamptz not null
last_update_time timestamptz not null
Primary Key
"Cursor_pkey" [primary key]
"scope"
type
Indexes
"Cursor_pkey" [unique index]
"scope" ascending
type ascending

 

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
Indexes
idxhlqqd5uy98cjyos72d81x9j95 [non-unique index]
domain_repo_id ascending
"DelegationSignerData_pkey" [unique index]
domain_repo_id ascending
key_tag ascending
algorithm ascending
digest_type ascending
digest ascending

 

public."DnsRefreshRequest" [table]
id bigserial not null
default nextval('"DnsRefreshRequest_id_seq"'::regclass)
auto-incremented
name text not null
request_time timestamptz not null
tld text not null
type text not null
last_process_time timestamptz not null
Primary Key
"DnsRefreshRequest_pkey" [primary key]
id
Indexes
"DnsRefreshRequest_pkey" [unique index]
id ascending
idxfdk2xpil2x1gh0omt84k2y3o1 [non-unique index]
last_process_time ascending
idx8gtvnbk64yskcvrdp61f5ied3 [non-unique index]
request_time ascending

 

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
last_epp_update_time timestamptz
statuses _text
auth_info_repo_id text
auth_info_value text
domain_name text
idn_table_name text
last_transfer_time timestamptz
launch_notice_accepted_time timestamptz
launch_notice_expiration_time timestamptz
launch_notice_tcn_id text
launch_notice_validator_id text
registration_expiration_time timestamptz
smd_id text
subordinate_hosts _text
tld text
admin_contact text
billing_contact text
registrant_contact text
tech_contact text
transfer_poll_message_id_1 int8
transfer_poll_message_id_2 int8
transfer_billing_cancellation_id int8
transfer_billing_event_id int8
transfer_billing_recurrence_id int8
transfer_autorenew_poll_message_id int8
transfer_renew_period_unit text
transfer_renew_period_value int4
transfer_client_txn_id text
transfer_server_txn_id text
transfer_registration_expiration_time timestamptz
transfer_gaining_registrar_id text
transfer_losing_registrar_id text
transfer_pending_expiration_time timestamptz
transfer_request_time timestamptz
transfer_status text
update_timestamp timestamptz
billing_recurrence_id int8
autorenew_poll_message_id int8
deletion_poll_message_id int8
autorenew_end_time timestamptz
transfer_autorenew_poll_message_history_id int8
transfer_history_entry_id int8
transfer_repo_id text
transfer_poll_message_id_3 int8
current_package_token text
lordn_phase text not null
default 'NONE'::text
last_update_time_via_epp timestamptz
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
Indexes
idxsfci08jgsymxy6ovh4k7r358c [non-unique index]
billing_recurrence_id ascending
idxhteajcrxmq4o8rsys8kevyiqr [non-unique index]
transfer_billing_cancellation_id ascending
idx3y3k7m2bkgahm9sixiohgyrga [non-unique index]
transfer_billing_event_id ascending
idxcju58vqascbpve1t7fem53ctl [non-unique index]
transfer_billing_recurrence_id ascending
idxnb02m43jcx24r64n8rbg22u4q [non-unique index]
admin_contact ascending
idxq9gy8x2xynt9tb16yajn1gcm8 [non-unique index]
billing_contact ascending
idxkjt9yaq92876dstimd93hwckh [non-unique index]
current_sponsor_registrar_id ascending
idx1rcgkdd777bpvj0r94sltwd5y [non-unique index]
domain_name ascending
idxnjhib7v6fj7dhj5qydkefkl2u [non-unique index]
lordn_phase ascending
idxa7fu0bqynfb79rr80528b4jqt [non-unique index]
registrant_contact ascending
"Domain_pkey" [unique index]
repo_id ascending
idxr22ciyccwi9rrqmt1ro0s59qf [non-unique index]
tech_contact ascending
idxrwl38wwkli1j7gkvtywi9jokq [non-unique index]
tld ascending
idxlrq7v63pc21uoh3auq6eybyhl [non-unique index]
autorenew_end_time ascending
idx8nr0ke9mrrx4ewj6pd2ag4rmr [non-unique index]
creation_time ascending
idx5mnf0wn20tno4b9do88j61klr [non-unique index]
deletion_time ascending

 

public."DomainDsDataHistory" [table]
ds_data_history_revision_id int8 not null
algorithm int4 not null
digest bytea not null
digest_type int4 not null
domain_history_revision_id int8 not null
key_tag int4 not null
domain_repo_id text
Primary Key
"DomainDsDataHistory_pkey" [primary key]
ds_data_history_revision_id
Indexes
"DomainDsDataHistory_pkey" [unique index]
ds_data_history_revision_id ascending
domain_history_to_ds_data_history_idx [non-unique index]
domain_repo_id ascending
domain_history_revision_id ascending
idxmk1d2ngdtfkg6odmw7l5ejisw [non-unique index]
domain_repo_id ascending
domain_history_revision_id ascending

 

public."DomainHistory" [table]
history_revision_id int8 not null
history_by_superuser bool not null
history_registrar_id text
history_modification_time timestamptz not null
history_reason text
history_requested_by_registrar bool
history_client_transaction_id text
history_server_transaction_id text
history_type text not null
history_xml_bytes bytea
admin_contact text
auth_info_repo_id text
auth_info_value text
billing_recurrence_id int8
autorenew_poll_message_id int8
billing_contact text
deletion_poll_message_id int8
domain_name text
idn_table_name text
last_transfer_time timestamptz
launch_notice_accepted_time timestamptz
launch_notice_expiration_time timestamptz
launch_notice_tcn_id text
launch_notice_validator_id text
registrant_contact text
registration_expiration_time timestamptz
smd_id text
subordinate_hosts _text
tech_contact text
tld text
transfer_billing_cancellation_id int8
transfer_billing_recurrence_id int8
transfer_autorenew_poll_message_id int8
transfer_billing_event_id int8
transfer_renew_period_unit text
transfer_renew_period_value int4
transfer_registration_expiration_time timestamptz
transfer_poll_message_id_1 int8
transfer_poll_message_id_2 int8
transfer_client_txn_id text
transfer_server_txn_id text
transfer_gaining_registrar_id text
transfer_losing_registrar_id text
transfer_pending_expiration_time timestamptz
transfer_request_time timestamptz
transfer_status text
creation_registrar_id text
creation_time timestamptz
current_sponsor_registrar_id text
deletion_time timestamptz
last_epp_update_registrar_id text
last_epp_update_time timestamptz
statuses _text
update_timestamp timestamptz
domain_repo_id text not null
autorenew_end_time timestamptz
history_other_registrar_id text
history_period_unit text
history_period_value int4
autorenew_poll_message_history_id int8
transfer_autorenew_poll_message_history_id int8
transfer_history_entry_id int8
transfer_repo_id text
transfer_poll_message_id_3 int8
current_package_token text
lordn_phase text not null
default 'NONE'::text
last_update_time_via_epp timestamptz
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
Indexes
idxaro1omfuaxjwmotk3vo00trwm [non-unique index]
history_registrar_id ascending
idxsu1nam10cjes9keobapn5jvxj [non-unique index]
history_type ascending
idxrh4xmrot9bd63o382ow9ltfig [non-unique index]
creation_time ascending
idx6w3qbtgce93cal2orjg1tw7b7 [non-unique index]
history_modification_time ascending
"DomainHistory_pkey" [unique index]
domain_repo_id ascending
history_revision_id ascending

 

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
Indexes
idx69qun5kxt3eux5igrxrqcycv0 [non-unique index]
domain_history_domain_repo_id ascending
ukt2e7ae3t8gcsxd13wjx2ka7ij [unique index]
domain_history_history_revision_id ascending
domain_history_domain_repo_id ascending
host_repo_id ascending

 

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
Indexes
idxjw3rwtfrexyq53x9vu7qghrdt [non-unique index]
host_repo_id ascending
ukat9erbh52e4lg3jw6ai9wkjj9 [unique index]
domain_repo_id ascending
host_repo_id ascending

 

public."DomainTransactionRecord" [table]
id bigserial not null
default nextval('"DomainTransactionRecord_id_seq"'::regclass)
auto-incremented
report_amount int4 not null
report_field text not null
reporting_time timestamptz not null
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
Indexes
"DomainTransactionRecord_pkey" [unique index]
id ascending
domain_history_to_transaction_record_idx [non-unique index]
domain_repo_id ascending
history_revision_id ascending
idx1dyqmqb61xbnj7mt7bk27ds25 [non-unique index]
domain_repo_id ascending
history_revision_id ascending

 

public."FeatureFlag" [table]
feature_name text not null
status hstore not null
Primary Key
"FeatureFlag_pkey" [primary key]
feature_name
Indexes
"FeatureFlag_pkey" [unique index]
feature_name ascending

 

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
expiration_time timestamptz not null
type 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
Indexes
idxbgssjudpm428mrv0xfpvgifps [non-unique index]
billing_event_id ascending
idx5u5m6clpk3nktrvtyy5umacb6 [non-unique index]
billing_recurrence_id ascending
"GracePeriod_pkey" [unique index]
grace_period_id ascending
idxj1mtx98ndgbtb1bkekahms18w [non-unique index]
domain_repo_id ascending

 

public."GracePeriodHistory" [table]
grace_period_history_revision_id int8 not null
billing_event_id int8
billing_recurrence_id int8
registrar_id text not null
domain_repo_id text not null
expiration_time timestamptz not null
type text not null
domain_history_revision_id int8
grace_period_id int8 not null
Primary Key
"GracePeriodHistory_pkey" [primary key]
grace_period_history_revision_id
Indexes
"GracePeriodHistory_pkey" [unique index]
grace_period_history_revision_id ascending
idxd01j17vrpjxaerxdmn8bwxs7s [non-unique index]
domain_repo_id ascending
idxl67y6wclc2uaupepnvkoo81fl [non-unique index]
domain_repo_id ascending
domain_history_revision_id ascending

 

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
last_epp_update_time timestamptz
statuses _text
host_name text
last_superordinate_change timestamptz
last_transfer_time timestamptz
superordinate_domain text
inet_addresses _text
update_timestamp timestamptz
transfer_poll_message_id_3 int8
last_update_time_via_epp timestamptz
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
Indexes
idxrc77s1ndiemi2vwwudchye214 [non-unique index]
inet_addresses unknown
idxl49vydnq0h5j1piefwjy4i8er [non-unique index]
current_sponsor_registrar_id ascending
idxkpkh68n6dy5v51047yr6b0e9l [non-unique index]
host_name ascending
"Host_pkey" [unique index]
repo_id ascending
idxorp4yv9ult4ds6kgxo5fs5gnw [non-unique index]
superordinate_domain ascending
idxy98mebut8ix1v07fjxxdkqcx [non-unique index]
creation_time ascending
idxovmntef6l45tw2bsfl56tcugx [non-unique index]
deletion_time ascending

 

public."HostHistory" [table]
history_revision_id int8 not null
history_by_superuser bool not null
history_registrar_id text not null
history_modification_time timestamptz not null
history_reason text
history_requested_by_registrar bool
history_client_transaction_id text
history_server_transaction_id text
history_type text not null
history_xml_bytes bytea
host_name text
inet_addresses _text
last_superordinate_change timestamptz
last_transfer_time timestamptz
superordinate_domain text
creation_registrar_id text
creation_time timestamptz
current_sponsor_registrar_id text
deletion_time timestamptz
last_epp_update_registrar_id text
last_epp_update_time timestamptz
statuses _text
host_repo_id text not null
update_timestamp timestamptz
transfer_poll_message_id_3 int8
last_update_time_via_epp timestamptz
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
Indexes
idx1iy7njgb7wjmj9piml4l2g0qi [non-unique index]
history_registrar_id ascending
idxknk8gmj7s47q56cwpa6rmpt5l [non-unique index]
history_type ascending
idxj77pfwhui9f0i7wjq6lmibovj [non-unique index]
host_name ascending
idxfg2nnjlujxo6cb9fha971bq2n [non-unique index]
creation_time ascending
idx67qwkjtlq5q8dv6egtrtnhqi7 [non-unique index]
history_modification_time ascending
"HostHistory_pkey" [unique index]
host_repo_id ascending
history_revision_id ascending

 

public."Lock" [table]
resource_name text not null
"scope" text not null
acquired_time timestamptz not null
expiration_time timestamptz not null
Primary Key
"Lock_pkey" [primary key]
resource_name
"scope"
Indexes
"Lock_pkey" [unique index]
resource_name ascending
"scope" ascending

 

public."PackagePromotion" [table]
package_promotion_id bigserial not null
default nextval('"Package_promotion_id_seq"'::regclass)
auto-incremented
last_notification_sent timestamptz
max_creates int4 not null
max_domains int4 not null
next_billing_date timestamptz not null
package_price_amount numeric(19, 2) not null
package_price_currency text not null
token text not null
Primary Key
"PackagePromotion_pkey" [primary key]
package_promotion_id
Indexes
"PackagePromotion_pkey" [unique index]
package_promotion_id ascending
idxlg6a5tp70nch9cp0gc11brc5o [non-unique index]
token ascending

 

public."PasswordResetRequest" [table]
type text not null
request_time timestamptz not null
requester text not null
fulfillment_time timestamptz
destination_email text not null
verification_code text not null
registrar_id text not null
Primary Key
"PasswordResetRequest_pkey" [primary key]
verification_code
Indexes
"PasswordResetRequest_pkey" [unique index]
verification_code ascending

 

public."PollMessage" [table]
type text not null
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
message text
transfer_response_contact_id text
transfer_response_domain_expiration_time timestamptz
transfer_response_domain_name text
pending_action_response_action_result bool
pending_action_response_name_or_id text
pending_action_response_processed_date timestamptz
pending_action_response_client_txn_id text
pending_action_response_server_txn_id text
transfer_response_gaining_registrar_id text
transfer_response_losing_registrar_id text
transfer_response_pending_transfer_expiration_time timestamptz
transfer_response_transfer_request_time timestamptz
transfer_response_transfer_status text
autorenew_end_time timestamptz
autorenew_domain_name text
transfer_response_host_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
Indexes
"PollMessage_pkey" [unique index]
poll_message_id ascending
idxf2q9dqj899h1q8lah5y719nxd [non-unique index]
domain_repo_id ascending
idxe7wu46c7wpvfmfnj4565abibp [non-unique index]
registrar_id ascending
idxaydgox62uno9qx8cjlj5lauye [non-unique index]
event_time ascending
idxnuyqo6hrtuvbcmuecf7vkfmle [non-unique index]
domain_repo_id ascending
domain_history_revision_id ascending

 

public."PremiumEntry" [table]
revision_id int8 not null
price numeric(19, 2) 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
Indexes
"PremiumEntry_pkey" [unique index]
revision_id ascending
domain_label ascending

 

public."PremiumList" [table]
revision_id bigserial not null
default nextval('"PremiumList_revision_id_seq"'::regclass)
auto-incremented
creation_timestamp timestamptz
name text not null
bloom_filter bytea not null
currency 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
Indexes
"PremiumList_pkey" [unique index]
revision_id ascending
premiumlist_name_idx [non-unique index]
name ascending

 

public."RdeRevision" [table]
tld text not null
mode text not null
"date" date not null
update_timestamp timestamptz
revision int4 not null
Primary Key
"RdeRevision_pkey" [primary key]
tld
mode
"date"
Indexes
"RdeRevision_pkey" [unique index]
tld ascending
mode ascending
"date" ascending

 

public."Registrar" [table]
registrar_id text not null
allowed_tlds _text
billing_account_map hstore
block_premium_names bool not null
client_certificate text
client_certificate_hash text
contacts_require_syncing bool not null
creation_time timestamptz not null
drive_folder_id text
email_address text
failover_client_certificate text
failover_client_certificate_hash text
fax_number text
iana_identifier int8
icann_referral_email text
i18n_address_city text
i18n_address_country_code text
i18n_address_state text
i18n_address_street_line1 text
i18n_address_street_line2 text
i18n_address_street_line3 text
i18n_address_zip text
ip_address_allow_list _text
last_certificate_update_time timestamptz
last_update_time timestamptz not null
localized_address_city text
localized_address_country_code text
localized_address_state text
localized_address_street_line1 text
localized_address_street_line2 text
localized_address_street_line3 text
localized_address_zip text
password_hash text
phone_number text
phone_passcode text
po_number text
rdap_base_urls _text
registrar_name text not null
registry_lock_allowed bool not null
password_salt text
state text
type text not null
url text
whois_server text
last_expiring_cert_notification_sent_date timestamptz
last_expiring_failover_cert_notification_sent_date timestamptz
last_poc_verification_date timestamptz
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
Indexes
registrar_iana_identifier_idx [non-unique index]
iana_identifier ascending
"Registrar_pkey" [unique index]
registrar_id ascending
registrar_name_idx [non-unique index]
registrar_name ascending

 

public."RegistrarPoc" [table]
email_address text not null
allowed_to_set_registry_lock_password bool not null
fax_number text
name text
phone_number text
registry_lock_password_hash text
registry_lock_password_salt text
types _text
visible_in_domain_whois_as_abuse bool not null
visible_in_whois_as_admin bool not null
visible_in_whois_as_tech bool not null
registry_lock_email_address text
registrar_id text not null
id bigserial not null
default nextval('"RegistrarPoc_id_seq"'::regclass)
auto-incremented
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
Indexes
"RegistrarPoc_pkey" [unique index]
registrar_id ascending
email_address ascending

 

public."RegistrarPocUpdateHistory" [table]
history_revision_id int8 not null
history_modification_time timestamptz not null
history_method text not null
history_request_body text
history_type text not null
history_url text not null
email_address text not null
registrar_id text not null
allowed_to_set_registry_lock_password bool not null
fax_number text
login_email_address text
name text
phone_number text
registry_lock_email_address text
registry_lock_password_hash text
registry_lock_password_salt text
types _text
visible_in_domain_whois_as_abuse bool not null
visible_in_whois_as_admin bool not null
visible_in_whois_as_tech bool 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
Indexes
"RegistrarPocUpdateHistory_pkey" [unique index]
history_revision_id ascending
idxr1cxua6it0rxgt9tpyugspxk [non-unique index]
email_address ascending
idxrn6posxkx58de1cp09g5257cw [non-unique index]
history_acting_user ascending
idxfr24wvpg8qalwqy4pni7evrpj [non-unique index]
registrar_id ascending

 

public."RegistrarUpdateHistory" [table]
history_revision_id int8 not null
history_modification_time timestamptz not null
history_method text not null
history_request_body text
history_type text not null
history_url text not null
allowed_tlds _text
billing_account_map hstore
block_premium_names bool not null
client_certificate text
client_certificate_hash text
contacts_require_syncing bool not null
creation_time timestamptz not null
drive_folder_id text
email_address text
failover_client_certificate text
failover_client_certificate_hash text
fax_number text
iana_identifier int8
icann_referral_email text
i18n_address_city text
i18n_address_country_code text
i18n_address_state text
i18n_address_street_line1 text
i18n_address_street_line2 text
i18n_address_street_line3 text
i18n_address_zip text
ip_address_allow_list _text
last_certificate_update_time timestamptz
last_expiring_cert_notification_sent_date timestamptz
last_expiring_failover_cert_notification_sent_date timestamptz
localized_address_city text
localized_address_country_code text
localized_address_state text
localized_address_street_line1 text
localized_address_street_line2 text
localized_address_street_line3 text
localized_address_zip text
password_hash text
phone_number text
phone_passcode text
po_number text
rdap_base_urls _text
registrar_name text not null
registry_lock_allowed bool not null
password_salt text
state text
type text not null
url text
whois_server text
update_timestamp timestamptz
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
Indexes
"RegistrarUpdateHistory_pkey" [unique index]
history_revision_id ascending
idxm6k18dusy2lfi5y81k8g256sa [non-unique index]
history_acting_user ascending
idx3d1mucv7axrhud8w8jl4vsu62 [non-unique index]
registrar_id ascending

 

public."RegistryLock" [table]
revision_id bigserial not null
default nextval('"RegistryLock_revision_id_seq"'::regclass)
auto-incremented
lock_completion_time timestamptz
lock_request_time timestamptz not null
domain_name text not null
is_superuser bool not null
registrar_id text not null
registrar_poc_id text
repo_id text not null
verification_code text not null
unlock_request_time timestamptz
unlock_completion_time timestamptz
last_update_time timestamptz not null
relock_revision_id int8
relock_duration interval
Primary Key
"RegistryLock_pkey" [primary key]
revision_id
Foreign Keys
fk2lhcwpxlnqijr96irylrh1707 [foreign key, with no action]
revision_id ←(0..many) relock_revision_id
Indexes
"RegistryLock_pkey" [unique index]
revision_id ascending
idx_registry_lock_registrar_id [non-unique index]
registrar_id ascending
idx_registry_lock_verification_code [non-unique index]
verification_code ascending
idx_registry_lock_repo_id_revision_id [unique index]
repo_id ascending
revision_id ascending

 

public."ReservedEntry" [table]
revision_id int8 not null
comment text
reservation_type int4 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
Indexes
"ReservedEntry_pkey" [unique index]
revision_id ascending
domain_label ascending

 

public."ReservedList" [table]
revision_id bigserial not null
default nextval('"ReservedList_revision_id_seq"'::regclass)
auto-incremented
creation_timestamp timestamptz not null
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
Indexes
"ReservedList_pkey" [unique index]
revision_id ascending
reservedlist_name_idx [non-unique index]
name ascending

 

public."ServerSecret" [table]
secret uuid not null
id int8 not null
default 1
Primary Key
"ServerSecret_pkey" [primary key]
id
Indexes
"ServerSecret_pkey" [unique index]
id ascending

 

public."SignedMarkRevocationEntry" [table]
revision_id int8 not null
revocation_time timestamptz 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
Indexes
"SignedMarkRevocationEntry_pkey" [unique index]
revision_id ascending
smd_id ascending

 

public."SignedMarkRevocationList" [table]
revision_id bigserial not null
default nextval('"SignedMarkRevocationList_revision_id_seq"'::regclass)
auto-incremented
creation_time timestamptz
Primary Key
"SignedMarkRevocationList_pkey" [primary key]
revision_id
Foreign Keys
fk5ivlhvs3121yx2li5tqh54u4 [foreign key, with no action]
revision_id ←(0..many) public."SignedMarkRevocationEntry".revision_id
Indexes
"SignedMarkRevocationList_pkey" [unique index]
revision_id ascending

 

public."Spec11ThreatMatch" [table]
id bigserial not null
default nextval('"SafeBrowsingThreat_id_seq"'::regclass)
auto-incremented
check_date date not null
domain_name text not null
domain_repo_id text not null
registrar_id text not null
threat_types _text not null
tld text not null
Primary Key
"SafeBrowsingThreat_pkey" [primary key]
id
Indexes
"SafeBrowsingThreat_pkey" [unique index]
id ascending
spec11threatmatch_check_date_idx [non-unique index]
check_date ascending
spec11threatmatch_registrar_id_idx [non-unique index]
registrar_id ascending
spec11threatmatch_tld_idx [non-unique index]
tld ascending

 

public."Tld" [table]
tld_name text not null
add_grace_period_length interval not null
allowed_fully_qualified_host_names _text
allowed_registrant_contact_ids _text
anchor_tenant_add_grace_period_length interval not null
auto_renew_grace_period_length interval not null
automatic_transfer_length interval not null
claims_period_end timestamptz not null
creation_time timestamptz not null
currency text not null
dns_paused bool not null
dns_writers _text not null
drive_folder_id text
eap_fee_schedule hstore not null
escrow_enabled bool not null
invoicing_enabled bool not null
lordn_username text
num_dns_publish_locks int4 not null
pending_delete_length interval not null
premium_list_name text
pricing_engine_class_name text
redemption_grace_period_length interval not null
registry_lock_or_unlock_cost_amount numeric(19, 2)
registry_lock_or_unlock_cost_currency text
renew_billing_cost_transitions hstore not null
renew_grace_period_length interval not null
reserved_list_names _text
restore_billing_cost_amount numeric(19, 2)
restore_billing_cost_currency text
roid_suffix text
server_status_change_billing_cost_amount numeric(19, 2)
server_status_change_billing_cost_currency text
tld_state_transitions hstore not null
tld_type text not null
tld_unicode text not null
transfer_grace_period_length interval not null
default_promo_tokens _text
dns_a_plus_aaaa_ttl interval
dns_ds_ttl interval
dns_ns_ttl interval
idn_tables _text
breakglass_mode bool not null
default false
bsa_enroll_start_time timestamptz
create_billing_cost_transitions hstore 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
Indexes
"Tld_pkey" [unique index]
tld_name ascending

 

public."TmchCrl" [table]
certificate_revocations text not null
update_timestamp timestamptz not null
url text not null
id int8 not null
default 1
Primary Key
"TmchCrl_pkey" [primary key]
id
Indexes
"TmchCrl_pkey" [unique index]
id ascending

 

public."User" [table]
email_address text not null
registry_lock_password_hash text
registry_lock_password_salt text
global_role text not null
is_admin bool not null
registrar_roles hstore not null
update_timestamp timestamptz
registry_lock_email_address text
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
Indexes
"User_pkey" [unique index]
email_address ascending
user_unique_email [unique index]
email_address ascending

 

public."UserUpdateHistory" [table]
history_revision_id int8 not null
history_modification_time timestamptz not null
history_method text not null
history_request_body text
history_type text not null
history_url text not null
email_address text not null
registry_lock_password_hash text
registry_lock_password_salt text
global_role text not null
is_admin bool not null
registrar_roles hstore
update_timestamp timestamptz
history_acting_user text not null
registry_lock_email_address text
Primary Key
"UserUpdateHistory_pkey" [primary key]
history_revision_id
Indexes
"UserUpdateHistory_pkey" [unique index]
history_revision_id ascending
idx5yqacw829y5bm6f7eajsq1cts [non-unique index]
email_address ascending
idxbjacjlm8ianc4kxxvamnu94k5 [non-unique index]
history_acting_user ascending