O'Reilly logo

Learning Dynamics NAV Patterns by Mark Brummel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

The Bed and Breakfast setup

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required