# SchemaCrawler Output

## System Information

generated by | SchemaCrawler 16.10.1
generated on | 2023-10-04 16:08:53.388005
last flyway file | V147__drop_gaia_id_from_user.sql

## 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
| registration_behavior | text not null
| allowed_epp_actions | _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_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 |
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

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

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

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
|  | 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.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
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 |
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
|  | 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
| last_update_time_via_epp | timestamptz
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 |
Indexes
idxsfci08jgsymxy6ovh4k7r358c | [non-unique index]
| billing_recurrence_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 |
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 |
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

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
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 |
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
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
|  | 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 |
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 |
Indexes
DomainTransactionRecord_pkey | [unique index]
| id | ascending
domain_history_to_transaction_record_idx | [non-unique index]
| domain_repo_id | ascending
| history_revision_id | 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 |
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 |
Indexes
GracePeriodHistory_pkey | [unique index]
| grace_period_history_revision_id | ascending
idxd01j17vrpjxaerxdmn8bwxs7s | [non-unique index]
| domain_repo_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_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 |
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
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_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 |
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
|  | 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.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_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 |
Indexes
PollMessage_pkey | [unique index]
| poll_message_id | ascending
idxe7wu46c7wpvfmfnj4565abibp | [non-unique index]
| registrar_id | ascending
idxaydgox62uno9qx8cjlj5lauye | [non-unique index]
| event_time | 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
|  | 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
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 |
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
| 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 |
Indexes
registrarpoc_login_email_idx | [non-unique index]
| login_email_address | ascending
RegistrarPoc_pkey | [unique index]
| registrar_id | ascending
| email_address | ascending

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
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
|  | auto-incremented
| creation_timestamp | timestamptz not null
| name | text not null
| should_publish | bool 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
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
|  | 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
|  | 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
| create_billing_cost_amount | numeric(19, 2)
| create_billing_cost_currency | text
| 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
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
Primary Key
TmchCrl_pkey | [primary key]
| id |
Indexes
TmchCrl_pkey | [unique index]
| id | ascending

public."User" [table]
| id | bigserial not null
|  | auto-incremented
| 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
Primary Key
User_pkey | [primary key]
| id |
Indexes
User_pkey | [unique index]
| id | ascending
user_unique_email | [unique index]
| email_address | ascending
user_email_address_idx | [non-unique index]
| email_address | ascending