Applying a few table effective practices can:
- Significantly aide others in understanding the purpose and use of tables and column fields
- Provide more migratable meta data to inform and enable the capabilities of other tools
- And, from a self-preservation point of view, reduce the number of meetings, emails, and phone required to explain and clarify what the table and fields business meaning and roles
Among the Effective practices when modeling and design tables are:
- Add Primary Key
- Add table comments
- Add column field comments
- Add ‘Organize by’ fields to provide essential optimization on frequently used and/or key performance fields
