System Information

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

 

 

SchemaCrawler_Diagram generated by SchemaCrawler 16.25.2 generated on 2025-06-04 18:53:06 allocationtoken_a08ccbef public."AllocationToken" [table] token text not null domain_name text redemption_domain_repo_id text token_type 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 allocation_token text billing_time timestamptz cancellation_matching_billing_recurrence_id int8 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 recurrence_end_time timestamptz recurrence_time_of_year text 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 iana_identifier int8 registrar_name text not null 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 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 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 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 contact_id text search_name text transfer_gaining_registrar_id text transfer_losing_registrar_id text 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 domain_6c51cffa:w->tld_f1fa57e2:e fk_domain_tld domainhistory_a54cc226 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 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 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 bsadownload_98d031ce public."BsaDownload" [table] job_id bigserial not null auto-incremented creation_time timestamptz not null bsalabel_2755e1da public."BsaLabel" [table] label text not null bsaunblockabledomain_b739a38 public."BsaUnblockableDomain" [table] label text not null tld text not null bsaunblockabledomain_b739a38:w->bsalabel_2755e1da:e fkbsaunblockabledomainlabel claimsentry_105da9f1 public."ClaimsEntry" [table] revision_id int8 not null domain_label text not null claimslist_3d49bc2b public."ClaimsList" [table] revision_id bigserial not null auto-incremented claimsentry_105da9f1:w->claimslist_3d49bc2b:e fk6sc6at5hedffc0nhdcab6ivuq consoleeppactionhistory_bcc2a2c6 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 consoleupdatehistory_5237b2aa public."ConsoleUpdateHistory" [table] revision_id int8 not null modification_time timestamptz not null type text not null acting_user text not null user_f2216f01 public."User" [table] email_address text not null 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_registrar_id text history_modification_time timestamptz not null history_type text not null creation_time timestamptz contact_repo_id text not null 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] 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 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 host_name text superordinate_domain text inet_addresses _text pollmessage_614a523e:w->host_f21b78de:e fk_poll_message_host_repo_id hosthistory_56210c2 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 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 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 request_time timestamptz 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 domain_history_revision_id int8 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 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 graceperiodhistory_40ccc1f1 public."GracePeriodHistory" [table] grace_period_history_revision_id int8 not null domain_repo_id text not null domain_history_revision_id int8 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 packagepromotion_56aa33 public."PackagePromotion" [table] package_promotion_id bigserial not null auto-incremented token text not null passwordresetrequest_8484e7b1 public."PasswordResetRequest" [table] verification_code text not null premiumentry_b0060b91 public."PremiumEntry" [table] revision_id int8 not null domain_label text not null premiumlist_7c3ea68b public."PremiumList" [table] revision_id bigserial not null auto-incremented name 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 registrarpoc_ab47054d public."RegistrarPoc" [table] email_address text not null registrar_id text not null registrarpoc_ab47054d:w->registrar_6e1503e3:e fk_registrar_poc_registrar_id registrarupdatehistory_8a38bed4 public."RegistrarUpdateHistory" [table] history_revision_id int8 not null 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 email_address text not null registrar_id text 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 registrar_id text not null repo_id text not null verification_code text not null relock_revision_id int8 registrylock_ac88663e:w->registrylock_ac88663e:e fk2lhcwpxlnqijr96irylrh1707 reservedentry_1a7b8520 public."ReservedEntry" [table] revision_id int8 not null domain_label text not null reservedlist_b97c3f1c public."ReservedList" [table] revision_id bigserial not null auto-incremented name text not null reservedentry_1a7b8520:w->reservedlist_b97c3f1c:e fkgq03rk0bt1hb915dnyvd3vnfc serversecret_6cc90f09 public."ServerSecret" [table] id int8 not null signedmarkrevocationentry_99c39721 public."SignedMarkRevocationEntry" [table] revision_id int8 not null smd_id text not null signedmarkrevocationlist_c5d968fb public."SignedMarkRevocationList" [table] revision_id bigserial not null auto-incremented signedmarkrevocationentry_99c39721:w->signedmarkrevocationlist_c5d968fb:e fk5ivlhvs3121yx2li5tqh54u4 spec11threatmatch_a61228a6 public."Spec11ThreatMatch" [table] id bigserial not null auto-incremented check_date date not null registrar_id text not null tld text not null tmchcrl_d282355 public."TmchCrl" [table] id int8 not null userupdatehistory_24efd476 public."UserUpdateHistory" [table] history_revision_id int8 not null email_address text not null history_acting_user text not null

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