This is personal study note
Copyright and original reference:
https://www.youtube.com/watch?v=yrBXTq3XRKw&list=PLVsNizTWUw7HhYtI-4GGmlJ5yxNdwNI_X
================================================================================
MySQL provides the "modeling (ER: entity relationship) tool"
================================================================================
Create userTBL with fields
Create buyTBL with fields
select 1:N relationship
click field for N key
click field for 1 key
================================================================================
mwb: MySQL WorkBench model
================================================================================
Open saved model
================================================================================
This ER model can be automatically implemented into DB structure
automatically generated scripts
See generated DB
================================================================================
Reverse engineering:
- DB to ER model