Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
Letter
PRIV
Display
Relationships Relationships
Tracking text is used to annotate the Relationship shape.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
10 = Tracking Text
DB Engineer /CMD=1003 PinX PinY User.OldPinX User.OldPinY
PinX guard(pntx(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
PinY guard(pnty(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
Shape ID to Track `BEnter the sheet id of the shape that you want this text to follow.
Control Row to Track `wIdentify the 'Tracked' shpe's control point by entering it's row number within the controls section of the shape sheet.
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) 2001 Microsoft Corporation. All rights reserved.
IDEF1X Notation
Crow's Foot Notation
Relational Notation
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.)
User.DBNotation `7This formula conditionally sets the DBNotation setting.
`3Calculates a reference point for Relationship text.
User.CrowsFoot `<This formula conditionally sets the CrowsFoot notation flag.
Shape's version.
`"reference to associated text shape
?FkkÁ Õ?Fkk Q(-DT Q(-DT
Q(-DT Q(-DT
`'Locate referencial integrity text here.
Locate cardinality text here.
Database Properties... `0Edit the model properties for this relationship. DB Engineer /CMD=1001
Relational Notation `4Display this relationship using Relational notation. User.CrowsFoot User.Override user.dbnotation
IDEF1X Notation `0Display this relationship using IDEF1X notation. User.CrowsFoot User.Override user.dbnotation
Crow's Foot Notation `5Display this relationship using Crow's Foot symbols. User.CrowsFoot User.Override
Database Model master stores embedded model information.
%DocTitleLong
%PageDesc
%Date %Time
is of
idnummer
versie
A\QJ
naam
VARCHAR
is identified by
beste
identifies
bestelnummer
INTEGER
huisnummer
is partly identified by
partly identifies
rechtspersoon
klant
CObjTypeD
barcode
CRole
CPredicateD
CElemArrayOfCells
CElemCell
product
voorr
voorraad
CConstraintList
CUCIndexConstraint
CRoleArray
produkt
produktnaam
CMandatoryConstraint
bestelling
land
woonplaats
straat
volledigenaam
leverancier
ODBC Generic Driver
bestellen-mysql
wwwis.win.tue.nl via TCP/IP
Generic OLE DB Provider
_bestellen-mysql
Page %PageNo of %PageCount
CTimeStamp
Date of last Merge
Date of last Validation
Date of last Mapping
Date of last stelling_PK
product_bestelling_FK1
product_PK
leverancier_product_FK1
leverancier_PK
CCategory
rechtspersoon_leverancier_FK1
rechtspersoon_PK
rechtspersoon_klant_FK1
klant_PK
server=;database=bestellen-mysql;user=;password=;
DSN=bestellen-mysql;OPTION=0;PWD=yas;PORT=0;SERVER=wwwis.win.tue.nl;UID=ywedemo
Mapping
Date of last MergepC
Date of last ValidationpC
Date of last MappingpC
barc
Administrator
Last modified database 'null' on server 'wwwis.win.tue.nl via TCP/IP' on December 20, 2005 04:19.
Database Model Document
rpost
Visio 2000
CDBTable
CDBColumn
CDBConstraint
CMappingGroup
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
CForeignKey
klant_bestelling_FK1
CLogicalKey
bestelling_PK
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.
Use to add a table to your Entity Relationship diagram.
se schema.
Vis_D200.chm!#28127 `?Copyright (c) 2001 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.
User.DBNotation `*Conditionally sets the DBNotation setting.
`7Use to add a table to your Entity Relationship diagram.
`FAdd,use,Relational,Database,object,your,table,Entity,diagram,ER,IDEF1X
Database Properties... DB Engineer /CMD=1001
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 User.DBHidePKSeperatorLine User.DBHideTabLine1 User.DBHideTabLine2
Use to define a foreign key between two tables in your Entity Relationship diagram.
Vis_D200.chm!#28129 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`SUse to define a foreign key between two tables in your Entity Relationship diagram.
`huse,two,key,between,Relational,Database,define,object,your,Relationship,diagram,ER,IDEF1X,foreign,tables
Q(-DT Q(-DT Add text here.
Relational Notation User.CrowsFoot User.Override user.dbnotation
IDEF1X Notation User.CrowsFoot User.Override user.dbnotation
Crow's Foot Notation User.CrowsFoot User.Override
`$Set to hide category discriminators.
Categories Categories
Use to specify that one or more tables in your Entity Relationship diagram are categories in another table.
Vis_D200.chm!#28124 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Categories
Edit Discriminator
Complete Category
Show Discriminator
Show Discriminator User.DBHideDiscriminator User.Override
Complete Category User.DBComplete
Category
0 = IDEF1x, 2 = Relational
`ISet to allow free-form edits (manual edits are not managed by the model.)
`.Set to indicate that the category is complete.
`"Set to hide the discriminator text
`ESet to override Databaes | Document | Options locally for this shape.
User.DBHideDiscriminator `=This formula conditionally sets the DBHideDiscriminator flag.
`(Unique id used internally by the add-on.
Shape's version number
`kUse to specify that one or more tables are categories in another table in your Entity Relationship diagram.
`ouse,more,One,Relational,Database,Category,object,another,your,specify,table,diagram,ER,IDEF1X,tables,categories
Reposition Discriminator Text
Use to connect a parent table to a category in your Entity Relationship diagram.
ble.
Vis_D200.chm!#28128 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Parent Category Connector
`LSet to allow free form edits (manual edits are not maintained in the model.)
Shape's version number.
`PUse to connect a parent table to a category in your Entity Relationship diagram.
`Suse,Relational,Database,Category,connect,object,your,table,diagram,ER,IDEF1X,Parent
Use to connect a category to a child table in your Entity Relationship diagram.
s defines the child to be a "type" of the category's parent table.
Vis_D200.chm!#28125 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Child Category Connector
`LSet to allow free-form edits (manual edits are not maintained by the model.)
Unique ID used by the add-on.
`OUse to connect a category to a child table in your Entity Relationship diagram.
`Ruse,child,Relational,Database,Category,connect,object,your,table,diagram,ER,IDEF1X
C:\Program Files\Visio 2000e\Solutions\Database\Entity Relationship.vss
C:\Program Files\Visio 2000e\Solutions\Database\Object Relational.vss
`: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
Composite Types
Table Inheritance Table Inheritance
`&{A1647B43-3C52-4F8B-9452-12C7B1551CBF}
Database Properties...
Show Related Tables
`&{0AFC2D9B-8A9E-460D-A9BC-DEA2AB029821}
`&{1B944534-5C41-4A51-AF69-62BDB480A529}
`&{574689D0-BCFA-438A-8707-E8BDBE1F9DF0}
`&{A7CE19F8-D328-44D3-B414-C2F553EBB7AA}
`&{C4CD2879-C375-4614-8439-03838C92C6C3}
`&{4E900856-48E7-465F-934D-B2EFA969C749}
`&{C332F7CA-18A1-471A-80B1-BDC5F0BB281C}
`&{967D9C07-DD9F-4FDD-A067-357D9C449CCE}
`&{67ED8B23-4E7D-48CB-ADE7-429DF1404FAB}
`&{5666957D-1D43-458D-87B9-848488AFA52C}
`&{86E29284-0647-459C-97A0-DAF93D0EE35C}
DB Engineer
/CMD=1
Guide
TheDoc
Page-1
Gesture Format
Database Model
DBNotation
Visio Extended Data
DBCrowsFoot
DBHideDiscriminator
DBDependent
DBHideAnnotations
visDescription
DBHidePKRow
visKeywords
DBHideTypes
visVersion
DBHideVerticalLines
Width
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
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Relationship
Entity.15
DBComplete
OverrideDBHideDescriminator
Parent
Child
Parent to category
Category to child
Attribut
e VB_Nam
e = "Thi
sDocumen
|Global
Spac
dCreat
Pred
ecla
BExpo
Templ
ateDeriv
Bustomi
Visio
Win16
Win32
VBA6
bestellen
stdole
ThisDocument<
_Evaluate
Documentj
EngineerF
_B_var_Engineer
_B_var_DB
bestelleDn
rs@tdole>
E:\WINNT
STDOLE2.
TLB#
tomation
FThis
Document
CuB"
ThisDocument
ID="{F56DB128-B81D-4C48-AF30-269499BA9280}"
Document=ThisDocument/&H00000000
Name="bestellen"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="282AFF0503050305030503"
DPB="5052872888288828"
GC="787AAF50B050B0AF"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000