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