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