Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
\\Nps\netops
Letter
DINU"
winspool
Relationships
Tracking text is used to annotate the Relationship shape.
`9Copyright © 1998 Visio 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.
Use the Relationship connector to define a foreign key between two tables.
Vis_D200.chm!#20000 `7Copyright 1999 Visio 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
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.
VUUUU
@VUUUU
YY]V
V'xR&D
boar
is of
board_model_id
%DocTitleLong
%PageDesc
%Date %Time
Page %PageNo of %PageCount
rrayOfCells
CTimeStamp
Date of last Merge
Date of last Validation
slot
chassis
chassis_id
is identified by
identifies
board_id
board
port
Ql}I
ynT%
snmp_agent_id
CObjTypeD
action
CRole
CPredicateD
CElemArrayOfCells
CElemCell
syslog
username
user_id
CConstraintList
CUCIndexConstraint
CRoleArray
date
allowed_functions
func
function_id
CMandatoryConstraint
user
port_model_id
ifin
ifindex
board_model
mandatory
name
board_ports_model
model_model_id
chassis_boards_model
chassis_model_id
building
comment
loca
location
building_id
closet
description
cable
jack
media
media_id
port_id
closet_id
desc
switch
swip
snmp_agent
chassis_model
ifinde
ifindex_formula
default_enumerated_value_id
default
misc_enumerated_setting
misc_model
table
default_string_value
port_string_setting
model
default_string_value_id
has default
misc_string_setting
misc
defaultp
port_enum_group_profile
port_enum_group_id
functions
global_attributes
value
version
hash
time
password
port_enum_group_value
port_enum_value_id
port_enum_group_profile_id
port_enum_value
port_enum_setting_id
label
port_enum_setting
port_enum_group
misc_enumerated_value
misc_enumerated_setting_id
misc_string_value
misc_string_setting_id
othe
misc_id
port_profile_instance
profile
port_profile_id
lan_type
port_model
lan_type_id
interbuilding_jack
jack2_id
jack1_id
port_media
misc_enumerated_glue
misc_enumerated_value_id
port1_id
uplinks
port2
port2_id
port_enum_group_profile_instance
port_enumeration_value_id
value_
port_profile_enumeration
profile_
port_string_value
setting
port_string_setting_id
ODBC Generic Driver
CLogicalKey
CMappingGroup
CRolePath
CAggregateInst
CMappingNodeList
CAggregate
CMappingNodeArray
CForeignKey
]Same as misc_string_setting, except stores enumerated values instead of simple string values.
kThe actual value. misc_id is the foreign key of the appropri
ate table as indicated in misc_string_setting.
Used for storing string-type configuration settings on secondary tables, currently buildings, closets, chassis, boards, and jacks. table indicates which of the above this setting applies to, misc_model which model (if applicable - chassis and boards).
Holds only a single row - the version of the database schema. This was done in a single table, since that's the best way I can think of to make sure that the version is forcably associated with the database itself, and not stored seperately in a config file.
>Glue table indicating which users can perform which functions.
Users and the crypted passwords, of course. Time is the last time they performed an action (used for seeing if their session has expired) and hash is used to store the hash to send back and forth to the browser.
`Contains the date in time_t format (ie, seconds since Jan 1 1970), and who did what from where.
-An indexed list of functions and their names.
Date of last Mapping
odel Document
Visi
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 the Entity shape to represent a table in your database schema.
Vis_D200.chm!#20000 `7Copyright 2000 Visio 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.
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
`7Copyright 2000 Visio 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... Edit the table's 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.
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
Q(-DT Q(-DT Add text here.
C:\Program Files\Visio\Solutions\Database\Entity Relationship.vss
C:\Program Files\Visio\Solutions\Database\Object Relational.vss
Categories
Table Inheritance Table Inheritance
Composite Types
Type Inheritance
`$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.
`&{F86E0DA3-B31D-4C0F-84CF-F8B2E61F3ED1}
Database Properties...
Show Related Tables
`&{C3122A2E-90BD-4ECF-BA74-FE796E5425EC}
`&{27126AFF-F62E-457B-B378-4ABDD3D9C66C}
`&{A0643E1C-0ABC-4CB7-9C26-C99240857F10}
`&{92A48D77-91F7-4E22-A1D7-4161519E126E}
`&{AD8EE473-0DE7-4764-A4A4-C20EC1962A3A}
`&{D034294B-25BA-4C9D-B6DB-02BB6EC72702}
`&{12C05E6A-BB3A-46BB-B5A3-63CF3C2F8460}
`&{0E68DD49-FA6B-451E-9D71-819DE233B380}
`&{2C0BAE02-3FE5-477F-AD1C-97DBA9D1B0A2}
?AJL
`&{6F7484CB-0B67-4D01-8B7E-0440BEDF31D6}
`&{3D1E9AE7-37C2-4DBE-A58F-3CDEB19AD272}
`&{6787BE52-0DC8-46D9-B158-0D469204B746}
`&{DE7B2EAD-39C8-407C-833B-F8F782508167}
`&{49FBFC60-132A-4B71-AB65-7EB5BD6765A0}
`&{0FA78BE2-C701-400F-A3C5-D60E59595D56}
`&{48607A7F-AE85-4D5E-96DB-3A4B6AA48BC0}
`&{9A35E70C-24F6-4079-B0FB-E2C2F47B00B7}
`&{DC13254A-836C-4D0B-8E18-477EAA308194}
`&{78AAC3B2-E571-4910-AE4B-7AA44083C2CD}
`&{3DD2C07B-D19F-4976-BEDC-BA8304D99BC8}
`&{87585D37-AF6A-452E-9102-5791E1302018}
`&{AE71677E-68DA-4D1A-A434-DB63ECD9209A}
PF-DT
`&{8C3417EF-F492-4057-B0B9-93AF2B6FD932}
`&{27569AB3-5278-4426-BD94-886BF058D057}
mmv{# mmv{#
`&{75DC75A3-47BF-4550-9095-5C0499659A03}
`&{D867C2E6-E9C1-4CED-A881-77E6C585B060}
`&{7373DDC1-5BB8-4413-8FA1-0C97F93C10FA}
`&{3F1D565D-B938-4A56-BE28-52871E44D094}
`&{DC25ED4B-16D6-4C4A-A8ED-DD32C3C17B2F}
`&{69035A2A-F453-449E-9FFB-A9F328E29BE4}
`&{B36CAF75-D3A6-4E0F-B0E0-8C9D0AFFEBBB}
`&{43C7FA1A-9C7D-47BE-A0B2-E87E51812B84}
`&{47184D5D-66AB-4DAF-B09D-095933981226}
`&{F029AB6E-C57A-4143-AD89-F3380402D372}
`&{4E7E2CDE-883B-403B-959F-213C6CAE09AF}
`&{F306CE49-1966-4608-8BAF-08305C079AA2}
`&{E502DF48-CC53-4364-833B-4D8E1DF60193}
`&{BBACB026-9CF2-4D48-B983-A8811DC180A3}
`&{36EB0255-4B9E-479A-B29C-BBB37F99E315}
`&{7565B7F7-640C-4154-B2AC-FE209E55499D}
`&{3D9305AE-D58E-46EB-A95F-13F24890F00F}
`&{13665D20-5270-4011-A09A-A36C22DEC581}
`&{8CEDD6FD-4A71-47FF-88CC-07D88D9FDC44}
`&{CB5B1D1C-01A3-4DEC-AB69-A52FE3AB6984}
?AABÃ0 Õ?AAB
`&{27393F18-DC3F-408B-AAB9-540D8CF19330}
`&{0CC43696-F92F-49E9-A24A-3D00645C0236}
`&{69C2E0F3-F483-4558-93EB-68A2F473EC37}
`&{26071969-F461-41FF-B447-7AAADFC92A60}
`&{525D39BF-9845-4996-ADC0-661A4EB9E276}
`&{8D6FA8DD-9BB2-4CCF-9399-C3B6AC1EDD55}
`&{E372CB46-CB45-4BC6-A894-849E6AC3D046}
`&{854D2F35-11B2-46CA-821D-91EFC1983AF3}
`&{D28F68A0-93E8-402C-8916-375996228C8E}
`&{50BC3274-1D21-469C-8983-78DBD2252919}
`&{6B9AE33E-2125-4B9F-815F-41DA27B2B85B}
`&{CAB8380E-58F0-429B-B761-3ECC2DEFF734}
P"-DT
`&{31DDDA7E-D2F8-4C96-A07D-F094453239C7}
`&{D8FD1DD4-A43A-4D00-A42F-7CCDB2A6C803}
`&{0CFC191B-C0E7-4850-849B-D5665C968858}
`&{D84A16D1-6D2B-42C4-BDB4-355EB68E5FDB}
`&{E12257DF-40DE-48EF-B4CA-A1FEA962AA9E}
`&{287A503E-7BA7-4872-8B04-5636C8870D78}
`&{A890FD04-1776-413D-A2EE-5E2CE967CFC4}
`&{6B69B574-0183-4DAF-BD91-2983BEB2E897}
`&{C9B6B401-BC6B-43A8-9406-576F84A9E648}
`&{A7AEECB5-6C51-497D-B9D9-1A62519AB3CA}
`&{8E72FCF5-5B8F-412D-9EC0-E82A6E075E9D}
`&{B10FC602-BF39-4758-AD57-860CD2E793D8}
`&{8980414B-0B0A-4426-BB35-F5FEF5B615F5}
`&{45EC309D-E6D1-45C9-A932-BC85CDE26DD0}
`&{648EAD52-FC8D-4D53-8894-4312F95D9B30}
`&{5D40C984-6790-443D-8C99-B7F1B2EB7AAA}
`&{C428A30B-E574-4ED7-B31A-0030A31DDA47}
`&{67F02855-B2ED-4596-B56A-7017772CD166}
`&{94BF3603-D990-4484-9D65-A70C3C50F6A5}
`&{264DE6B7-3ED8-4065-96A3-A08F32192F1F}
Page-1
Connector
Dynamic Connector
DBNotation
DBCrowsFoot
DBHideRelationships
Database Model
VisioExtendedData1
Visio Extended Data
DBDependent
White line
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
Relationship
DBHideDiscriminator
DBHideRelationshipText
DBHideAnnotations
DBHidePKRow
Arial centered
Arial top left
Arial top
Times centered
Times top
Times top left
DBHideTypes
DBHideVerticalLines
DBHideHorizontalLine
DBShapeType
RefShapeGuid
Identifying
CrowsFoot
Optional
Override
ManualEdits
OverrideDBNotation
EndAngle
OverrideCrowsFoot
BeginAngle
RITextRefGuid
CardTextRefGuid
Tracking Text
DBEventTrigger
OldPinX
OldPinY
Hide
SetPinX
SetPinY
RefSheetID
RefControl
Guide
DBCardinality
Gesture Format
DBShapeVersion
VisioExtendedData2, 268293, 1, VISXDATALib, VisioExtendedData
Attribut
e VB_Nam
e = "Thi
sDocumen
|Global
Spac
dCreat
Pred
ecla
BExpo
Templ
ateDeriv
Bustomi
2Contr
Visio
Extended
VISXDATA8Lib
Win16
Win32
VBA6
Database_Model
stdole
MSFormsC
VISXDATALibY
ThisDocument<
_Evaluate
VisioExtendedData23
Documentj
Database
_Model
rstdo
WINNT\Sy
stem32\S
TDOLE2.T
Aut
omation
MSF orms>
452EE1-E
8C4D0BB4
DFM20.DL
L#MicrosPoft
Object L
ibrary/
A1-BC32-
48D3-A4C
8-06FDC3@7A49A2
OCUME~1\
fs\LOCAL
Temp\V
R.exd
VISXDATA
2FE9117F
6-98C5-1D1D@57F5@K6
gram Fil
es\Visio`\Solu
`Extra
".Pdll#
pType
>ACB
BFF8-D75
q7CC-883
E94BxBB9@
}ThisD
ocumentGD
h`9sA ;o
ID="{E5E4FD9C-652A-11D2-BBFA-006008BF0962}"
Document=ThisDocument/&H00000000
Name="Database_Model"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="9B9976D1C9D5C9D5C9D5C9D5"
DPB="F2F01F8A778B778B77"
GC="494BA439A539A5C6"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000
&H00000002={000D0D06-0000-0000-C000-000000000046};Visio2000;&H00000000
[Workspace]
ThisDocument=0, 0, 0, 0, C
ThisDocument
DB Engineer
/CMD=1