# View and Joined Table Design

[**View and Joined Table Design**](https://dev.to/jerrywang1983/view-and-joined-table-design-3585)

View Design  
\[Proposal\] Do not nest views unless they have strong dependency on each other.  
\[Proposal\] Try to avoid collation operations in a view definition.  
Joined Table Design  
\[Proposal\] Minimize joined columns across tables.  
\[Proposal\] Use the same data type for joined columns.  
\[Proposal\] The names of joined columns should indicate their relationship. For example, they can use the same name.