Database and data model is not reflective of the ER diagram

[Wyvernix]

Explaination Currently our data model was generated using rails scaffolding. It was then modified in order to define the relationships correctly. Because of this, our database isn't using many of the features of SQL and would benefit from doing so. In addition, some of the information is not correct. A number of fields were added to reference other tables, but only the "child" who "belongs to" another table should have this information.

Proposal

• Check this information is correct then,
• Add missing indices to tables. (check schema.rb)
• Setup unique fields?
• Setup foreign keys?
• Remove fields:
  • customers.person_id
  • customers.payment_id
  • episodes.video_id
  • movies.video_id
• Review relationships for models

Related information

• Rails migration docs
• Rails migration api
  • add_foreign_key
  • change_column
  • add_index
  • add_reference

Note that while the db/schema.rb file has information about the current state of the database, not all fields are listed (such as the id field for each table) because they are implied. Download db/development.sqlite3 and open with DB Browser to view complete database.