(DB) ERD 다이어 그램 만들어 보기 - 16

 

https://app.diagrams.net/

Flowchart Maker & Online Diagram Software

https://dbdiagram.io/d

dbdiagram.io - Database Relationship Diagrams Design Tool

 

 

show create table employees;

show create table dept_emp;

CREATE TABLE `employees` (
   `emp_no` int NOT NULL,
   `birth_date` date NOT NULL,
   `first_name` varchar(14) NOT NULL,.
   `last_name` varchar(16) NOT NULL,
   `gender` enum('M','F') NOT NULL,
   `hire_date` date NOT NULL,
   PRIMARY KEY (`emp_no`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci