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.
UGRPInfo
MAPInfo
TSTAMPInfo
SourceDocs
leLong
Arial
itleLong
&DocTitleLong
&PageDesc
is of
State
City
Suburb
has AddressLine1
AddressLine1
AddressLine2
is identified by
identifies
AddressID
Action
Permissions
Description
PermissionID
Address_tbl
Post
ostCode
Person_tbl
Photo
Phone
Email
MiddleName
LastName
Fird
FirstName
Status
Person
PersonID
Store_tbl
Time
TimeZone
Store
StoreName
PhoneNumber
ExternalID
StoreID
AuthorityLevel
Author
Role_tbl
Name
RoleI
RoleID
BillingHistory_tbl
Payment
PaymentDate
Details
Total
TotalAmount
PaymentMethod
BillingID
Body
Message_tbl
Subject
Sender_PersonID
MessageID
BreakID
Brea
Breaks_tbl
EndDateTime
Start
StartDateTime
HoursID
Comment
Staff_Hours_tbl
Hours
Date
Comments
Taskin
gFeedback_tbl
publishedGroupsID
Flag
Finished
FinishedBy_PersonID
Fini
FinishedTime
Stat
Duration
Priority
TaskName
Task
TaskFeedbackID
ConsecutiveFailedAttempts
Credentials_tbl
IsAccountLocked
LoggedOnCounter
Password
User
Username
Credential
CredentialID
CookieDetails
Cookie
Machines_tbl
Machine
MachineName
MachineID
Published_Groups
GroupName
Schedule
StartTime
Template_Schedule_tbl
Temp
Temp_ScheduleID
TemplateID
OperatingHours_tbl
EndTime
OpHoursID
Delay
Task_tbl
TaskID
Group_Template_mapping_tbl
StartT
Record
RecordID
TaskGroupID
Group
TaskGroup_tbl
IPAddress
Application
LoginHistory_tbl
LogDateTime
Recprd
Machines_Store_Mapping
Message_Recipient_tbl
Order
Task_Group_MappingCol2
Task_Group_Mapping
Permission_Role_Mapping
Person_Store_Mapping
Store_Person_Mapping
Sotre
StoreContact
Relationship
Store_Role_Mapping
Template_tbl
TemplateName
Template
PhoneNumb
&Date &Time
&PageNo
Date of last Merge
Date of last Validation
Date of last Mapping
Date of
PostCode
Relationship is of Store_Person_Mapping,i.e employee, owner or other
TaskingFeedback_tbl
ting
Day is of OperatingHours_tbl, can be nullable if refering to a specific date
Date is of OperatingHours_tbl,nullable if record refers to a day of week
upName
pnljhf
NLJHF
last Merge
Date of l
VisDBEngrSecondaryObjMapData
VisDBEngrModelEngData
IMWDD.Document
ORMInfo
Folders
SummaryInformation
DBSnapshot
Dictionary
VisDBEngrObjMapData
Root Entry
VisDBEngrData
VisDBEngrDocData
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.
C:\Program Files (x86)\Microsoft Office\Office14\visio content\1033\ENTITY_M.VSS
C:\Program Files (x86)\Microsoft Office\Office14\visio content\1033\OBJREL_M.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.
{1E3FFB02-82F4-4B6B-9015-06112FA974F3}
Database Properties...
Show Related Tables
{7E06955A-DF82-43A4-8193-37A246A20755}
{017F6937-3AF4-407A-BCA2-7A7EAD13EEF5}
{A199EB1B-682E-4968-BE02-2C7B5EA6044C}
{C25C2428-9173-45F3-8E9A-EA6F2146D1D3}
{D8CA25C4-92C1-4DC5-A561-792031CD87AE}
{C7FB7D9C-3E53-42C8-8221-B6397566C11D}
{F19160B5-B968-422F-9FE3-BA4FFE6F59A6}
{4E46E289-14AD-47ED-9B41-FEC1C0DD144D}
{4BE24F22-9CB6-4D81-B095-F618511E6021}
{630D7324-9708-4ABA-9C1E-99193BF05FFE}
{3D963DE9-9D5A-40A6-A3CB-974536B2D327}
{9184D826-5E4F-427C-8F34-3F00067E48AB}
{5836B746-362B-4255-B26D-C0E410B87F25}
{EE599912-7418-4E09-A326-33E5D12BD621}
{27A47D24-E76C-4F64-B8FA-61A5E3ADCA04}
{EBA052C4-CBF1-4C53-84D7-9986CAA321D8}
{5FDDE1CD-E363-4686-937D-C222B93FCE38}
{01F85435-4395-48A3-8270-1D93A71F4EF7}
{426C82C4-8A68-44FE-B68F-E992B36BAD3F}
{38C6FBC9-FB3B-48F5-BE21-6DC560CEC03B}
{B3385935-7EFA-46EA-A8F4-F23697918E9D}
{FCEDEFD3-F483-4177-8F86-B6519F4540E4}
{BED8BAC9-2F2C-4A83-A49A-80F8F2FE98FC}
{0440A2CF-70A5-4CCF-BA94-679F38D8918F}
{18650231-834C-42CA-B3A1-9B2A3A6CAACE}
{2E9A5524-1B9A-41EB-A1C4-C37500E5ECB8}
{2E0B4145-BB2F-452E-88CD-42A1C05B4B8F}
{D8485DAE-0A09-4834-A729-AC4C893527A7}
{0009FBE7-454F-49DA-BC17-5922BDAEBA2E}
{08815737-34F9-497B-98C6-C8A01FC8B66B}
{00DF4F2B-726D-4EB6-AEFE-64C179FB226D}
{4D237CA3-ACDE-4792-9EC7-2FE4A8FC5AE9}
{FCC17FD0-56C1-45D2-8AA6-37A51440E304}
{C0777C74-3A17-478F-A999-C61DF7504957}
{1E452D6C-E7BB-49DD-8E03-DC38F14656E7}
{644AA488-93B6-4DB4-8B75-75149A73D0E9}
{21839975-6260-44FF-B9F4-D88ABD55FA57}
{904A5E96-D04A-4EB1-8CC4-A0ECB2869382}
{2D6A7051-7D5A-415A-83EA-E05E331A8AEC}
{835A4F84-CB29-4BBA-A61F-53C9CB68FB06}
{9A4A9C29-FBD7-4E67-9C7A-5C9283BE56A5}
{58675EC6-6AE6-4921-B9A9-A4F51BD14783}
{99697FD3-E0AD-4ED9-B3B2-22B289080598}
{87591D5C-5DF8-4AF3-9478-15D573FA329E}
{C7683F97-D58C-48A0-A029-D4DE493665D5}
{9EDBF3CF-5F36-4BAD-BCA6-F77FDFC1B1B6}
{F29CF4D0-C452-49BC-A78B-D668E8E3EA01}
{E011B7DF-CAE3-44C0-BC8A-1D47A4E436F5}
{872F4309-6E02-49C4-BCEB-EF4DCD5F8696}
{FA9F4D72-F95E-4217-B0F1-E549C280F908}
{13940AAE-6D8F-4421-B50D-0CE3712E6F37}
{9CA2DE17-33AD-4756-B2F2-376AAB870CC1}
{B259821C-3935-4FFC-8CF7-AC9E3FE6FFE9}
{7DDBF2BD-E7F9-49F0-96C0-37A5443E0545}
{A36BF7AA-81C0-41BD-B9C0-D48F69003BD8}
{5C936036-3B58-4E51-90FE-85CC9048DDC3}
{F1AB66C3-2E06-4E05-855A-F1BC33B0C278}
{5123515C-413C-4978-9757-7784D33BD32E}
{377EF84B-2048-47FA-9AD8-D04002EDDB02}
{AB740CDF-0737-4E1A-BD42-150914A91692}
{C8D4CF46-BAE1-4CDD-91F5-C9294381A9D8}
{CB762D3B-1B6F-4DB5-9E7B-C6EA085AA812}
Arial Unicode MS
Symbol
Wingdings
Calibri
SimSun
PMingLiU
MS PGothic
Dotum
Sylfaen
Estrangelo Edessa
Vrinda
Shruti
Mangal
Tunga
Sendnya
Raavi
Dhenu
Latha
Gautami
Cordia New
Malgun Gothic
Times New Roman
Guide
TheDoc
Page-1
Gesture Format
Row_1
DBNotation
Row_2
DBCrowsFoot
Row_3
DBHideDiscriminator
Row_4
DBHideAnnotations
Database Model
DBHidePKRow
Visio Extended Data
DBHideTypes
DBHideVerticalLines
DBDependent
DBHideHorizontalLine
msvNoAutoConnect
msvNoApplyDataGraphicAfterLink
msvNoSubprocess
Connector
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
visDescription
visVersion
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Entity.7
Dynamic Connector.48
Entity.16
Entity.22
Entity.34
Dynamic Connector.50
Entity.59
Dynamic Connector.62
Entity.109
Entity.114