DB Engineer
/CMD=1
Root Entry
Module1
dole
__SRP_0
__SRP_1
__SRP_2
__SRP_3
Manage File
Page-1
.vsd
\\te-epc-lpc.web.cern.ch\te-epc-lpc\databases\r2e-database\pagesources\r2e-database-design.png
\\Te-epc-lpc.web.cern.ch\te-epc-lpc\databases\r2e-database\pagesources\history\r2e-database-design-
yyyy-mmm-dd
hh.mm
\\te-epc-lpc.web.cern.ch\te-epc-lpc\databases\r2e-database\pagesources\r2e-database-design.vsd
NewMacros
ThisDocument
_VBA_PROJECT
PROJECT
*\G{000204EF-0000-0000-C000-000000000046}#4.1#
N0{00021A21-0000-0000-C000-000000000046}
$*\Rffff*0<51519a78
*\R1*#1ad
*\R1*#ab
*\R1*#bd
*\R1*#be
9#C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications
*\G{00021A98-0000-0000-C000-000000000046}#4.e#0#C:\Program Files (x86)\Microsoft Office\Office14\VISLIB.DLL#Microsoft Visio 14.0 Type Library
*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation
*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.5#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\MSO.DLL#Microsoft Office 14.0 Object Library
*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library
*\G{F0DB4559-1A56-44E6-9AB1-25A3BE030CBF}#2.0#0#D:\Profiles\ythurel\AppData\Local\Temp\28\MicrosoftVisio14\MSForms.exd#Microsoft Forms 2.0 Object Library
PROJECTlk
PROJECTwm
tThisDocument
1Module1
sNewMacros
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
&DocTitleLong
Arial
&PageDesc
&Date &Time
&PageNo
Date o
CITY
is of
VARCHAR
Manufactur
MANUFACTURER_NAME
is identified by
MANUFACTU
identifies
MANUFACTURER_ID
INTEGER
ANGLE_OF_INCIDENCE
INCI
ADDRESS
ADDRE
Manufacturers
MTF_
MTF_CODE
POSTCODE
COUNTRY
STATE
Test_Beam_Type
NUMERIC
RANGE
SETTING_UNIT_ID
TID_OR_DD
TEST_ID
IONISINB
IONISING_RATE
DEVICE
DEVICE_LOCATION
PARTICLE_ENERGY
TEST_
FLUX_RATE
TEST_BEAM_TYPE_ID
BEAM_TYPE_ID
ATTACHMENT_ID
ATTACHMENT
Attachments
LINK
COMMENT_ID
BATCH_DATE
Batches
Production_Site_ID
SITE_ID
CERN
CERN_BATCH_REF
manufac
MANUFACTURER_BATCH_REF
NUMBER_OF_UNITS
is partly identified by
bATCH
partly identifies
BATCH_ID
TYPE_ID
COMPONENT_ID
Samples
SAMPLE
SAMPLE_REF_NUM
SAMPLE_ID
Stock_Level
QUANTITY_REMAINING
compo
COMPONENT_TYPE_ID
MTF_Batch_Links
Quantiy
QUANTITY
MTF_BATCH_LINK_ID
MTF_PART_ID
Facility_Beams
FACILI
FACILITY_BEAM_ID
FACILITY_ID
beam
ntifies
Beam_Types
pARIT
PARTICLE_NAME
CERN_ID
People
Group
GROUP
EMAI
EMAIL_ADDRESS
FullN
FULLNAME
FORE
FORENAME
SURNAME
pEOPLE
PERSON_ID
CLASS_ID
Components
PACKAGE_ID
Referen
REFERENCE
DESCRIPTION
NAME
TYpe_
COMMENT
Comments
Table
TABLE_NAME
Object
OBJECT_ID
Comment
COMPONENT_CLASS_ID
Component_Settings
component_ser
COMPONENT_SETTING_ID
CRITICAL
SETTING_DEF_ID
Clas
Component_Classes
PARENT
PARENT_CLASS
cLASS nAME
COMPONENT_REF_NUM
Sample_Components
ON_BEAM
SAMPLE_COMPONENTS_ID
Test_Settings
SET_I
RESULT_SET_ID
VARIABLE_OR_CONSTANT
TEST_SETTING_ID
CRIT_PARAM_VALUE_ID
Critical_Parameter_Value_Number
Value
VALUE
TEST_TYPE_CRIT_PARAM_ID
DESC
Tests
SAMPLE_ITEM_ID
SAMPLE_COMPONENT_ID
END_DATE
DATE
START_DATE
APckage
Packages
Package
TYPE
DESCRIP
Setting_Units
Unit
UNIT
DOSE
FIXED
Result_Points
EQU_20MEV_PER_CM2
EQU_1MEV_PER_CM2
ResultsCol1
IONS_PER_CM2
SE_FLAG
POINT
POINT_ID
Y_VALUE
Point
POINT_NUMBER
Facilities
PARENT_FACILITY_ID
LOCA
LOCATION
Facility ID
Production_Sites
Production
MTF_Equipment
Setting_Definitions
Testers
TEST
TEST_PERSON_ID
Y_AXIS
Result_Sets
SETTING_VALUE_ID
Setting_Values
TEST_TYPE_SETTING_ID
.ATg
*>Qdw
Test_Types
'7531/-+S_]QY
ljh}
last Merge
Date of last Validation
Date of last Mapping
Date of last Merge
Date of
VisDBEngrSecondaryObjMapData
VisDBEngrModelEngData
IMWDD.Document
ORMInfo
Folders
SummaryInformation
DBSnapshot
Dictionary
VisDBEngrData
VisDBEngrDocData
VisDBEngrObjMapData
Date of las
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.
View,Relational,Database,Entity,Relationship,IDEF1X
Drag onto the page to add a view.
View
Set for dependent tables (doesnt apply to views).
Use to add a view to your Entity Relationship diagram.
Relational,Database,Relationship,IDEF1X,foreign,tables
elational diagram.
Use to define a foreign key between two tables in your Object Relational diagram.
Relational,Database,object,Entity,IDEF1X
Use to add a table to your Object Relational diagram.
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.
{111E91E3-C1E8-44A1-9510-9A9F4BA66A3B}
Database Properties...
Show Related Tables
{69CF748A-4D2C-458D-831B-896C1E2F9240}
{403CB667-EED2-490B-84DC-9EA4BD7101CC}
{5492B889-71E4-4DCC-A157-20725CDDDD29}
{47CF6697-4AD6-47F7-AA57-AE4C11A45FC5}
{276E7DCA-76D3-4BBC-8974-7AFB9AF0F702}
{CCD138C2-4325-45F2-BC16-7907F2E0BC45}
{D9F7CBF1-D2AD-47B7-B896-079400FFDF20}
{74715FED-DA72-46FA-A90E-4A7F3E62FF86}
{A199E531-1178-43DD-BCF3-F51B01B97587}
{CEBD33A3-D8B3-4495-B90C-CEA5B777F55A}
{D012EA4C-6C02-4CFC-A136-88A3A5EEEA37}
{5528FEC1-BA3E-4FE9-985D-81A40148D335}
{0B9641E9-7523-409F-8566-AE7B4F757224}
{344909BD-3018-4C4E-AD0B-224B0C5A721A}
{9792BA2A-9C0F-4ADA-9125-449D0BBEEEA0}
{F9B0D4EA-B93B-46FE-BBA3-872E70FEC2AC}
{4D59562C-14D1-4D4A-8C29-61F0DE900BCF}
{A58E0209-353A-441A-BB6A-7F18E993B5B7}
{00483765-26C2-4646-9B24-0AB07448B8FC}
{BC94BBF5-639E-40E2-9DFE-6838C1D25092}
{6B8676D4-A90B-495C-8482-AC2AD2DF07D8}
{DBB83955-2CAA-403B-930F-B31F633A6752}
{4450618B-E971-4755-AEC8-A67523C398DA}
{092748F1-657E-4250-90A1-AFAD01595776}
{4F4C70B5-BB8F-45EA-84D9-9F85D674C03A}
{992047BD-9493-4581-A039-6ED1CFDF1BFD}
{A99AF67F-0DE3-4495-A0AA-24792142252B}
{8781360F-CFD9-4751-BFC9-37099E835A94}
{15079D56-E0F1-4AF5-8AEC-39D1535073B0}
{E11BC872-76D3-441F-A0CE-1F390FF36F91}
{F1C32C03-7226-4D01-8846-BFAB2BAF039D}
{9B764E58-4B4C-480C-B94E-C0FFE22FA0E4}
{8FF71FBE-B6AA-4A91-8EB9-BBA5E8FC695F}
{483F79A3-AFA2-4B5E-98BC-A72EDBE329BB}
{9C160579-4397-4D8C-9D81-1113BF95CCED}
{837ADECC-6369-43E0-8015-AF7CFBEB6D99}
{789E319B-BB2E-4734-9C19-A6AB96739CEB}
{D1E82D4D-75E2-4971-B80C-2717AE7BFF48}
{32F47CF4-DC69-4FBD-ABC2-8229F1FE844C}
{D9F9ADA6-C01F-441E-98D7-C9D03A745F1E}
{AA0F446C-4858-4C88-A294-1A385B703911}
{3CA70DDF-21B5-48ED-92A3-F1B949CFACEA}
{36BC4EE5-7947-4EAB-BDB5-5BEF3914FB27}
{4A3201B0-B0E9-449A-A833-2FAE63174FFC}
{AF512C28-E1C6-4D64-A56D-21FF89730BBC}
{6F2453BC-9AF5-435A-8156-18CBF35491AC}
{868AF13F-9A0E-4265-9EF7-6947971F053D}
{E81C11DB-6BDB-478A-9105-794BDE6E11EA}
{16A92AE7-F85C-40A7-94E6-78AC4D225C98}
{136C4E6C-147C-4371-9127-4B155BD67989}
{A5C33BC9-ADFC-4656-8175-65D84DDE2A65}
{861D6702-2E84-481C-B0A8-CE81082CCFA4}
{8030A1B6-CBE4-47A9-A374-4F0F189A5D8A}
{0E3B07EF-2212-4F35-9F86-70A95F1D96E4}
{E6CDDD2F-6BF4-414B-8708-EC100EA7179F}
{D348E012-4711-41D7-8135-872DC36A213E}
{C7628159-8CBB-4560-8BB1-43F39908B27F}
Root Entry contents CompObj
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
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
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
Relationship
Entity.68
msvNoSubprocess
CommandButton1.2
Relationship.10
Entity.11
CommandButton1
Entity.106