Interactory Publicaties
Home
Onderwerpen
IDEA Addon voor Sparx
Web Publicatie Platform voor Sparx
Architectuur Repository
Sparx Enterprise Architect
Architectuur
Webvideo's
Whitepapers
Blog
Alle onderwerpen
Zoeken in repository
Trefwoorden zoeken in repository
ArchiMate zoeken in repository
Geavanceerd zoeken in repository
Packages in repository
Diagrammen in repository
Repository elementen
Extra
Repository verkenner
Matrix van Package
Matrix van Diagram
Begrippenlijst
Grafieken
Release notes
Participant
Inschrijven voor de webmailing
Login
Contact
Deze website is verplaatst naar
Data-docent.nl
AddressType
Types of addresses stored in the Address table.
Package
Physical datamodel example
Author
Bert Dingemans
Alias
--
Stereotypes
table
Attributes
Name
Type
Cardinality
Description
AddressTypeID
int
1 - 1
Primary key for AddressType records.
Name
nvarchar
1 - 1
Address type description. For example, Billing, Home, or Shipping.
rowguid
uniqueidentifier
1 - 1
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate
datetime
1 - 1
Date and time the record was last updated.
Mappings
Name
Source
Source attribute
Target
Target attribute
AddressTypeID
AddressType
AddressTypeID
AddressType
AddressTypeID
Name
AddressType
Name
AddressType
Name
rowguid
AddressType
rowguid
AddressType
rowguid
ModifiedDate
AddressType
ModifiedDate
AddressType
ModifiedDate
Diagrams
Import Adventureworks Database
--
Physical example project
Physical data model for the TFG Academy example. It shows a subset of the tables as they are included in the TFG Academy database. These three entities are used and expanded in the other two layers logically and conceptually.
Gekoppelde elementen
Logical datamodel example
AddressType
AddressType trace
Physical datamodel example
BusinessEntityAddress FK
Links 2 Tags
Archimate
Architect
Architectuur
Architectuur document
Architectuur repository
Big data
Bouwblokken en patronen
Criteria
Data
Data architectuur
Data governance
Data kwaliteit
Data management
Data modelleren
Enterprise architectuur
Idea
Image library
Master data
Matrix
Mdg
Meta data
Metafoor
Modelleren
Open source
Principes
Register
Repository
Simulator
Software
Sparx enterprise architect
Sql
Stakeholders
Time aware modelleren
Tips en tricks
Training
Webvideo
Wpp