study
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(20) — NOT NULL
- quit_data — date
- created_at — datetime
- role_id — int — Foreign key → role.id — NOT NULL — 직책 아이디
employee_info
- id — int — Foreign key → employee.id — NOT NULL
- adress — varchar(100)
- etc — text
role
- id — int — Primary key — NOT NULL — 직책 아이디
- name — varchar(10) — NOT NULL — 직책 이름
- min_salary — int — NOT NULL — 최저 연봉