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
StateProvince
State and province lookup table.
Package
Physical datamodel example
Author
Bert Dingemans
Alias
--
Stereotypes
table
Attributes
Name
Type
Cardinality
Description
StateProvinceID
int
1 - 1
Primary key for StateProvince records.
StateProvinceCode
nchar
1 - 1
ISO standard state or province code.
CountryRegionCode
nvarchar
1 - 1
ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
IsOnlyStateProvinceFlag
bit
1 - 1
0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
Name
nvarchar
1 - 1
State or province description.
TerritoryID
int
1 - 1
ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
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.
Diagrams
Import Adventureworks Database
--
Gekoppelde elementen
Physical datamodel example
Address FK
CountryRegion 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