test
Tables (3)
employee
- id — int — Primary key — NOT NULL
- name — varchar(45) — Primary key — NOT NULL
- email — varchar(100) — NOT NULL
- salary — int — NOT NULL
- team — varchar(45) — NOT NULL
- quit_daste — date
- created_at — datetime
- role_id — int — Foreign key → role.id — NOT NULL — 직책아이디
employee_info
- id (id2) — int — Foreign key → employee.id — NOT NULL
- name — varchar(45) — Foreign key → employee.name — NOT NULL
- id — int — NOT NULL
- address — varchar(100)
- etc — text
role
- id — int — Primary key — NOT NULL — 직책아이디
- name — varchar(10) — NOT NULL — 직책이름
- minSalary — int — NOT NULL — 최저연봉