Dataro Reference Schema

The tables below document the structure of the reference schema.

N.b. it is not necessary or required that we have all fields with complete data. It is quite common for some data to not be available (i.e. full contact details) and in other cases to be incomplete (i.e. only a subset of the records have a birth_date). Furthermore, there can be good reasons why certain tables may not be present at all, i.e. if an organization has no recurring giving program, then we do not expect to have any data for commitments.