The rr table

This table contains all resource record types that are not SOA or PTR. It has a unique key on the combination of zone, name, type, and data.

id INT UNSIGNED NOT NULL

A unique number identifying this record. (Auto increment / Primary key)

zone INT UNSIGNED NOT NULL

The ID of the zone (from the soa table) to which this resource record belongs.

name CHAR(64) NOT NULL

The name (beneath the origin) that this RR describes. Wildcard values such as * or *.sub are supported.
ex: foo

type ENUM('A','AAAA','CNAME','MX','NS','TXT')

The type of resource record.

data CHAR(255) NOT NULL

The data associated with this resource record. For A and AAAA records, this is an IP address in dotted-decimal format. For CNAME, MX, and NS records, this is a name (can be just a machine name if the name is within the origin zone, or a FQDN). For TXT records, any text.
ex: 127.0.0.1 (A or AAAA)
ex: foo (CNAME, MX, or NS within this zone)
ex: foo.example.com. (CNAME, MX, or NS outside this zone)

aux INT UNSIGNED NOT NULL

An auxillary numeric value in addition to data. Currently this field is meaningful only for MX records, where it specifies the preference.
ex: 10

ttl INT UNSIGNED NOT NULL default '86400'

The time interval that this resource record may be cached before the source of the information should again be consulted. Zero values are interpreted to mean that the RR can only be used for the transaction in progress, and should not be cached.
ex: 86400