Arial
Wingdings
Monotype Sorts
Symbol
Times New Roman
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... DB Engineer /CMD=1001
Relational Notation User.CrowsFoot User.Override user.dbnotation
IDEF1X Notation User.CrowsFoot User.Override user.dbnotation
Crow's Foot Notation User.CrowsFoot User.Override
Database Model master stores embedded model information.
DR(fJ
eJr~J
&DocTitleLong
&PageDesc
&Date &Time
AC_ACO_SECTIONSNAME
NAME
is of
ACO_SECTIONS
HIDDEN
NUMBERPS
ORDER_VALUE
VALUE
VARCHAR2
is identified by
identifies
CObjTypeD
AC_ACL_SECTIONSNAME
CRole
CPredicateD
CElemArrayOfCells
CElemCell
ACL_SECTIONS
CConstraintList
CMandatoryConstraint
CRoleArray
CUCIndexConstraint
AC_ACONAME
SECTION_VALUE
AC_ARO_GROUPSNAME
ARO_GROUPS
ist von
TEXT
PARENT_ID
AC_ARO_SECTIONSNAME
ARO_SECTIONS
AC_ARONAME
AC_AXO_GROUPSNAME
AXO_GROUPS
AC_AXO_SECTIONSNAME
AXO_SECTIONS
AC_AXONAME
AC_PHPGACLNAME
PHPGACL
UPDATED_DATE
NOTE
RETURN_VALUE
ENABLED
ALLOW
B_GR
ACL_ID
is partly identified by
partly identifies
AXO_MAP
AXO_GROUPS_MAP
GROUP_ID
ARO_MAP
ARO_GROUPS_MAP
ACO_MAP
ARO_ID
GROUPS_ARO_MAP
AXO_ID
GROUPS_AXO_MAP
CONF_WORKSPACES
WM$CONFLICT_PAYLOAD_TYPE
KEYVALUE
TABLENAME
TIMESTAMP
DATE
USERSTATE
INDEX_FIELD
WM$ED_UNDO_CODE_NODE_TYPE
WM$ED_UNDO_CODE_TABLE_TYPE
CCollectionConstraint
SQL_STR
CLOB
INDEX_TYPE
INTEGER
INFO
WM$LOCK_INFO_TYPE
WM$LOCK_TABLE_TYPE
TABLE_NAME
TABLE_OWNER
Oracle 7
BTPORTAL01
&PageNo
TIONS
SHDOCBASE
CTimeStamp
Date of last MergepC
Date of last ValidationpC
Date of last MappingpC
Date of last K_HIDDEN_AXO
HIDDEN IN (0,1)
NULL
AC_CHECK_HIDDEN_AXO_SECTIONS
AC_PRIMARY_AXO_SECTIONS
AC_UNIQUE_VALUE_AXO_SECTIONS
AC_HIDDEN_AXO_SECTIONS
AC_FK_SECTION_VALUE_AXO
CMappingGroup
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
CLogicalKey
AC_PRIMARY_PHPGACL
CForeignKey
CMapCodeList
CMapCode
AC_CHEC
GETBLOB
IN INTEGER
AC_CHECK_ALLOW_ACL
ALLOW IN (0,1)
AC_CHECK_ENABLED_ACL
ENABLED IN (0,1)
AC_CHECK_HIDDEN_ACL_SECTIONS
AC_PRIMARY_ACL_SECTIONS
AC_UNIQUE_VALUE_ACL_SECTIONS
AC_HIDDEN_ACL_SECTIONS
AC_FK_SECTION_VALUE_ACL
AC_CHECK_HIDDEN_ACO
AC_CHECK_HIDDEN_ACO_SECTIONS
AC_PRIMARY_ACO_SECTIONS
AC_UNIQUE_VALUE_ACO_SECTIONS
AC_HIDDEN_ACO_SECTIONS
AC_FK_SECTION_VALUE_ACO
AC_PRIMARY_ACO
AC_UK_SECTION_VALUE_VALUE_ACO
AC_HIDDEN_ACO
AC_FK_SV_VALUE_ACO_MAP
AC_PRIMARY_ACO_MAP
AC_FK_ACL_ID_ACO_MAP
AC_CHECK_HIDDEN_ARO
AC_CHECK_HIDDEN_ARO_SECTIONS
AC_PRIMARY_ARO_SECTIONS
AC_UNIQUE_VALUE_ARO_SECTIONS
AC_HIDDEN_ARO_SECTIONS
AC_FK_SECTION_VALUE_ARO
AC_FK_ACL_ID_ARO_MAP
AC_PRIMARY_ARO_MAP
AC_FK_SV_VALUE_ARO_MAP
AC_PRIMARY_ARO
AC_UK_SECTION_VALUE_VALUE_ARO
AC_HIDDEN_ARO
AC_FK_ARO_ID_GROUPS_ARO_MAP
AC_PRIMARY_GROUPS_ARO_MAP
AC_FK_GRP_ID_GROUPS_ARO_MAP
AC_PRIMARY_ARO_GROUPS
AC_LFT_RGT_ARO_GROUPS
AC_PARENT_ID_ARO_GROUPS
AC_VALUE_AXO_GROUPS
AC_FK_GROUP_ID_ARO_GROUPS_MAP
AC_PRIMARY_ARO_GROUPS_MAP
AC_FK_ACL_ID_ARO_GROUPS_MAP
AC_FK_GRP_ID_GROUPS_AXO_MAP
AC_PRIMARY_AXO_GROUPS
AC_LFT_RGT_AXO_GROUPS
AC_PARENT_ID_AXO_GROUPS
AC_FK_GRP_ID_AXO_GROUPS_MAP
AC_PRIMARY_AXO_GROUPS_MAP
AC_FK_ACL_ID_AXO_GROUPS_MAP
AC_PRIMARY_ACL
AC_ENABLED_ACL
AC_SECTION_VALUE_ACL
AC_UPDATED_DATE_ACL
AC_FK_ACL_ID_AXO_MAP
AC_PRIMARY_AXO_MAP
AC_FK_SV_VALUE_AXO_MAP
AC_PRIMARY_AXO
AC_UNIQUE_SV_VALUE_AXO
AC_HIDDEN_AXO
AC_FK_AXO_ID_GROUPS_AXO_MAP
AC_PRIMARY_GROUPS_AXO_MAP
WMSYS
DSN=db001;DBQ=db001;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F;CSR=F;FWC=F;PFC=10;TLO=0;
TEMP
INDX
USERS
MappingpC
IQUE_VALUE_ACL_SECTIONS
AC_ACL_SECTIONS
_VALUE_ACL_SECTIONS
Microsoft Visio
CDBTable
AC_ACO
AC_ACO_SECTIONS
AC_ACL
CDBColumn
ARCHAR2
CHAR2
CISION
CDBCode
SE_NAMEB OUTf
SETOBf
CDBConstraint
AC_ACO_MAP
AC_ARO
AC_ARO_SECTIONS
AC_ARO_GROUPS
AC_ARO_GROUPS_MAP
AC_ARO_MAP
AC_AXO
AC_CHECK_HIDDEN_AXO
SECTION_VA
AC_AXO_SECTIONS
AC_AXO_GROUPS
AC_AXO_GROUPS_MAP
AC_AXO_MAP
AC_GROUPS_ARO_MAP
AC_GROUPS_AXO_MAP
AC_PHPGACL
CDBAggregate
CDBAggInst
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
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.
Drag to add a rectangle with connection points and text that stays level when shape is rotated.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_PE.chm!#27512
`jRectangle,Drag,add,connection,points,text,stays,level,rotated,Drawing,Tool,graphics,architectural,drawings
Graphic text box into which you can type a title and date. Drag a selection handle to resize.
Vis_SE.chm!#26880 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`xTitle,block,retro,Graphic,text,box,into,type,date,Drag,selection,handle,resize,Borders,Titles,backgrounds,buttons,blocks
Retro The theme for this shape only. Theme `*Classic;Contemporary;Elegant;Notepad;Retro
&Resize to fit text Width Scratch.X2 Height Scratch.Y2
dddddd
Vis_SE.chm!#26869 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`zTitle,block,classic,Graphic,text,box,into,type,date,Drag,selection,handle,resize,Borders,Titles,backgrounds,buttons,blocks
Classic The theme for this shape only. Theme `*Classic;Contemporary;Elegant;Notepad;Retro
Move to change feature size.
Annotations Annotations
Drag to add a text block with 12pt. font. Apply line style to make border.
make border.
Vis_PE.chm!#26204 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`x12pt,text,Drag,add,block,font,Apply,line,style,border,Annotations,surveying,textual,notes,definitions,headings,redlining
Vis_SE.chm!#26871 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`zTitle,block,contemp,Graphic,text,box,into,type,date,Drag,selection,handle,resize,Borders,Titles,backgrounds,buttons,blocks
Contemporary The theme for this shape only. Theme `*Classic;Contemporary;Elegant;Notepad;Retro
Vis_SE.chm!#26879 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`zTitle,block,notepad,Graphic,text,box,into,type,date,Drag,selection,handle,resize,Borders,Titles,backgrounds,buttons,blocks
Notepad The theme for this shape only. Theme `*Classic;Contemporary;Elegant;Notepad;Retro
Vis_SE.chm!#26875 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`zTitle,block,elegant,Graphic,text,box,into,type,date,Drag,selection,handle,resize,Borders,Titles,backgrounds,buttons,blocks
Drag to add a text block with 8pt. font. Apply line style to make border.
border.
Vis_PE.chm!#26208 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`w8pt,text,Drag,add,block,font,Apply,line,style,border,Annotations,surveying,textual,notes,definitions,headings,redlining
Use to define a foreign key between two tables in your Object Relational diagram.
Vis_D200.chm!#29885 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`QUse to define a foreign key between two tables in your Object Relational diagram.
Connector Connector
Use to connect processes in your Object Relational diagram.
press Ctrl to glue shape-to-shape.
methods.
ods.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D200.chm!#29881
`;Use to connect processes in your Object Relational diagram.
`Yuse,Connector,Dynamic,Relational,Database,connect,object,your,processes,diagram,ER,IDEF1X
Small text box used to create a note or sidebar. Drag a selection handle to resize.
Vis_SE.chm!#26855 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`{Border,small,text,box,used,create,note,sidebar,Drag,selection,handle,resize,Borders,Titles,backgrounds,buttons,title,blocks
Decorative box for notes that can be automatically sized to fit text.
y size the shape.
Vis_SE.chm!#26862 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`nNote,box,classic,Decorative,notes,automatically,sized,fit,text,Borders,Titles,backgrounds,buttons,title,blocks
&Resize to fit text Width Scratch.X1 Height Scratch.Y1
Vis_SE.chm!#26863 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`nNote,box,contemp,Decorative,notes,automatically,sized,fit,text,Borders,Titles,backgrounds,buttons,title,blocks
Vis_SE.chm!#26867 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`pNote,box,triangles,Decorative,notes,automatically,sized,fit,text,Borders,Titles,backgrounds,buttons,title,blocks
ally size the shape.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_SE.chm!#26865
&Resize to fit text Width Scratch.a2 Height Scratch.b1
`kNote,box,file,Decorative,notes,automatically,sized,fit,text,Borders,Titles,backgrounds,buttons,title,blocks
ddddd
Vis_SE.chm!#26866 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`kNote,box,neon,Decorative,notes,automatically,sized,fit,text,Borders,Titles,backgrounds,buttons,title,blocks
Drag onto page and adjust height to get 1-15 lines. Use for parts lists, title blocks, bill of materials, etc.
aterials, etc.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_PE.chm!#26205
Adjust Line Spacing
15,ruled,column,Drag,onto,page,adjust,height,get,lines,Use,parts,lists,title,blocks,bill,materials,etc,Annotations,surveying,textual,notes,definitions,headings,redlining
C:\Programme\Microsoft Office\Visio11\1031\ENTITY_M.VSS
C:\Programme\Microsoft Office\Visio11\1031\OBJREL_M.VSS
C:\Programme\Microsoft Office\Visio11\1031\BORDER_M.VSS
C:\Programme\Microsoft Office\Visio11\1031\DRAWTL_M.VSS
C:\Programme\Microsoft Office\Visio11\1031\ANNOT_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
Composite Types
Table Inheritance Table Inheritance
Categories
`&{47E37599-9648-4BC2-A6D1-07BE70223BC8}
Database Properties...
Show Related Tables
`&{30B87214-2A67-409C-B33E-C724D2617611}
`&{65D75FB8-724A-4A7E-8026-70A57975E778}
`&{C8970EFD-96CE-42CC-9171-A6FDEF6C8206}
`&{9E6EF68B-DBA9-4761-8FE8-F67FBE69AAE6}
`&{2FB39816-5693-4A14-A5A6-94BBC444B83C}
`&{DD91ABC9-1E03-43FA-BFE6-2FEA15C458E8}
`&{28D61403-BB57-439E-BBD1-1BB07F2E11B2}
`&{A6251168-BA10-4AE0-960F-94060DFEAEB5}
`&{9E80CAD6-D16D-43FF-A40D-1EE88DA9DF81}
`&{F8C29C6E-6A5D-4CC2-96A8-B037F32C2A53}
`&{78C7B96C-B085-4208-A010-2EDE77130BA5}
`&{7BBA1A50-F3EB-401E-A7CC-1C2CA2067589}
`&{9384396F-13B1-482C-9A28-AF05A943F1C5}
`&{2BA42A98-07CC-4C5A-AE8D-2BBBEDFBA4B2}
`&{3A96663D-BAE0-449D-A8A4-E5C31337C8E1}
`&{240A0EC5-6978-4D96-A93F-3349C39CD2A5}
`&{A953DFD5-C809-4488-938B-4EB0A8A84747}
`&{62792A87-6BAC-449D-BBF0-78349A7A7EA6}
`&{1435F3D8-98E1-4AB0-BCB8-160F5C4C0841}
`&{03E9884E-CEF3-4290-8167-AA2E08837A8B}
`&{2EF445CD-94E3-4EC8-A544-63F4C3210C62}
`&{7E0E11BB-2735-4CF6-91BC-692865C670B3}
P[-DT
`&{F282CF0A-31D0-4809-BDB9-BA38806299A1}
`&{B10FE780-E21D-4ED0-8E19-C349B287ADC0}
`&{AB848DA1-72BD-4D44-BA90-6B862B685480}
`&{8CAAADC1-32C3-4F8D-9393-0D81ACAE2B6A}
`&{1A2EC30B-8492-4F81-BFB8-AD0F0171EDEC}
Aa7w Aa7w
`&{722C84E2-A95A-4A46-ACD4-96569ABBDC6B}
`&{15DE77C3-3600-47C9-BDFF-D0F7D7E3F361}
`&{161AECAA-93FF-4648-8E04-D1AC0CEAD41F}
`&{5AAAC54F-4C92-464C-A96B-BAEA1F4CA8D0}
`&{ACF9AB5D-5415-4CED-8C84-5E6988B95C4B}
`&{03F583D2-E24C-4820-B9D7-42AE3E383320}
`&{C45F481A-AC68-42B6-B28B-B8E4F9E6C063}
`&{44DFDB89-2852-4A66-A8CE-1FAF437B1B94}
`&{AF355C66-E69E-4AD1-A9C9-F41A2DB6CAB1}
`&{7EA84FE6-D6F5-47A0-90B7-F08318DB1008}
DB Engineer
/CMD=1
Guide
TheDoc
Hairline
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
phpGACL Schema 2.1
Rectangle
Visio 13
Title Block Text
Visio 70
Title block retro
Theme
Margin
AntiScale
Scale
Title block classic
12pt. text
AutoWidth
WidthIncrement
12pt. text.79
12pt. text.80
12pt. text.81
Border graduated
Border Annotation
Visio 21
Title block contemp.
Notepad Foreground
Visio 20
Title block notepad
Visio 01
Title block elegant
8pt. text
Relationship.17
Dynamic connector.18
Border Dark
Border small
Border Page Number
Visio 00
Note box classic
Border Text Transparent Left
Note box contemp.
Visio 10
Note box triangles
Border Text Transparent Center
Note box file
Visio 11
Note box neon
15 ruled column
phpGACL Schema
Row_1
Row_2
Row_3
Row_4