3
EER- MySQL Workbench.
: MySQL Workbench MySQL.
:
1. MySQL Workbench ;
2. EER-;
3. EER-, .
:
( ) EER- MySQL Workbench.
1
MySQL Workbench
MySQL Workbench - , , , MySQL.
, ' , . EER-, .
MySQL Workbench . - 6.3. :
Microsoft Windows ( MSI Installer ZIP )
Ubuntu Linux
Fedora
Red Hat Enterprise Linux / Oracle Linux
Mac OS X
ϳ Oracle. , " No thanks, just start my download " - . , .
MySQL Workbench. - :
MySQL , - . MySQL Workbench. !
EER-
, . " Models " " File → New Model " (Ctrl + N):
ϳ :
' mydb. Edit schema. ' . , , oblik rezultativ sesii.
|
|
. , , , .
. utf8- utf8_general_ci. . ³ .
ij . Add diagram, :
. , . ' table1. , ' .
³ (VIDDILENNYA). : KV, NV, ϲ . PIB_ZV.
table1 VIDDILENNYA .
:
' ( !);
. ( mysql ):
INT - ;
VARCHAR () - , ;
DECIMAL (, _) - ;
DATE - ;
DATETIME - .
, , :
PK (primary key) - ;
NN (not null) - ;
UQ (unique) - ;
AI (auto incremental) - , , : 1, 2, 3, ..;
DEFAULT - , , , , .
:
(SPECIALNIST). : KS, NS.
:
, . , , , .
' . ' ³ ( ) ( ), ' 1:.
' 1: ( ), . ', , .
, , , ³:
, . ̳ . , - . , , ' viddilennya_kv (, ' ' ). fk_specialnist_viddilennya_idx.
|
|
(GRUPA). : KG, NG, ʳ Kst, Kurs, ϲ PIB_KL.
.
(STUDENT). : ZK, PS, IS, PBS, DN, TS, FF.
.
(DISCUPLINA). : KD, ND, VK.
, .
, , ( , ).
' .
, ' . ̳ ' , , :
ocinka (), ocinka.
EER- :
, (Ctrl+S).