Add created/modified/deleted fields to each record type

[idolpx]

Useful for syncing data

[mrdudz]

This should also include things like "imported" (flag data imported from elsewhere but not verified), "reviewed" (perhaps including a link to who did it), "confirmed", "guessed" and perhaps more

[Grrrolf]

Don't forget to add an audit table/log storing who created, modified or deleted any of the records. Useful for auditing purposes and transparency.

[idolpx]

Yep yep... Ideally I would like some kind of version control so anyone could look at changes over time for individual items.

[idolpx]

I've added dateCreated, dateUpdated, dateDeleted and deleted to the major types in the schema.