Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
Custom page 1
Custom page 2
Custom page 3
Display
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)
`%Unique identifier used by the add-on.
`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.
`LAdd,use,Relational,Database,your,table,Entity,Relationship,diagram,ER,IDEF1X
Database Properties... DB Engineer /CMD=1001
Show Related Tables DB Engineer /CMD=1002
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
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
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 Relationships
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.
Relationships
IDEF1X Notation
Crow's Foot Notation
Relational Notation
Relationship (Foreign Key)
`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
`SUse to define a foreign key between two tables in your Entity Relationship diagram.
`huse,two,key,between,Relational,Database,define,your,Entity,Relationship,diagram,ER,IDEF1X,foreign,tables
Q(-DT Q(-DT Add text here.
`'Locate referencial integrity text here.
Locate cardinality 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
DB Engineer
/CMD=1
`&{83AE6687-8377-11D6-9D41-0001033D12E3}
Database Properties...
Show Related Tables
`&{83AE668E-8377-11D6-9D41-0001033D12E3}
`&{9E6574AC-8444-11D6-9D41-0001033D12E3}
Guide
TheDoc
Page-1
Gesture Format
DBNotation
DBCrowsFoot
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
DBShapeType
ManualEdits
DBShapeVersion
DBHideRelationships
DBHideRelationshipText
RefShapeGuid
Identifying
DBCardinality
CrowsFoot
Optional
Override
OverrideDBNotation
EndAngle
OverrideCrowsFoot
BeginAngle
RITextRefGuid
CardTextRefGuid
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Relationship
Entity.20
Relationship.32