Database Schema

The database schema for Agora is structured as follows (I do not list updated-at or created-at columns here, but each table has these columns in implementation):

• users

  • id: integer
  • username: string
  • password_digest: string
  • session_token: string

• questions

  • id: integer
  • interlocutor_id: integer, null: false, unique: true
  • title: string, null: false
  • body: text, null: false
  • topic: string
  • tag: string

• answers

  • id: integer
  • rhetor_id: integer, null: false
  • question_id: integer, null: false
  • title: string, null: false
  • body: text, null: false

• comments

  • id: integer
  • commentor_id: integer, null: false
  • answer_id: integer, null: false
  • parent_id: integer
  • message: string, null: false

Back to Table of Contents...