📄 e-r.pdm
字号:
<?xml version="1.0" encoding="UTF-8"?>
<?PowerDesigner AppLocale="UTF16" ID="{6CB28AB2-BDCD-41EE-9149-5DEEB1E78EC6}" Label="" Name="E-R" Objects="211" Symbols="42" Target="MySQL 5.0" Type="{CDE44E21-9669-11D1-9914-006097355D9B}" signature="PDM_DATA_MODEL_XML" version="12.0.0.1700"?>
<!-- do not edit this file -->
<Model xmlns:a="attribute" xmlns:c="collection" xmlns:o="object">
<o:RootObject Id="o1">
<c:Children>
<o:Model Id="o2">
<a:ObjectID>6CB28AB2-BDCD-41EE-9149-5DEEB1E78EC6</a:ObjectID>
<a:Name>E-R</a:Name>
<a:Code>E-R</a:Code>
<a:CreationDate>1179125361</a:CreationDate>
<a:Creator>Sam Lee</a:Creator>
<a:ModificationDate>1237165872</a:ModificationDate>
<a:Modifier>haize</a:Modifier>
<a:PackageOptionsText>[FolderOptions]
[FolderOptions\Physical Objects]
GenerationCheckModel=Yes
GenerationPath=
GenerationOptions=
GenerationTasks=
GenerationTargets=
GenerationSelections=
RevPkey=Yes
RevFkey=Yes
RevAkey=Yes
RevCheck=Yes
RevIndx=Yes
RevOpts=Yes
RevViewAsTabl=No
RevViewOpts=Yes
RevSystAsTabl=Yes
RevTablPerm=No
RevViewPerm=No
RevProcPerm=No
RevDbpkPerm=No
RevSqncPerm=No
RevAdtPerm=No
RevUserPriv=No
RevUserOpts=No
RevGrpePriv=No
RevRolePriv=No
RevDtbsOpts=Yes
RevDtbsPerm=No
RevViewIndx=Yes
RevJidxOpts=Yes
RevCaseSensitive=No
GenTrgrStdMsg=Yes
GenTrgrMsgTab=
GenTrgrMsgNo=
GenTrgrMsgTxt=
TrgrPreserve=No
TrgrIns=Yes
TrgrUpd=Yes
TrgrDel=Yes
TrgrC2Ins=Yes
TrgrC2Upd=Yes
TrgrC3=Yes
TrgrC4=Yes
TrgrC5=Yes
TrgrC6=Yes
TrgrC7=Yes
TrgrC8=Yes
TrgrC9=Yes
TrgrC10=Yes
TrgrC11=Yes
TrgrC1=Yes
TrgrC12Ins=Yes
TrgrC12Upd=Yes
TrgrC13=Yes
GenScriptName0=
GenScriptName1=
GenScriptName2=
GenScriptName3=
GenScriptName4=
GenScriptName5=
GenScriptName6=
GenScriptName7=
GenScriptName8=
GenScriptName9=
GenTrgScriptName=cretrg
GenTrgScriptName0=
GenTrgScriptName1=
GenTrgScriptName2=
GenTrgScriptName3=
GenTrgScriptName4=
GenTrgScriptName5=
GenTrgScriptName6=
GenTrgScriptName7=
GenTrgScriptName8=
GenTrgScriptName9=
GenTrgPathName=
GenTrgSingleFile=Yes
GenDataPathName=
GenDataSinglefile=Yes
GenDataScriptName=testdata
GenDataScriptName0=
GenDataScriptName1=
GenDataScriptName2=
GenDataScriptName3=
GenDataScriptName4=
GenDataScriptName5=
GenDataScriptName6=
GenDataScriptName7=
GenDataScriptName8=
GenDataScriptName9=
GenDataDelOld=No
GenDataTitle=No
GenDataDefNumRows=20
GenDataCommit=0
GenDataPacket=0
GenDataOwner=No
GenDataProfNumb=
GenDataProfChar=
GenDataProfDate=
GenSynmPathName=
GenSynmSinglefile=Yes
GenSynmScriptName=synonym
GenSynmScriptName0=
GenSynmScriptName1=
GenSynmScriptName2=
GenSynmScriptName3=
GenSynmScriptName4=
GenSynmScriptName5=
GenSynmScriptName6=
GenSynmScriptName7=
GenSynmScriptName8=
GenSynmScriptName9=
GenSynmOdbc=No
GenSynmTitle=No
GenSynmOwner=No
GenPrivPathName=
GenPrivSinglefile=Yes
GenPrivScriptName=privilege
GenPrivScriptName0=
GenPrivScriptName1=
GenPrivScriptName2=
GenPrivScriptName3=
GenPrivScriptName4=
GenPrivScriptName5=
GenPrivScriptName6=
GenPrivScriptName7=
GenPrivScriptName8=
GenPrivScriptName9=
GenPrivOdbc=No
GenPrivTitle=No
GenPrivOwner=No
GenMultPathName=
GenMultSinglefile=Yes
GenMultScriptName=synonym
GenMultScriptName0=
GenMultScriptName1=
GenMultScriptName2=
GenMultScriptName3=
GenMultScriptName4=
GenMultScriptName5=
GenMultScriptName6=
GenMultScriptName7=
GenMultScriptName8=
GenMultScriptName9=
GenMultOdbc=No
GenMultTitle=No
GenMultOwner=No
[FolderOptions\Physical Objects\Database Generation]
GenScriptName=security.sql
GenScriptName0=ware.sql
GenScriptName1=crebas.sql
GenScriptName2=drugstore.sql
GenScriptName3=
GenScriptName4=
GenScriptName5=
GenScriptName6=
GenScriptName7=
GenScriptName8=
GenScriptName9=
GenPathName=D:\EclipseSpace\rstdataquery\rstdataquery\db\e-r\
GenSingleFile=Yes
GenODBC=No
GenCheckModel=Yes
GenScriptPrev=Yes
GenArchiveModel=No
GenUseSync=No
GenSyncChoice=0
GenSyncArch=
GenSyncRmg=0
[FolderOptions\Physical Objects\Database Generation\Format]
GenScriptTitle=Yes
GenScriptNamLabl=No
GenScriptQDtbs=No
GenScriptQOwnr=No
GenScriptCase=0
GenScriptEncoding=UTF8
GenScriptNAcct=No
[FolderOptions\Physical Objects\Database Generation\Database]
Create=No
Open=No
Close=No
Drop=No
Permission=No
[FolderOptions\Physical Objects\Database Generation\Database\Create]
Physical Options=No
Header=No
Footer=No
[FolderOptions\Physical Objects\Database Generation\Tablespace]
Create=No
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\Tablespace\Create]
Header=Yes
Footer=Yes
[FolderOptions\Physical Objects\Database Generation\Storage]
Create=No
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\User]
Create=No
Grant=No
Drop=No
Privilege=No
[FolderOptions\Physical Objects\Database Generation\User\Create]
Physical Options=No
[FolderOptions\Physical Objects\Database Generation\Group]
Create=No
Drop=No
Privilege=Yes
[FolderOptions\Physical Objects\Database Generation\Role]
Create=No
Drop=No
Privilege=No
[FolderOptions\Physical Objects\Database Generation\UserDefinedDataType]
Create=No
Comment=No
Drop=No
[FolderOptions\Physical Objects\Database Generation\UserDefinedDataType\Create]
Default value=No
Check=No
[FolderOptions\Physical Objects\Database Generation\AbstractDataType]
Create=No
Header=No
Footer=No
Drop=No
Comment=No
Install JAVA class=No
Remove JAVA class=No
Permission=No
[FolderOptions\Physical Objects\Database Generation\Rule]
Create=No
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\Default]
Create=No
Comment=Yes
Drop=No
[FolderOptions\Physical Objects\Database Generation\Sequence]
Create=No
Drop=No
Comment=No
Permission=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column]
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Table]
Create=Yes
Drop=Yes
Comment=No
Permission=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create]
Check=Yes
Physical Options=No
Header=Yes
Footer=Yes
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create\Check]
Constraint declaration=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Column]
User datatype=No
Default value=Yes
Check=Yes
Physical Options=Yes
Comment=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Column\Check]
Constraint declaration=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Key]
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key]
Create=Yes
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key\Create]
Constraint declaration=No
Physical Options=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key]
Create=Yes
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key\Create]
Constraint declaration=No
Physical Options=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key]
Create=Yes
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key\Create]
Constraint declaration=No
Declarative integrity=Yes
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key\Create\Declarative integrity]
Update constraint restrict=Yes
Update constraint cascade=No
Update constraint set null=No
Update constraint set default=No
Delete constraint restrict=Yes
Delete constraint cascade=No
Delete constraint set null=No
Delete constraint set default=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Index]
Create=Yes
Drop=Yes
Comment=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Create]
Constraint declaration=Yes
Physical Options=Yes
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Filter]
Primary key=No
Foreign key=No
Alternate key=No
Cluster=Yes
Other=Yes
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger]
Create=No
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger\Filter]
For insert=No
For update=No
For delete=No
For other=No
[FolderOptions\Physical Objects\Database Generation\View]
Create=Yes
Drop=Yes
Comment=No
Permission=No
[FolderOptions\Physical Objects\Database Generation\View\Create]
Force Column list=No
Physical Options=Yes
Header=Yes
Footer=Yes
[FolderOptions\Physical Objects\Database Generation\View\ViewIndex]
Create=Yes
Drop=Yes
Comment=No
[FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Create]
Constraint declaration=Yes
Physical Options=Yes
[FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Filter]
Primary key=Yes
Foreign key=Yes
Alternate key=No
Cluster=Yes
Other=Yes
[FolderOptions\Physical Objects\Database Generation\View\Trigger]
Create=No
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\View\Trigger\Filter]
For insert=No
For update=No
For delete=No
For other=No
[FolderOptions\Physical Objects\Database Generation\Synonym]
Create=No
Drop=No
[FolderOptions\Physical Objects\Database Generation\Synonym\Filter]
Table=Yes
View=Yes
Proc=Yes
Synonym=Yes
Database Package=Yes
Sequence=Yes
[FolderOptions\Physical Objects\Database Generation\JoinIndex]
Create=No
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\JoinIndex\Create]
Physical Options=No
Header=No
Footer=No
[FolderOptions\Physical Objects\Database Generation\Procedure]
Create=Yes
Drop=Yes
Comment=No
Permission=No
[FolderOptions\Physical Objects\Database Generation\Procedure\Create]
Header=Yes
Footer=Yes
[FolderOptions\Physical Objects\Database Generation\DatabasePackage]
Create=No
Drop=No
Permission=No
[FolderOptions\Physical Objects\Database Generation\WebService]
Create=No
Drop=No
Comment=No
[FolderOptions\Physical Objects\Database Generation\Dimension]
Create=No
Drop=No
[FolderOptions\Physical Objects\Database Generation\Synchronization]
GenBackupTabl=1
GenKeepBackTabl=1
GenTmpTablDrop=No
GenKeepTablOpts=No
[FolderOptions\Physical Objects\Test Data]
GenDataPathName=
GenDataSinglefile=Yes
GenDataScriptName=testdata
GenDataScriptName0=
GenDataScriptName1=
GenDataScriptName2=
GenDataScriptName3=
GenDataScriptName4=
GenDataScriptName5=
GenDataScriptName6=
GenDataScriptName7=
GenDataScriptName8=
GenDataScriptName9=
GenDataOdbc=No
GenDataDelOld=No
GenDataTitle=No
GenDataDefNumRows=20
GenDataCommit=0
GenDataPacket=0
GenDataOwner=No
GenDataProfNumb=
GenDataProfChar=
GenDataProfDate=
GenDataCSVSeparator=,
GenDataFileFormat=CSV
GenDataUseWizard=No
[FolderOptions\Pdm]
IndxIQName=%COLUMN%_%INDEXTYPE%
IndxPK=Yes
IndxFK=Yes
IndxAK=Yes
IndxPKName=%TABLE%_PK
IndxFKName=%REFR%_FK
IndxAKName=%AKEY%_AK
IndxPreserve=No
IndxThreshold=0
RefrPreserve=No
JidxPreserve=No
RbldMultiFact=Yes
RbldMultiDim=Yes
RbldMultiJidx=Yes
CubePreserve=No
CubeScriptPath=
CubeScriptCase=0
CubeScriptEncoding=ANSI
CubeScriptNacct=No
CubeScriptHeader=No
CubeScriptExt=csv
CubeScriptExt0=txt
CubeScriptExt1=
CubeScriptExt2=
CubeScriptSep=,
CubeScriptDeli="
DfltDomnName=D_%.U:VALUE%
DfltColnName=D_%.U:VALUE%
DfltReuse=Yes
DfltDrop=Yes
[FolderOptions\CheckModel]
[FolderOptions\CheckModel\Replication]
[FolderOptions\CheckModel\Replication\PartialReplication]
CheckSeverity=Yes
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Package]
[FolderOptions\CheckModel\Package\CircularReference]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Package\ConstraintName]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Package\CnstMaxLen]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Package\CircularDependency]
CheckSeverity=Yes
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Package\ShortcutUniqCode]
CheckSeverity=Yes
FixRequested=No
CheckRequested=No
[FolderOptions\CheckModel\Table]
[FolderOptions\CheckModel\Table\UniqueName]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\UniqueCode]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\UniqIndex]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\MaxLen - NAME]
CheckSeverity=Yes
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\MaxLen - CODE]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\EmptyColl - COLNCOL]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\EmptyColl - INDXCOL]
CheckSeverity=Yes
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\EmptyColl - KEYCOL]
CheckSeverity=Yes
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\SerialColumnNumber]
CheckSeverity=No
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\EmptyCollYesYes]
CheckSeverity=Yes
FixRequested=No
CheckRequested=Yes
[FolderOptions\CheckModel\Table\TableIndexes]
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -