## System Information

generated by | SchemaCrawler 17.12.2
generated on | 2026-08-12 15:33:59
last flyway file | V228__hosthistory_repo_id_mod_time_idx.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
|  | default 'DEFAULT'::text
| registration_behavior | text not null
|  | default 'DEFAULT'::text
| allowed_epp_actions | _text
| renewal_price_amount | numeric(19, 2)
| renewal_price_currency | text
| discount_price_amount | numeric(19, 2)
| discount_price_currency | text
Primary Key
"AllocationToken_pkey" | [primary key]
| token |
Foreign Keys
fk_billing_event_allocation_token | [foreign key, with no action]
| token ←(0..many) public."BillingEvent".allocation_token |
fk_domain_current_package_token | [foreign key, with no action]
| token ←(0..many) public."Domain".current_package_token |
fk_domain_history_current_package_token | [foreign key, with no action]
| token ←(0..many) public."DomainHistory".current_package_token |
Indexes
allocation_token_domain_name_idx | [non-unique index]
| domain_name | ascending
idxtmlqd31dpvvd2g1h9i7erw6aj | [non-unique index]
| redemption_domain_repo_id | ascending
"AllocationToken_pkey" | [unique index]
| token | ascending
allocationtoken_token_hash | [non-unique hashed index]
| token | unknown
idx9g3s7mjv1yn4t06nqid39whss | [non-unique index]
| token_type | ascending

public."BillingCancellation" [table]
| billing_cancellation_id | int8 not null
| registrar_id | text not null
| domain_history_revision_id | int8 not null
| domain_repo_id | text not null
| event_time | timestamptz not null
| flags | _text
| reason | text not null
| domain_name | text not null
| billing_time | timestamptz
| billing_event_id | int8
| billing_recurrence_id | int8
Primary Key
"BillingCancellation_pkey" | [primary key]
| billing_cancellation_id |
Foreign Keys
fk_billing_cancellation_billing_event_id | [foreign key, with no action]
| billing_event_id (0..many)→ public."BillingEvent".billing_event_id |
fk_billing_cancellation_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id |
fk_billing_cancellation_registrar_id | [foreign key, with no action]
| registrar_id (1..many)→ public."Registrar".registrar_id |
fk_domain_transfer_billing_cancellation_id | [foreign key, with no action]
| billing_cancellation_id ←(0..many) public."Domain".transfer_billing_cancellation_id |
Indexes
"BillingCancellation_pkey" | [unique index]
| billing_cancellation_id | ascending
billingcancellation_billing_cancellation_id_hash | [non-unique hashed index]
| billing_cancellation_id | unknown
idx4ytbe5f3b39trsd4okx5ijhs4 | [non-unique index]
| billing_event_id | ascending
idxku0fopwyvd57ebo8bf0jg9xo2 | [non-unique index]
| billing_recurrence_id | ascending
idxl8vobbecsd32k4ksavdfx8st6 | [non-unique index]
| domain_repo_id | ascending
idxeokttmxtpq2hohcioe5t2242b | [non-unique index]
| registrar_id | ascending
idxqa3g92jc17e8dtiaviy4fet4x | [non-unique index]
| billing_time | ascending
idx2exdfbx6oiiwnhr8j6gjpqt2j | [non-unique index]
| event_time | ascending
idx7v75e535c47mxfb2rk9o843bn | [non-unique index]
| domain_repo_id | ascending
| domain_history_revision_id | ascending

public."BillingEvent" [table]
| billing_event_id | int8 not null
| registrar_id | text not null
| domain_history_revision_id | int8 not null
| domain_repo_id | text not null
| event_time | timestamptz not null
| flags | _text
| reason | text not null
| domain_name | text not null
| allocation_token | text
| billing_time | timestamptz
| cancellation_matching_billing_recurrence_id | int8
| cost_amount | numeric(19, 2)
| cost_currency | text
| period_years | int4
| synthetic_creation_time | timestamptz
| recurrence_history_revision_id | int8
Primary Key
"BillingEvent_pkey" | [primary key]
| billing_event_id |
Foreign Keys
fk_billing_cancellation_billing_event_id | [foreign key, with no action]
| billing_event_id ←(0..many) public."BillingCancellation".billing_event_id |
fk_billing_event_allocation_token | [foreign key, with no action]
| allocation_token (0..many)→ public."AllocationToken".token |
fk_billing_event_cancellation_matching_billing_recurrence_id | [foreign key, with no action]
| cancellation_matching_billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id |
fk_billing_event_registrar_id | [foreign key, with no action]
| registrar_id (1..many)→ public."Registrar".registrar_id |
fk_domain_transfer_billing_event_id | [foreign key, with no action]
| billing_event_id ←(0..many) public."Domain".transfer_billing_event_id |
fk_grace_period_billing_event_id | [foreign key, with no action]
| billing_event_id ←(0..many) public."GracePeriod".billing_event_id |
Indexes
"BillingEvent_pkey" | [unique index]
| billing_event_id | ascending
billingevent_billing_event_id_hash | [non-unique hashed index]
| billing_event_id | unknown
idx6ebt3nwk5ocvnremnhnlkl6ff | [non-unique index]
| cancellation_matching_billing_recurrence_id | ascending
idxhmv411mdqo5ibn4vy7ykxpmlv | [non-unique index]
| allocation_token | ascending
idxbgfmveqa7e5hn689koikwn70r | [non-unique index]
| domain_repo_id | ascending
idx73l103vc5900ig3p4odf0cngt | [non-unique index]
| registrar_id | ascending
idx6py6ocrab0ivr76srcd2okpnq | [non-unique index]
| billing_time | ascending
idx5yfbr88439pxw0v3j86c74fp8 | [non-unique index]
| event_time | ascending
idxplxf9v56p0wg8ws6qsvd082hk | [non-unique index]
| synthetic_creation_time | ascending
idx77ceolnf7rok8ui957msmo6en | [non-unique index]
| domain_repo_id | ascending
| domain_history_revision_id | ascending
idxehp8ejwpbsooar0e8k32847m3 | [non-unique index]
| domain_repo_id | ascending
| recurrence_history_revision_id | ascending

public."BillingRecurrence" [table]
| billing_recurrence_id | int8 not null
| registrar_id | text not null
| domain_history_revision_id | int8 not null
| domain_repo_id | text not null
| event_time | timestamptz not null
| flags | _text
| reason | text not null
| domain_name | text not null
| recurrence_end_time | timestamptz
| recurrence_time_of_year | text
| renewal_price_behavior | text not null
|  | default 'DEFAULT'::text
| renewal_price_currency | text
| renewal_price_amount | numeric(19, 2)
| recurrence_last_expansion | timestamptz not null
|  | default '2021-05-31 20:00:00-04'::timestamp with time zone
Primary Key
"BillingRecurrence_pkey" | [primary key]
| billing_recurrence_id |
Foreign Keys
fk_billing_cancellation_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public."BillingCancellation".billing_recurrence_id |
fk_billing_event_cancellation_matching_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public."BillingEvent".cancellation_matching_billing_recurrence_id |
fk_billing_recurrence_registrar_id | [foreign key, with no action]
| registrar_id (1..many)→ public."Registrar".registrar_id |
fk_domain_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public."Domain".billing_recurrence_id |
fk_domain_transfer_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public."Domain".transfer_billing_recurrence_id |
fk_grace_period_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id ←(0..many) public."GracePeriod".billing_recurrence_id |
Indexes
"BillingRecurrence_pkey" | [unique index]
| billing_recurrence_id | ascending
billingrecurrence_billing_recurrence_id_hash | [non-unique hashed index]
| billing_recurrence_id | unknown
idxoqttafcywwdn41um6kwlt0n8b | [non-unique index]
| domain_repo_id | ascending
idxjny8wuot75b5e6p38r47wdawu | [non-unique index]
| recurrence_time_of_year | ascending
idxn898pb9mwcg359cdwvolb11ck | [non-unique index]
| registrar_id | ascending
idx6syykou4nkc7hqa5p8r92cpch | [non-unique index]
| event_time | ascending
idxp3usbtvk0v1m14i5tdp4xnxgc | [non-unique index]
| recurrence_end_time | ascending
idxp0pxi708hlu4n40qhbtihge8x | [non-unique index]
| recurrence_last_expansion | ascending
idxlh9lvmxb2dj3ti83buauwvbil | [non-unique index]
| domain_repo_id | ascending
| domain_history_revision_id | ascending

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

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

public."BsaLabel" [table]
| label | text not null
| creation_time | timestamptz not null
Primary Key
"BsaLabel_pkey" | [primary key]
| label |
Foreign Keys
fkbsaunblockabledomainlabel | [foreign key, on update no action, on delete cascade]
| label ←(1..many) public."BsaUnblockableDomain".label |
Indexes
"BsaLabel_pkey" | [unique index]
| label | ascending

public."BsaUnblockableDomain" [table]
| label | text not null
| tld | text not null
| creation_time | timestamptz not null
| reason | text not null
Primary Key
"BsaUnblockableDomain_pkey" | [primary key]
| label |
| tld |
Foreign Keys
fkbsaunblockabledomainlabel | [foreign key, on update no action, on delete cascade]
| label (1..many)→ public."BsaLabel".label |
Indexes
"BsaUnblockableDomain_pkey" | [unique index]
| label | ascending
| tld | ascending

public."ClaimsEntry" [table]
| revision_id | int8 not null
| claim_key | text not null
| domain_label | text not null
Primary Key
"ClaimsEntry_pkey" | [primary key]
| revision_id |
| domain_label |
Foreign Keys
fk6sc6at5hedffc0nhdcab6ivuq | [foreign key, with no action]
| revision_id (1..many)→ public."ClaimsList".revision_id |
Indexes
"ClaimsEntry_pkey" | [unique index]
| revision_id | ascending
| domain_label | ascending

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

public."ConsoleEppActionHistory" [table]
| history_revision_id | int8 not null
| history_modification_time | timestamptz not null
| history_method | text not null
| history_request_body | text
| history_type | text not null
| history_url | text not null
| history_entry_class | text not null
| repo_id | text not null
| revision_id | int8 not null
| history_acting_user | text not null
Primary Key
"ConsoleEppActionHistory_pkey" | [primary key]
| history_revision_id |
Indexes
"ConsoleEppActionHistory_pkey" | [unique index]
| history_revision_id | ascending
idxiahqo1d1fqdfknywmj2xbxl7t | [non-unique index]
| revision_id | ascending
idxcclyb3n5gbex8u8m9fjlujitw | [non-unique index]
| history_acting_user | ascending
idx6y67d6wsffmr6jcxax5ghwqhd | [non-unique index]
| repo_id | ascending

public."ConsoleUpdateHistory" [table]
| revision_id | int8 not null
| modification_time | timestamptz not null
| "method" | text not null
| type | text not null
| url | text not null
| description | text
| acting_user | text not null
Primary Key
"ConsoleUpdateHistory_pkey" | [primary key]
| revision_id |
Foreign Keys
fk_console_update_history_acting_user | [foreign key, with no action]
| acting_user (1..many)→ public."User".email_address |
Indexes
"ConsoleUpdateHistory_pkey" | [unique index]
| revision_id | ascending
idx_console_update_history_acting_user | [non-unique index]
| acting_user | ascending
idx_console_update_history_type | [non-unique index]
| type | ascending
idx_console_update_history_modification_time | [non-unique index]
| modification_time | ascending

public."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 (1..many)→ public."Domain".repo_id |
Indexes
delegationsignerdata_domain_repo_id_hash | [non-unique hashed index]
| domain_repo_id | unknown
idxhlqqd5uy98cjyos72d81x9j95 | [non-unique index]
| domain_repo_id | ascending
"DelegationSignerData_pkey" | [unique index]
| domain_repo_id | ascending
| key_tag | ascending
| algorithm | ascending
| digest_type | ascending
| digest | ascending

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

public."Domain" [table]
| repo_id | text not null
| creation_registrar_id | text not null
| creation_time | timestamptz not null
| current_sponsor_registrar_id | text not null
| deletion_time | timestamptz
| last_epp_update_registrar_id | text
| last_epp_update_time | timestamptz
| statuses | _text
| auth_info_repo_id | text
| auth_info_value | text
| domain_name | text
| idn_table_name | text
| last_transfer_time | timestamptz
| launch_notice_accepted_time | timestamptz
| launch_notice_expiration_time | timestamptz
| launch_notice_tcn_id | text
| launch_notice_validator_id | text
| registration_expiration_time | timestamptz
| smd_id | text
| subordinate_hosts | _text
| tld | text
| admin_contact | text
| billing_contact | text
| registrant_contact | text
| tech_contact | text
| transfer_poll_message_id_1 | int8
| transfer_poll_message_id_2 | int8
| transfer_billing_cancellation_id | int8
| transfer_billing_event_id | int8
| transfer_billing_recurrence_id | int8
| transfer_autorenew_poll_message_id | int8
| transfer_renew_period_unit | text
| transfer_renew_period_value | int4
| transfer_client_txn_id | text
| transfer_server_txn_id | text
| transfer_registration_expiration_time | timestamptz
| transfer_gaining_registrar_id | text
| transfer_losing_registrar_id | text
| transfer_pending_expiration_time | timestamptz
| transfer_request_time | timestamptz
| transfer_status | text
| update_timestamp | timestamptz
| billing_recurrence_id | int8
| autorenew_poll_message_id | int8
| deletion_poll_message_id | int8
| autorenew_end_time | timestamptz
| transfer_autorenew_poll_message_history_id | int8
| transfer_history_entry_id | int8
| transfer_repo_id | text
| transfer_poll_message_id_3 | int8
| current_package_token | text
| lordn_phase | text not null
|  | default 'NONE'::text
| last_update_time_via_epp | timestamptz
Primary Key
"Domain_pkey" | [primary key]
| repo_id |
Foreign Keys
fktr24j9v14ph2mfuw2gsmt12kq | [foreign key, with no action]
| repo_id ←(1..many) public."DelegationSignerData".domain_repo_id |
fk_domain_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id |
fk2jc69qyg2tv9hhnmif6oa1cx1 | [foreign key, with no action]
| creation_registrar_id (1..many)→ public."Registrar".registrar_id |
fk_domain_current_package_token | [foreign key, with no action]
| current_package_token (0..many)→ public."AllocationToken".token |
fk2u3srsfbei272093m3b3xwj23 | [foreign key, with no action]
| current_sponsor_registrar_id (1..many)→ public."Registrar".registrar_id |
fkjc0r9r5y1lfbt4gpbqw4wsuvq | [foreign key, with no action]
| last_epp_update_registrar_id (0..many)→ public."Registrar".registrar_id |
fk_domain_tld | [foreign key, with no action]
| tld (0..many)→ public."Tld".tld_name |
fk_domain_transfer_billing_cancellation_id | [foreign key, with no action]
| transfer_billing_cancellation_id (0..many)→ public."BillingCancellation".billing_cancellation_id |
fk_domain_transfer_billing_event_id | [foreign key, with no action]
| transfer_billing_event_id (0..many)→ public."BillingEvent".billing_event_id |
fk_domain_transfer_billing_recurrence_id | [foreign key, with no action]
| transfer_billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id |
fk_domain_transfer_gaining_registrar_id | [foreign key, with no action]
| transfer_gaining_registrar_id (0..many)→ public."Registrar".registrar_id |
fk_domain_transfer_losing_registrar_id | [foreign key, with no action]
| transfer_losing_registrar_id (0..many)→ public."Registrar".registrar_id |
fk_domain_history_domain_repo_id | [foreign key, with no action]
| repo_id ←(1..many) public."DomainHistory".domain_repo_id |
fkfmi7bdink53swivs390m2btxg | [foreign key, with no action]
| repo_id ←(1..many) public."DomainHost".domain_repo_id |
fk_grace_period_domain_repo_id | [foreign key, with no action]
| repo_id ←(1..many) public."GracePeriod".domain_repo_id |
fk_host_superordinate_domain | [foreign key, with no action]
| repo_id ←(0..many) public."Host".superordinate_domain |
fk_poll_message_domain_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public."PollMessage".domain_repo_id |
Indexes
idxsfci08jgsymxy6ovh4k7r358c | [non-unique index]
| billing_recurrence_id | ascending
idxhteajcrxmq4o8rsys8kevyiqr | [non-unique index]
| transfer_billing_cancellation_id | ascending
idx3y3k7m2bkgahm9sixiohgyrga | [non-unique index]
| transfer_billing_event_id | ascending
idxcju58vqascbpve1t7fem53ctl | [non-unique index]
| transfer_billing_recurrence_id | ascending
idxnb02m43jcx24r64n8rbg22u4q | [non-unique index]
| admin_contact | ascending
idxq9gy8x2xynt9tb16yajn1gcm8 | [non-unique index]
| billing_contact | ascending
domain_current_package_token_idx | [non-unique hashed index]
| current_package_token | unknown
idxkjt9yaq92876dstimd93hwckh | [non-unique index]
| current_sponsor_registrar_id | ascending
domain_no_duplicate_active | [unique index]
| domain_name | ascending
| [filter condition]
(deletion_time = '294247-01-09 23:00:54.775-05'::timestamp with time zone)
domain_domain_name_hash | [non-unique hashed index]
| domain_name | unknown
idx1rcgkdd777bpvj0r94sltwd5y | [non-unique index]
| domain_name | ascending
idxnjhib7v6fj7dhj5qydkefkl2u | [non-unique index]
| lordn_phase | ascending
| [filter condition]
(lordn_phase <> 'NONE'::text)
idxa7fu0bqynfb79rr80528b4jqt | [non-unique index]
| registrant_contact | ascending
"Domain_pkey" | [unique index]
| repo_id | ascending
domain_domain_repo_id_hash | [non-unique hashed index]
| repo_id | unknown
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
domain_tld_domain_name_idx | [non-unique index]
| tld | ascending
| domain_name | ascending

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

public."DomainHistory" [table]
| history_revision_id | int8 not null
| history_by_superuser | bool not null
| history_registrar_id | text
| history_modification_time | timestamptz not null
| history_reason | text
| history_requested_by_registrar | bool
| history_client_transaction_id | text
| history_server_transaction_id | text
| history_type | text not null
| history_xml_bytes | bytea
| admin_contact | text
| auth_info_repo_id | text
| auth_info_value | text
| billing_recurrence_id | int8
| autorenew_poll_message_id | int8
| billing_contact | text
| deletion_poll_message_id | int8
| domain_name | text
| idn_table_name | text
| last_transfer_time | timestamptz
| launch_notice_accepted_time | timestamptz
| launch_notice_expiration_time | timestamptz
| launch_notice_tcn_id | text
| launch_notice_validator_id | text
| registrant_contact | text
| registration_expiration_time | timestamptz
| smd_id | text
| subordinate_hosts | _text
| tech_contact | text
| tld | text
| transfer_billing_cancellation_id | int8
| transfer_billing_recurrence_id | int8
| transfer_autorenew_poll_message_id | int8
| transfer_billing_event_id | int8
| transfer_renew_period_unit | text
| transfer_renew_period_value | int4
| transfer_registration_expiration_time | timestamptz
| transfer_poll_message_id_1 | int8
| transfer_poll_message_id_2 | int8
| transfer_client_txn_id | text
| transfer_server_txn_id | text
| transfer_gaining_registrar_id | text
| transfer_losing_registrar_id | text
| transfer_pending_expiration_time | timestamptz
| transfer_request_time | timestamptz
| transfer_status | text
| creation_registrar_id | text
| creation_time | timestamptz
| current_sponsor_registrar_id | text
| deletion_time | timestamptz
| last_epp_update_registrar_id | text
| last_epp_update_time | timestamptz
| statuses | _text
| update_timestamp | timestamptz
| domain_repo_id | text not null
| autorenew_end_time | timestamptz
| history_other_registrar_id | text
| history_period_unit | text
| history_period_value | int4
| autorenew_poll_message_history_id | int8
| transfer_autorenew_poll_message_history_id | int8
| transfer_history_entry_id | int8
| transfer_repo_id | text
| transfer_poll_message_id_3 | int8
| current_package_token | text
| lordn_phase | text not null
|  | default 'NONE'::text
| last_update_time_via_epp | timestamptz
Primary Key
"DomainHistory_pkey" | [primary key]
| domain_repo_id |
| history_revision_id |
Foreign Keys
fk_domain_history_current_package_token | [foreign key, with no action]
| current_package_token (0..many)→ public."AllocationToken".token |
fk_domain_history_domain_repo_id | [foreign key, with no action]
| domain_repo_id (1..many)→ public."Domain".repo_id |
fk_domain_history_registrar_id | [foreign key, with no action]
| history_registrar_id (0..many)→ public."Registrar".registrar_id |
fka9woh3hu8gx5x0vly6bai327n | [foreign key, with no action]
| domain_repo_id ←(1..many) public."DomainHistoryHost".domain_history_domain_repo_id |
| history_revision_id ←(1..many) public."DomainHistoryHost".domain_history_history_revision_id |
Indexes
domainhistory_history_revision_id_hash | [non-unique hashed index]
| history_revision_id | unknown
domainhistory_current_package_token_idx | [non-unique hashed index]
| current_package_token | unknown
domainhistory_domain_repo_id_hash | [non-unique hashed index]
| domain_repo_id | unknown
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
domainhistory_repo_id_modification_time | [non-unique index]
| domain_repo_id | ascending
| history_modification_time | 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 (1..many)→ public."DomainHistory".domain_repo_id |
| domain_history_history_revision_id (1..many)→ public."DomainHistory".history_revision_id |
Indexes
domainhistoryhost_domain_history_history_revision_id_hash | [non-unique hashed index]
| domain_history_history_revision_id | unknown
idx69qun5kxt3eux5igrxrqcycv0 | [non-unique index]
| domain_history_domain_repo_id | ascending
ukt2e7ae3t8gcsxd13wjx2ka7ij | [unique index]
| domain_history_history_revision_id | ascending
| domain_history_domain_repo_id | ascending
| host_repo_id | ascending

public."DomainHost" [table]
| domain_repo_id | text not null
| host_repo_id | text
Foreign Keys
fkfmi7bdink53swivs390m2btxg | [foreign key, with no action]
| domain_repo_id (1..many)→ public."Domain".repo_id |
fk_domainhost_host_valid | [foreign key, with no action]
| host_repo_id (0..many)→ public."Host".repo_id |
Indexes
domainhost_domain_repo_id_hash | [non-unique hashed index]
| domain_repo_id | unknown
idxjw3rwtfrexyq53x9vu7qghrdt | [non-unique index]
| host_repo_id | ascending
ukat9erbh52e4lg3jw6ai9wkjj9 | [unique index]
| domain_repo_id | ascending
| host_repo_id | ascending

public."DomainTransactionRecord" [table]
| id | bigserial not null
|  | default nextval('"DomainTransactionRecord_id_seq"'::regclass)
|  | auto-incremented
| report_amount | int4 not null
| report_field | text not null
| reporting_time | timestamptz not null
| tld | text not null
| domain_repo_id | text
| history_revision_id | int8
Primary Key
"DomainTransactionRecord_pkey" | [primary key]
| id |
Foreign Keys
fk_domain_transaction_record_tld | [foreign key, with no action]
| tld (1..many)→ public."Tld".tld_name |
Indexes
"DomainTransactionRecord_pkey" | [unique index]
| id | ascending
domaintransactionrecord_id_hash | [non-unique hashed index]
| id | unknown
domaintransactionrecord_domain_history_revision_id_hash | [non-unique hashed index]
| history_revision_id | unknown
domain_history_to_transaction_record_idx | [non-unique index]
| domain_repo_id | ascending
| history_revision_id | ascending
idx1dyqmqb61xbnj7mt7bk27ds25 | [non-unique index]
| domain_repo_id | ascending
| history_revision_id | ascending

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

public."GracePeriod" [table]
| grace_period_id | int8 not null
| billing_event_id | int8
| billing_recurrence_id | int8
| registrar_id | text not null
| domain_repo_id | text not null
| expiration_time | timestamptz not null
| type | text not null
Primary Key
"GracePeriod_pkey" | [primary key]
| grace_period_id |
Foreign Keys
fk_grace_period_billing_event_id | [foreign key, with no action]
| billing_event_id (0..many)→ public."BillingEvent".billing_event_id |
fk_grace_period_billing_recurrence_id | [foreign key, with no action]
| billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id |
fk_grace_period_domain_repo_id | [foreign key, with no action]
| domain_repo_id (1..many)→ public."Domain".repo_id |
fk_grace_period_registrar_id | [foreign key, with no action]
| registrar_id (1..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
graceperiod_grace_period_id_hash | [non-unique hashed index]
| grace_period_id | unknown
graceperiod_domain_repo_id_hash | [non-unique hashed index]
| domain_repo_id | unknown
idxj1mtx98ndgbtb1bkekahms18w | [non-unique index]
| domain_repo_id | ascending

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

public."Host" [table]
| repo_id | text not null
| creation_registrar_id | text
| creation_time | timestamptz
| current_sponsor_registrar_id | text
| deletion_time | timestamptz
| last_epp_update_registrar_id | text
| last_epp_update_time | timestamptz
| statuses | _text
| host_name | text
| last_superordinate_change | timestamptz
| last_transfer_time | timestamptz
| superordinate_domain | text
| inet_addresses | _text
| update_timestamp | timestamptz
| transfer_poll_message_id_3 | int8
| last_update_time_via_epp | timestamptz
Primary Key
"Host_pkey" | [primary key]
| repo_id |
Foreign Keys
fk_domainhost_host_valid | [foreign key, with no action]
| repo_id ←(0..many) public."DomainHost".host_repo_id |
fk_host_creation_registrar_id | [foreign key, with no action]
| creation_registrar_id (0..many)→ public."Registrar".registrar_id |
fk_host_current_sponsor_registrar_id | [foreign key, with no action]
| current_sponsor_registrar_id (0..many)→ public."Registrar".registrar_id |
fk_host_last_epp_update_registrar_id | [foreign key, with no action]
| last_epp_update_registrar_id (0..many)→ public."Registrar".registrar_id |
fk_host_superordinate_domain | [foreign key, with no action]
| superordinate_domain (0..many)→ public."Domain".repo_id |
fk_hosthistory_host | [foreign key, with no action]
| repo_id ←(1..many) public."HostHistory".host_repo_id |
fk_poll_message_host_repo_id | [foreign key, with no action]
| repo_id ←(0..many) public."PollMessage".host_repo_id |
Indexes
idxrc77s1ndiemi2vwwudchye214 | [non-unique index]
| inet_addresses | unknown
idxl49vydnq0h5j1piefwjy4i8er | [non-unique index]
| current_sponsor_registrar_id | ascending
host_host_name_hash | [non-unique hashed index]
| host_name | unknown
idxkpkh68n6dy5v51047yr6b0e9l | [non-unique index]
| host_name | ascending
"Host_pkey" | [unique index]
| repo_id | ascending
host_repo_id_hash | [non-unique hashed index]
| repo_id | unknown
idxorp4yv9ult4ds6kgxo5fs5gnw | [non-unique index]
| superordinate_domain | ascending
idxy98mebut8ix1v07fjxxdkqcx | [non-unique index]
| creation_time | ascending
idxovmntef6l45tw2bsfl56tcugx | [non-unique index]
| deletion_time | ascending

public."HostHistory" [table]
| history_revision_id | int8 not null
| history_by_superuser | bool not null
| history_registrar_id | text not null
| history_modification_time | timestamptz not null
| history_reason | text
| history_requested_by_registrar | bool
| history_client_transaction_id | text
| history_server_transaction_id | text
| history_type | text not null
| history_xml_bytes | bytea
| host_name | text
| inet_addresses | _text
| last_superordinate_change | timestamptz
| last_transfer_time | timestamptz
| superordinate_domain | text
| creation_registrar_id | text
| creation_time | timestamptz
| current_sponsor_registrar_id | text
| deletion_time | timestamptz
| last_epp_update_registrar_id | text
| last_epp_update_time | timestamptz
| statuses | _text
| host_repo_id | text not null
| update_timestamp | timestamptz
| transfer_poll_message_id_3 | int8
| last_update_time_via_epp | timestamptz
Primary Key
"HostHistory_pkey" | [primary key]
| host_repo_id |
| history_revision_id |
Foreign Keys
fk_history_registrar_id | [foreign key, with no action]
| history_registrar_id (1..many)→ public."Registrar".registrar_id |
fk_hosthistory_host | [foreign key, with no action]
| host_repo_id (1..many)→ public."Host".repo_id |
fk_poll_message_host_history | [foreign key, with no action]
| host_repo_id ←(0..many) public."PollMessage".host_repo_id |
| history_revision_id ←(0..many) public."PollMessage".host_history_revision_id |
Indexes
idx1iy7njgb7wjmj9piml4l2g0qi | [non-unique index]
| history_registrar_id | ascending
idxknk8gmj7s47q56cwpa6rmpt5l | [non-unique index]
| history_type | ascending
idxj77pfwhui9f0i7wjq6lmibovj | [non-unique index]
| host_name | ascending
idxfg2nnjlujxo6cb9fha971bq2n | [non-unique index]
| creation_time | ascending
idx67qwkjtlq5q8dv6egtrtnhqi7 | [non-unique index]
| history_modification_time | ascending
"HostHistory_pkey" | [unique index]
| host_repo_id | ascending
| history_revision_id | ascending
hosthistory_repo_id_modification_time | [non-unique index]
| host_repo_id | ascending
| history_modification_time | ascending

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

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

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

public."PollMessage" [table]
| type | text not null
| poll_message_id | int8 not null
| registrar_id | text not null
| contact_repo_id | text
| contact_history_revision_id | int8
| domain_repo_id | text
| domain_history_revision_id | int8
| event_time | timestamptz not null
| host_repo_id | text
| host_history_revision_id | int8
| message | text
| transfer_response_contact_id | text
| transfer_response_domain_expiration_time | timestamptz
| transfer_response_domain_name | text
| pending_action_response_action_result | bool
| pending_action_response_name_or_id | text
| pending_action_response_processed_date | timestamptz
| pending_action_response_client_txn_id | text
| pending_action_response_server_txn_id | text
| transfer_response_gaining_registrar_id | text
| transfer_response_losing_registrar_id | text
| transfer_response_pending_transfer_expiration_time | timestamptz
| transfer_response_transfer_request_time | timestamptz
| transfer_response_transfer_status | text
| autorenew_end_time | timestamptz
| autorenew_domain_name | text
| transfer_response_host_id | text
Primary Key
"PollMessage_pkey" | [primary key]
| poll_message_id |
Foreign Keys
fk_poll_message_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 (1..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_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
pollmessage_poll_message_id_hash | [non-unique hashed index]
| poll_message_id | unknown
idxf2q9dqj899h1q8lah5y719nxd | [non-unique index]
| domain_repo_id | ascending
idxe7wu46c7wpvfmfnj4565abibp | [non-unique index]
| registrar_id | ascending
idxaydgox62uno9qx8cjlj5lauye | [non-unique index]
| event_time | ascending
idxnuyqo6hrtuvbcmuecf7vkfmle | [non-unique index]
| domain_repo_id | ascending
| domain_history_revision_id | ascending

public."PremiumEntry" [table]
| revision_id | int8 not null
| price | numeric(19, 2) not null
| domain_label | text not null
Primary Key
"PremiumEntry_pkey" | [primary key]
| revision_id |
| domain_label |
Foreign Keys
fko0gw90lpo1tuee56l0nb6y6g5 | [foreign key, with no action]
| revision_id (1..many)→ public."PremiumList".revision_id |
Indexes
"PremiumEntry_pkey" | [unique index]
| revision_id | ascending
| domain_label | ascending

public."PremiumList" [table]
| revision_id | bigserial not null
|  | default nextval('"PremiumList_revision_id_seq"'::regclass)
|  | auto-incremented
| creation_timestamp | timestamptz
| name | text not null
| bloom_filter | bytea not null
| currency | text not null
Primary Key
"PremiumList_pkey" | [primary key]
| revision_id |
Foreign Keys
fko0gw90lpo1tuee56l0nb6y6g5 | [foreign key, with no action]
| revision_id ←(1..many) public."PremiumEntry".revision_id |
Indexes
"PremiumList_pkey" | [unique index]
| revision_id | ascending
premiumlist_name_idx | [non-unique index]
| name | ascending

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

public."Registrar" [table]
| registrar_id | text not null
| allowed_tlds | _text
| billing_account_map | hstore
| block_premium_names | bool not null
| client_certificate | text
| client_certificate_hash | text
| contacts_require_syncing | bool not null
| creation_time | timestamptz not null
| drive_folder_id | text
| email_address | text
| failover_client_certificate | text
| failover_client_certificate_hash | text
| fax_number | text
| iana_identifier | int8
| icann_referral_email | text
| i18n_address_city | text
| i18n_address_country_code | text
| i18n_address_state | text
| i18n_address_street_line1 | text
| i18n_address_street_line2 | text
| i18n_address_street_line3 | text
| i18n_address_zip | text
| ip_address_allow_list | _text
| last_certificate_update_time | timestamptz
| last_update_time | timestamptz not null
| localized_address_city | text
| localized_address_country_code | text
| localized_address_state | text
| localized_address_street_line1 | text
| localized_address_street_line2 | text
| localized_address_street_line3 | text
| localized_address_zip | text
| password_hash | text
| phone_number | text
| phone_passcode | text
| po_number | text
| rdap_base_urls | _text
| registrar_name | text not null
| registry_lock_allowed | bool not null
| password_salt | text
| state | text
| type | text not null
| url | text
| whois_server | text
| last_expiring_cert_notification_sent_date | timestamptz
| last_expiring_failover_cert_notification_sent_date | timestamptz
| last_poc_verification_date | timestamptz
| expiry_access_period_enabled | bool not null
|  | default false
Primary Key
"Registrar_pkey" | [primary key]
| registrar_id |
Foreign Keys
fk_billing_cancellation_registrar_id | [foreign key, with no action]
| registrar_id ←(1..many) public."BillingCancellation".registrar_id |
fk_billing_event_registrar_id | [foreign key, with no action]
| registrar_id ←(1..many) public."BillingEvent".registrar_id |
fk_billing_recurrence_registrar_id | [foreign key, with no action]
| registrar_id ←(1..many) public."BillingRecurrence".registrar_id |
fk2jc69qyg2tv9hhnmif6oa1cx1 | [foreign key, with no action]
| registrar_id ←(1..many) public."Domain".creation_registrar_id |
fk2u3srsfbei272093m3b3xwj23 | [foreign key, with no action]
| registrar_id ←(1..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 ←(1..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 ←(1..many) public."HostHistory".history_registrar_id |
fk_poll_message_registrar_id | [foreign key, with no action]
| registrar_id ←(1..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 ←(1..many) public."RegistrarPoc".registrar_id |
fkregistrarupdatehistoryregistrarid | [foreign key, with no action]
| registrar_id ←(1..many) public."RegistrarUpdateHistory".registrar_id |
Indexes
registrar_iana_identifier_idx | [non-unique index]
| iana_identifier | ascending
"Registrar_pkey" | [unique index]
| registrar_id | ascending
registrar_name_idx | [non-unique index]
| registrar_name | ascending

public."RegistrarPoc" [table]
| email_address | text not null
| allowed_to_set_registry_lock_password | bool
| fax_number | text
| name | text
| phone_number | text
| registry_lock_password_hash | text
| registry_lock_password_salt | text
| types | _text
| visible_in_domain_whois_as_abuse | bool not null
| visible_in_whois_as_admin | bool not null
| visible_in_whois_as_tech | bool not null
| registry_lock_email_address | text
| registrar_id | text not null
| id | bigserial not null
|  | default nextval('"RegistrarPoc_id_seq"'::regclass)
|  | auto-incremented
Primary Key
"RegistrarPoc_pkey" | [primary key]
| registrar_id |
| email_address |
Foreign Keys
fk_registrar_poc_registrar_id | [foreign key, with no action]
| registrar_id (1..many)→ public."Registrar".registrar_id |
fkregistrarpocupdatehistoryemailaddress | [foreign key, with no action]
| email_address ←(1..many) public."RegistrarPocUpdateHistory".email_address |
| registrar_id ←(1..many) public."RegistrarPocUpdateHistory".registrar_id |
Indexes
"RegistrarPoc_pkey" | [unique index]
| registrar_id | ascending
| email_address | ascending

public."RegistrarPocUpdateHistory" [table]
| history_revision_id | int8 not null
| history_modification_time | timestamptz not null
| history_method | text not null
| history_request_body | text
| history_type | text not null
| history_url | text not null
| email_address | text not null
| registrar_id | text not null
| allowed_to_set_registry_lock_password | bool not null
| fax_number | text
| login_email_address | text
| name | text
| phone_number | text
| registry_lock_email_address | text
| registry_lock_password_hash | text
| registry_lock_password_salt | text
| types | _text
| visible_in_domain_whois_as_abuse | bool not null
| visible_in_whois_as_admin | bool not null
| visible_in_whois_as_tech | bool not null
| history_acting_user | text not null
Primary Key
"RegistrarPocUpdateHistory_pkey" | [primary key]
| history_revision_id |
Foreign Keys
fkregistrarpocupdatehistoryemailaddress | [foreign key, with no action]
| email_address (1..many)→ public."RegistrarPoc".email_address |
| registrar_id (1..many)→ public."RegistrarPoc".registrar_id |
Indexes
"RegistrarPocUpdateHistory_pkey" | [unique index]
| history_revision_id | ascending
idxr1cxua6it0rxgt9tpyugspxk | [non-unique index]
| email_address | ascending
idxrn6posxkx58de1cp09g5257cw | [non-unique index]
| history_acting_user | ascending
idxfr24wvpg8qalwqy4pni7evrpj | [non-unique index]
| registrar_id | ascending

public."RegistrarUpdateHistory" [table]
| history_revision_id | int8 not null
| history_modification_time | timestamptz not null
| history_method | text not null
| history_request_body | text
| history_type | text not null
| history_url | text not null
| allowed_tlds | _text
| billing_account_map | hstore
| block_premium_names | bool not null
| client_certificate | text
| client_certificate_hash | text
| contacts_require_syncing | bool not null
| creation_time | timestamptz not null
| drive_folder_id | text
| email_address | text
| failover_client_certificate | text
| failover_client_certificate_hash | text
| fax_number | text
| iana_identifier | int8
| icann_referral_email | text
| i18n_address_city | text
| i18n_address_country_code | text
| i18n_address_state | text
| i18n_address_street_line1 | text
| i18n_address_street_line2 | text
| i18n_address_street_line3 | text
| i18n_address_zip | text
| ip_address_allow_list | _text
| last_certificate_update_time | timestamptz
| last_expiring_cert_notification_sent_date | timestamptz
| last_expiring_failover_cert_notification_sent_date | timestamptz
| localized_address_city | text
| localized_address_country_code | text
| localized_address_state | text
| localized_address_street_line1 | text
| localized_address_street_line2 | text
| localized_address_street_line3 | text
| localized_address_zip | text
| password_hash | text
| phone_number | text
| phone_passcode | text
| po_number | text
| rdap_base_urls | _text
| registrar_name | text not null
| registry_lock_allowed | bool not null
| password_salt | text
| state | text
| type | text not null
| url | text
| whois_server | text
| update_timestamp | timestamptz
| registrar_id | text not null
| history_acting_user | text not null
Primary Key
"RegistrarUpdateHistory_pkey" | [primary key]
| history_revision_id |
Foreign Keys
fkregistrarupdatehistoryregistrarid | [foreign key, with no action]
| registrar_id (1..many)→ public."Registrar".registrar_id |
Indexes
"RegistrarUpdateHistory_pkey" | [unique index]
| history_revision_id | ascending
idxm6k18dusy2lfi5y81k8g256sa | [non-unique index]
| history_acting_user | ascending
idx3d1mucv7axrhud8w8jl4vsu62 | [non-unique index]
| registrar_id | ascending

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

public."ReservedEntry" [table]
| revision_id | int8 not null
| comment | text
| reservation_type | int4 not null
| domain_label | text not null
Primary Key
"ReservedEntry_pkey" | [primary key]
| revision_id |
| domain_label |
Foreign Keys
fkgq03rk0bt1hb915dnyvd3vnfc | [foreign key, with no action]
| revision_id (1..many)→ public."ReservedList".revision_id |
Indexes
"ReservedEntry_pkey" | [unique index]
| revision_id | ascending
| domain_label | ascending

public."ReservedList" [table]
| revision_id | bigserial not null
|  | default nextval('"ReservedList_revision_id_seq"'::regclass)
|  | auto-incremented
| creation_timestamp | timestamptz not null
| name | text not null
Primary Key
"ReservedList_pkey" | [primary key]
| revision_id |
Foreign Keys
fkgq03rk0bt1hb915dnyvd3vnfc | [foreign key, with no action]
| revision_id ←(1..many) public."ReservedEntry".revision_id |
Indexes
"ReservedList_pkey" | [unique index]
| revision_id | ascending
reservedlist_name_idx | [non-unique index]
| name | ascending

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

public."SignedMarkRevocationEntry" [table]
| revision_id | int8 not null
| revocation_time | timestamptz not null
| smd_id | text not null
Primary Key
"SignedMarkRevocationEntry_pkey" | [primary key]
| revision_id |
| smd_id |
Foreign Keys
fk5ivlhvs3121yx2li5tqh54u4 | [foreign key, with no action]
| revision_id (1..many)→ public."SignedMarkRevocationList".revision_id |
Indexes
"SignedMarkRevocationEntry_pkey" | [unique index]
| revision_id | ascending
| smd_id | ascending

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

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

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

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

public."User" [table]
| email_address | text not null
| registry_lock_password_hash | text
| registry_lock_password_salt | text
| global_role | text not null
| is_admin | bool not null
| registrar_roles | hstore not null
| update_timestamp | timestamptz
| registry_lock_email_address | text
Primary Key
"User_pkey" | [primary key]
| email_address |
Foreign Keys
fk_console_update_history_acting_user | [foreign key, with no action]
| email_address ←(1..many) public."ConsoleUpdateHistory".acting_user |
Indexes
"User_pkey" | [unique index]
| email_address | ascending
user_unique_email | [unique index]
| email_address | ascending
user_registry_lock_email_address_idx | [non-unique hashed index]
| registry_lock_email_address | unknown

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