mySQL
Tables (3)
employee
- id — int — Primary key — NOT NULL
- name — varchar(45) — NOT NULL
- email — varchar(100) — NOT NULL
- salary — int — NOT NULL
- team — varchar(45) — NOT NULL
- quitDate — date
- createdAt — datetime
- roleId — int — Foreign key → role.id — NOT NULL — 아이디
employeeInfo
- id — int — Foreign key → employee.id — NOT NULL
- address — varchar(100)
- etc — text
role
- id — int — Primary key — NOT NULL — 아이디
- name — varchar(10) — NOT NULL — 직책이름
- minSalary — int — NOT NULL — 최저연봉