mysql.md

0. [MySQL naming convention] (#1-naming-convention)
1. [Mandatory columns] (#2-mandatory-columns)

##1. Naming Convention

0. Tables name must always be plural (ie users, presentations, ...)

1. Dates must always be starting with date_ and ends with the past tense (ie date_created, date_updated, ...)

2. Columns must always be named using the underscore convention (date_created, presentation_owner, user_id, ...)

3. Foreign keys must be named table_id, singular (ie user_id when referencing the users table)

##2. Mandatory Columns

0. All tables must have a id column

1. All tables that can change in time must have a date_created and date_updated columns