Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
\\HK\Apple LaserWriter Select 3
PRIV
winspool
\\HK\Apple LaserWriter Select 360
LPT1:
obat 4.0\PDF Out
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.
gfffff
@@gfffff
UQamB
&JwgP
%DocTitleLong
%PageDesc
%Date %Time
Page %PageNo of %PageCount
rrayOfCells
is of
VARCHAR2
is identified by
wp_id
identifies
NUMBER
CMandatoryConstraint
anleihen
waehrungen_id
kuponfrequenz_id
kupon
CObjTypeD
aktien
CRole
CPredicateD
CElemArrayOfCells
CElemCell
CConstraintList
CUCIndexConstraint
CRoleArray
emmissionstag
DATE
emittenten_id
name
isin
laufzeitende
laufzeitbegin
anzahl
wertpapiere
depot_id
transaktionen_id
wertpapiere_id
transaktionen
kauf_verkauf
datum
marktdaten_id
depot
waehrung
user_id
emittent
emittenten
gattung
gattungen
gattungen_id
marktdaten
kurs
kurstyp_id
kuerzel
waehrungen
kuponfrequenz
kurstyp
user
passwort
vorname
Oracle 7
wp_id partly identifies anleihen
wkn identifies anleihen
isin is of anleihen
name is of anleihen
emittenten_id is of anleihen
laufzeitbegin is of anleihen
laufzeitende is of anleihen
kupon is of anleihen
kuponfrequenz_id is of anleihen
waehrungen_id is of anleihen
Table of kuponfrequenz
)kuponfrequenz_id identifies kuponfrequenz
!kuponfrequenz is of kuponfrequenz
CLogicalKey
kuponfrequenz_anleihen_FK1
Table of emittenten
#emittenten_id identifies emittenten
emittent is of emittenten
emittenten_aktien_FK1
emittenten_anleihen_FK1
anleihen_wertpapiere_FK1
Table of marktdaten
*marktdaten_id partly identifies marktdaten
CMappingGroup
Table of wertpapiere
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
%wertpapiere_id identifies wertpapiere
wp_id is of wertpapiere
.transaktionen_id partly identifies wertpapiere
depot_id is of wertpapiere
anzahl is of wertpapiere
CForeignKey
Table of aktien
wp_id identifies aktien
wkn is of aktien
isin is of aktien
name is of aktien
emittenten_id is of aktien
emissionstag
emmissionstag is of aktien
waehrungen_id is of aktien
Table of waehrungen
#waehrungen_id identifies waehrungen
name is of waehrungen
kuerzel is of waehrungen
kupon bedeutet zinssatz
gattungen_id is of marktdaten
kurstyp_id identifies marktdaten
kurs is of marktdaten
wp_id is of marktdaten
aktien_marktdaten_FK1
Table of kurstyp
kurstyp_id identifies kurstyp
kurstyp is of kurstyp
kurstyp_marktdaten_FK1
Table of gattungen
!gattungen_id identifies gattungen
gattung is of gattungen
gattungen_marktdaten_FK1
Table of transaktionen
0transaktionen_id partly identifies transaktionen
!marktdaten_id is of transaktionen
datum is of transaktionen
kauf_verkauf is of transaktionen
anzahl is of transaktionen
transaktionen_wertpapiere_FK1
marktdaten_transaktionen_FK1
anleihen_marktdaten_FK1
waehrungen_anleihen_FK1
waehrungen_aktien_FK1
aktien_wertpapiere_FK1
Table of depot
depot_id identifies depot
user_id is of depot
name is of depot
waehrung is of depot
Table of user
user_id partly identifies user
name identifies user
vorname partly identifies user
passwort is of user
user_depot_FK1
gehoert
depot_wertpapiere_FK1
liegt im
CTimeStamp
Date of last Merge
Date of last Validation
Date of 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
C:\Programme\Visio\Solutions\Database\Entity Relationship.vss
C:\Programme\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.
`&{8CE8FA84-C2CF-4171-9B5F-F820672845DF}
Database Properties...
Show Related Tables
`&{0E2CF844-685B-4328-BF49-3C4AC321773E}
`&{85CFC7ED-B850-40AA-9A64-A8E452035BF7}
`&{E2FCFE17-5B25-4F63-B93F-70DEADDF3242}
`&{140E920E-01B5-44B3-8FDD-E85B8038377E}
`&{D0586941-347E-4327-8F42-D8D4E6372509}
`&{F9B3076A-07F3-4710-939F-EAC5FAE10ACA}
`&{2F1DC379-3931-4447-9E03-D6027F7FA79F}
`&{1B315E65-1C78-4CAF-AD66-AB9526AB36E5}
?Abiã Õ?Abi
`&{BAC0305D-FC86-4EFF-819B-3ABC3B265359}
`&{A3BD6BA8-A72B-497C-A96A-B17F21D5BA09}
`&{636113DA-F785-4866-955A-2932316AB3C7}
`&{0CC23CF5-57DC-41C0-934F-93ECA5AF536E}
`&{6880B383-C1A8-4B0A-A235-3C45C53FB753}
`&{383A2CEE-2150-49CE-8718-239D6CB17EBB}
`&{A9CBAE52-C796-4D3B-BBA8-DCE10D571FAF}
A v<N$ Õ?A v<N$
A v<N$ A v<N$
`&{B71C3E23-C1E0-46BA-BA1B-C27FEDE1D097}
`&{774A26A5-5067-47E2-B983-F4696B3A5B22}
`&{E109EC3A-32D0-4B54-8F2C-175A6DED71DA}
?AdM Õ?AdM
`&{24640031-A0A1-40A4-87E8-D951A3EA8BBD}
`&{55CF022F-6151-426D-BAB3-CAB9A708B408}
`&{195EA245-54B9-4514-81F9-09939CD3093B}
`&{07CC4CF3-1404-449C-ACBB-2C7B60072093}
`&{37F149B7-19A5-4B9B-9B7A-8F8E96DDC297}
`&{89FDC606-0AFE-4C31-A737-C8B6CAA4F7C5}
P!-DT
`&{32D010A1-C6C6-4784-8A98-5FFAA779659B}
`&{FCBF018D-3BCD-4D72-BCFF-0CD34E832E9C}
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
ER-Diagramm
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
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.DL
L#MicrosPoft
Object L
ibrary/
DF-7EE5-
A1DE-
27DA173C
DBB@
FXDOK
UME~1\hk@\LOKAL
emp\VBE\
R.exd
VIS XDATA@F>
8C5-11D1 -B7F5@K60
Prog
ramme\Vi
sio\Solu
Extr
!.dll#
Type
DB-994C-
1535574Bx5AC
b}ThisD
ocumentGD
u@neT
EngineerF
_B_var_Engineer
\ThisDocument
ID="{E5E4FD9C-652A-11D2-BBFA-006008BF0962}"
Document=ThisDocument/&H00000000
Name="Database_Model"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="0002EDEBF1EBF1EBF1EBF1"
DPB="AFAD42355E4B0C4C0C4C0C"
GC="5E5CB3E6CD3A7D3B7D3B82"
[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
0000-0000-C000-000000000046};Visio