psa.dns_recs

Overview
The dns_recs table contains the actual DNS records for a specific DNS zone.

Column Descriptions
id – primary key that is automatically incremented
dns_zone_id – Links to id in dns_zone table
type – DNS record type (NS, A, CNAME, MX, PTR, TXT, master or none)
displayHost – hostname part of DNS record (left side of DNS zone file)
host – shown in Plesk, should match displayHost
displayVal – DNS server’s response (right side of DNS zone file)
val – shown in Plesk, should match displayVal
opt – subnet mask for PTR records, priority for MX records, or empty for other records
time_stamp – the last time the record was updated (automatic MySQL timestamp)

Table Structure

CREATE TABLE `dns_recs` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `dns_zone_id` int(10) unsigned default NULL,
 `type` enum('NS','A','CNAME','MX','PTR','TXT','SRV','master','none') NOT NULL default 'A',
 `displayHost` varchar(255) character set utf8 NOT NULL default '',
 `host` varchar(255) character set ascii NOT NULL default '',
 `displayVal` varchar(255) character set utf8 NOT NULL default '',
 `val` varchar(255) character set ascii NOT NULL default '',
 `opt` varchar(255) character set ascii NOT NULL default '',
 `time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 PRIMARY KEY  (`id`),
 KEY `type` (`type`),
 KEY `dns_zone_id` (`dns_zone_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2827 DEFAULT CHARSET=latin1

Related documentation