DatabaseLayout

What are all the objects we're going to store?

• documents
• sentences
• tags
• translations of sentences
• users

what are their relationships?

• documents

  • have a source language (and a target language??!)
  • have many tags
  • have a user who uploaded them
  • have a title

• sentences

  • have text
  • pertain to a document
  • have many translations (and a most recent one -- so translations have an ordering)

• translations

  • have text
  • have a user who did them
  • pertain to a sentence
  • pertain to a document (this is strictly not necessary to store, but we're going to do queries like "give me all the translations for this document")