Diagrams

Table

Post Code

DynamicsDocs.comPost Code«Table 225»Post CodeCode [PK,NN]City [PK,NN]Search CityCountry/Region CodeCounty«Table 5096»Segment Wizard FilterSegment No. [PK]Functionality; [Add Contacts,Remove Co...Mailing Group Code FilterIndustry Group Code FilterSalesperson Code FilterCountry/Region Code FilterTerritory Code FilterPost Code FilterBusiness Relation Code FilterProfile Questn. Code FilterProfile Questn. Line FilterJob Responsibility Code FilterProfile Questionnaire CodeAdd Additional CriteriaWizard Step; [,1,2,3,4,5,6]«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT SchemeLast Modified Date TimeId<Country/Region Code><Post Code Filter><Country/Region Code Filter>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code (Code) Code20 NotBlank: Yes
2 City (City) Text30 NotBlank: Yes
3 Search City (Search City) Code30
4 Country/Region Code (Country/Region Code) Code10
5 County (County) Text30

Keys

# Fields
0 Code,City (Code,City) Clustered: Yes
1 City,Code (City,Code)
2 Search City (Search City)
3 Country/Region Code (Country/Region Code)

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code (Country/Region Code) Country/Region Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Segment Wizard Filter Post Code Filter (Post Code Filter) 1..n