Skip to content

Latest commit

 

History

History
21 lines (16 loc) · 612 Bytes

README.md

File metadata and controls

21 lines (16 loc) · 612 Bytes

Database schema for general application

Notes

  • Use plural table name => users
  • Always use an auto increment column => id
  • Use lower case for table columns => username
  • Use snake_case for table columns => created_at
  • Default values should give less access for example if there is a disabled field the default value should be true
  • You shouldn't go to code for understanding data structure and vice versa

Blog database schema

Shop database schema

Future development

  • ACL: access control list
  • Ticketing (support)
  • Add SQL file
  • Add migration
  • Add Models