epp
Tables (27)
contact
- id — int(10) — Primary key — NOT NULL
- identifier — varchar(255) — NOT NULL
- voice — varchar(17)
- voice_x — int(10)
- fax — varchar(17)
- fax_x — int(10)
- email — varchar(255) — NOT NULL
- nin — varchar(255)
- nin_type — enum('personal','business')
- clid — int(10) — Foreign key → registrar.id — NOT NULL
- crid — int(10) — Foreign key → registrar.id — NOT NULL
- crdate — datetime — NOT NULL
- upid — int(10) — Foreign key → registrar.id
- update — datetime
- trdate — datetime
- trstatus — enum('clientApproved','clientCancelled','clientRejected','pending','serverApproved','serverCancelled')
- reid — int(10)
- redate — datetime
- acid — int(10)
- acdate — datetime
- disclose_voice — enum('0','1') — NOT NULL
- disclose_fax — enum('0','1') — NOT NULL
- disclose_email — enum('0','1') — NOT NULL
contact_authInfo
- id — int(10) — Primary key — NOT NULL
- contact_id — int(10) — Foreign key → contact.id — NOT NULL
- authtype — enum('pw','ext') — NOT NULL
- authinfo — varchar(64) — NOT NULL
contact_auto_approve_transfer
- id — int(10) — Primary key — NOT NULL
- identifier — varchar(255) — NOT NULL
- voice — varchar(17)
- voice_x — int(10)
- fax — varchar(17)
- fax_x — int(10)
- email — varchar(255) — NOT NULL
- nin — varchar(255)
- nin_type — enum('personal','business')
- clid — int(10) — NOT NULL
- crid — int(10) — NOT NULL
- crdate — datetime — NOT NULL
- upid — int(10)
- update — datetime
- trdate — datetime
- trstatus — enum('clientApproved','clientCancelled','clientRejected','pending','serverApproved','serverCancelled')
- reid — int(10)
- redate — datetime
- acid — int(10)
- acdate — datetime
- disclose_voice — enum('0','1') — NOT NULL
- disclose_fax — enum('0','1') — NOT NULL
- disclose_email — enum('0','1') — NOT NULL
contact_postalInfo
- id — int(10) — Primary key — NOT NULL
- contact_id — int(10) — Foreign key → contact.id — NOT NULL
- type — enum('int','loc') — NOT NULL
- name — varchar(255) — NOT NULL
- org — varchar(255)
- street1 — varchar(255)
- street2 — varchar(255)
- street3 — varchar(255)
- city — varchar(255) — NOT NULL
- sp — varchar(255)
- pc — varchar(16)
- cc — char(2) — NOT NULL
- disclose_name_int — enum('0','1') — NOT NULL
- disclose_name_loc — enum('0','1') — NOT NULL
- disclose_org_int — enum('0','1') — NOT NULL
- disclose_org_loc — enum('0','1') — NOT NULL
- disclose_addr_int — enum('0','1') — NOT NULL
- disclose_addr_loc — enum('0','1') — NOT NULL
contact_status
- id — int(10) — Primary key — NOT NULL
- contact_id — int(10) — Foreign key → contact.id — NOT NULL
- status — enum('clientDeleteProhibited','clientTransferProhibited','clientUpdateProhibited','linked','ok','pendingCreate','pendingDelete','pendingTransfer','pendingUpdate','serverDeleteProhibited','serverTransferProhibited','serverUpdateProhibited') — NOT NULL
domain
- id — int(10) — Primary key — NOT NULL
- name — varchar(68) — NOT NULL
- tldid — int(10) — Foreign key → domain_tld.id — NOT NULL
- registrant — int(10) — Foreign key → contact.id
- crdate — datetime — NOT NULL
- exdate — datetime — NOT NULL
- update — datetime
- clid — int(10) — Foreign key → registrar.id — NOT NULL
- crid — int(10) — Foreign key → registrar.id — NOT NULL
- upid — int(10) — Foreign key → registrar.id
- trdate — datetime
- trstatus — enum('clientApproved','clientCancelled','clientRejected','pending','serverApproved','serverCancelled')
- reid — int(10) — Foreign key → registrar.id
- redate — datetime
- acid — int(10) — Foreign key → registrar.id
- acdate — datetime
- transfer_exdate — datetime
- idnlang — varchar(16)
- delTime — datetime
- resTime — datetime
- rgpstatus — enum('addPeriod','autoRenewPeriod','renewPeriod','transferPeriod','pendingDelete','pendingRestore','redemptionPeriod')
- rgppostData — text
- rgpdelTime — datetime
- rgpresTime — datetime
- rgpresReason — text
- rgpstatement1 — text
- rgpstatement2 — text
- rgpother — text
- addPeriod — tinyint(3)
- autoRenewPeriod — tinyint(3)
- renewPeriod — tinyint(3)
- transferPeriod — tinyint(3)
- renewedDate — datetime
domain_authInfo
- id — int(10) — Primary key — NOT NULL
- domain_id — int(10) — Foreign key → domain.id — NOT NULL
- authtype — enum('pw','ext') — NOT NULL
- authinfo — varchar(64) — NOT NULL
domain_auto_approve_transfer
- id — int(10) — Primary key — NOT NULL
- name — varchar(68) — NOT NULL
- registrant — int(10)
- crdate — datetime — NOT NULL
- exdate — datetime — NOT NULL
- update — datetime
- clid — int(10) — NOT NULL
- crid — int(10) — NOT NULL
- upid — int(10)
- trdate — datetime
- trstatus — enum('clientApproved','clientCancelled','clientRejected','pending','serverApproved','serverCancelled')
- reid — int(10)
- redate — datetime
- acid — int(10)
- acdate — datetime
- transfer_exdate — datetime
domain_contact_map
- id — int(10) — Primary key — NOT NULL
- domain_id — int(10) — Foreign key → domain.id — NOT NULL
- contact_id — int(10) — Foreign key → contact.id — NOT NULL
- type — enum('admin','billing','tech') — NOT NULL
domain_host_map
- id — int(10) — Primary key — NOT NULL
- domain_id — int(10) — Foreign key → domain.id — NOT NULL
- host_id — int(10) — Foreign key → host.id — NOT NULL
domain_price
- id — int(10) — Primary key — NOT NULL
- tldid — int(10) — Foreign key → domain_tld.id — NOT NULL
- command — enum('create','renew','transfer') — NOT NULL
- m0 — decimal(10,2) — NOT NULL
- m12 — decimal(10,2) — NOT NULL
- m24 — decimal(10,2) — NOT NULL
- m36 — decimal(10,2) — NOT NULL
- m48 — decimal(10,2) — NOT NULL
- m60 — decimal(10,2) — NOT NULL
- m72 — decimal(10,2) — NOT NULL
- m84 — decimal(10,2) — NOT NULL
- m96 — decimal(10,2) — NOT NULL
- m108 — decimal(10,2) — NOT NULL
- m120 — decimal(10,2) — NOT NULL
domain_restore_price
- id — int(10) — Primary key — NOT NULL
- tldid — int(10) — Foreign key → domain_tld.id — NOT NULL
- price — decimal(10,2) — NOT NULL
domain_status
- id — int(10) — Primary key — NOT NULL
- domain_id — int(10) — Foreign key → domain.id — NOT NULL
- status — enum('clientDeleteProhibited','clientHold','clientRenewProhibited','clientTransferProhibited','clientUpdateProhibited','inactive','ok','pendingCreate','pendingDelete','pendingRenew','pendingTransfer','pendingUpdate','serverDeleteProhibited','serverHold','serverRenewProhibited','serverTransferProhibited','serverUpdateProhibited') — NOT NULL
domain_tld
- id — int(10) — Primary key — NOT NULL
- tld — varchar(32) — NOT NULL
host
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- domain_id — int(10) — Foreign key → domain.id
- clid — int(10) — Foreign key → registrar.id — NOT NULL
- crid — int(10) — Foreign key → registrar.id — NOT NULL
- crdate — datetime — NOT NULL
- upid — int(10) — Foreign key → registrar.id
- update — datetime
- trdate — datetime
host_addr
- id — int(10) — Primary key — NOT NULL
- host_id — int(10) — Foreign key → host.id — NOT NULL
- addr — varchar(45) — NOT NULL
- ip — enum('v4','v6') — NOT NULL
host_status
- id — int(10) — Primary key — NOT NULL
- host_id — int(10) — Foreign key → host.id — NOT NULL
- status — enum('clientDeleteProhibited','clientUpdateProhibited','linked','ok','pendingCreate','pendingDelete','pendingTransfer','pendingUpdate','serverDeleteProhibited','serverUpdateProhibited') — NOT NULL
payment_history
- id — int(10) — Primary key — NOT NULL
- registrar_id — int(10) — Foreign key → registrar.id — NOT NULL
- date — datetime — NOT NULL
- description — text — NOT NULL
- amount — decimal(8,2) — NOT NULL
poll
- id — int(10) — Primary key — NOT NULL
- registrar_id — int(10) — Foreign key → registrar.id — NOT NULL
- qdate — datetime — NOT NULL
- msg — text
- msg_type — enum('lowBalance','domainTransfer','contactTransfer')
- obj_name_or_id — varchar(68)
- obj_trStatus — enum('clientApproved','clientCancelled','clientRejected','pending','serverApproved','serverCancelled')
- obj_reID — varchar(255)
- obj_reDate — datetime
- obj_acID — varchar(255)
- obj_acDate — datetime
- obj_exDate — datetime
- registrarName — varchar(255)
- creditLimit — decimal(8,2)
- creditThreshold — decimal(8,2)
- creditThresholdType — enum('FIXED','PERCENT')
- availableCredit — decimal(8,2)
registrar
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- clid — varchar(16) — NOT NULL
- pw — varchar(64) — NOT NULL
- prefix — char(2) — NOT NULL
- email — varchar(255) — NOT NULL
- whois_server — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- abuse_email — varchar(255) — NOT NULL
- abuse_phone — varchar(255) — NOT NULL
- accountBalance — decimal(8,2) — NOT NULL
- creditLimit — decimal(8,2) — NOT NULL
- creditThreshold — decimal(8,2) — NOT NULL
- thresholdType — enum('fixed','percent') — NOT NULL
- crdate — datetime — NOT NULL
- update — TIMESTAMP
registrar_contact
- id — int(10) — Primary key — NOT NULL
- registrar_id — int(10) — Foreign key → registrar.id — NOT NULL
- type — enum('owner','admin','billing','tech') — NOT NULL
- title — varchar(255) — NOT NULL
- first_name — varchar(255) — NOT NULL
- middle_name — varchar(255) — NOT NULL
- last_name — varchar(255) — NOT NULL
- org — varchar(255)
- street1 — varchar(255)
- street2 — varchar(255)
- street3 — varchar(255)
- city — varchar(255) — NOT NULL
- sp — varchar(255)
- pc — varchar(16)
- cc — char(2) — NOT NULL
- voice — varchar(17)
- fax — varchar(17)
- email — varchar(255) — NOT NULL
registrar_whitelist
- id — int(10) — Primary key — NOT NULL
- registrar_id — int(10) — Foreign key → registrar.id — NOT NULL
- addr — varchar(45) — NOT NULL
reserved_domain_names
- id — int(10) — Primary key — NOT NULL
- name — varchar(68) — NOT NULL
- type — enum('reserved','restricted') — NOT NULL
secdns
- id — int(10) — Primary key — NOT NULL
- domain_id — int(10) — Foreign key → domain.id — NOT NULL
- maxsiglife — int(10)
- interface — enum('dsData','keyData') — NOT NULL
- keytag — smallint(5) — NOT NULL
- alg — tinyint(3) — NOT NULL
- digesttype — tinyint(3) — NOT NULL
- digest — varchar(64) — NOT NULL
- flags — smallint(5)
- protocol — smallint(5)
- keydata_alg — tinyint(3)
- pubkey — varchar(255)
statement
- id — int(10) — Primary key — NOT NULL
- registrar_id — int(10) — Foreign key → registrar.id — NOT NULL
- date — datetime — NOT NULL
- command — enum('create','renew','transfer','restore','autoRenew') — NOT NULL
- domain_name — varchar(68) — NOT NULL
- length_in_months — tinyint(3) — NOT NULL
- from — datetime — NOT NULL
- to — datetime — NOT NULL
- amount — decimal(8,2) — NOT NULL
statistics
- id — int(10) — Primary key — NOT NULL
- date — date — NOT NULL
- total_domains — int(10) — NOT NULL
- created_domains — int(10) — NOT NULL
- renewed_domains — int(10) — NOT NULL
- transfered_domains — int(10) — NOT NULL
- deleted_domains — int(10) — NOT NULL
- restored_domains — int(10) — NOT NULL
transaction_identifier
- id — bigint(20) — Primary key — NOT NULL
- registrar_id — int(10) — Foreign key → registrar.id — NOT NULL
- clTRID — varchar(64)
- clTRIDframe — text
- cldate — datetime
- clmicrosecond — int(6)
- cmd — enum('login','logout','check','info','poll','transfer','create','delete','renew','update')
- obj_type — enum('domain','host','contact')
- obj_id — text
- code — smallint(4)
- msg — varchar(255)
- svTRID — varchar(64)
- svTRIDframe — text
- svdate — datetime
- svmicrosecond — int(6)