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