generated by | SchemaCrawler 16.25.2 |
generated on | 2025-06-04 18:53:03 |
last flyway file | V195__registrar_poc_id.sql |
token | text not null | |
update_timestamp | timestamptz | |
allowed_registrar_ids | _text | |
allowed_tlds | _text | |
creation_time | timestamptz not null | |
discount_fraction | float8(17, 17) not null | |
discount_premiums | bool not null | |
discount_years | int4 not null | |
domain_name | text | |
redemption_domain_repo_id | text | |
token_status_transitions | hstore | |
token_type | text | |
redemption_domain_history_id | int8 | |
renewal_price_behavior | text not null | |
default 'DEFAULT'::text | ||
registration_behavior | text not null | |
default 'DEFAULT'::text | ||
allowed_epp_actions | _text | |
renewal_price_amount | numeric(19, 2) | |
renewal_price_currency | text | |
discount_price_amount | numeric(19, 2) | |
discount_price_currency | text | |
Primary Key | ||
"AllocationToken_pkey" | [primary key] | |
token | ||
Foreign Keys | ||
fk_billing_event_allocation_token | [foreign key, with no action] | |
token ←(0..many) public."BillingEvent".allocation_token | ||
fk_domain_current_package_token | [foreign key, with no action] | |
token ←(0..many) public."Domain".current_package_token | ||
fk_domain_history_current_package_token | [foreign key, with no action] | |
token ←(0..many) public."DomainHistory".current_package_token | ||
Indexes | ||
allocation_token_domain_name_idx | [non-unique index] | |
domain_name | ascending | |
idxtmlqd31dpvvd2g1h9i7erw6aj | [non-unique index] | |
redemption_domain_repo_id | ascending | |
"AllocationToken_pkey" | [unique index] | |
token | ascending | |
idx9g3s7mjv1yn4t06nqid39whss | [non-unique index] | |
token_type | ascending |
billing_cancellation_id | int8 not null | |
registrar_id | text not null | |
domain_history_revision_id | int8 not null | |
domain_repo_id | text not null | |
event_time | timestamptz not null | |
flags | _text | |
reason | text not null | |
domain_name | text not null | |
billing_time | timestamptz | |
billing_event_id | int8 | |
billing_recurrence_id | int8 | |
Primary Key | ||
"BillingCancellation_pkey" | [primary key] | |
billing_cancellation_id | ||
Foreign Keys | ||
fk_billing_cancellation_billing_event_id | [foreign key, with no action] | |
billing_event_id (0..many)→ public."BillingEvent".billing_event_id | ||
fk_billing_cancellation_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id | ||
fk_billing_cancellation_registrar_id | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_transfer_billing_cancellation_id | [foreign key, with no action] | |
billing_cancellation_id ←(0..many) public."Domain".transfer_billing_cancellation_id | ||
Indexes | ||
"BillingCancellation_pkey" | [unique index] | |
billing_cancellation_id | ascending | |
idx4ytbe5f3b39trsd4okx5ijhs4 | [non-unique index] | |
billing_event_id | ascending | |
idxku0fopwyvd57ebo8bf0jg9xo2 | [non-unique index] | |
billing_recurrence_id | ascending | |
idxl8vobbecsd32k4ksavdfx8st6 | [non-unique index] | |
domain_repo_id | ascending | |
idxeokttmxtpq2hohcioe5t2242b | [non-unique index] | |
registrar_id | ascending | |
idxqa3g92jc17e8dtiaviy4fet4x | [non-unique index] | |
billing_time | ascending | |
idx2exdfbx6oiiwnhr8j6gjpqt2j | [non-unique index] | |
event_time | ascending | |
idx7v75e535c47mxfb2rk9o843bn | [non-unique index] | |
domain_repo_id | ascending | |
domain_history_revision_id | ascending |
billing_event_id | int8 not null | |
registrar_id | text not null | |
domain_history_revision_id | int8 not null | |
domain_repo_id | text not null | |
event_time | timestamptz not null | |
flags | _text | |
reason | text not null | |
domain_name | text not null | |
allocation_token | text | |
billing_time | timestamptz | |
cancellation_matching_billing_recurrence_id | int8 | |
cost_amount | numeric(19, 2) | |
cost_currency | text | |
period_years | int4 | |
synthetic_creation_time | timestamptz | |
recurrence_history_revision_id | int8 | |
Primary Key | ||
"BillingEvent_pkey" | [primary key] | |
billing_event_id | ||
Foreign Keys | ||
fk_billing_cancellation_billing_event_id | [foreign key, with no action] | |
billing_event_id ←(0..many) public."BillingCancellation".billing_event_id | ||
fk_billing_event_allocation_token | [foreign key, with no action] | |
allocation_token (0..many)→ public."AllocationToken".token | ||
fk_billing_event_cancellation_matching_billing_recurrence_id | [foreign key, with no action] | |
cancellation_matching_billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id | ||
fk_billing_event_registrar_id | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_transfer_billing_event_id | [foreign key, with no action] | |
billing_event_id ←(0..many) public."Domain".transfer_billing_event_id | ||
fk_grace_period_billing_event_id | [foreign key, with no action] | |
billing_event_id ←(0..many) public."GracePeriod".billing_event_id | ||
Indexes | ||
"BillingEvent_pkey" | [unique index] | |
billing_event_id | ascending | |
idx6ebt3nwk5ocvnremnhnlkl6ff | [non-unique index] | |
cancellation_matching_billing_recurrence_id | ascending | |
idxhmv411mdqo5ibn4vy7ykxpmlv | [non-unique index] | |
allocation_token | ascending | |
idxbgfmveqa7e5hn689koikwn70r | [non-unique index] | |
domain_repo_id | ascending | |
idx73l103vc5900ig3p4odf0cngt | [non-unique index] | |
registrar_id | ascending | |
idx6py6ocrab0ivr76srcd2okpnq | [non-unique index] | |
billing_time | ascending | |
idx5yfbr88439pxw0v3j86c74fp8 | [non-unique index] | |
event_time | ascending | |
idxplxf9v56p0wg8ws6qsvd082hk | [non-unique index] | |
synthetic_creation_time | ascending | |
idx77ceolnf7rok8ui957msmo6en | [non-unique index] | |
domain_repo_id | ascending | |
domain_history_revision_id | ascending | |
idxehp8ejwpbsooar0e8k32847m3 | [non-unique index] | |
domain_repo_id | ascending | |
recurrence_history_revision_id | ascending |
billing_recurrence_id | int8 not null | |
registrar_id | text not null | |
domain_history_revision_id | int8 not null | |
domain_repo_id | text not null | |
event_time | timestamptz not null | |
flags | _text | |
reason | text not null | |
domain_name | text not null | |
recurrence_end_time | timestamptz | |
recurrence_time_of_year | text | |
renewal_price_behavior | text not null | |
default 'DEFAULT'::text | ||
renewal_price_currency | text | |
renewal_price_amount | numeric(19, 2) | |
recurrence_last_expansion | timestamptz not null | |
default '2021-05-31 20:00:00-04'::timestamp with time zone | ||
Primary Key | ||
"BillingRecurrence_pkey" | [primary key] | |
billing_recurrence_id | ||
Foreign Keys | ||
fk_billing_cancellation_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id ←(0..many) public."BillingCancellation".billing_recurrence_id | ||
fk_billing_event_cancellation_matching_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id ←(0..many) public."BillingEvent".cancellation_matching_billing_recurrence_id | ||
fk_billing_recurrence_registrar_id | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id ←(0..many) public."Domain".billing_recurrence_id | ||
fk_domain_transfer_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id ←(0..many) public."Domain".transfer_billing_recurrence_id | ||
fk_grace_period_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id ←(0..many) public."GracePeriod".billing_recurrence_id | ||
Indexes | ||
"BillingRecurrence_pkey" | [unique index] | |
billing_recurrence_id | ascending | |
idxoqttafcywwdn41um6kwlt0n8b | [non-unique index] | |
domain_repo_id | ascending | |
idxjny8wuot75b5e6p38r47wdawu | [non-unique index] | |
recurrence_time_of_year | ascending | |
idxn898pb9mwcg359cdwvolb11ck | [non-unique index] | |
registrar_id | ascending | |
idx6syykou4nkc7hqa5p8r92cpch | [non-unique index] | |
event_time | ascending | |
idxp3usbtvk0v1m14i5tdp4xnxgc | [non-unique index] | |
recurrence_end_time | ascending | |
idxp0pxi708hlu4n40qhbtihge8x | [non-unique index] | |
recurrence_last_expansion | ascending | |
idxlh9lvmxb2dj3ti83buauwvbil | [non-unique index] | |
domain_repo_id | ascending | |
domain_history_revision_id | ascending |
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 |
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 |
label | text not null | |
creation_time | timestamptz not null | |
Primary Key | ||
"BsaLabel_pkey" | [primary key] | |
label | ||
Foreign Keys | ||
fkbsaunblockabledomainlabel | [foreign key, on update no action, on delete cascade] | |
label ←(0..many) public."BsaUnblockableDomain".label | ||
Indexes | ||
"BsaLabel_pkey" | [unique index] | |
label | ascending |
label | text not null | |
tld | text not null | |
creation_time | timestamptz not null | |
reason | text not null | |
Primary Key | ||
"BsaUnblockableDomain_pkey" | [primary key] | |
label | ||
tld | ||
Foreign Keys | ||
fkbsaunblockabledomainlabel | [foreign key, on update no action, on delete cascade] | |
label (0..many)→ public."BsaLabel".label | ||
Indexes | ||
"BsaUnblockableDomain_pkey" | [unique index] | |
label | ascending | |
tld | ascending |
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 |
revision_id | bigserial not null | |
default nextval('"ClaimsList_revision_id_seq"'::regclass) | ||
auto-incremented | ||
creation_timestamp | timestamptz not null | |
tmdb_generation_time | timestamptz not null | |
Primary Key | ||
"ClaimsList_pkey" | [primary key] | |
revision_id | ||
Foreign Keys | ||
fk6sc6at5hedffc0nhdcab6ivuq | [foreign key, with no action] | |
revision_id ←(0..many) public."ClaimsEntry".revision_id | ||
Indexes | ||
"ClaimsList_pkey" | [unique index] | |
revision_id | ascending |
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 |
revision_id | int8 not null | |
modification_time | timestamptz not null | |
"method" | text not null | |
type | text not null | |
url | text not null | |
description | text | |
acting_user | text not null | |
Primary Key | ||
"ConsoleUpdateHistory_pkey" | [primary key] | |
revision_id | ||
Foreign Keys | ||
fk_console_update_history_acting_user | [foreign key, with no action] | |
acting_user (0..many)→ public."User".email_address | ||
Indexes | ||
"ConsoleUpdateHistory_pkey" | [unique index] | |
revision_id | ascending | |
idx_console_update_history_acting_user | [non-unique index] | |
acting_user | ascending | |
idx_console_update_history_type | [non-unique index] | |
type | ascending | |
idx_console_update_history_modification_time | [non-unique index] | |
modification_time | ascending |
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 | |
text | ||
fax_phone_extension | text | |
fax_phone_number | text | |
addr_i18n_city | text | |
addr_i18n_country_code | text | |
addr_i18n_state | text | |
addr_i18n_street_line1 | text | |
addr_i18n_street_line2 | text | |
addr_i18n_street_line3 | text | |
addr_i18n_zip | text | |
addr_i18n_name | text | |
addr_i18n_org | text | |
addr_i18n_type | text | |
last_transfer_time | timestamptz | |
addr_local_city | text | |
addr_local_country_code | text | |
addr_local_state | text | |
addr_local_street_line1 | text | |
addr_local_street_line2 | text | |
addr_local_street_line3 | text | |
addr_local_zip | text | |
addr_local_name | text | |
addr_local_org | text | |
addr_local_type | text | |
search_name | text | |
voice_phone_extension | text | |
voice_phone_number | text | |
transfer_poll_message_id_1 | int8 | |
transfer_poll_message_id_2 | int8 | |
transfer_client_txn_id | text | |
transfer_server_txn_id | text | |
transfer_gaining_registrar_id | text | |
transfer_losing_registrar_id | text | |
transfer_pending_expiration_time | timestamptz | |
transfer_request_time | timestamptz | |
transfer_status | text | |
update_timestamp | timestamptz | |
transfer_history_entry_id | int8 | |
transfer_repo_id | text | |
transfer_poll_message_id_3 | int8 | |
last_update_time_via_epp | timestamptz | |
Primary Key | ||
"Contact_pkey" | [primary key] | |
repo_id | ||
Foreign Keys | ||
fk1sfyj7o7954prbn1exk7lpnoe | [foreign key, with no action] | |
creation_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk93c185fx7chn68uv7nl6uv2s0 | [foreign key, with no action] | |
current_sponsor_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fkmb7tdiv85863134w1wogtxrb2 | [foreign key, with no action] | |
last_epp_update_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_contact_transfer_gaining_registrar_id | [foreign key, with no action] | |
transfer_gaining_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_contact_transfer_losing_registrar_id | [foreign key, with no action] | |
transfer_losing_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_contact_history_contact_repo_id | [foreign key, with no action] | |
repo_id ←(0..many) public."ContactHistory".contact_repo_id | ||
fk_domain_admin_contact | [foreign key, with no action] | |
repo_id ←(0..many) public."Domain".admin_contact | ||
fk_domain_billing_contact | [foreign key, with no action] | |
repo_id ←(0..many) public."Domain".billing_contact | ||
fk_domain_registrant_contact | [foreign key, with no action] | |
repo_id ←(0..many) public."Domain".registrant_contact | ||
fk_domain_tech_contact | [foreign key, with no action] | |
repo_id ←(0..many) public."Domain".tech_contact | ||
fk_poll_message_contact_repo_id | [foreign key, with no action] | |
repo_id ←(0..many) public."PollMessage".contact_repo_id | ||
Indexes | ||
idxoqd7n4hbx86hvlgkilq75olas | [non-unique index] | |
contact_id | ascending | |
idxbn8t4wp85fgxjl8q4ctlscx55 | [non-unique index] | |
current_sponsor_registrar_id | ascending | |
"Contact_pkey" | [unique index] | |
repo_id | ascending | |
idx1p3esngcwwu6hstyua6itn6ff | [non-unique index] | |
search_name | ascending | |
idx3y752kr9uh4kh6uig54vemx0l | [non-unique index] | |
creation_time | ascending | |
idxn1f711wicdnooa2mqb7g1m55o | [non-unique index] | |
deletion_time | ascending |
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 | |
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 |
"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 |
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 |
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 |
repo_id | text not null | |
creation_registrar_id | text not null | |
creation_time | timestamptz not null | |
current_sponsor_registrar_id | text not null | |
deletion_time | timestamptz | |
last_epp_update_registrar_id | text | |
last_epp_update_time | timestamptz | |
statuses | _text | |
auth_info_repo_id | text | |
auth_info_value | text | |
domain_name | text | |
idn_table_name | text | |
last_transfer_time | timestamptz | |
launch_notice_accepted_time | timestamptz | |
launch_notice_expiration_time | timestamptz | |
launch_notice_tcn_id | text | |
launch_notice_validator_id | text | |
registration_expiration_time | timestamptz | |
smd_id | text | |
subordinate_hosts | _text | |
tld | text | |
admin_contact | text | |
billing_contact | text | |
registrant_contact | text | |
tech_contact | text | |
transfer_poll_message_id_1 | int8 | |
transfer_poll_message_id_2 | int8 | |
transfer_billing_cancellation_id | int8 | |
transfer_billing_event_id | int8 | |
transfer_billing_recurrence_id | int8 | |
transfer_autorenew_poll_message_id | int8 | |
transfer_renew_period_unit | text | |
transfer_renew_period_value | int4 | |
transfer_client_txn_id | text | |
transfer_server_txn_id | text | |
transfer_registration_expiration_time | timestamptz | |
transfer_gaining_registrar_id | text | |
transfer_losing_registrar_id | text | |
transfer_pending_expiration_time | timestamptz | |
transfer_request_time | timestamptz | |
transfer_status | text | |
update_timestamp | timestamptz | |
billing_recurrence_id | int8 | |
autorenew_poll_message_id | int8 | |
deletion_poll_message_id | int8 | |
autorenew_end_time | timestamptz | |
transfer_autorenew_poll_message_history_id | int8 | |
transfer_history_entry_id | int8 | |
transfer_repo_id | text | |
transfer_poll_message_id_3 | int8 | |
current_package_token | text | |
lordn_phase | text not null | |
default 'NONE'::text | ||
last_update_time_via_epp | timestamptz | |
Primary Key | ||
"Domain_pkey" | [primary key] | |
repo_id | ||
Foreign Keys | ||
fktr24j9v14ph2mfuw2gsmt12kq | [foreign key, with no action] | |
repo_id ←(0..many) public."DelegationSignerData".domain_repo_id | ||
fk_domain_admin_contact | [foreign key, with no action] | |
admin_contact (0..many)→ public."Contact".repo_id | ||
fk_domain_billing_contact | [foreign key, with no action] | |
billing_contact (0..many)→ public."Contact".repo_id | ||
fk_domain_billing_recurrence_id | [foreign key, with no action] | |
billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id | ||
fk2jc69qyg2tv9hhnmif6oa1cx1 | [foreign key, with no action] | |
creation_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_current_package_token | [foreign key, with no action] | |
current_package_token (0..many)→ public."AllocationToken".token | ||
fk2u3srsfbei272093m3b3xwj23 | [foreign key, with no action] | |
current_sponsor_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fkjc0r9r5y1lfbt4gpbqw4wsuvq | [foreign key, with no action] | |
last_epp_update_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_registrant_contact | [foreign key, with no action] | |
registrant_contact (0..many)→ public."Contact".repo_id | ||
fk_domain_tech_contact | [foreign key, with no action] | |
tech_contact (0..many)→ public."Contact".repo_id | ||
fk_domain_tld | [foreign key, with no action] | |
tld (0..many)→ public."Tld".tld_name | ||
fk_domain_transfer_billing_cancellation_id | [foreign key, with no action] | |
transfer_billing_cancellation_id (0..many)→ public."BillingCancellation".billing_cancellation_id | ||
fk_domain_transfer_billing_event_id | [foreign key, with no action] | |
transfer_billing_event_id (0..many)→ public."BillingEvent".billing_event_id | ||
fk_domain_transfer_billing_recurrence_id | [foreign key, with no action] | |
transfer_billing_recurrence_id (0..many)→ public."BillingRecurrence".billing_recurrence_id | ||
fk_domain_transfer_gaining_registrar_id | [foreign key, with no action] | |
transfer_gaining_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_transfer_losing_registrar_id | [foreign key, with no action] | |
transfer_losing_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_domain_history_domain_repo_id | [foreign key, with no action] | |
repo_id ←(0..many) public."DomainHistory".domain_repo_id | ||
fkfmi7bdink53swivs390m2btxg | [foreign key, with no action] | |
repo_id ←(0..many) public."DomainHost".domain_repo_id | ||
fk_grace_period_domain_repo_id | [foreign key, with no action] | |
repo_id ←(0..many) public."GracePeriod".domain_repo_id | ||
fk_host_superordinate_domain | [foreign key, with no action] | |
repo_id ←(0..many) public."Host".superordinate_domain | ||
fk_poll_message_domain_repo_id | [foreign key, with no action] | |
repo_id ←(0..many) public."PollMessage".domain_repo_id | ||
Indexes | ||
idxsfci08jgsymxy6ovh4k7r358c | [non-unique index] | |
billing_recurrence_id | ascending | |
idxhteajcrxmq4o8rsys8kevyiqr | [non-unique index] | |
transfer_billing_cancellation_id | ascending | |
idx3y3k7m2bkgahm9sixiohgyrga | [non-unique index] | |
transfer_billing_event_id | ascending | |
idxcju58vqascbpve1t7fem53ctl | [non-unique index] | |
transfer_billing_recurrence_id | ascending | |
idxnb02m43jcx24r64n8rbg22u4q | [non-unique index] | |
admin_contact | ascending | |
idxq9gy8x2xynt9tb16yajn1gcm8 | [non-unique index] | |
billing_contact | ascending | |
idxkjt9yaq92876dstimd93hwckh | [non-unique index] | |
current_sponsor_registrar_id | ascending | |
idx1rcgkdd777bpvj0r94sltwd5y | [non-unique index] | |
domain_name | ascending | |
idxnjhib7v6fj7dhj5qydkefkl2u | [non-unique index] | |
lordn_phase | ascending | |
idxa7fu0bqynfb79rr80528b4jqt | [non-unique index] | |
registrant_contact | ascending | |
"Domain_pkey" | [unique index] | |
repo_id | ascending | |
idxr22ciyccwi9rrqmt1ro0s59qf | [non-unique index] | |
tech_contact | ascending | |
idxrwl38wwkli1j7gkvtywi9jokq | [non-unique index] | |
tld | ascending | |
idxlrq7v63pc21uoh3auq6eybyhl | [non-unique index] | |
autorenew_end_time | ascending | |
idx8nr0ke9mrrx4ewj6pd2ag4rmr | [non-unique index] | |
creation_time | ascending | |
idx5mnf0wn20tno4b9do88j61klr | [non-unique index] | |
deletion_time | ascending |
ds_data_history_revision_id | int8 not null | |
algorithm | int4 not null | |
digest | bytea not null | |
digest_type | int4 not null | |
domain_history_revision_id | int8 not null | |
key_tag | int4 not null | |
domain_repo_id | text | |
Primary Key | ||
"DomainDsDataHistory_pkey" | [primary key] | |
ds_data_history_revision_id | ||
Indexes | ||
"DomainDsDataHistory_pkey" | [unique index] | |
ds_data_history_revision_id | ascending | |
domain_history_to_ds_data_history_idx | [non-unique index] | |
domain_repo_id | ascending | |
domain_history_revision_id | ascending | |
idxmk1d2ngdtfkg6odmw7l5ejisw | [non-unique index] | |
domain_repo_id | ascending | |
domain_history_revision_id | ascending |
history_revision_id | int8 not null | |
history_by_superuser | bool not null | |
history_registrar_id | text | |
history_modification_time | timestamptz not null | |
history_reason | text | |
history_requested_by_registrar | bool | |
history_client_transaction_id | text | |
history_server_transaction_id | text | |
history_type | text not null | |
history_xml_bytes | bytea | |
admin_contact | text | |
auth_info_repo_id | text | |
auth_info_value | text | |
billing_recurrence_id | int8 | |
autorenew_poll_message_id | int8 | |
billing_contact | text | |
deletion_poll_message_id | int8 | |
domain_name | text | |
idn_table_name | text | |
last_transfer_time | timestamptz | |
launch_notice_accepted_time | timestamptz | |
launch_notice_expiration_time | timestamptz | |
launch_notice_tcn_id | text | |
launch_notice_validator_id | text | |
registrant_contact | text | |
registration_expiration_time | timestamptz | |
smd_id | text | |
subordinate_hosts | _text | |
tech_contact | text | |
tld | text | |
transfer_billing_cancellation_id | int8 | |
transfer_billing_recurrence_id | int8 | |
transfer_autorenew_poll_message_id | int8 | |
transfer_billing_event_id | int8 | |
transfer_renew_period_unit | text | |
transfer_renew_period_value | int4 | |
transfer_registration_expiration_time | timestamptz | |
transfer_poll_message_id_1 | int8 | |
transfer_poll_message_id_2 | int8 | |
transfer_client_txn_id | text | |
transfer_server_txn_id | text | |
transfer_gaining_registrar_id | text | |
transfer_losing_registrar_id | text | |
transfer_pending_expiration_time | timestamptz | |
transfer_request_time | timestamptz | |
transfer_status | text | |
creation_registrar_id | text | |
creation_time | timestamptz | |
current_sponsor_registrar_id | text | |
deletion_time | timestamptz | |
last_epp_update_registrar_id | text | |
last_epp_update_time | timestamptz | |
statuses | _text | |
update_timestamp | timestamptz | |
domain_repo_id | text not null | |
autorenew_end_time | timestamptz | |
history_other_registrar_id | text | |
history_period_unit | text | |
history_period_value | int4 | |
autorenew_poll_message_history_id | int8 | |
transfer_autorenew_poll_message_history_id | int8 | |
transfer_history_entry_id | int8 | |
transfer_repo_id | text | |
transfer_poll_message_id_3 | int8 | |
current_package_token | text | |
lordn_phase | text not null | |
default 'NONE'::text | ||
last_update_time_via_epp | timestamptz | |
Primary Key | ||
"DomainHistory_pkey" | [primary key] | |
domain_repo_id | ||
history_revision_id | ||
Foreign Keys | ||
fk_domain_history_current_package_token | [foreign key, with no action] | |
current_package_token (0..many)→ public."AllocationToken".token | ||
fk_domain_history_domain_repo_id | [foreign key, with no action] | |
domain_repo_id (0..many)→ public."Domain".repo_id | ||
fk_domain_history_registrar_id | [foreign key, with no action] | |
history_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fka9woh3hu8gx5x0vly6bai327n | [foreign key, with no action] | |
domain_repo_id ←(0..many) public."DomainHistoryHost".domain_history_domain_repo_id | ||
history_revision_id ←(0..many) public."DomainHistoryHost".domain_history_history_revision_id | ||
Indexes | ||
idxaro1omfuaxjwmotk3vo00trwm | [non-unique index] | |
history_registrar_id | ascending | |
idxsu1nam10cjes9keobapn5jvxj | [non-unique index] | |
history_type | ascending | |
idxrh4xmrot9bd63o382ow9ltfig | [non-unique index] | |
creation_time | ascending | |
idx6w3qbtgce93cal2orjg1tw7b7 | [non-unique index] | |
history_modification_time | ascending | |
"DomainHistory_pkey" | [unique index] | |
domain_repo_id | ascending | |
history_revision_id | ascending |
domain_history_history_revision_id | int8 not null | |
host_repo_id | text | |
domain_history_domain_repo_id | text not null | |
Foreign Keys | ||
fka9woh3hu8gx5x0vly6bai327n | [foreign key, with no action] | |
domain_history_domain_repo_id (0..many)→ public."DomainHistory".domain_repo_id | ||
domain_history_history_revision_id (0..many)→ public."DomainHistory".history_revision_id | ||
Indexes | ||
idx69qun5kxt3eux5igrxrqcycv0 | [non-unique index] | |
domain_history_domain_repo_id | ascending | |
ukt2e7ae3t8gcsxd13wjx2ka7ij | [unique index] | |
domain_history_history_revision_id | ascending | |
domain_history_domain_repo_id | ascending | |
host_repo_id | ascending |
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 |
id | bigserial not null | |
default nextval('"DomainTransactionRecord_id_seq"'::regclass) | ||
auto-incremented | ||
report_amount | int4 not null | |
report_field | text not null | |
reporting_time | timestamptz not null | |
tld | text not null | |
domain_repo_id | text | |
history_revision_id | int8 | |
Primary Key | ||
"DomainTransactionRecord_pkey" | [primary key] | |
id | ||
Foreign Keys | ||
fk_domain_transaction_record_tld | [foreign key, with no action] | |
tld (0..many)→ public."Tld".tld_name | ||
Indexes | ||
"DomainTransactionRecord_pkey" | [unique index] | |
id | ascending | |
domain_history_to_transaction_record_idx | [non-unique index] | |
domain_repo_id | ascending | |
history_revision_id | ascending | |
idx1dyqmqb61xbnj7mt7bk27ds25 | [non-unique index] | |
domain_repo_id | ascending | |
history_revision_id | ascending |
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 |
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 |
grace_period_history_revision_id | int8 not null | |
billing_event_id | int8 | |
billing_recurrence_id | int8 | |
registrar_id | text not null | |
domain_repo_id | text not null | |
expiration_time | timestamptz not null | |
type | text not null | |
domain_history_revision_id | int8 | |
grace_period_id | int8 not null | |
Primary Key | ||
"GracePeriodHistory_pkey" | [primary key] | |
grace_period_history_revision_id | ||
Indexes | ||
"GracePeriodHistory_pkey" | [unique index] | |
grace_period_history_revision_id | ascending | |
idxd01j17vrpjxaerxdmn8bwxs7s | [non-unique index] | |
domain_repo_id | ascending | |
idxl67y6wclc2uaupepnvkoo81fl | [non-unique index] | |
domain_repo_id | ascending | |
domain_history_revision_id | ascending |
repo_id | text not null | |
creation_registrar_id | text | |
creation_time | timestamptz | |
current_sponsor_registrar_id | text | |
deletion_time | timestamptz | |
last_epp_update_registrar_id | text | |
last_epp_update_time | timestamptz | |
statuses | _text | |
host_name | text | |
last_superordinate_change | timestamptz | |
last_transfer_time | timestamptz | |
superordinate_domain | text | |
inet_addresses | _text | |
update_timestamp | timestamptz | |
transfer_poll_message_id_3 | int8 | |
last_update_time_via_epp | timestamptz | |
Primary Key | ||
"Host_pkey" | [primary key] | |
repo_id | ||
Foreign Keys | ||
fk_domainhost_host_valid | [foreign key, with no action] | |
repo_id ←(0..many) public."DomainHost".host_repo_id | ||
fk_host_creation_registrar_id | [foreign key, with no action] | |
creation_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_host_current_sponsor_registrar_id | [foreign key, with no action] | |
current_sponsor_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_host_last_epp_update_registrar_id | [foreign key, with no action] | |
last_epp_update_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_host_superordinate_domain | [foreign key, with no action] | |
superordinate_domain (0..many)→ public."Domain".repo_id | ||
fk_hosthistory_host | [foreign key, with no action] | |
repo_id ←(0..many) public."HostHistory".host_repo_id | ||
fk_poll_message_host_repo_id | [foreign key, with no action] | |
repo_id ←(0..many) public."PollMessage".host_repo_id | ||
Indexes | ||
idxrc77s1ndiemi2vwwudchye214 | [non-unique index] | |
inet_addresses | unknown | |
idxl49vydnq0h5j1piefwjy4i8er | [non-unique index] | |
current_sponsor_registrar_id | ascending | |
idxkpkh68n6dy5v51047yr6b0e9l | [non-unique index] | |
host_name | ascending | |
"Host_pkey" | [unique index] | |
repo_id | ascending | |
idxorp4yv9ult4ds6kgxo5fs5gnw | [non-unique index] | |
superordinate_domain | ascending | |
idxy98mebut8ix1v07fjxxdkqcx | [non-unique index] | |
creation_time | ascending | |
idxovmntef6l45tw2bsfl56tcugx | [non-unique index] | |
deletion_time | ascending |
history_revision_id | int8 not null | |
history_by_superuser | bool not null | |
history_registrar_id | text not null | |
history_modification_time | timestamptz not null | |
history_reason | text | |
history_requested_by_registrar | bool | |
history_client_transaction_id | text | |
history_server_transaction_id | text | |
history_type | text not null | |
history_xml_bytes | bytea | |
host_name | text | |
inet_addresses | _text | |
last_superordinate_change | timestamptz | |
last_transfer_time | timestamptz | |
superordinate_domain | text | |
creation_registrar_id | text | |
creation_time | timestamptz | |
current_sponsor_registrar_id | text | |
deletion_time | timestamptz | |
last_epp_update_registrar_id | text | |
last_epp_update_time | timestamptz | |
statuses | _text | |
host_repo_id | text not null | |
update_timestamp | timestamptz | |
transfer_poll_message_id_3 | int8 | |
last_update_time_via_epp | timestamptz | |
Primary Key | ||
"HostHistory_pkey" | [primary key] | |
host_repo_id | ||
history_revision_id | ||
Foreign Keys | ||
fk_history_registrar_id | [foreign key, with no action] | |
history_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_hosthistory_host | [foreign key, with no action] | |
host_repo_id (0..many)→ public."Host".repo_id | ||
fk_poll_message_host_history | [foreign key, with no action] | |
host_repo_id ←(0..many) public."PollMessage".host_repo_id | ||
history_revision_id ←(0..many) public."PollMessage".host_history_revision_id | ||
Indexes | ||
idx1iy7njgb7wjmj9piml4l2g0qi | [non-unique index] | |
history_registrar_id | ascending | |
idxknk8gmj7s47q56cwpa6rmpt5l | [non-unique index] | |
history_type | ascending | |
idxj77pfwhui9f0i7wjq6lmibovj | [non-unique index] | |
host_name | ascending | |
idxfg2nnjlujxo6cb9fha971bq2n | [non-unique index] | |
creation_time | ascending | |
idx67qwkjtlq5q8dv6egtrtnhqi7 | [non-unique index] | |
history_modification_time | ascending | |
"HostHistory_pkey" | [unique index] | |
host_repo_id | ascending | |
history_revision_id | ascending |
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 |
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 |
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 |
type | text not null | |
poll_message_id | int8 not null | |
registrar_id | text not null | |
contact_repo_id | text | |
contact_history_revision_id | int8 | |
domain_repo_id | text | |
domain_history_revision_id | int8 | |
event_time | timestamptz not null | |
host_repo_id | text | |
host_history_revision_id | int8 | |
message | text | |
transfer_response_contact_id | text | |
transfer_response_domain_expiration_time | timestamptz | |
transfer_response_domain_name | text | |
pending_action_response_action_result | bool | |
pending_action_response_name_or_id | text | |
pending_action_response_processed_date | timestamptz | |
pending_action_response_client_txn_id | text | |
pending_action_response_server_txn_id | text | |
transfer_response_gaining_registrar_id | text | |
transfer_response_losing_registrar_id | text | |
transfer_response_pending_transfer_expiration_time | timestamptz | |
transfer_response_transfer_request_time | timestamptz | |
transfer_response_transfer_status | text | |
autorenew_end_time | timestamptz | |
autorenew_domain_name | text | |
transfer_response_host_id | text | |
Primary Key | ||
"PollMessage_pkey" | [primary key] | |
poll_message_id | ||
Foreign Keys | ||
fk_poll_message_contact_repo_id | [foreign key, with no action] | |
contact_repo_id (0..many)→ public."Contact".repo_id | ||
fk_poll_message_domain_repo_id | [foreign key, with no action] | |
domain_repo_id (0..many)→ public."Domain".repo_id | ||
fk_poll_message_host_repo_id | [foreign key, with no action] | |
host_repo_id (0..many)→ public."Host".repo_id | ||
fk_poll_message_registrar_id | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_poll_message_transfer_response_gaining_registrar_id | [foreign key, with no action] | |
transfer_response_gaining_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_poll_message_transfer_response_losing_registrar_id | [foreign key, with no action] | |
transfer_response_losing_registrar_id (0..many)→ public."Registrar".registrar_id | ||
fk_poll_message_contact_history | [foreign key, with no action] | |
contact_repo_id (0..many)→ public."ContactHistory".contact_repo_id | ||
contact_history_revision_id (0..many)→ public."ContactHistory".history_revision_id | ||
fk_poll_message_host_history | [foreign key, with no action] | |
host_repo_id (0..many)→ public."HostHistory".host_repo_id | ||
host_history_revision_id (0..many)→ public."HostHistory".history_revision_id | ||
Indexes | ||
"PollMessage_pkey" | [unique index] | |
poll_message_id | ascending | |
idxf2q9dqj899h1q8lah5y719nxd | [non-unique index] | |
domain_repo_id | ascending | |
idxe7wu46c7wpvfmfnj4565abibp | [non-unique index] | |
registrar_id | ascending | |
idxaydgox62uno9qx8cjlj5lauye | [non-unique index] | |
event_time | ascending | |
idxnuyqo6hrtuvbcmuecf7vkfmle | [non-unique index] | |
domain_repo_id | ascending | |
domain_history_revision_id | ascending |
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 |
revision_id | bigserial not null | |
default nextval('"PremiumList_revision_id_seq"'::regclass) | ||
auto-incremented | ||
creation_timestamp | timestamptz | |
name | text not null | |
bloom_filter | bytea not null | |
currency | text not null | |
Primary Key | ||
"PremiumList_pkey" | [primary key] | |
revision_id | ||
Foreign Keys | ||
fko0gw90lpo1tuee56l0nb6y6g5 | [foreign key, with no action] | |
revision_id ←(0..many) public."PremiumEntry".revision_id | ||
Indexes | ||
"PremiumList_pkey" | [unique index] | |
revision_id | ascending | |
premiumlist_name_idx | [non-unique index] | |
name | ascending |
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 |
registrar_id | text not null | |
allowed_tlds | _text | |
billing_account_map | hstore | |
block_premium_names | bool not null | |
client_certificate | text | |
client_certificate_hash | text | |
contacts_require_syncing | bool not null | |
creation_time | timestamptz not null | |
drive_folder_id | text | |
email_address | text | |
failover_client_certificate | text | |
failover_client_certificate_hash | text | |
fax_number | text | |
iana_identifier | int8 | |
icann_referral_email | text | |
i18n_address_city | text | |
i18n_address_country_code | text | |
i18n_address_state | text | |
i18n_address_street_line1 | text | |
i18n_address_street_line2 | text | |
i18n_address_street_line3 | text | |
i18n_address_zip | text | |
ip_address_allow_list | _text | |
last_certificate_update_time | timestamptz | |
last_update_time | timestamptz not null | |
localized_address_city | text | |
localized_address_country_code | text | |
localized_address_state | text | |
localized_address_street_line1 | text | |
localized_address_street_line2 | text | |
localized_address_street_line3 | text | |
localized_address_zip | text | |
password_hash | text | |
phone_number | text | |
phone_passcode | text | |
po_number | text | |
rdap_base_urls | _text | |
registrar_name | text not null | |
registry_lock_allowed | bool not null | |
password_salt | text | |
state | text | |
type | text not null | |
url | text | |
whois_server | text | |
last_expiring_cert_notification_sent_date | timestamptz | |
last_expiring_failover_cert_notification_sent_date | timestamptz | |
last_poc_verification_date | timestamptz | |
Primary Key | ||
"Registrar_pkey" | [primary key] | |
registrar_id | ||
Foreign Keys | ||
fk_billing_cancellation_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."BillingCancellation".registrar_id | ||
fk_billing_event_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."BillingEvent".registrar_id | ||
fk_billing_recurrence_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."BillingRecurrence".registrar_id | ||
fk1sfyj7o7954prbn1exk7lpnoe | [foreign key, with no action] | |
registrar_id ←(0..many) public."Contact".creation_registrar_id | ||
fk93c185fx7chn68uv7nl6uv2s0 | [foreign key, with no action] | |
registrar_id ←(0..many) public."Contact".current_sponsor_registrar_id | ||
fkmb7tdiv85863134w1wogtxrb2 | [foreign key, with no action] | |
registrar_id ←(0..many) public."Contact".last_epp_update_registrar_id | ||
fk_contact_transfer_gaining_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."Contact".transfer_gaining_registrar_id | ||
fk_contact_transfer_losing_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."Contact".transfer_losing_registrar_id | ||
fk_contact_history_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."ContactHistory".history_registrar_id | ||
fk2jc69qyg2tv9hhnmif6oa1cx1 | [foreign key, with no action] | |
registrar_id ←(0..many) public."Domain".creation_registrar_id | ||
fk2u3srsfbei272093m3b3xwj23 | [foreign key, with no action] | |
registrar_id ←(0..many) public."Domain".current_sponsor_registrar_id | ||
fkjc0r9r5y1lfbt4gpbqw4wsuvq | [foreign key, with no action] | |
registrar_id ←(0..many) public."Domain".last_epp_update_registrar_id | ||
fk_domain_transfer_gaining_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."Domain".transfer_gaining_registrar_id | ||
fk_domain_transfer_losing_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."Domain".transfer_losing_registrar_id | ||
fk_domain_history_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."DomainHistory".history_registrar_id | ||
fk_grace_period_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."GracePeriod".registrar_id | ||
fk_host_creation_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."Host".creation_registrar_id | ||
fk_host_current_sponsor_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."Host".current_sponsor_registrar_id | ||
fk_host_last_epp_update_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."Host".last_epp_update_registrar_id | ||
fk_history_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."HostHistory".history_registrar_id | ||
fk_poll_message_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."PollMessage".registrar_id | ||
fk_poll_message_transfer_response_gaining_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."PollMessage".transfer_response_gaining_registrar_id | ||
fk_poll_message_transfer_response_losing_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."PollMessage".transfer_response_losing_registrar_id | ||
fk_registrar_poc_registrar_id | [foreign key, with no action] | |
registrar_id ←(0..many) public."RegistrarPoc".registrar_id | ||
fkregistrarupdatehistoryregistrarid | [foreign key, with no action] | |
registrar_id ←(0..many) public."RegistrarUpdateHistory".registrar_id | ||
Indexes | ||
registrar_iana_identifier_idx | [non-unique index] | |
iana_identifier | ascending | |
"Registrar_pkey" | [unique index] | |
registrar_id | ascending | |
registrar_name_idx | [non-unique index] | |
registrar_name | ascending |
email_address | text not null | |
allowed_to_set_registry_lock_password | bool not null | |
fax_number | text | |
name | text | |
phone_number | text | |
registry_lock_password_hash | text | |
registry_lock_password_salt | text | |
types | _text | |
visible_in_domain_whois_as_abuse | bool not null | |
visible_in_whois_as_admin | bool not null | |
visible_in_whois_as_tech | bool not null | |
registry_lock_email_address | text | |
registrar_id | text not null | |
id | bigserial not null | |
default nextval('"RegistrarPoc_id_seq"'::regclass) | ||
auto-incremented | ||
Primary Key | ||
"RegistrarPoc_pkey" | [primary key] | |
registrar_id | ||
email_address | ||
Foreign Keys | ||
fk_registrar_poc_registrar_id | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_id | ||
fkregistrarpocupdatehistoryemailaddress | [foreign key, with no action] | |
email_address ←(0..many) public."RegistrarPocUpdateHistory".email_address | ||
registrar_id ←(0..many) public."RegistrarPocUpdateHistory".registrar_id | ||
Indexes | ||
"RegistrarPoc_pkey" | [unique index] | |
registrar_id | ascending | |
email_address | ascending |
history_revision_id | int8 not null | |
history_modification_time | timestamptz not null | |
history_method | text not null | |
history_request_body | text | |
history_type | text not null | |
history_url | text not null | |
email_address | text not null | |
registrar_id | text not null | |
allowed_to_set_registry_lock_password | bool not null | |
fax_number | text | |
login_email_address | text | |
name | text | |
phone_number | text | |
registry_lock_email_address | text | |
registry_lock_password_hash | text | |
registry_lock_password_salt | text | |
types | _text | |
visible_in_domain_whois_as_abuse | bool not null | |
visible_in_whois_as_admin | bool not null | |
visible_in_whois_as_tech | bool not null | |
history_acting_user | text not null | |
Primary Key | ||
"RegistrarPocUpdateHistory_pkey" | [primary key] | |
history_revision_id | ||
Foreign Keys | ||
fkregistrarpocupdatehistoryemailaddress | [foreign key, with no action] | |
email_address (0..many)→ public."RegistrarPoc".email_address | ||
registrar_id (0..many)→ public."RegistrarPoc".registrar_id | ||
Indexes | ||
"RegistrarPocUpdateHistory_pkey" | [unique index] | |
history_revision_id | ascending | |
idxr1cxua6it0rxgt9tpyugspxk | [non-unique index] | |
email_address | ascending | |
idxrn6posxkx58de1cp09g5257cw | [non-unique index] | |
history_acting_user | ascending | |
idxfr24wvpg8qalwqy4pni7evrpj | [non-unique index] | |
registrar_id | ascending |
history_revision_id | int8 not null | |
history_modification_time | timestamptz not null | |
history_method | text not null | |
history_request_body | text | |
history_type | text not null | |
history_url | text not null | |
allowed_tlds | _text | |
billing_account_map | hstore | |
block_premium_names | bool not null | |
client_certificate | text | |
client_certificate_hash | text | |
contacts_require_syncing | bool not null | |
creation_time | timestamptz not null | |
drive_folder_id | text | |
email_address | text | |
failover_client_certificate | text | |
failover_client_certificate_hash | text | |
fax_number | text | |
iana_identifier | int8 | |
icann_referral_email | text | |
i18n_address_city | text | |
i18n_address_country_code | text | |
i18n_address_state | text | |
i18n_address_street_line1 | text | |
i18n_address_street_line2 | text | |
i18n_address_street_line3 | text | |
i18n_address_zip | text | |
ip_address_allow_list | _text | |
last_certificate_update_time | timestamptz | |
last_expiring_cert_notification_sent_date | timestamptz | |
last_expiring_failover_cert_notification_sent_date | timestamptz | |
localized_address_city | text | |
localized_address_country_code | text | |
localized_address_state | text | |
localized_address_street_line1 | text | |
localized_address_street_line2 | text | |
localized_address_street_line3 | text | |
localized_address_zip | text | |
password_hash | text | |
phone_number | text | |
phone_passcode | text | |
po_number | text | |
rdap_base_urls | _text | |
registrar_name | text not null | |
registry_lock_allowed | bool not null | |
password_salt | text | |
state | text | |
type | text not null | |
url | text | |
whois_server | text | |
update_timestamp | timestamptz | |
registrar_id | text not null | |
history_acting_user | text not null | |
Primary Key | ||
"RegistrarUpdateHistory_pkey" | [primary key] | |
history_revision_id | ||
Foreign Keys | ||
fkregistrarupdatehistoryregistrarid | [foreign key, with no action] | |
registrar_id (0..many)→ public."Registrar".registrar_id | ||
Indexes | ||
"RegistrarUpdateHistory_pkey" | [unique index] | |
history_revision_id | ascending | |
idxm6k18dusy2lfi5y81k8g256sa | [non-unique index] | |
history_acting_user | ascending | |
idx3d1mucv7axrhud8w8jl4vsu62 | [non-unique index] | |
registrar_id | ascending |
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 |
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 |
revision_id | bigserial not null | |
default nextval('"ReservedList_revision_id_seq"'::regclass) | ||
auto-incremented | ||
creation_timestamp | timestamptz not null | |
name | text not null | |
Primary Key | ||
"ReservedList_pkey" | [primary key] | |
revision_id | ||
Foreign Keys | ||
fkgq03rk0bt1hb915dnyvd3vnfc | [foreign key, with no action] | |
revision_id ←(0..many) public."ReservedEntry".revision_id | ||
Indexes | ||
"ReservedList_pkey" | [unique index] | |
revision_id | ascending | |
reservedlist_name_idx | [non-unique index] | |
name | ascending |
secret | uuid not null | |
id | int8 not null | |
default 1 | ||
Primary Key | ||
"ServerSecret_pkey" | [primary key] | |
id | ||
Indexes | ||
"ServerSecret_pkey" | [unique index] | |
id | ascending |
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 |
revision_id | bigserial not null | |
default nextval('"SignedMarkRevocationList_revision_id_seq"'::regclass) | ||
auto-incremented | ||
creation_time | timestamptz | |
Primary Key | ||
"SignedMarkRevocationList_pkey" | [primary key] | |
revision_id | ||
Foreign Keys | ||
fk5ivlhvs3121yx2li5tqh54u4 | [foreign key, with no action] | |
revision_id ←(0..many) public."SignedMarkRevocationEntry".revision_id | ||
Indexes | ||
"SignedMarkRevocationList_pkey" | [unique index] | |
revision_id | ascending |
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 |
tld_name | text not null | |
add_grace_period_length | interval not null | |
allowed_fully_qualified_host_names | _text | |
allowed_registrant_contact_ids | _text | |
anchor_tenant_add_grace_period_length | interval not null | |
auto_renew_grace_period_length | interval not null | |
automatic_transfer_length | interval not null | |
claims_period_end | timestamptz not null | |
creation_time | timestamptz not null | |
currency | text not null | |
dns_paused | bool not null | |
dns_writers | _text not null | |
drive_folder_id | text | |
eap_fee_schedule | hstore not null | |
escrow_enabled | bool not null | |
invoicing_enabled | bool not null | |
lordn_username | text | |
num_dns_publish_locks | int4 not null | |
pending_delete_length | interval not null | |
premium_list_name | text | |
pricing_engine_class_name | text | |
redemption_grace_period_length | interval not null | |
registry_lock_or_unlock_cost_amount | numeric(19, 2) | |
registry_lock_or_unlock_cost_currency | text | |
renew_billing_cost_transitions | hstore not null | |
renew_grace_period_length | interval not null | |
reserved_list_names | _text | |
restore_billing_cost_amount | numeric(19, 2) | |
restore_billing_cost_currency | text | |
roid_suffix | text | |
server_status_change_billing_cost_amount | numeric(19, 2) | |
server_status_change_billing_cost_currency | text | |
tld_state_transitions | hstore not null | |
tld_type | text not null | |
tld_unicode | text not null | |
transfer_grace_period_length | interval not null | |
default_promo_tokens | _text | |
dns_a_plus_aaaa_ttl | interval | |
dns_ds_ttl | interval | |
dns_ns_ttl | interval | |
idn_tables | _text | |
breakglass_mode | bool not null | |
default false | ||
bsa_enroll_start_time | timestamptz | |
create_billing_cost_transitions | hstore not null | |
Primary Key | ||
"Tld_pkey" | [primary key] | |
tld_name | ||
Foreign Keys | ||
fk_domain_tld | [foreign key, with no action] | |
tld_name ←(0..many) public."Domain".tld | ||
fk_domain_transaction_record_tld | [foreign key, with no action] | |
tld_name ←(0..many) public."DomainTransactionRecord".tld | ||
Indexes | ||
"Tld_pkey" | [unique index] | |
tld_name | ascending |
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 |
email_address | text not null | |
registry_lock_password_hash | text | |
registry_lock_password_salt | text | |
global_role | text not null | |
is_admin | bool not null | |
registrar_roles | hstore not null | |
update_timestamp | timestamptz | |
registry_lock_email_address | text | |
Primary Key | ||
"User_pkey" | [primary key] | |
email_address | ||
Foreign Keys | ||
fk_console_update_history_acting_user | [foreign key, with no action] | |
email_address ←(0..many) public."ConsoleUpdateHistory".acting_user | ||
Indexes | ||
"User_pkey" | [unique index] | |
email_address | ascending | |
user_unique_email | [unique index] | |
email_address | ascending |
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 |