Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
HP LaserJet 4000 Series PS
Letter
PRIV
winspool
IP_10.5.7.1_rbpr1
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.
UUUUU
@UUUUU
ONw!
YlY'C
AHWJ
%DocTitleLong
%PageDesc
%Date %Time
Page %PageNo of %PageCount
CTimeStamp
Date of last Merge
Date of last Validation
)ySrM
-GQfFE
c6QA
TTgl.J
@fPM
b0cC
LAjLE
=NLK
xi&F
gD)z
6s%Fg
Fmmo
MHi_
nI`zZX
ki"QR}
S`gP
kcaAE
-GQfFE1
.!cwM
"nb?8JM
/&mzmf
ki"QR
GEO_CODE
VARCHAR
GEO_NAME
is of
GEO_TYPE_ID
is identified by
GEO_ID
identifies
CMandatoryConstraint
ACCOUNT_NUMBER
EFT_ACCOUNT
CUserDataType
BOOLEAN
CDataType
LONG BYTE
VARCHAR() BYTE
VARBINARY
CHAR() BYTE
BINARY
LONG
FIXED
DECIMAL
DOUBLE PRECISION
CObjTypeD
ABBREVIATION
CRole
CPredicateD
CElemArrayOfCells
CElemCell
GEO_SEC_CODE
CConstraintList
CUCIndexConstraint
CRoleArray
CONTACT_MECH_ID
COMPANY_NAME_ON_ACCOUNT
NAME_ON_ACCOUNT
ACCOUNT_TYPE
ROUTING_NUMBER
BANK_NAME
PAYMENT_METHOD_ID
ADDRESS1
POSTAL_ADDRESS
POSTAL_CODE_GEO_ID
STATE_PROVINCE_GEO_ID
COUNTRY_GEO_ID
POSTAL_CODE
CITY
DIRECTIONS
ADDRESS2
ATTN_NAME
TO_NAME
AFFILIATE
DATE_TIME_APPROVED
TIME
DATE_TIME_CREATED
SITE_VISITORS
SITE_PAGE_VIEWS
SITE_TYPE
YEAR_ESTABLISHED
AFFILIATE_DESCRIPTION
AFFILIATE_NAME
PARTY_ID
ALLOW_SOLICITATION
PARTY_CONTACT_MECH
COMMENTS
EXTENSION
ROLE_TYPE_ID
THRU_DATE
is partly identified by
FROM_DATE
partly identifies
CHAR
AREA_CODE
TELECOM_NUMBER
CONTACT_NUMBER
COUNTRY_CODE
ATTR_NAME
PARTY_TYPE_ATTR
PARTY_TYPE_ID
PARTY_ATTRIBUTE
ATTR_VALUE
CUST_REQUEST_TYPE_ATTR
CUST_REQUEST_TYPE_ID
CUST_REQUEST_ATTRIBUTE
CUST_REQUEST_ID
CONTACT_MECH_TYPE_ATTR
CONTACT_MECH_TYPE_ID
CONTACT_MECH_ATTRIBUTE
BIN_END_DATE_TIME
SERVER_HIT_BIN
MAX_TIME_MILLIS
MIN_TIME_MILLIS
TOTAL_TIME_MILLIS
NUMBER_HITS
BIN_START_DATE_TIME
SERVER_HOST_NAME
SERVER_IP_ADDRESS
HIT_TYPE_ID
CONTENT_ID
SERVER_HIT_BIN_ID
BIRTH_DATE
PERSON
TOTAL_YEARS_WORK_EXPERIENCE
PASSPORT_EXPIRE_DATE
DATE
PASSPORT_NUMBER
SOCIAL_SECURITY_NUMBER
MARITAL_STATUS
MOTHERS_MAIDEN_NAME
WEIGHT
HEIGHT
GENDER
NICKNAME
SUFFIX
PERSONAL_TITLE
MIDDLE_NAME
FIRST_NAME
LAST_NAME
CAMPAIGN_NAME
MARKETING_CAMPAIGN
CAMPAIGN_SUMMARY
LONGVARCHAR
MARKETING_CAMPAIGN_ID
CARD_NUMBER
CREDIT_CARD
COMPANY_NAME_ON_CARD
NAME_ON_CARD
EXPIRE_DATE
CARD_SECURITY_CODE
CARD_TYPE
PARTY_RELATIONSHIP
PARTY_RELATIONSHIP_TYPE_ID
PRIORITY_TYPE_ID
STATUS_ID
PARTY_ID_FROM
PARTY_ID_TO
ROLE_TYPE_ID_FROM
ROLE_TYPE_ID_TO
PARTY_GROUP
FEDERAL_TAX_ID
GROUP_NAME
COMMUNICATION_EVENT
NOTE
DATETIME_ENDED
DATETIME_STARTED
ROLE_TYPE_ID_FRO
COMMUNICATION_EVENT_TYPE_ID
COMMUNICATION_EVENT_ID
COMMUNICATION_EVENT_WORK_EFF
DESCRIPTION
WORK_EFFORT_ID
COMMUNICATION_EVENT_ROLE
COMMUNICATION_EVENT_PURPOSE
COMMUNICATION_EVENT_PRP_TYP_ID
COMMUNICATION_EVENT_PRP_TYP
HAS_TABLE
PARENT_TYPE_ID
COMMUNICATION_EVENT_TYPE
CONDITION_EXPRESSION
STATUS_VALID_CHANGE
TRANSITION_NAME
STATUS_ID_TO
CONTACT_MECH
INFO_STRING
VISIT
COOKIE
USER_AGENT_ID
INITIAL_USER_AGENT
INITIAL_REFERRER
INITIAL_REQUEST
INITIAL_LOCALE
WEBAPP_NAME
SESSION_ID
USER_LOGIN_ID
VISIT_ID
POSTAL_ADDRESS_BOUNDARY
PARTY_CONTACT_MECH_PURPOSE
CONTACT_MECH_PURPOSE_TYPE_ID
CONTACT_MECH_ID_FROM
CONTACT_MECH_LINK
is partly identified
CONTACT_MECH_ID_TO
CONTACT_MECH_PURPOSE_TYPE
CONTACT_MECH_TYPE_PURPOSE
CONTACT_MECH_TYPE
VALID_CONTACT_MECH_ROLE
SERVER_HIT
REF_BY_WEB_CONTACT_MECH_ID
ID_BY_IP_CONTACT_MECH_ID
REFERRER_URL
REQUEST_URL
RUNNING_TIME_MILLIS
NUM_OF_BYTES
HIT_START_DATE_TIME
CURRENT_PASSWORD
USER_LOGIN
SUCCESSIVE_FAILED_LOGINS
DISABLED_DATE_TIME
ENABLED
PASSWORD_HINT
CUST_REQUEST
RESPONSE_REQUIRED_DATE
CUST_REQUEST_DATE
CUST_REQUEST_STATUS
STATUS_DATETIME
CUST_REQUEST_ITEM_SEQ_ID
CUST_REQUEST_STATUS_ID
CUST_REQUEST_ROLE
CUST_REQUEST_ITEM_NOTE
NOTE_ID
CUST_REQUEST_ITEM
STORY
MAXIMUM_AMOUNT
QUANTITY
REQUIRED_BY_DATE
CUST_REQUEST_TYPE
STATUS_TYPE
STATUS_TYPE_ID
STATUS_ITEM
SEQUENCE_ID
STATUS_CODE
SHOPPING_LIST_TYPE
SHOPPING_LIST_TYPE_ID
SHOPPING_LIST
LIST_NAME
PARENT_SHOPPING_LIST_ID
SHOPPING_LIST_ID
SERVER_HIT_TYPE
SECURITY_PERMISSION
PERMISSION_ID
SECURITY_GROUP
GROUP_ID
PAYMENT_METHOD_TYPE
PAYMENT_METHOD_TYPE_ID
PARTY_TYPE
PARTY_RELATIONSHIP_TYPE
PARTY_RELATIONSHIP_NAME
ROLE_TYPE_ID_VALID_TO
ROLE_TYPE_ID_VALID_FROM
PARTY_CLASSIFICATION_TYPE
PARTY_CLASSIFICATION_TYPE_ID
PARTY_CLASSIFICATION_GROUP
PARTY_CLASSIFICATION_GROUP_ID
GEO_TYPE
GEO_ASSOC_TYPE
GEO_ASSOC_TYPE_ID
ENUMERATION_TYPE
ENUM_TYPE_ID
ENUMERATION
ENUM_CODE
ENUM_ID
USER_LOGIN_SECURITY_GROUP
USER_LOGIN_HISTORY
SUCCESSFUL_LOGIN
PASSWORD_USED
PAYMENT_METHOD
PARTY_RATE
RATE
RATE_TYPE_ID
PARTY_CLASSIFICATION
MARKET_INTEREST
PRODUCT_CATEGORY_ID
GEO_ASSOC
GEO_ID_TO
SECURITY_GROUP_PERMISSION
MARKETING_CAMPAIGN_PROMO
PRODUCT_PROMO_ID
MARKETING_CAMPAIGN_PRICE
PRODUCT_PRICE_RULE_ID
MARKETING_CAMPAIGN_NOTE
PARTY_NOTE
PARTY
WEB_USER_PREFERENCE
WEB_PREFERENCE_TYPE_ID
PARTY_SURVEY_RESPONSE
RESPONSE_DATE_TIME
SURVEY_RESPONSE
SURVEY_RESPONSE_ID
SURVEY_ID
PARTY_ROLE
PRODUCT_ID
SHOPPING_LIST_ITEM
SHOPPING_LIST_ITEM_SEQ_ID
SEQ_ID
SEQUENCE_VALUE_ITEM
SEQ_NAME
SITE_NAME
WEB_SITE
WEB_SITE_ID
ODBC Generic Driver
ofbiz_sapdb
ATTR_PK
PARTY_TYP_ATTR
hasPARTY_TYP_ATTR
PARTY_TYPE_PK
PARTY_PTY_TYP
hasPARTY_PTY_TYP
OFBIZ
PARTY_GRP_PARTY
hasPARTY_GRP_PARTY
PARTY_GROUP_PK
AFFILIATE_PGRP
hasAFFILIATE_PGRP
AFFILIATE_PK
AFFILIATE_PARTY
hasAFFILIATE_PARTY
CMappingGroup
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
CForeignKey
PARTY_TYPE_PAR
hasPARTY_TYPE_PAR
CLogicalKey
PARTY_TYPE_
COM_EVNT_TYPE_PAR
hasCOM_EVNT_TYPE_PAR
COMMUNICATION_EVENT_TYPE_PK
COM_EVNT_TYPE
hasCOM_EVNT_TYPE
COM_EVNT_FPTY
hasCOM_EVNT_FPTY
STATUS_TYPE_PARENT
hasSTATUS_TYPE_PARENT
STATUS_TYPE_PK
STATUS_TO_TYPE
hasSTATUS_TO_TYPE
CUST_REQ_TYPE_PAR
hasCUST_REQ_TYPE_PAR
CUST_REQUEST_TYPE_ATTR_PK
CUST_REQ_TYPE_ATTR
hasCUST_REQ_TYPE_ATTR
CUST_REQUEST_TYPE_PK
CUST_REQ_TYPE
hasCUST_REQ_TYPE
COM_EVNT_ISCS
hasCOM_EVNT_ISCS
CUST_REQUE
ST_ATTRIBUTE_PK
CUST_REQ_ATTR
hasCUST_REQ_ATTR
CUSTREQ_RL_PARTY
hasCUSTREQ_RL_PARTY
PARTY_RLE_PARTY
hasPARTY_RLE_PARTY
COM_EVRL_CMEV
hasCOM_EVRL_CMEV
COM_EVRL_PTY
hasCOM_EVRL_PTY
COMMUNICATION_EVENT_ROLE_PK
COM_EVRL_PRLE
hasCOM_EVRL_PRLE
PARTY_CMECH_PARTY
hasPARTY_CMECH_PARTY
CONT_MECH_TYP_PAR
hasCONT_MECH_TYP_PAR
COM_EVNT_CMTP
hasCOM_EVNT_CMTP
CONTACT_MECH_TYPE_ATTR_PK
CONT_MECH_TYP_ATR
hasCONT_MECH_TYP_ATR
PARTY_CMPRP_PARTY
hasPARTY_CMPRP_PARTY
PARTY_CMPRP_CMECH
hasPARTY_CMPRP_CMECH
PARTY_CONTACT_MECH_PURPOSE_PK
PARTY_CMPRP_TYPE
hasPARTY_CMPRP_TYPE
CONTACT_MECH_PURPOSE_TYPE_PK
CONT_MECH_TP_PRPTP
hasCONT_MECH_TP_PRPTP
CONTACT_MECH_TYPE_PURPOSE_PK
CONT_MECH_TP_TYPE
hasCONT_MECH_TP_TYPE
VALID_CONTACT_MECH_ROLE_PK
VAL_CMRLE_CMTYPE
hasVAL_CMRLE_CMTYPE
CONTACT_MECH_TYPE_PK
CONT_MECH_TYPE
hasCONT_MECH_TYPE
CONTACT_MECH_ATTRIBUTE_PK
CONT_MECH_ATTR
hasCONT_MECH_ATTR
CONT_MECH_TCMECH
hasCONT_MECH_TCMECH
CONTACT_MECH_LINK_PK
CONT_MECH_FCMECH
hasCONT_MECH_FCMECH
PAYMENT_METHOD_TYPE_PK
PAYMETH_TYPE
hasPAYMETH_TYPE
PAYMETH_PARTY
hasPAYMETH_PARTY
EFTACCT_CMECH
hasEFTACCT_CMECH
POST_ADDR_CMECH
hasPOST_ADDR_CMECH
GEO_TYPE_PARENT
hasGEO_TYPE_PARENT
GEO_TYPE_PK
GEO_TO_TYPE
hasGEO_TO_TYPE
GEO_ASSC_TO_ASSC
hasGEO_ASSC_TO_ASSC
GEO_ASSOC_TYPE_PK
GEO_ASSC_TO_TYPE
hasGEO_ASSC_TO_TYPE
GEO_ASSOC_PK
GEO_ASSC_TO_MAIN
hasGEO_ASSC_TO_MAIN
POST_ADDR_SPGEO
hasPOST_ADDR_SPGEO
POST_ADDR_PCGEO
hasPOST_ADDR_PCGEO
POST_ADDR_BNDRY
hasPOST_ADDR_BNDRY
POSTAL_ADDRESS_BOUNDARY_PK
POST_ADDR_BNDRYGEO
hasPOST_ADDR_BNDRYGEO
GEO_PK
POST_ADDR_CGEO
hasPOST_ADDR_CGEO
CREDCART_PADDR
hasCREDCART_PADDR
POSTAL_ADDRESS_PK
EFTACCT_PADDR
hasEFTACCT_PADDR
EFT_ACCOUNT_PK
EFTACCT_PMETH
hasEFTACCT_PMETH
PAYMENT_METHOD_PK
CREDCART_PMNTMETH
hasCREDCART_PMNTMETH
CREDIT_CARD_PK
CREDCART_CMECH
hasCREDCART_CMECH
SERVER_HIT_BIN_PK
SERVER_HBIN_TYPE
hasSERVER_HBIN_TYPE
SERVER_HIT_TYPE_PK
SERVER_HIT_SHTYP
hasSERVER_HIT_SHTYP
VISIT_CONT_MECH
hasVISIT_CONT_MECH
VISIT_PARTY
hasVISIT_PARTY
VISIT_PARTY_ROLE
hasVISIT_PARTY_ROLE
VISIT_PK
SERVER_HIT_VISIT
hasSERVER_HIT_VISIT
SERVER_HIT_PARTY
hasSERVER_HIT_PARTY
SERVER_HIT_REFWEB
hasSERVER_HIT_REFWEB
SERVER_HIT_STATUS
hasSERVER_HIT_STATUS
SERVER_HIT_USER
hasSERVER_HIT_USER
SERVER_HIT_PK
SERVER_HIT_IDBYIP
hasSERVER_HIT_IDBYIP
TELECOM_NUMBER_PK
TEL_NUM_CMECH
hasTEL_NUM_CMECH
CONTACT_MECH_PK
PARTY_CMECH_CMECH
hasPARTY_CMECH_CMECH
PARTY_CONTACT_MECH_PK
PARTY_CMECH_PROLE
hasPARTY_CMECH_PROLE
PARTY_REL_FPARTY
hasPARTY_REL_FPARTY
PARTY_REL_TPARTY
hasPARTY_REL_TPARTY
PARTY_REL_TPROLE
hasPARTY_REL_TPROLE
PARTY_REL_STTS
hasPARTY_REL_STTS
PARTY_RELTYP_PAR
hasPARTY_RELTYP_PAR
PARTY_RELATIONSHIP_TYPE_PK
PARTY_REL_TYPE
hasPARTY_REL_TYPE
PARTY_RELATIONSHIP_PK
PARTY_REL_FPROLE
hasPARTY_REL_FPROLE
PARTY_ROLE_PK
CUSTREQ_RL_PROLE
hasCUSTREQ_RL_PROLE
CUST_REQUEST_ROLE_PK
CUSTREQ_RL_CRQST
hasCUSTREQ_RL_CRQST
CUST_REQUEST_PK
CUST_REQ_STRQ
hasCUST_REQ_STRQ
CUST_REQUEST_STATUS_PK
CUST_REQ_STTS
hasCUST_REQ_STTS
STATUS_CHG_TO
hasSTATUS_CHG_TO
STATUS_VALID_CHANGE_PK
STATUS_CHG_MAIN
hasSTATUS_CHG_MAIN
STATUS_ITEM_PK
COM_EVNT_STTS
hasCOM_EVNT_STTS
COM_EVNT_PRP_TYP
hasCOM_EVNT_PRP_TYP
COMMUNICATION_EVENT_PRP_TYP_PK
COM_EVNT_PRP_TYPE
hasCOM_EVNT_PRP_TYPE
COMMUNICATION_EVENT_PURPOSE_PK
COM_EVNT_PRP_EVNT
hasCOM_EVNT_PRP_EVNT
COMMUNICATION_EVENT_WORK_EFF_PK
COMEV_WEFF_CMEV
hasCOMEV_WEFF_CMEV
COMMUNICATION_EVENT_PK
COM_EVNT_TPTY
hasCOM_EVNT_TPTY
PARTY_ATTRIBUTE_PK
PARTY_ATTR
hasPARTY_ATTR
PARTY_CLASS_TYPPAR
hasPARTY_CLASS_TYPPAR
PARTY_CLASSIFICATION_TYPE_PK
PARTY_CLASS_TYPE
hasPARTY_CLASS_TYPE
PARTY_CLASS_GRPPAR
hasPARTY_CLASS_GRPPAR
MARKET_INTEREST_PK
MARKET_INT_PCGRP
hasMARKET_INT_PCGRP
PARTY_CLASSIFICATION_GROUP_PK
PARTY_CLASS_GRP
hasPARTY_CLASS_GRP
PARTY_CLASSIFICATION_PK
PARTY_CLASS_PARTY
hasPARTY_CLASS_PARTY
PARTY_NOTE_PK
PARTY_NOTE_PARTY
hasPARTY_NOTE_PARTY
PARTY_RATE_PK
PRTY_RTE_PRTY
hasPRTY_RTE_PRTY
PARTY_SURVEY_RESPONSE_PK
PARTY_SRVYRSP_PTY
hasPARTY_SRVYRSP_PTY
PERSON_PK
PERSON_PARTY
hasPERSON_PARTY
USER_LH_USER
hasUSER_LH_USER
USER_LOGIN_HISTORY_PK
USER_LH_PAR
hasUSER_LH_PARTY
WEB_PREF_PARTY
hasWEB_PREF_PARTY
PARTY_PK
USER_PARTY
hasUSER_PARTY
SECURITY_GROUP_PERMISSION_PK
SEC_GRP_PERM_GRP
hasSEC_GRP_PERM_GRP
SECURITY_GROUP_PK
USER_SECGRP_GRP
hasUSER_SECGRP_GRP
USER_LOGIN_SECURITY_GROUP_PK
USER_SECGRP_USER
hasUSER_SECGRP_USER
USER_LOGIN_PK
WEB_PREF_USER
hasWEB_PREF_USER
WEB_USER_PREFERENCE_PK
WEB_SITE_PK
SHLIST_PARENT
hasSHLIST_PARENT
SHOPPING_LIST_ITEM_PK
SHLIST_ITEM_LIST
hasSHLIST_ITEM_LIST
SHOPPING_LIST_PK
SHLIST_TYPE
hasSHLIST_TYPE
SHOPPING_LIST_TYPE_PK
SEQUENCE_VALUE_ITEM_PK
SECURITY_PERMISSION_PK
MARKETING_CAMPAIGN_NOTE_PK
MKTGCPN_NOTE_CMPN
hasMKTGCPN_NOTE_CMPN
MARKETING_CAMPAIGN_PRICE_PK
MKTGCPN_PRICE_MC
hasMKTGCPN_PRICE_MC
MARKETING_CAMPAIGN_PK
MKTGCPN_PROMO_MC
hasMKTGCPN_PROMO_MC
MARKETING_CAMPAIGN_PROMO_PK
ENUM_TYPE_PARENT
hasENUM_TYPE_PARENT
ENUMERATION_PK
ENUM_TO_TYPE
hasENUM_TO_TYPE
ENUMERATION_TYPE_PK
MAXIMUM_AMOUN
CUST_REQUEST_ITEM_PK
CUST_REQ_ITNT
hasCUST_REQ_ITNT
CUST_REQUEST_ITEM_NOTE_PK
DSN=ofbiz_sapdb;UID=OFBIZ;PWD=OFBIZ;SERVERDB=OFBIZ;SERVERNODE=;DRIVER=;
Date of last Mapping
Onn=
jFaN
jonesde
Last reverse engineered from database 'OFBIZ' on server '' on August 28, 2002 7:19 AM.
Database Model Document
Visio 2000
COMMUNICATION_EVENT_PRP_TYP_F
CDBTable
CDBColumn
CDBConstraint
COMMUNICATION_EVENT_WORK
_EFF_PK
CUST_REQUEST_ATTRIBUTE_PK
PARTY_TYPE_ATTR_PK
SHOPPING
_LIST
NTACT_MECH_ID
USER_LH_PARTY
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.
`&{3663A618-4151-42A7-BAB1-3A3D4333CFD7}
Database Properties...
Show Related Tables
`&{00532AEF-2B47-4FD0-87CC-A63EB650A23E}
`&{4CAC07A8-732F-410A-97F3-79E23AB6489C}
`&{7D475286-A01F-4B5A-9911-8224161AE85A}
`&{63F271A1-6A0D-4C15-A4B3-C2CCC481C2F6}
`&{90ECCC61-0E22-44D5-AB5F-40B72CE3CFA4}
`&{C4ABBDD8-FA87-4D2B-A4D5-F3723D85384F}
`&{8EA85EC3-B40D-4D0C-863D-005CEAFA7B78}
`&{927AFE62-93F4-4C82-8077-F96FD3C3977D}
`&{1A9C8523-DAD2-4AF1-A228-57C91709D733}
`&{CD60A27C-78A2-45A2-99C6-24C8FD789BB2}
`&{B072431E-4E3D-4B4C-9E67-13236486F86F}
`&{FA59A660-D6E5-44A9-A560-570652D3468B}
`&{E5868B47-4239-497F-BE88-0F6FAE1E410F}
`&{6DDDF86B-35DA-41D6-8694-3B8C571EB34E}
`&{21467BDC-8CAF-4DE3-90C8-5D52312309E9}
`&{1E910952-72BE-4A3C-8CCF-53606750CB69}
`&{770D5B96-89D4-4495-926F-740F18A7F5A1}
`&{8B675DC9-A09C-4A8C-A913-61B41EBAABAC}
`&{1A41F069-F5E5-4B29-8B2C-5F0EF7EEA7DC}
`&{0277F432-3E6E-4AED-BB16-20815B166A83}
`&{4389856F-E86E-4237-B19E-E0EE5A9D24EA}
`&{33CA7260-C580-4BB3-8872-6AAE69C9970A}
`&{40539F3B-CD12-4B25-ABE4-C51EAC0E109B}
`&{D3010D6E-5385-4BDE-916E-ED9D4F4E7721}
`&{8C0B1965-E22A-4B54-AF3C-8ECDF977DB50}
`&{B05C3078-E031-4AE9-BA1D-3635C126BA3A}
`&{D0332377-D80A-4D80-8EB4-A751C8140A26}
`&{5AAEC83C-0412-4BF8-9517-37A6233D218D}
`&{3E9CFBEB-FE8F-4B08-B2CB-C44A33E4D755}
`&{ECFE1092-58A5-4BE1-BE2C-C0459784B9D1}
`&{5BB01CDE-8F1F-43BA-BA4B-8A902E216377}
`&{EC4DC525-3B0F-4FDB-B911-378A12584658}
`&{DDA05BCC-28BE-4338-9F99-BBEC97A2953A}
`&{B45A1471-DCCF-4715-B934-71E881299258}
`&{2C232CA9-717F-41D9-A078-DFC37F4CED52}
`&{FB186DD4-791B-4DC8-B8EC-1FFE95EAB99D}
`&{090A0386-A7B1-4936-853B-61E0A1A19756}
`&{0B493697-69B9-4C89-B951-041C7AB0E3CE}
`&{5454FC7D-6C67-4A2E-AA73-590CDF2B8DED}
`&{915E03C4-192F-4A64-BB03-AE9B5762E56A}
`&{6C02C02D-4894-462A-8812-E49009006432}
`&{39E70FC8-A004-4E79-8132-5A96D6B72E03}
`&{5BAE364B-320A-4990-B4A6-E2B08FF8BA5C}
`&{46B1496F-8C5F-454B-8E80-2D4751664645}
`&{1E66CA2E-EE19-4E35-A87A-E3A8B349AB6F}
`&{C384BB30-677F-4FCC-B2E3-3656BFCA91AE}
`&{98802055-776C-4CE8-8DB8-631D780E1855}
`&{FE260070-D740-462F-B0F6-1743D69B0514}
`&{668E2E1E-2FCE-4B8C-AA80-D08EB32FC81A}
`&{59D761D4-9510-466E-8A45-99E10450746F}
`&{E7FC6CD5-4C8B-4F4D-9272-9A957BE77773}
`&{E5809BFE-7586-4470-8424-BDF1D36AC5FB}
`&{A1C48022-FF67-4404-A558-2BDA2A948CA3}
`&{9635F257-A3D9-4EFF-9D4A-CAC25F8B7E33}
`&{FF5A4AAA-CCE2-411E-97E0-966C37807C37}
`&{3FF87100-5F08-49F2-B4DA-84BB6EC9BA75}
`&{14826E14-3A5D-4A03-9ADE-67837E989935}
`&{290FDBCF-5379-4D72-97BF-736FDCC57EAD}
`&{58BE4562-E1C8-4D52-9C0F-9C81B6733314}
`&{59B31F73-596C-4327-8E95-E1DB7B332535}
`&{B553FEAD-BBEA-4C99-BDD2-CFADD6A12DCB}
`&{4850EE58-9F30-4E66-8A99-3011244CF3E9}
`&{5498880E-F098-41B3-A499-768911446223}
`&{ABB2A113-FAFF-475C-9363-245AA09653A7}
`&{E2D3DA44-63B7-4E43-B867-4A17F4899920}
`&{C15993EA-A5BB-405D-BCE5-163FCDD4B92F}
`&{854D41D3-26E8-4446-972E-B440647C2200}
`&{6BD0813C-B9BB-4D8F-8017-EDD8370417BD}
`&{C1518EE1-FD6D-4577-969B-176B41EC982C}
`&{A5FB17F5-4841-4A57-8C8D-D040FE88DEDE}
`&{399B18A9-D5FE-40D3-82FA-448E5928F7F5}
`&{1864087B-7712-4155-8F8D-E76A43BCCE04}
`&{D2DF39BA-7832-4AC6-A138-D5DF8B41BEB1}
`&{F30A1251-93AD-43B5-9D22-9FCC466D6D6F}
`&{872D48EB-DC5A-4D4E-A787-D7EAC95FAF16}
`&{3054B9DF-ED53-4D53-861D-39D093B45A7B}
`&{C1A3EC1B-6978-4626-BCF7-E6216DF3CCC7}
`&{EC89493C-3FBD-4B5D-A01C-8B2F72B55488}
`&{4384D413-63E1-4682-BB95-D9105945C960}
`&{7525F5D0-E798-41AC-B1DF-54FE3A7390CE}
`&{13BD4699-B25E-4AC3-B9BC-3C6225947A8E}
`&{C9B691F3-B39A-42C4-A0A8-4584259B9278}
`&{E4FF521E-46DD-468E-8BDB-A7B5EE5FD243}
`&{E281753F-83DE-42D9-9CD5-128DB73E7497}
`&{6C8F9483-C68C-4EF6-BC63-3ED56E521FE5}
`&{5A9C1150-A567-4153-BBCE-7BA428492844}
`&{77CA462F-8092-44E0-8AD8-E379D5A63089}
`&{3A54D099-D448-457B-B70C-037B24FD9646}
`&{2850B107-1904-4424-80C0-BA9E5D438D40}
`&{1BD10F44-DE4A-4783-8E03-E26B69225152}
`&{C3BB8488-55A3-4EF6-A0A0-B707F4674429}
`&{AB3B4774-A788-47EF-86B0-0F261C7ADFAD}
`&{E9ACAC51-2C7D-49F3-9A44-DEFEA1AB68F4}
`&{6527392E-14C5-4DA4-B383-C5FFD886E5EB}
`&{5A31E2EF-2167-4E03-9669-030C15D3F497}
`&{D100A133-4DEA-4D37-A1C4-862E5A17E332}
`&{F585AD48-CCB4-4CCA-B4E7-992E0A2ADACF}
`&{A9786F37-8279-447F-993F-F337990872EB}
`&{1F7B1A25-F5A1-4887-A7D1-5C62086C9B52}
`&{C90F43E2-7AD2-4D32-BCDB-D23673254667}
P@-DT
`&{DE35CD98-8183-4077-AB13-D65290D0C97B}
c2EY
@AQla_T @AQla_T
`&{FAFE24AC-3062-4363-991E-45DD77B967BC}
`&{5D7A45DE-32E2-4239-9EB1-44B152650A09}
`&{7258FA32-FF89-4155-B230-88539F4BC314}
`&{FD93D2AA-6252-4699-ADBB-2062E4AC8B93}
@r'0@As Í@r'0@As
JZ0@A JZ0@A
`&{3AC0ABC6-146A-4D6D-8CD0-AA6001B30695}
@AMP @AMP
`&{DCEB4A08-9238-49B0-BAD4-9BD042185AEC}
`&{BEB9EB6C-5A9E-4FF9-B017-D745748594BD}
`&{396CF284-E763-4546-B9EF-D7554729BFB5}
`&{1582544A-AEF4-4524-814D-8F7342B3E965}
`&{4A166F69-BA45-43E5-8F10-6273DF817408}
`&{CBA011B0-7422-4B40-BE09-298B91496A52}
P@.DT
`&{0B687C19-A97E-4163-B9C4-9BF60F73BC35}
`&{9044603E-EA4A-4EDD-8DE2-FE279DBA0B7A}
ApL4 Ë?ApL4
ApL4 ApL4
?AKr
`&{281CEA2A-9BDE-4848-A4D3-31C38B492931}
`&{54C27735-B698-45A8-A0C9-F9D0F46F0A22}
`&{2FC97EC3-B150-4B9A-A8D1-967B226A8D8F}
`&{25413CCB-C0BA-49D2-99B0-66553009E164}
P'-DT
`&{BC1EBC93-2CE1-482D-9626-0D872E3BA0EA}
WLH^
`&{08B2505B-B7C7-430E-A043-9D4499E1CEC5}
`&{4E7EC82F-6835-41F9-B921-608118E6510E}
`&{E9D68865-C6FA-4972-A332-419DE6879E0F}
`&{A99AAD2B-B417-490A-8FA5-503A731A0141}
`&{E7BF9AE3-52F6-4BD5-B23F-D0FAA8CCADA3}
`&{B06B16B1-A7C8-44DB-9FF1-CADD628B9FC5}
Wi'@A Wi'@A
`&{1A740346-0B65-451F-9561-0E3DBE1732FC}
`&{D79178D3-4696-47B5-BB57-255D1A7DC532}
BdR7â ÙBdR7
BdR7â A1ÙBdR7
`&{66F0233A-A4BE-4371-9950-BEF3552FC671}
A1jvV A1jvV
`&{1796BB64-BE16-467C-AFC4-EE984376E9F8}
@Aap @Aap
`&{7E851100-3DDD-421A-9CFD-B44817135529}
`&{4196FCA8-A0FD-4D69-9BAC-6B848C127594}
`&{7C5DFCCA-B406-43A9-A912-ACC9FE137FD6}
?ACG,+Æwà Ë?ACG,+
`&{7A6D262F-666D-46C7-8873-5D1300432E90}
?AH>fÿ Ë?AH>f
AH>fÿ AH>f
A#T/wÓÇú ÀA#T/w
`&{B47F32F0-43F7-45B1-A331-97E4705565D3}
`&{710347F3-D9E9-401E-8320-58F190E648E3}
`&{41B1B978-B249-4CE7-AD1D-FA8A09F05B87}
`&{C4E357F6-7DE3-4426-9DAD-7FDA90A2C41E}
`&{51FF275C-6C2D-451E-BF8B-01214F7E264A}
`&{5C41FFAA-156D-48C3-893B-905477B968AC}
`&{EDF0D6AE-6640-4D50-9BA1-AB43BAD02E85}
`&{94B659E4-7D86-4CC7-903A-E35EC9F4C81B}
`&{4161636B-A745-41E6-ABCD-9D28D05E5780}
`&{7048411A-EDF2-4A1B-BC38-3491BBC895B7}
`&{7213E8B7-77D6-4676-880D-62B0EC288179}
`&{325FF298-ACB7-453B-9609-1CEF9E06F936}
`&{013E0C75-3AA6-44B0-891C-713D1D4D4869}
`&{DD81BA38-A1B3-4D92-82BC-730977479837}
`&{4F984655-F71D-46DE-8B12-35DDE2996B3A}
`&{41C6CC68-AE13-435F-8FA8-1736C08DE851}
`&{65EB861A-030D-4F46-BBB9-3DB387BCA236}
`&{0FBDCDAF-7BD4-4C89-9C00-514BE0702487}
`&{15F7604C-5D71-41DE-949C-C4AB121C5FCF}
`&{CB441F88-AA54-4E06-A18C-12AD584A59C0}
mc1@A mc1@A
`&{A3FC6611-2493-4270-8AF3-5A945016DCDD}
PR-DT
lsH+ lsH+
`&{5C0E5B55-FABB-40EC-8D4F-09B0BFA1B26A}
`&{4D94C9F7-91F7-41F8-A1FF-FFBE0B12A2F5}
`&{9777291A-E86D-4CCD-B2B9-BA5E404DDEFC}
SuTn
@ SuTn
`&{C5384366-1336-4CEF-AAE4-CF76F560BA94}
`&{637ECC0F-BD69-4DE7-BB64-3837515DA0D4}
`&{80F19761-660E-41DB-B83C-ECDA322BA297}
@ XBi
`&{73BDAFD9-A732-4281-B764-95240161874A}
?AFrÓqDOâ¿AHªmužtÝ?AFr
uUU"±?A`)p†jfç¿AŽ­uUU"
`&{DE09480C-7A18-4978-9324-2AD6E6587E9C}
`&{CD5E39DC-F6ED-4F15-99AA-302DED24338E}
`&{4CC3B1BC-6A41-454C-86DD-EAC30FA3E84E}
`&{589D3848-7F72-4A7C-A7D7-BF9CF735B6FD}
AFC:ºÁNé?A²ÿUW"XÕ¿AFC:ºÁNé?A²ÿUW"X
`UL"@ATÇô÷ƒg!ÀA×hÊ`UL"@AT
`&{C49013B9-3C3E-4A97-8D2F-D646D2B5D037}
G>Apå G>Ap
`&{8BB1739B-BF39-4866-842B-EC3DCB22F4E8}
`&{85E59D79-BDA1-4C78-9350-526EB176219E}
`&{D1AE4DF0-8064-4231-B6DC-5A682EB8851C}
`&{AA20A89D-108C-400B-88BF-5E31363B1729}
P@i"@A4 P@i"@A4
P@i"@AÎ(þõHN¶¿Añc‹P@i"@A
`&{05ACBA47-7DEE-4504-8BD0-6E49607A5A58}
ApWzã ÀApWz
`&{CBB633BF-95FF-4C36-A8E8-4D4FF4C93B08}
Pe/DT
`&{C301B636-6060-4E8E-AE1C-CA1C3F73974B}
`&{8655B2E4-FC5E-46EC-9F5B-2F839043B83D}
?ATf(òt ?ATf(
`&{497CDEB4-A4AD-47ED-96E5-281024BC9728}
`&{FC0F92E3-C7BC-486D-A88E-7575911C3833}
`&{93EAF077-5121-4D84-8372-92C9303A1D29}
`&{D9EFE6F4-EE91-496B-B9DE-3C92700EF81A}
!vN O
vN O
?AYhrK= òø?AYhrK=
`&{159B901C-93B3-45B7-8F23-2DB9A2472F04}
PD-DT
`&{626E22B4-383F-4D4A-99EA-B8EFBCEE45B0}
?ANV
`&{3F1AE81E-1EBD-4DAD-8FA2-B37E64B330B5}
`&{CF4D37BA-C5BF-49D1-8A9B-5D11D53C4F67}
`&{630B86F1-5D2D-412F-9E50-1C393FA0D13D}
`&{2ABE0794-DB70-4EEA-B285-990BEBC62BFF}
`&{240CA92B-D171-4724-A5ED-F5C5FC8642A3}
ALl6mÇ ALl6m
`&{80311D23-7A10-41EE-8E3C-15B212A9DE29}
gsFO^
Ku,@Ai qãKu,@Ai
`&{37D12AA6-DA47-4FE3-906B-CB3C4E71A987}
?AXM¹ËÝyá¿A¤{£6~ÎÃ?AXM
`&{D889B395-856F-4D66-8501-2640B7BDAFAB}
`&{517F0EE1-5CC8-4825-9D9B-1BF6B90A1080}
`&{9A47BD42-55DD-4392-AB85-2DAF25C9001E}
`&{AA02EBB6-6448-4411-A867-8CEEF157C8BA}
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
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/
6DOCUM
E~1\jone
sde\LOCA
Temp\
VBE\
S.ex
VISXDAT"A
FE9117F6
D1-B7F5
ogram Fi
les\Visi
o\SoluA
Extra
.dll#
Type?p
s4 3ACD5
BC34-5DB
ThisDocu
mentG
EngineerF
_B_var_Engineer
ThisDocument
ID="{E5E4FD9C-652A-11D2-BBFA-006008BF0962}"
Document=ThisDocument/&H00000000
Name="Database_Model"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="3133DC24E024E024E024E0"
DPB="D1D33CC13DC13DC1"
GC="71739C619D619D9E"
[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
BE;&H0
0000-0000-C000-000000000046};Visio2000;&H00000000