Generate CDM, PDM, and SQL using PowerDesigner

By Power Designer

1. Personnel organization structure

Entity Remarks
Organization (id, name)
Department (id, name) An organization has multiple departments
person (id, name) One ​​person belongs to one department, and there are multiple people under one department
Leader Leaders are also people
Role (id, name) One ​​role can correspond to multiple people, and one person has multiple roles
permissions (id, Name) A role can have multiple permissions, and one permission corresponds to multiple roles

< p>

2, conceptual model

New conceptual model

< p>650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png “title=”002.PNG” alt=”wKioL1e7uB7Qkh55AADnaWvAC3g875.png” data-src=”http://s1.51cto.com/wyfs02/M00/86/4D/wKioL1e7uB7Qkh55AADnaWvAC3g875.png”>

2.1, institution

650) this.width=650;” src=”/wp-content /uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”005.PNG” alt=”wKiom1e76oLgT_DtAABiF_HOcYo095.png” data-src=”http://s2.51cto.com/wyfs02/M02 /86/51/wKiom1e76oLgT_DtAABiF_HOcYo095.png”>

2.2. Department

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”008.PNG “alt=”wKiom1e76tfC_vyfAABXq3vlhss631.png” data-src=”http://s1.51cto.com/wyfs02/M02/86/51/wKiom1e76tfC_vyfAABXq3vlhss631.png”>

2.3, personnel

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg /static/loading.png” title=”011.PNG” alt=”wKioL1e76yWi_iN0AABWmZ7mJLw566.png” data-src=”http://s4.51cto.com/wyfs02/M00/86/50/wKioL1e76yWi_iN0AABWmZ7mJ /p>

2.4, leadership


650) this.width=650;” src=”/wp-content/uploadshttp:/img.voi dcn.com/vcimg/static/loading.png” title=”014.PNG” alt=”wKioL1e765XRtsg-AABUDmUyVrI706.png” data-src=”http://s5.51cto.com/wyfs02/M01/86/50 /wKioL1e765XRtsg-AABUDmUyVrI706.png”>

2.5, role

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/ static/loading.png” title=”017.PNG” alt=”wKiom1e76_Sgpa1_AABWprXRnVs099.png” data-src=”ht tp://s3.51cto.com/wyfs02/M02/86/51/wKiom1e76_Sgpa1_AABWprXRnVs099.png”>

2.6, permissions

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”020.PNG” style =”float:none;” alt=”wKioL1e77D2yyT7ZAABZE4l-4UA507.png” data-src=”http://s5.51cto.com/wyfs02/M02/86/51/wKioL1e77D2yyT7ZAABZE4 l-4UA507.png”>

2.7. Institution-department relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”023.PNG” style=”float:none;” alt=”wKioL1e77NriDKTJAABX2GGhlQ0742.png” data-src=”http://s2.51cto.com/wyfs02/M01/86/51/wKioL1e77NriDKTJAABX2GGh lQ0742.png”>

650) this.width =650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”025.PNG” style=”float:none;” alt=”wKioL1e77NmziyCPAACQ3ctvDvY799.png “data-src=”http://s4.51cto.com/wyfs02/M00/86/51/wKioL1e77NmziyCPAACQ3ctvDvY799.png”>

< span style="font-size:24px;">2.8. Department-personnel relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn. com/vcimg/static/loading.png” title=”027.PNG” style=”float:none;” alt=”wKiom1e77VrxjzUHAABWCvD5rco485.png” data-src=”http://s1.51cto.com/wyfs02/M01 /86/52/wKiom1e77VrxjzUHAABWCvD5rco485.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”029.PNG” style=”float:none;” alt =”wKiom1e77VmxsU0cAACUdFi11CA018.png” data-src=”http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77VmxsU0cAACUdFi11CA018.png”>

2.9. Personnel-Leadership Relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/ vcimg/static/loading.png” title=”031.PNG” style=”float:none;” alt=”wKiom1e77dayZr0kAAA14GTVlr0016.png” data-src=”http://s4.51cto.com/wyfs02/M01/86 /52/wKiom1e77dayZr0kAAA14GTVlr0016.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img. voidcn.com/vcimg/static/loading.png” title=”0 33.PNG” style=”float:none;” alt=”wKiom1e77dXB3LaCAACXFidiVVg238.png” data-src=”http://s1.51cto.com/wyfs02/M00/86/52/wKiom1e77dXB3LaCAACXFidiVVg238.png”>

2.10. Personnel-role relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”035.PNG” style=”float:none;” alt=”wKiom1e77mCBXpCLAAAvtw4vhqU996.png” data-src =”http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77mCBXpCLAAAvtw4vhqU996.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”037.PNG” style=” float:none;” alt=”wKiom1e77mDiW0PxAAC2GPiuBro633.png” data-src=”http://s4.51cto.com/wyfs02/M00/86/52/wKiom1e77mDiW0PxAAC2GPiuBro633.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”039.PNG” alt=”wKiom1e77unwk_CNAABGb_1hD3M040.png” data-src=”http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77unwk_CNAABGb_1hD3M040.png”>

2.11, role-authority relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” style=” float:none;” title=”041.PNG” alt=”wKioL1e771uD3nOsAABSV3Bzo20300.png” data-src=”http://s5.51cto.com/wyfs02/M02/86/52/wKioL1e771uD3nOsAABSV3Bzo20300.png”>

650) this.width=650;” src=”/wp-content/uplo adshttp:/img.voidcn.com/vcimg/static/loading.png” title=”043.PNG” style=”float:none;” alt=”wKioL1e771rwpAlaAAC61XLH2ag927.png” data-src=”http://s1. 51cto.com/wyfs02/M01/86/52/wKioL1e771rwpAlaAAC61XLH2ag927.png”>

3. Physics Model

Generate physical model

650) this.width=650;” src=” /wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”045.PNG” style=”float:none;” alt=”wKiom1e78B_Rp_6FAABDq5v6jCM919.png” data-src=”http ://s1.51cto.com/wyfs02/M00/86/53/wKiom1e78B_Rp_6FAABDq5v6jCM919.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”047.PNG” style=”float:none;” alt=”wKiom1e78B6hHY_uAAC7PhI6Rmw248.png” data-src=”http://s4.51cto.com/wyfs02/M02/86/53/wKiom1e78B6hHY_uAAC7PhI6Rmw248.png”>

4. Generate SQL

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/ static/loading.png” title=”050.PNG” style=”float:none;” alt=”wKioL1e78L2wfvnGAABFJEC1EwI130.png” data-src=”http://s1.51cto.com/wyfs02/M00/86/52 /wKioL1e78L2wfvnGAABFJEC1EwI130.png”>

, , , , ,

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 857 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.