Arial
Times New Roman
Monotype Sorts
Wingdings
Symbol
CutePDF Writer
Letter
PRIVB0
winspool
CPW2:
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 `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
?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
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.
Database Model master stores embedded model information.
gB2A
[XDpqF
,pFB
K+L=d
%Date %Time
Page %PageNo of %PageCount
is of
www site
Name
is identified by
identifies
Address
Customers
Type
is partly identified by
Bonu
partly identifies
BONUS_ID
CObjTypeD
Additional information
CRole
CPredicateD
CElemArrayOfCells
CElemCell
Uwagi
CConstraintList
CUCIndexConstraint
CRoleArray
Wyroznienia
Poda
Ponad godziny
Wyniki w pracy
EMPLOYEE_ID
CMandatoryConstraint
Addrew
Company
E-mail
Mobile P
Mobile Phone
Tele
Phone
CUSTOM
Adress
Holidays
Telepho
Telephone
Length
Countrt
Country_ID
HOLI
HOLIDAY_ID
Street
Shops
Province
CITY_ID
NAme
Shop_ID
Employes
Sala
Type of work ? P/C
DEPARTMENT_ID
Telephone Mobile
Telephone Home
Surm
Surname
Advertise
Sponsor_ID
is ident
ified by
ADVERTISE_ID
Sponsors
requirements
Capital
Capital given
TYpe
SPONSOR_ID
ADVERTI
"CONNECTIONS ADVERTISEMENTS TO CITY
Leng
Cities
Tel Kierunkowy
State
Bonuses
Discount
Discount %
Capacity
Transport Trucks
WEREHOUSE_ID
Last
Last time checked
DATETIME
TT_ID
Werehouses
E-Mail
Telepj
CITY
Departments
DepartmemntsCol1
Continent
Conti
Country
COUNTRY_ID
Contract
wage value
INTEGER
Contrator
Countity
Goods
Gvar
Warranty Length
Producet
PRODUCER_ID
GOOD_ID
Cuntry
Producers
tele
telephone
www si
PRODI
PRODUCES_ID
CUSTOMER_ID
Orders
Date
Order
ORDER_ID
SHOP_ID
Parmanent
Sallary value
Entity1
Quanti
Quantity
ORDER_
PRODUCT_ID
PERSO
Person
CTimeStamp
Date of last Merge
Date of last Validation
Date of last Mapping
Date o
%DocTitleLong
%PageDesc
CLogicalKey
CMappingGroup
Table1
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
CForeignKey
CCategory
f last Mapping
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.
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
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
?FkkÁ Õ?Fkk Q(-DT Q(-DT Add text here.
Q(-DT Q(-DT Add text here.
`$Set to hide category discriminators.
Categories
Use the Category shape to specify that one or more tables are "types" (categories) of another table.
Edit Discriminator
Complete Category
Show Discriminator
Database Properties... `+Edit the model properties of this category. DB Engineer /CMD=1001
Edit Discriminator `'Edit the category's discriminator text.
Show Discriminator `8Display the name of the category's discriminator column. User.DBHideDiscriminator User.Override
Complete Category `FSpecifies that this category represents all types of the parent table. 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
Reposition Discriminator Text
Use the Parent to category connector to connect a category shape to its parent table.
Parent Category Connector
`LSet to allow free form edits (manual edits are not maintained in the model.)
Shape's version number.
Database Properties... `4Edit the model properties of the connected category. DB Engineer /CMD=1001
Use the Category to child connector to connect a category to a child table. This defines the child to be a "type" of the category's parent table.
Database Properties... `9Edit the model properties for this category relationship. DB Engineer /CMD=1001
Child Category Connector
`LSet to allow free-form edits (manual edits are not maintained by the model.)
Unique ID used by the add-on.
Connector
Connector with up to 5 legs. Glue shapes point-to-point, or press Ctrl to glue shape-to-shape.
methods.
ods.
`7Copyright 1999 Visio Corporation. All rights reserved. Vis_D200.chm!#20000
G:\Program Files\Visio\Solutions\Database\Entity Relationship.vss
G:\Program Files\Visio\Solutions\Database\Object Relational.vss
Table Inheritance Table Inheritance
Composite Types
Type Inheritance
`: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.
`&{82D0DB2A-0BDF-48C5-A30B-59B7693EB6E6}
Database Properties...
Show Related Tables
`&{1D030738-ABFC-40D9-A84E-EDC662017531}
`&{C79C8967-A8C6-4679-8558-02849B0EAAAD}
`&{3237BA76-299B-4C13-836B-7969B595B0F3}
`&{6B81FB55-1C0F-4144-A6C3-6EBBE3BCDB06}
`&{8B4D4D6E-27E1-4807-966B-BD033FA582F6}
`&{EEB1EDB0-3189-4D16-857C-F50CA31929CE}
`&{2156A1FF-3400-47BB-A5E0-8C054BAF1B89}
`&{32426788-8F41-4FBC-97BA-C59B92673F5E}
`&{4A6380C4-C50B-4B18-A7BD-DAD07DAB2FFD}
`&{6DD66228-E678-4751-883A-27125BD8FB95}
`&{6B28C3AF-4590-4B7A-94A5-D9F7F70EA061}
`&{CEAA77C1-C462-42BD-B3A1-E3054B2B4C3D}
`&{25815AD8-FB59-4C73-9A00-5773988DD655}
`&{6D20086C-7ABB-4BBE-9E24-8C957F95CE83}
`&{D5873B61-A201-40B0-A9AD-FAEA1FBFF3B2}
`&{283EDAA4-DC6E-48B6-B0C3-ED3AF428AA9D}
`&{C06519B4-DA22-4CBF-B7B2-B485F64F4DF9}
`&{9245F62B-702C-4246-8528-1BF4CBE959D0}
`&{36A7F3DD-C5EA-4608-BD22-7204179BEE11}
`&{66A90716-63C3-40F0-A9B7-269E834FB77B}
`&{FC3B5622-D02F-4553-9BFC-208A5288CFBC}
`&{0B3DF943-8030-4263-B5AE-38B0EB56691C}
`&{18908E60-97FA-4F99-A850-9E80ED2FAC6C}
`&{F6BB3C72-A315-4593-8D46-E58FB79D0E15}
`&{07519E68-87C9-420F-9810-9D5CC6BE0CED}
`&{840EABBE-E8DB-4C48-B762-0BE87B662F13}
`&{93284E9F-D57C-4400-A75A-D1099CD41250}
`&{005CDFAF-5716-4539-8483-E6C005617B3B}
?FJD
`&{298F3DBF-7689-48D6-B57C-3E42C4658E25}
`&{24C63232-972D-4C78-A072-66312ABCEEA6}
`&{585BFEA1-7044-4671-8080-55007724D8ED}
`&{FCD1A754-2DF6-47DB-91CF-CFE6BECD9040}
`&{972BF1F5-EEB3-420A-BF8E-162F9023FA76}
`&{4EC18875-6E0F-450A-85C5-AB9AD049099A}
`&{C43EBBF0-6CA3-471E-83BA-F465BD9A9BF9}
`&{C434BD39-46E4-4C87-9D42-E8762E353C78}
`&{F14C9B2B-A741-465B-8047-F6A0BEB3B8C8}
`&{131B7BCE-B3BA-4675-ABE7-DBF500A09C41}
`&{AA075428-63EC-469F-A930-6EFFB5CF8111}
`&{C21E8B62-6944-489E-BEEC-264A92A18BAB}
?F7;5:hXÏ¿Fàgm¯o©Ó?F7;5:hX
F8;5:hXÏ F8;5:hX
`&{FA5DFEC2-5CD3-4E7F-874E-13DE299DD461}
`&{B288EBC5-8F98-466E-B960-5782338E6985}
Pb-DT
?FzS
?FvS
`&{A90481DD-F6E1-431C-A1D1-434C802DBD19}
`&{62ABC259-C570-4D34-9C65-F47C55054E83}
`&{0F2D8494-102F-4791-9496-7C29F3391FA8}
`&{EEF3B365-04A0-4A20-8ECE-EDFEEE461FE0}
`&{197CF8F6-1820-4292-9F3E-7D366A1306A9}
Page-1
Dynamic Connector
DBNotation
DBCrowsFoot
DBHideRelationships
Database Model
VisioExtendedData1
Visio Extended Data
DBDependent
White line
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
Relationship
DBHideDiscriminator
DBComplete
OverrideDBHideDescriminator
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
Parent
DBShapeVersion
Child
Entity.36
Parent to category
Category to child
Dynamic connector.12
DB Engineer
/CMD=1
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.
DLL#Micr@osoft
\ Object
Library
-49C1-B8@19-E1A
-5 EB2EB
Mp\VBE\
E.exd -
VIS XDATA
=\\PJWS
TK\apps\
Program
Files\Vi
sio\Solu
Extra
D%.dll#
Type?d
D35FA44B
C66-D01E
E2A5B
DOCUME~1
\s3672\L OCALS
hisDocum@entG
2ID="{E5E4FD9C-652A-11D2-BBFA-006008BF0962}"
Document=ThisDocument/&H00000000
Name="Database_Model"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="62608FF14FF54FF54FF54FF5"
DPB="1E1CF3B513CDCECECECECE"
GC="DAD83779F27AF27A0D"
[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