Data Schema

[sixstring]

Here are the data I think we should track in a first iteration.

People (we might also want this entity to serve as our user table)

• Name (first, initial, last, etc.)
• Bio/Description
• URL

Books (we can gather much of this data from the Amazon and/or Worldcat APIs)

• Title
• Author (link to people table)
• Publisher
• Published Date
• Etc.

Scripture references

We're also going to want to store blog posts, journal articles, sermons, podcast episodes, etc. I'm not sure how we'll want to do that. We could have one abstract object for all the shared fields (e.g. "title") and then other objects that extend that data. But that may be overkill.

The target is for us to track all sorts of Reformed resources and have them intelligently linked to people, Scripture references, and other resources. For example, if an article mentions a book, we should be able to establish a link in the system between those two resources.