Are there any Database schema patterns - for scenarios of extensible of data variations?

Are there any Database schema patterns - for scenarios of extensible of data variations?

For example a tool which could be customized by client for extra fields, need to have certain allowable schema - meta table which holds dynamic column type, constraints and its data. Similarly, Are there any database related tricks and tips for extendable models for future requirements?