Arial
Wingdings
Monotype Sorts
Symbol
Times New Roman
DB Engineer
/CMD=1
Relationships Relationships
Tracking text is used to annotate the Relationship shape.
`?Copyright (c) 2003 Microsoft Corporation. All rights reserved.
10 = Tracking Text
DB Engineer /CMD=1003
guard(pntx(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
guard(pnty(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
Shape ID to Track
Control Row to Track
0 = IDEF1X; 2 = Relational
`SOverrides the relationship notation specifed by the IDEF1X or Relational notations.
`)Set to hide all relationships on the page
Set to hide relationship text.
`*Set to hide PK, FK, and Index annotations.
`'Set to hide the PK section of Entities.
`.Set to hide the Datatype section for Entities.
`\Set to hide the vertical lines seperating the Annotation and Datatype sections for Entities.
`jSet to hide the horizontal line seperating the Primary Key section from the other columns within Entities.
Relationships
Use the Relationship connector to define a foreign key between two tables.
Vis_D200.chm!#20000 `?Copyright (c) 2003 Microsoft Corporation. All rights reserved.
Relationship (Foreign Key)
`%Unique identifier used by the add-on.
`BSet to indicate the relationship is an 'Identifying Relationship'.
`C25=exactly one, 28=one or more, 29=zero one or more, 30=zero or one
`-Set to indicate the relationship is optional.
`RSet to override Database | Document | Options locally for this relationship shape.
`NSet to allow free-form editing (manual edits are not maintained in the model.)
`7This formula conditionally sets the DBNotation setting.
P{)DTû `3Calculates a reference point for Relationship text.
`<This formula conditionally sets the CrowsFoot notation flag.
`3Calculates a reference point for Relationship text.
Shape's version.
`"reference to associated text shape
Q(-DT Q(-DT
`'Locate referencial integrity text here.
Locate cardinality text here.
Database Properties... DB Engineer /CMD=1001
Relational Notation
IDEF1X Notation
Crow's Foot Notation
Database Model master stores embedded model information.
\qrL
5bQL
te of last Validation`5
&DocTitleLong
&PageDesc
&Date &Time
&PageNo
CElemArrayOfCell
CTimeStamp
Date of last Merge`5
Date of last Validation`5
Date of last Mapping`5
is identified by
CustomerPostalCode
identifies
PostalCode
sxqP
CustomerID
is partly identified by
partly identifies
Puhelinnumero
is of
PhoneNumber
PhoneNumberID
Tilaus
CObjTypeD
Asiakas
CRole
CPredicateD
CElemArrayOfCells
CElemCell
CustomerCol1
CConstraintList
CUCIndexConstraint
CRoleArray
CustomerExtraInformation
AsiakasOsoite
CustomerName
CMandatoryConstraint
City
DeliveryCity
Postitoimipaikka
OrderCol1
Reference
OrderContactPerson
OrderExtraInfo
OrderDate
OrderID
DeliveryAddress
Deliver
Toimitus
DeliveryPostalCode
DeliveryCompany
DeliveryContactPerson
CValueConstraint
Postipaketti
Kirje
Nouto
Toimitustapa
CCollectionConstraint
Toimitusaika
DeliveryExtraInfo
DeliveryDate
DeliveryID
Tilausrivi
Unit
Price
ProductID
Quantity
OrderRowID
GeneralID
General
Yleistiedot
Licence
LicenceOwner
ProductExtraInformation
Tuote
ProductPrice
Produ
ProductGroup
ProductName
TilausID
=Varsinainen toimitusp
muodossa p.k.vvvv, esim. 20.12.2007
DeliveryTimeRequest
LToimitusaika, joilloin toimituksen toivotaan olevan perill
, esim. viikko 14
DeliveryType
AToimitustapa (valitse listasta), esim. postipaketti, kirje, nouto
,Yritys tai henkil
, jolle tilaus toimitetaan
Katuosoite tai PL
Postinro
JToimitetun l
hetyksen yhteyshenkil
(vastaanottaja), esim. Pekka Miettinen
Muita tietoja tilauksesta
OrderRow
TuoteID
$Tilattujen tuotteiden m
, esim. 5
Tuotteen hinta tilausrivill
Yksikk
(kpl tms.)
Product
!Autommaatisesti numeroituva tieto
"Tuotteen nimi, esim. Kuksa, Solmio
Esim. puutuote, kangastuote
CMappingGroup
PostalCode_Name
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
Postinumero
CForeignKey
Customer
!Automaattisesti numeroituva tieto
5Asiakkaan nimi, esim. Nokia Oyj tai Matti Meik
inen
CustomerAddress
Postinumero (valitse listasta)
Muita tietoja asiakkaasta
Order
Tilausnumero
.TilausPvm muodossa p.k.vvvv, esim. 20.12.2007
$Yhteyshenkil
, esim. Pekka Miettinen
Viite (tilauksen otsikko)
Delivery
Tuotteen hinta (euroissa)
Muita tietoja tuotteesta
CLogicalKey
(Puhelinnumeron yksil
tieto (laskuri)
Puhelinnumeron haltija
6Puhelinnumero, esim. +358 40 123 456 tai (014) 123 456
General_info
GeneralID yksil
i yleistiedot
Esim. Demox Oy
Date of last Merge
Date of last Validation
Date of last Mapping
Microsoft Visio
Entities Entities
0 = IDEF1X, 2 = Relational
`@Set to hide the PK seperator lines in the Entities on this page.
`;Set to hide the Tabstop lines in the Entities on this page.
Drag onto the page to add a table.
elationship diagram.
Vis_D200.chm!#54176 `?Copyright (c) 2003 Microsoft Corporation. All rights reserved.
Entity
`-Identifies the shape's version to the add-on.
Set for dependent tables.
`KSet to allow free-from edits (manual edits are not maintained in the model)
`LSet if this shape's Database | Document | Options have have local overrides.
`*Conditionally sets the DBNotation setting.
`7Use to add a table to your Entity Relationship diagram.
`.Relational,Database,Entity,Relationship,IDEF1X
Show Related Tables DB Engineer /CMD=1002
width of this shape's text
height of this shape's text
`*Subshape id within the Entity group shape.
Edit Table Name...
`*Subshape ID within the Entity group shape.
`9specifies the number of columns in the tables primary key
`HSet to hide the horizontal line seperating the PK columns from the rest.
`&Set to hide the 1st vertical tab line.
`&Set to hide the 2nd vertical tab line.
`*Indicates the number of lines in the text.
`&Indicates the height of one text line.
Edit Column Text...
Show Lines
Drag onto the page to define a foreign key between two tables.
Vis_D200.chm!#54177 `?Copyright (c) 2003 Microsoft Corporation. All rights reserved.
`SUse to define a foreign key between two tables in your Entity Relationship diagram.
`Etwo,key,Relational,Database,Entity,Relationship,IDEF1X,foreign,tables
?ArkÁ Ö?Ark Q(-DT Q(-DT Add text here.
Q(-DT Q(-DT Add text here.
Drag onto the page and then type to add text.
iagram.
`?Copyright (c) 2003 Microsoft Corporation. All rights reserved. Vis_D112.chm!#54397
Connect Note
Display Se&mantic Errors UML Background Add-on /CMD=1002
Shape Displa&y Options... UML Background Add-on /CMD=1008
%Propert&ies UML Background Add-on /CMD=1001
`%Use to place a comment on a diagram.
`%Note,UML,statechart,software,modeling
Drag the shape onto the drawing page.
utomatically sized to fit text.
y size the shape.
Vis_SE.chm!#49257 `?Copyright (c) 2003 Microsoft Corporation. All rights reserved.
Move to change feature size.
`1classic,note,box,title,caption,annotation,comment
Resi&ze to fit text Scratch.X1 Scratch.Y1
C:\Program Files\Microsoft Office\Visio11\1033\ENTITY_M.VSS
C:\Program Files\Microsoft Office\Visio11\1033\OBJREL_M.VSS
`$Set to hide category discriminators.
`:Set to hide PK, FK, and Index annotations within Entities.
`0Set to Hide Primary Key section within Entities.
`.Set to hide Datatypes section within Entities.
`bSet to hide the vertical lines that seperate the Annotation and Datatype sections within Entities.
`bSet to hide the horizontal line that seperates the PK section from the other columns of an Entity.
Type Inheritance Type Inheritance
Composite Types Composite Types
Table Inheritance Table Inheritance
Categories Categories
`&{C549D305-2F0A-49BD-B7AD-AAD889883C6C}
Database Properties...
Show Related Tables
`&{15051863-1D74-4E29-A0D9-65BCF7D5709E}
`&{EF9E1643-FC49-406D-99F0-73787150C5C8}
`&{2AC54DDD-379E-42DB-A64A-3FA8B28BF02D}
`&{7F86929F-3CF7-44C7-927F-745D76A8E7DB}
`&{65C9FA23-43D2-4274-8098-5CE2A45C7172}
`&{982A58FA-316A-400D-97DA-B92DEE40D9C0}
`&{A2A9BA24-6235-4C51-B40E-0E3F2D6F22D9}
`&{DC7D5A1D-B704-4EA8-A3A4-5B7723280FA2}
`&{CA670639-4DD4-4F5D-B501-A202967B06DA}
`&{274E7D75-B78F-49EB-9084-541AA12007C8}
`&{B7EF74AA-2CFB-44AB-8CD2-A088BB0DAA68}
P'-DT
`&{A410BBDA-3EDD-46D5-9B3F-CCF10A5032BF}
`&{2C981187-382D-40B0-9C16-E503D12085BF}
`&{50CCC1CF-8C21-48E8-BCAB-72E1061E45AC}
?App Ë?App
Guide
TheDoc
Note
Gesture Format
Row_1
DBNotation
Row_2
DBCrowsFoot
Row_3
DBHideDiscriminator
Row_4
DBHideAnnotations
Tietokantakaavio, v 0.1
DBHidePKRow
Tietokantakaavio, v 0.2
DBHideTypes
Row_5
DBHideVerticalLines
Row_6
DBHideHorizontalLine
Connector
White line
Arial centered
Arial top left
Arial top
Times centered
Times top
Times top left
Tracking Text
DBShapeType
DBEventTrigger
OldPinX
OldPinY
ManualEdits
Hide
SetPinX
SetPinY
DBShapeVersion
RefSheetID
RefControl
Dynamic Connector
DBHideRelationships
DBHideRelationshipText
RefShapeGuid
Identifying
DBCardinality
CrowsFoot
Optional
Override
OverrideDBNotation
EndAngle
OverrideCrowsFoot
BeginAngle
RITextRefGuid
CardTextRefGuid
Database Model
Visio Extended Data
Row_7
Row_8
UMLShapeType
UMLObjectGUID
UMLError
UMLVersion
UMLPresOption1
Name
visDescription
visVersion
Border Page Number
Visio 00
Border graduated
Visio 13
Note box classic
Margin
AntiScale
Scale
DBDependent
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Relationship
Entity.29
visKeywords