README.schema
1This directory contains the OpenDMARC schema plus any related files.
2
3The tables in this schema are populated by the opendmarc filter as it processes
4messages and downloads policies. The rows are then consumed by the scripts
5in the "reports" directory to generate regular aggregate reports.
6
7The tables are summarized here:
8
9domains A table that maps domain names to unique integer IDs.
10 Automatically tracks a "first seen" timestamp, and includes
11 a column to record when the last report was sent.
12
13selectors A table that maps selector names to unique integer IDs.
14 Automatically tracks a "first seen" timestamp. Also references the
15 foreign key (into the domains table) for the domain that owns the
16 selector.
17
18reporters A table mapping reporting hosts to unique integer IDs.
19 Intended for use by multi-MX systems so it's possible to tell
20 where an inbound message landed.
21
22ipaddr A table mapping IP addresses (as strings) to unique IDs.
23 Also tracks the "first seen" timestamp for each.
24
25messages A table tracking salient properties of all messages received.
26 A messages is uniquely identified by a {date, jobid, reporter}
27 tuple. Includes references to the "domains" table to track
28 the RFC5321.MailFrom domain, the RFC5322.From domain.
29 Also records the count of DKIM signatures, the SPF result,
30 and whether or not the SPF result was aligned with the
31 RFC5322.From domain.
32
33signatures A table tracking DKIM signatures, each of which refers to
34 a row in the "messages" table. Tracks the signing domain,
35 whether the signature passed, whether there was a verification
36 error other than a broken signature, and whether or not the
37 signing domain aligned with the RFC5322.From domain.
38
39requests A table containing a cache of DMARC reporting requests.
40 For each domain, the destination reporting URI for aggregate
41 reports is recorded along with a "last report sent" timestamp.
42
43--
44Copyright (c) 2012, 2018, The Trusted Domain Project. All rights reserved.
45