In the product I work on, there's a Metadata layer that maps user-supplied definitions, notes and commentary onto the raw table descriptions

These are optional but it allows manual override when schema design is poor