Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
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.
i}dY
Tqm,
kg N
%DocTitleLong
%PageDesc
%Date %Time
Page %PageNo of %PageCount
CEle
CTimeStamp
Date of last Mer
blog
is of
blog_frontpage_content
blog_last_generated
template_ID
INTEGER
blog_use_stats
blog_use_in_stats
CMandatoryConstraint
blog_number_of_posts_unity
blog_number_of_posts_unit
CObjTypeD
blog_allow_comments
CRole
CPredicateD
CElemArrayOfCells
CElemCell
blog_comments
blog_blogs
blog_
blog_it_display
CConstraintList
CUCIndexConstraint
CRoleArray
blog_creator_IP
blog_sponsor
blog_category_ID
blog_comment_order
blog_hitcount
blog_number_of_posts
blog_basic_language
blog_nickname
blog_description
blog_title
blog_creation_time
blog_creation_date
use_basic_template
is identified by
blog_ID
identifies
blog_basic_templates
template_author
template_thumbnail_picture_ID
picture_ID
template_freezones
template_content
is partly identified by
template_name
partly identifies
blog_templatesCol1
blog_categories
blog_categor
blog_category_nl
blog_category_fr
comme
comment_IP
comment_url
comment_author_email
comment_author_nickname
comment_time
comment_title
comment_date
comment_content
post_ID
comment_ID
blog_freezones
sidebar_num
freezone_num
sidebar_ID
freezone_ID
blog_posts
post
post_category
image_ID
post_title
post_content
user_ID
post_time
post_date
blog_users
blog_used
user_email
user_master
user_text_editor
user_nickname
user_PUID
blog_last_visitors
visit_time
blog_objects
has object_name
object_name
object_name_nl
object_name_fr
object_table_name
object_ID
blog_objects_instances
object_instance_position
is iden
tified by
object_instance_ID
blog_objects_variables
object_variable_value
object_variable_name
object_variable_ID
blog_pictures
picture
picture_content_thumb
filety
filetype
picture_height
picture_width
picture_size
picture_content
picture_name
blog_settings_archive
settings_order
type
blog_settings_archiveCol1
blog_settings_archive_ID
blog_settings_counter
settings
coun
counter_type
blog_settings_counter_ID
blog_settings_freetext
content
title
blog_settings_freetext_ID
blog_settings_linklist
link
linktext
blog_settings_linklist_ID
blog_settings_picture
resi
resize
object_
blog_settings_picture_ID
blog_settings_rssfeed
number_of_stories
show_channel_link
show
show_xml_image
title_characters
description
description_characters
blog_settings_rssfeed_ID
CMappingGroup
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
CForeignKey
CLogicalKey
Date of last Validation
Date of last Mapping
Date of last MergepC
Date of last ValidationpC
Date of last MappingpC
hphil
Database Model Document
Visio 2000
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
Connector Connector
Use to connect processes in your Entity Relationship diagram.
ess Ctrl to glue shape-to-shape.
methods.
ods.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D200.chm!#28126
`;Use to connect processes in your Object Relational diagram.
`Yuse,Connector,Dynamic,Relational,Database,connect,object,your,processes,diagram,ER,IDEF1X
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.
`: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.
Composite Types Composite Types
Use to add a composite type to your Object Relational diagram.
Composite Types
Vis_D200.chm!#29887 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Composite Type
`-Set to hide the primary key columns section .
`!Set to hide the column datatypes.
`NSet to hide the vertical lines seperating the annotation or datatype sections.
`ZSet to hide the vertical line seperating the primary key section from the columns section.
``Set to allow free form edits to the entity shape (manual edits are not maintained in the model.)
`,Set if the Entity is dependent upon another.
Shape's version number
User.DBHideAnnotations `:This fomula conditionally sets the DBHideAnnotations flag.
User.DBHidePKRow `5This formula conditionally sets the DBHidePKRow flag.
User.DBHideTypes `5This formula conditionally sets the DBHideTypes flag.
User.DBHideVerticalLines `=This formula conditionally sets the DBHideVerticalLines flag.
User.DBHideHorizontalLine `>This formula conditionally sets the DBHideHorizontalLine flag.
`?Set if this Entity shape represents a Typed table in the model.
`>Use to add a composite type to your Object Relational diagram.
`HAdd,use,type,Relational,Database,object,your,diagram,ER,IDEF1X,composite
Show Related Types DB Engineer /CMD=1002
Table
View
Type
`nTRUE if DBNotation = IDEF1X, or DBShapeType = View, or DBHideVerticalLines = TRUE, or DBHideAnnotations = TRUE
`9TRUE if DBHideTypes = TRUE, or DBHideVerticleLines = TRUE
`QTRUE if DBHideHorizontalLine = TRUE, or DBHidePKRow = TRUE, or DBShapeType = View
7 - Types
`HTRUE if DBHideTypes = TRUE, or DBHidePKRow = TRUE, or DBShapeType = View
6 - PKTypes
Char.Style
`OTRUE if DBHideAnnotations = TRUE, or DBNotation = IDEF1X, or DBShapeType = View
4 - Annotations
`eTRUE if DBHideAnnotations =TRUE, or DBHidePKRow = TRUE, or DBShapeType = View, or DBNotation = IDEF1X
3 - PKAnnotations
2 - Columns
`4TRUE if DBHidePKRow is true or if DBShapeType = View
1 = PKColumns
5 = Name
Categories Categories
Use to connect a parent table to a category in your Object Relational diagram.
table.
Vis_D200.chm!#29884 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Categories
Parent Category Connector
`LSet to allow free form edits (manual edits are not maintained in the model.)
Shape's version number.
`NUse to connect a parent table to a category in your Object Relational diagram.
`Suse,Relational,Database,Category,connect,object,your,table,diagram,ER,IDEF1X,Parent
Type Inheritance Type Inheritance
Use to add a super-/sub-type relationship from a parent type to a child type in your Object Relational diagram.
he child type.
Vis_D200.chm!#29888 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Type Inheritance
`(Unique ID used internally by the add-on.
Set to Hide the shape.
`LSet to allow free-form edits (manual edits are not maintained by the model.)
`oUse to add a super-/sub-type relationship from a parent type to a child type in your Object Relational diagram.
`sAdd,use,child,type,from,Relational,Database,object,your,Sub,Relationship,diagram,ER,IDEF1X,Parent,inheritance,super
Table Inheritance Table Inheritance
Use to add a super-/sub-table relationship from a parent table to a child table in your Object Relational diagram.
the child table.
Vis_D200.chm!#29886 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Table Inheritance
Set to hide the shape.
`rUse to add a super-/sub-table relationship from a parent table to a child table in your Object Relational diagram.
`tAdd,use,child,from,Relational,Database,object,your,table,Sub,Relationship,diagram,ER,IDEF1X,Parent,inheritance,super
`$Set to hide category discriminators.
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.
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.
`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 the Entity shape to represent a table in your database schema.
Vis_D200.chm!#20000 `7Copyright 1999 Visio Corporation. All rights reserved.
Database Properties... `2Edit the database model properties for this table. DB Engineer /CMD=1001
Show Related Tables `0Connect this table to all of its related tables. DB Engineer /CMD=1002
Edit Table Name... Edit the table's name
Edit Column Text... Edit the table's column text.
Show Lines `<Set to display lines seperating PK's, Annotations, and Types User.DBHidePKSeperatorLine User.DBHideTabLine1 User.DBHideTabLine2
D:\Program Files\Visio\Solutions\Database\Entity Relationship.vss
D:\Program Files\Visio\Solutions\Database\Object Relational.vss
`&{85808F8D-C585-4C23-8DBB-4265EC943EFF}
Database Properties...
Show Related Tables
`&{A51393A6-5B74-4621-9151-5989B615AFC0}
`&{337EE1B2-36C8-4C40-89BB-C20941D3F52B}
`&{C2329847-554D-431D-A90C-511A06CDD8EB}
`&{B1A38D95-7C1D-4440-B98E-A0CC1EAE3D50}
`&{8CFCEC38-9229-44FD-8767-7DE44CC23F20}
`&{C97A1C49-E1AC-4226-A7C7-9C3D2A48E6D7}
`&{E8F6938F-4CDC-4C24-88DC-DF7E0F117136}
`&{C06342D3-41DE-410E-A2BA-3BFBDA16AB10}
`&{3CE50F7B-7CDF-49FA-AB7D-DF85BC8BC45C}
`&{3E567FC5-2834-4B1E-99BD-80856BCB7481}
`&{AB7D52AB-B747-4DC8-89FA-225DCD4C3BED}
`&{1BD90744-7A6B-4BFF-8F37-140B437E5295}
PJV0
?FOj
`&{6C84DD64-0579-41D2-9441-3E0134BAB523}
`&{D072E4DE-BF54-4608-9475-E4C7934A1520}
`&{EA54B644-B280-46A7-A154-716D2CF67B46}
`&{0F1AA00C-7D7E-41E1-BF69-74E766940652}
?FRR
`&{74ADBF40-8732-41C1-AA4E-20118C1B34E9}
`&{3EB49C3F-E981-45E2-835E-F3FB04471243}
x?F~R x?F~R
`&{ACCD5A88-8A25-463F-A063-C88A4C15AC5E}
`&{2FFC84B4-5710-41AE-819F-C61A4A3F4C10}
F{vt ÀF{vt
`&{7A11B32D-C5F0-4D1A-B077-2805521D14DE}
`&{00DAD7D3-676B-4E20-8AB0-8AB64E7216C9}
`&{E104FB69-A0CC-4DA3-8549-B6072D923F89}
`&{00A90684-6773-46A9-8AE9-B483CFDAD0E8}
`&{DCD5F236-FDDD-44F7-8B2E-3033E22BAC7C}
FS;l?X ÀFS;l?X
`&{F4AAF417-A9F2-4CF9-874C-3695DF824D8B}
`&{F94E3B6E-F85A-4786-BF5F-581AE8EB4F40}
`&{57035F2F-BDA2-46A7-9E78-06AA9CA22F44}
`&{9D93AE6A-B0DA-41C8-AEA3-8BC54BAB959C}
`&{45019BE0-7856-4E01-B2DA-61F1D4B15BDA}
`&{0E134DA2-10A7-4B6C-B015-053615CE0450}
`&{F91223EA-C2B1-49D8-9A9E-97F59E1156CE}
`&{73595B8D-AFCB-4137-9969-7D64598BB10B}
DB Engineer
/CMD=1
SGView
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
Dynamic connector.9
Relationship.10
OverrideDBHideAnnotations
OverrideDBHidePKRow
OverrideDBHideTypes
OverrideDBHideVerticalLines
OverrideDBHideHorizontalLine
TypedTable
PKRowHeight
NonKeyRowHeight
AnnotationColWidth
ColumnColWidth
TypeColWidth
PKStyle
NameStyle
Parent to category
Type inheritance
LockMove
Table inheritance
DBComplete
OverrideDBHideDescriminator
Parent
Child
Entity.16
Attribut
e VB_Nam
e = "Thi
sDocumen
|Global
Spac
dCreat
Pred
ecla
BExpo
Templ
ateDeriv
Bustomi
Visio
Win16
Win32
VBA6
Project1
stdole
blog_databaseX
ThisDocument<
_Evaluate
EngineerF
_B_var_Engineer
_B_var_DB
Documentj
blog_dat@abase
rstdol
0#C:\WIN
DOWS\Sys@tem32\
.tlb#OLE
AutomatXion
hisDocum@entG
ThisDocument
ID="{765B1F49-2F1C-4B28-AF08-B1EC14B31DD8}"
Document=ThisDocument/&H00000000
Name="blog_database"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="AAA85F370D3B0D3B0D3B0D3B"
DPB="5456A1E1E18AE28AE28A"
GC="FEFC0B5B1FAFC8B0C8B037"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000