dev1
Tables (17)
activity
- pid — int — NOT NULL
- client_roid — varchar(89) — NOT NULL
client
- roid — varchar(89)
- clid — varchar(16) — NOT NULL
- pw — varchar(32) — NOT NULL
- administrator — bool — NOT NULL
- customer_service — bool — NOT NULL
- zone_build — bool — NOT NULL
- registrar — bool — NOT NULL
- name — varchar(254)
- email — varchar(254)
- address — text
- country — char(2) — NOT NULL
- language — char(2) — NOT NULL
- timezone — varchar(63) — NOT NULL
- search_results — int — NOT NULL
- phone — varchar(32)
- fax — varchar(32)
- admin_contact — varchar(254)
- admin_email — varchar(254)
- billing_contact — varchar(254)
- billing_email — varchar(254)
- tech_contact — varchar(254)
- tech_email — varchar(254)
- service_contact — varchar(254)
- service_email — varchar(254)
- registration_url — varchar(1023)
- primary_focus — varchar(64)
- currency — char(3) — NOT NULL
- tax — numeric(8,2) — NOT NULL
- tax_label — varchar(32)
- createdate — timestamp — NOT NULL
- updatedate — timestamp
configuration
- jclass — varchar(64) — NOT NULL
- name — varchar(64) — NOT NULL
- value — text
contact
- roid — varchar(89)
- id — varchar(16) — NOT NULL
- st_cl_deleteprohibited — varchar(1024)
- st_cl_transferprohibited — varchar(1024)
- st_cl_updateprohibited — varchar(1024)
- st_linked — varchar(1024)
- st_ok — varchar(1024)
- st_pendingcreate — varchar(1024)
- st_pendingdelete — varchar(1024)
- st_pendingtransfer — varchar(1024)
- st_pendingupdate — varchar(1024)
- st_sv_deleteprohibited — varchar(1024)
- st_sv_transferprohibited — varchar(1024)
- st_sv_updateprohibited — varchar(1024)
- intpostalname — varchar(255)
- intpostalorg — varchar(255)
- intpostalstreet1 — varchar(255)
- intpostalstreet2 — varchar(255)
- intpostalstreet3 — varchar(255)
- intpostalcity — varchar(255)
- intpostalsp — varchar(255)
- intpostalpc — varchar(255)
- intpostalcc — varchar(255)
- locpostalname — varchar(255)
- locpostalorg — varchar(255)
- locpostalstreet1 — varchar(255)
- locpostalstreet2 — varchar(255)
- locpostalstreet3 — varchar(255)
- locpostalcity — varchar(255)
- locpostalsp — varchar(255)
- locpostalpc — varchar(255)
- locpostalcc — varchar(255)
- voice — varchar(64)
- voicex — varchar(64)
- fax — varchar(64)
- faxx — varchar(64)
- email — varchar(2048)
- authinfopw — varchar(16)
- discloseintname — bool
- discloselocname — bool
- discloseintorg — bool
- discloselocorg — bool
- discloseintaddr — bool
- discloselocaddr — bool
- disclosevoice — bool
- disclosefax — bool
- discloseemail — bool
- clid — varchar(16) — NOT NULL
- crid — varchar(16) — NOT NULL
- createdate — timestamp — NOT NULL
- upid — varchar(16)
- updatedate — timestamp
- transferdate — timestamp
credit_limit
- client_clid — varchar(16) — Primary key — NOT NULL
- tld — varchar(64) — Primary key — NOT NULL
- credit_limit — numeric(17,2) — NOT NULL
credit_transaction
- id — SERIAL
- client_roid — varchar(89) — NOT NULL
- currency — char(3) — NOT NULL
- total — numeric(8,2) — NOT NULL
- card_type — varchar(32)
- card_number — varchar(32) — NOT NULL
- card_expiry — varchar(8) — NOT NULL
- card_cvc — varchar(4)
- card_address — text
- request_ip — varchar(16)
- processor — varchar(64)
- status — varchar(16)
- processor_ref — varchar(64)
- authorisation — varchar(64)
- authorised — timestamp
- created — timestamp — NOT NULL
domain
- roid — varchar(89)
- name — varchar(255) — NOT NULL
- zone — varchar(64) — NOT NULL
- exdate — timestamp — NOT NULL
- st_cl_deleteprohibited — varchar(1024)
- st_cl_hold — varchar(1024)
- st_cl_renewprohibited — varchar(1024)
- st_cl_transferprohibited — varchar(1024)
- st_cl_updateprohibited — varchar(1024)
- st_inactive — varchar(1024)
- st_ok — varchar(1024)
- st_pendingcreate — varchar(1024)
- st_pendingdelete — varchar(1024)
- st_pendingrenew — varchar(1024)
- st_pendingtransfer — varchar(1024)
- st_pendingupdate — varchar(1024)
- st_sv_deleteprohibited — varchar(1024)
- st_sv_hold — varchar(1024)
- st_sv_renewprohibited — varchar(1024)
- st_sv_transferprohibited — varchar(1024)
- st_sv_updateprohibited — varchar(1024)
- registrant — varchar(16)
- authinfopw — varchar(16)
- clid — varchar(16) — NOT NULL
- crid — varchar(16) — NOT NULL
- createdate — timestamp — NOT NULL
- upid — varchar(16)
- updatedate — timestamp
- transferdate — timestamp
domain_contact
- domain_name — varchar(255) — Primary key — NOT NULL
- contact_id — varchar(255) — Primary key — NOT NULL
- type — varchar(16) — Primary key — NOT NULL
domain_host
- domain_name — varchar(255) — Primary key — NOT NULL
- host_name — varchar(255) — Primary key — NOT NULL
- sort_order — int
host
- roid — varchar(89)
- name — varchar(255) — NOT NULL
- st_cl_deleteprohibited — varchar(1024)
- st_cl_updateprohibited — varchar(1024)
- st_linked — varchar(1024)
- st_ok — varchar(1024)
- st_pendingcreate — varchar(1024)
- st_pendingdelete — varchar(1024)
- st_pendingtransfer — varchar(1024)
- st_pendingupdate — varchar(1024)
- st_sv_deleteprohibited — varchar(1024)
- st_sv_updateprohibited — varchar(1024)
- clid — varchar(16) — NOT NULL
- crid — varchar(16) — NOT NULL
- createdate — timestamp — NOT NULL
- upid — varchar(16)
- updatedate — timestamp
- transferdate — timestamp
host_address
- host_name — varchar(255) — Primary key — NOT NULL
- ip — char(2) — Primary key — NOT NULL
- address — varchar(255) — Primary key — NOT NULL
ledger
- id — SERIAL
- client_roid — varchar(89) — NOT NULL
- description — text — NOT NULL
- currency — char(3) — NOT NULL
- tax — numeric(8,2)
- tax_label — varchar(32)
- total — numeric(8,2) — NOT NULL
- balance — numeric(17,2) — NOT NULL
- domain_name — varchar(128)
- tld — varchar(64) — NOT NULL
- trans_type — varchar(64)
- refund_expiry — timestamp
- refund_roid — varchar(89)
- refund_amount — numeric(8,2)
- credit_transaction_id — int
- created — timestamp — NOT NULL
registrar_access
- client_clid — varchar(16) — Primary key — NOT NULL
- zone_name — varchar(64) — Primary key — NOT NULL
- auto_renew — int — NOT NULL
- max_years — int — NOT NULL
- registration_prices — numeric(6,2) — NOT NULL
- renewal_prices — numeric(6,2) — NOT NULL
- registration_minimum — numeric(6,2) — NOT NULL
- renewal_minimum — numeric(6,2) — NOT NULL
tld
- tld — varchar(64) — Primary key — NOT NULL
- name — text
- cc_processor — varchar(64)
- cc_user — varchar(64)
- cc_pass — varchar(64)
tld_access
- client_clid — varchar(16) — Primary key — NOT NULL
- tld — varchar(64) — Primary key — NOT NULL
- administrator — bool — NOT NULL
- write_access — bool — NOT NULL
- read_access — bool — NOT NULL
zone
- name — varchar(64) — Primary key — NOT NULL
- tld — varchar(64) — NOT NULL
- header — text
- footer — text
- publish — bool — NOT NULL
- serial_type — varchar(64) — NOT NULL
- auto_suspend — int
- auto_delete — int
zone_access
- client_clid — varchar(16) — Primary key — NOT NULL
- zone_name — varchar(64) — Primary key — NOT NULL
- administrator — bool — NOT NULL
- write_access — bool — NOT NULL
- read_access — bool — NOT NULL