DB Engineer
/CMD=1
Tracking text is used to annotate the Relationship shape.
10 = Tracking Text
DB Engineer /CMD=1003
guard(pntx(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
guard(pnty(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
0 = IDEF1X; 2 = Relational
Overrides 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.
Set 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.
Relationship (Foreign Key)
Unique identifier used by the add-on.
Set to indicate the relationship is an 'Identifying Relationship'.
25=exactly one, 28=one or more, 29=zero one or more, 30=zero or one
Set to indicate the relationship is optional.
Set to override Database | Document | Options locally for this relationship shape.
Set to allow free-form editing (manual edits are not maintained in the model.)
This formula conditionally sets the DBNotation setting.
Calculates a reference point for Relationship text.
This formula conditionally sets the CrowsFoot notation flag.
Shape's version.
reference to associated text shape
Locate referencial integrity text here.
Locate cardinality text here.
Relational Notation
IDEF1X Notation
Crow's Foot Notation
Database Model master stores embedded model information.
Copyright (c) 2003 Microsoft Corporation. All rights reserved.
&DocTitleLong
Arial
&PageDesc
&Date &Time
&PageNo
BLOB
Date o
LONG
UGRPInfo
MAPInfo
TSTAMPInfo
SourceDocs
BINARY_FLOAT
BINARY_DOUBLE
DOUBLE PRECISION
VARCHAR2
LONG RAW
BFILE
CLOB
NCHAR
NVARCHAR2
NCLOB
is of
WWV_FLOW_TREE_ENTRY
WWV_FLOW_TREE_SUBS
NUMBER
NAME
LINK
KIDS
INDENT
EXPAND
AGE_IN_YEARS_NUM
PATIENT_DIMENSION
UPLOAD_ID
DECIMAL
SOURCESYSTEM_CD
VARCHAR
IMPORT_DATE
DATETIME
DOWNLOAD_DATE
UPDATE_DATE
PATIENT_BLOB
CHAR
STATECITYZIP_PATH
ZIP_CD
RELIGION_CD
MARITAL_STATUS_CD
RACE_CD
LANGUAGE_CD
SEX_CD
DEATH_DATE
BIRTH_DATE
VITAL_STATUS_CD
is identified by
PATIENT_NUM
identifies
ANYPART
XDB$DOCUMENTATION_T
XDB$DOCUMENTATION_LIST_T
DOCUMENTATION
XDB$ANNOTATION_T
ANNOTATION
XDB$ATTRGROUP_REF_T
SYS_XDBPD$
XDB$RAW_LIST_T
XDB$ATTRGROUP_DEF_T
ATTR_GROUPS
XDB$XMLTYPE_REF_LIST_T
ATTRIBUTES
ANY_ATTRS
XDB$XMLTYPE_REF_LIST_TField1
XDB$PROPERTY_T
PROPERTY
XDB$ANY_T
PROCESS_CONTENTS
XDB$PROCESSCHOICE
VALUE
NAMESPACE
MIN_OCCURS
INTEGER
MAX_OCCURS
TYPENAME
XDB$QNAME
ATTRGROUP_NAME
PROPREF_NAME
PREFIX_CODE
TRANSIENT
XDB$TRANSIENTCHOICE
SYSTEM
SQLTYPE
SQLSCHEMA
SQLNAME
SQLCOLLTYPE
SQLCOLLSCHEMA
LCOLLSCHEMA
PROP_NUMBER
MUTABLE
MEM_TYPE_CODE
MEM_BYTE_LENGTH
JAVA_TYPE
XDB$JAVATYPE
HIDDEN
GLOBAL
FORM
XDB$FORMCHOICE
FIXED_VALUE
DEFAULT_VALUE
BASEPROP
ATTR_USE
XDB$USECHOICE
XDB$APPINFO_T
XDB$APPINFO_LIST_T
APPINFO
SOURCE
XDB$ACL_T
shared
schemaOID
elementNum
NUMBERPS
description
XDB$ACE_LIST_T
XDB$ACE_T
privilege
XDB$PRIV_T
privNum
privNum2_COLL
privNum2_COLLField1
XDB$PRIV
principalID
grant
flags
security-role-ref21_T
security-role-ref22_COLL
security-role-ref
SERVLET_T
servlet-schema
servlet-name
servlet-language
XDB$ENUM_T
servlet-class
load-on-startup
jsp-file
icon
display-name
role-name
role-link
Response83_T
Message
Headers
Code
Body
Response62_T
Request82_T
Version
Resource-Path
Method
OracleError173_T
facility
errnum
ListingTyp101_T
size
name
ChildName
ChildName102_COLL
ChildName102_COLLField1
ContainerStats121_T
TotalRows
TotalContainers
RESOID
LastAnalyzedDate
TIMESTAMP
ImmediateContainers
FanOut
XDB$RAW_LIST_TField1
XDB$ANNOTATION_LIST_T
LANG
CARDINALITY
CTX_FEEDBACK_ITEM_TYPE
CTX_FEEDBACK_TYPE
TEXT
SCORE
CHILDNAME
PATH_LINKINFO
PATH_ARRAY
PATH
PARENT_OID
CONCEPT_BLOB
CONCEPT_DIMENSION
TABLE_NAME
NUMERIC
NAME_CHAR
CONCEPT_CD
CONCEPT_PATH
MAP_DATA_FACT
MAP_DATA_FACTCol1
MAP_DATA_FACT_ID
is partly identified by
partly identifies
MAP_ID
ENCODING_CD
MODIFIER_CD
START_DATE
ENCOUNTER_NUM
PROVIDER_ID
OBSERVATION_BLOB
CONFIDENCE_NUM
LOCATION_CD
END_DATE
UNITS_CD
QUANTITY_NUM
VALUEFLAG_CD
NVAL_NUM
TVAL_CHAR
VALTYPE_CD
OBSERVATION_FACT
OBSERVATION_FACTCol1
OBSERVATION_FACT_ID
MAP_DIMENSION
LAST_RUN_DATE
UPDATE_USER
UPLOAD_USER
MAP_DESC
MAP_PATH
TARGET_ENCODING
SOURCE_ENCODING
MAP_NAME
CREATE_DATE
ENCODING_DIMENSION
CREATE_USER
ENCODING_DESC
ENCOD
ING_NAME
ENCODING_NAME
DIRECT_PATH
DR$POPINDEX_STATE_T
TSTAMP
SESSION_STATE
DR$SESSION_STATE_T
DR$OPTIM_STATE_T
TTYPE
OPTMODE
MAXTIME
MAXHASH
DR$CREATEINDEX_STATE_T
POPULATE
PARAMS
INDEX_MEMORY
IMPORT
TRACES
LOGFILE
EVENTS
OPCODE
VISIT_DIMENSION
VISIT_BLOB
LOCATION_PATH
INOUT_CD
PROVIDER_DIMENSION
FLOAT
PROVIDER_BLOB
PROVIDER_PATH
DR$ITAB0_SET_T
DR$ITAB0_T
TOKEN_TYPE
TOKEN_TEXT
TOKEN_LAST
TOKEN_INFO_RAW
TOKEN_INFO_BLOB
TOKEN_FIRST
TOKEN_COUNT
DR$ITAB_SET_T
DR$ITAB_T
TOKEN_INFO
DR$OPTTF_IMPL_T
Entity1
Table1Col1
Entity1Attr1
FUNCSTATS
OBSERVATION_MAP_LINKCol1
OBSERVATION_MAP_LINK
PATHIDSET_T
PATHIDSET_TField1
XDB$COMPLEX_DERIVATION_T
4Qdw
NFJat
ODBC Generic Driver
I2B2DEMODATA
H\]^LIK
hasFK30
hasFK10
REF205
hasFK20
hasFK40
REFPATIENT_DIMENSION51
hasREFPATIENT_DIMENSION51
REF105
REF234
OBSERVATION_FACT_SEQ
REFVISIT_DIMENSION41
hasREFVISIT_DIMENSION41
MAP_DATA_FACT_SEQ
Table1
member function lookupValue RETURN VARCHAR2,
pragma restrict_references (lookupValue, wnds, wnps, rnps, rnds),
member procedure setValue(val IN VARCHAR2),
pragma restrict_references (setValue, wnds, wnps, rnps, rnds)
FLOWS_020100
CTXSYS
member function ODCITableFetch(self IN OUT dr$opttf_impl_t, nrows IN Number,
outarr OUT dr$itab0_set_t) return PLS_INTEGER
as language C
library dr$lib
name "optFetch"
with context
parameters (
context,
member function ODCITableClose(s
lf IN dr$opttf_impl_t) return PLS_INTEGER
name "optClose"
context
MAP MEMBER FUNCTION rank RETURN REAL,
PRAGMA RESTRICT_REFERENCES (rank, RNDS, WNDS, RNPS, WNPS)
RANK
REAL
}{ywusqomkige
lBar
DSN=XE;DBQ=XE ;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;
UNDO
SYSAUX
TEMP
USERS
hasFK50
last Merge
Date of last Validation
Date of last Mapping
Date of last Merge
I2B2DE
VisDBEngrSecondaryObjMapData
VisDBEngrModelEngData
IMWDD.Document
ORMInfo
Folders
SummaryInformation
DBSnapshot
Root Entry
VisDBEngrData
VisDBEngrDocData
VisDBEngrObjMapData
Dictionary
Relational,Database,Entity,Relationship,IDEF1X
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.
Drag onto the page to add a table.
elationship diagram.
Entity
Identifies the shape's version to the add-on.
Set for dependent tables.
Set to allow free-from edits (manual edits are not maintained in the model)
Set if this shape's Database | Document | Options have have local overrides.
Conditionally sets the DBNotation setting.
Use to add a table to your Entity Relationship diagram.
width of this shape's text
height of this shape's text
Subshape id within the Entity group shape.
Subshape ID within the Entity group shape.
specifies the number of columns in the tables primary key
Set 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.
two,key,Relational,Database,Entity,Relationship,IDEF1X,foreign,tables
Drag onto the page to define a foreign key between two tables.
Use to define a foreign key between two tables in your Entity Relationship diagram.
Add text here.
Relational,Database,Category,connect,Entity,Relationship,IDEF1X,Parent
Drag onto the page to connect a parent table to a category.
Parent Category Connector
Set to allow free form edits (manual edits are not maintained in the model.)
Shape's version number.
Use to connect a parent table to a category in your Entity Relationship diagram.
Relational,Database,Relationship,IDEF1X,foreign,tables
Use to define a foreign key between two tables in your Object Relational diagram.
Relationship,pointer,Express,ISO,10303,specifications
Drag onto the page to add a relationship pointer.
G diagram.
interface,system,Enterprise,Application,network
Drag the shape onto the drawing page.
ur system diagram.
rmation.
havior of a class, component or entity.
Resize Circle
line,curve,connector,PERT,project,schedule,chart,task,relationship,dependency,projection
Drag onto the page, then drag the ends to blue x
s on shapes (red indicates connection).
of curve.
Modify Curvature
line,connector,PERT,project,schedule,chart,task,relationship,dependency,projection
Adjust Curve Position
dotted,matrix,report,connect,line,organization,chart,secondary,relationship
dynamic,connector,PERT,project,schedule,chart,task,relationship,dependency,projection
circle
select the shape on the page and then type.
circle,ellipse,round,ring
Drag onto the page to add a circle or ellipse with text that stays level when shape is rotated.
<no master>
C:\Program Files\Microsoft Office\Office12\1033\ENTITY_U.VSS
C:\Program Files\Microsoft Office\Office12\1033\OBJREL_U.VSS
C:\Program Files\Microsoft Office\Office12\1033\EXPRG_U.VSS
Set to hide category discriminators.
Set to hide PK, FK, and Index annotations within Entities.
Set to Hide Primary Key section within Entities.
Set to hide Datatypes section within Entities.
Set to hide the vertical lines that seperate the Annotation and Datatype sections within Entities.
Set to hide the horizontal line that seperates the PK section from the other columns of an Entity.
{A8038B4A-192E-4ACB-808F-221845562B7C}
Database Properties...
Show Related Tables
{B163241C-5257-41F5-A1C6-592CAE5DD4DD}
{6593FD29-4867-43D0-9965-54ABF811D4C0}
{B0790BFB-EEA9-4B5C-A3C3-FC445A8A552A}
{76247678-AAC2-4510-AD27-B67DC347786E}
{336D8B38-85FD-48CB-A5F0-6E8B347226BE}
{664DD54E-1358-4CC5-83A1-8FF124A1E3AA}
{9314B6E4-18FC-4B92-A893-D60B2696B539}
{CECBD327-0021-43E8-8732-EF27A0038C57}
{4A89B6A4-4F34-4402-8DC4-0461DF7EDD29}
{2F9D02E5-07A7-4F55-84C2-41871B4E4DC2}
{CED571CB-0944-4958-8881-E793D00A4C21}
{DCF9F02D-C15A-4A7D-B25E-BF79B455E684}
{9DE945FE-C5C5-4FB7-99F6-7DFA7F6F1072}
{B046AFC6-DA8A-4163-A536-4B7D146D9965}
{BA1C953E-4436-402C-8466-5C43AD6444C9}
{FA904DC3-C88C-4303-A7D7-B9CBE32C9234}
{EC089967-9B42-488F-9244-65CD5D5608E3}
{1481D5E6-7641-4D3A-B2CB-064B57F0BEDA}
{5688DEB2-92A7-4F38-B269-68AE605D4E3E}
{63BA7497-CACB-4C3E-9EE0-047FB8617AAC}
{4F7A26B4-693B-4BB1-B395-00F222607E4B}
{F76BF34C-7CC8-4D16-8E90-10A855118EA9}
{8E5FC95F-5CB9-4AC6-94A0-83EDA6894CFD}
{E0DE9EED-2E75-46B0-B3D8-36E322CA1A98}
{B6231D6E-1864-4528-B2EB-D99F14233ECD}
{FAABCA2A-85BC-4EA3-BA4C-B03D6BD998FB}
{739A0006-A9E8-43DD-8AB0-C682B52DB490}
{29C0004A-0260-471A-BFD4-FFEE4761EC97}
{9E922624-1DD9-4E2F-8B5A-1C133A9878BD}
{1BDF85FE-948C-4513-B32B-F582594E923D}
{2BCDD3EA-D5BA-4583-8BD5-CF4B80EC5A2E}
{6115B02D-9F68-405D-AC11-838B665135A8}
{40E9F9B2-F708-4A3E-A250-D2B7D68ECB59}
{BAD9FC79-C562-4071-B7B0-868DEC909512}
{993AB5F2-EFE2-452C-9885-9E48D79FCD9B}
Arial Unicode MS
Symbol
Wingdings
SimSun
PMingLiU
MS PGothic
Dotum
Sylfaen
Estrangelo Edessa
Vrinda
Shruti
Mangal
Tunga
Sendnya
Raavi
Dhenu
Latha
Gautami
Cordia New
MS Farsi
Gulim
Times New Roman
Guide
TheDoc
Page-1
Gesture Format
Row_1
DBNotation
Row_2
DBCrowsFoot
Row_3
DBHideDiscriminator
Row_4
DBHideAnnotations
DBHidePKRow
DBDependent
DBHideTypes
visDescription
DBHideVerticalLines
visVersion
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
Database Model
Visio Extended Data
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Relationship
Entity.29
Parent to category
msvNoAutoConnect
Relationship.10
Relationship.11
Express
Relationship pointer
Interface
Relationship.14
Line-curve connector
Line connector
Dotted-line report
Dynamic connector.18
Block Normal
Circle
Hairline
Circle, ellipse
Relationship.42