0 ratings0% found this document useful (0 votes) 143 views2 pagesStaruml Reverse Ke DB PDF
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here.
Available Formats
Download as PDF or read online on Scribd
2erv2018 [ERD Generation Extension for StarUML v3 | starum/-everse-cb
View on GitHub
staruml-reverse-db
Extension for StarUML support to generate ER Data Model from
database schema
ERD Generation Extension for StarUML v3
DeBuild Status
This extension for Star UML support to generate ER Data Model from database schema,
Note This extension does not provide perfect reverse engineering. If you need a complete
reverse engineering feature, please check other professional reverse engineering tools,
Supported databases
>» @ N
SO Server PSO. MysSaL®
ER Data Model Generation
MS SQL
1. Click the menu (Tools > Database > MS SQL Server > Configure Server
2. Configure Database Connection Preferences
3. Choose one of the following to generate ER Data Model
© Click the menu (Tools > Database > MS SQL Server > Generate ER Data Model...) or
© Press the shortcut key(Alt + shift + ™)
4, Model will be created in the Project (If there is no open project, it will be created)
PostgreSQL
1. Click the menu (Tools > Database > Postgresgl Server > Configure Server...)
2. Configure Database Connection Preferences
3. Choose one of the following to generate ER Data Model
© Click the menu (Tools > Database > PostgreSQL Server > Generate ER Data Model...) or
© Press the shortcut key(alt + shift + U)
4, Model will be created in the Project (If there is no open project, it will be created)
MySQL
1, Click the menu (Tools > Database > MySQL Server > Configure Server...
2. Configure Database Connection Preferences
3. Choose one of the following to generate ER Data Model
© Click the menu (Tools > Database > MySQL Server > Generate ER Data Model...) or
© Press the shortcut key(alt + shift +P)
hitps:kkisz1 github iolstarum-everse-cb 12erv2018 ERD Genaration Extension for StarUML v3 | starum/-reverse-cb
4, Model will be created in the Project (If there is no open project, it will be created)
Belows are the rules to convert from database schema to ER Data Model elements.
Table
+ Converted to type. ERDEntity
+ Set the below properties:
© name: string
© columns: Array
Column
+ Converted to type. ERDColum
«Set the below properties:
© name: string
primaryKey: boolean
nullable: boolean
foreignKey: boolean
type: string
length: steing
unique: boolean
referenceTo: type.£RDColumn
Relationship
+ Converted to type. £RDReLationship
+ Set the below properties:
© foreignKeyName: string
© identifying: boolean
© endl: type. ERDRelationshipend
© end2: type. ERDRelationshipend
RelationshipEnd
+ Converted to type. ERDRelationshipénd
# Set the below properties:
name: string
identifying: boolean
cardinality: steing
reference: type. ERDColumn
staruml-reverse-db maintained by Kkrisz1
Published with GitHub Pages
hitps:kkisz1 github iolstarum-everse-cb
2