Microsoft Dynamics NAV

Applying Design Patterns

Most of these tables now only have an ID, Name, and Primary Key. We need to give them functional elements by adding Design Patterns.

The UML schemas for these Patterns can be found in Chapter 2, Architectural Patterns and Chapter 3, Design Patterns.

The Bed and Breakfast setup

In this example application, we need the Setup table to store the Number Series for the Stay table. Other than these, we don't have fields to add anything to this table.

Here's how I usually put table definitions in design documents:

Field No	Field Name	DataType	Comments
1	Primary Key	Code10	This is the Primary Key for this table
20	Stay Nos. ...