System Information

generated by SchemaCrawler 16.10.1
generated on 2023-03-09 22:05:25.449957
last flyway file V139__add_allowed_epp_actions_column.sql

 

 

SchemaCrawler_Diagram generated by SchemaCrawler 16.10.1 generated on 2023-03-09 22:05:25.449957 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 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 billingevent_a57d1815:w->domainhistory_a54cc226:e fk_billing_event_domain_history billingevent_a57d1815:w->domainhistory_a54cc226:e fk_billing_event_domain_history billingevent_a57d1815:w->domainhistory_a54cc226:e fk_billing_event_recurrence_history billingevent_a57d1815:w->domainhistory_a54cc226:e fk_billing_event_recurrence_history 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: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->domainhistory_a54cc226:e fk_billing_cancellation_domain_history billingcancellation_6eedf614:w->domainhistory_a54cc226:e fk_billing_cancellation_domain_history 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->domainhistory_a54cc226:e fk_billing_recurrence_domain_history billingrecurrence_5fa2cb01:w->domainhistory_a54cc226:e fk_billing_recurrence_domain_history billingrecurrence_5fa2cb01:w->registrar_6e1503e3:e fk_billing_recurrence_registrar_id 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 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->domainhistory_a54cc226:e fk_poll_message_domain_history pollmessage_614a523e:w->domainhistory_a54cc226:e fk_poll_message_domain_history 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 databasemigrationstateschedule_22edefab public.DatabaseMigrationStateSchedule [table] id int8 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 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 domaindsdatahistory_995b060d:w->domainhistory_a54cc226:e fko4ilgyyfnvppbpuivus565i0j domaindsdatahistory_995b060d:w->domainhistory_a54cc226:e fko4ilgyyfnvppbpuivus565i0j 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->domainhistory_a54cc226:e fkcjqe54u72kha71vkibvxhjye7 domaintransactionrecord_6e77ff61:w->domainhistory_a54cc226:e fkcjqe54u72kha71vkibvxhjye7 domaintransactionrecord_6e77ff61:w->tld_f1fa57e2:e fk_domain_transaction_record_tld graceperiodhistory_40ccc1f1 public.GracePeriodHistory [table] grace_period_history_revision_id int8 not null domain_repo_id text not null domain_history_revision_id int8 graceperiodhistory_40ccc1f1:w->domainhistory_a54cc226:e fk7w3cx8d55q8bln80e716tr7b8 graceperiodhistory_40ccc1f1:w->domainhistory_a54cc226:e fk7w3cx8d55q8bln80e716tr7b8 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 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 login_email_address text registrarpoc_ab47054d:w->registrar_6e1503e3:e fk_registrar_poc_registrar_id 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 user_f2216f01 public."User" [table] id bigserial not null auto-incremented email_address text not null gaia_id text

Tables

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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