How to design the schema
- how to design unique slug with auto increment table. see here
- how to design tagging system
- how to design Auth system
- how to design relationship system
- how to design roles and permission system
- how to design supertype/subtype system
- how to design booking system
- how to design polymorphic type (not recommended due to lack of referential integrity)
- how to design short URL
- how to design history tables
- how to design comment system
- how to design notification system (requires revision)
- how to design reference table
- how to design status types
- how to design bill of material
- how to design workflow system
- how to design subscription system
- how to design counter cache
- how to design soft delete