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)