TEST
Tables (4)
department
- dept_id — VARCHAR(20)
- dept_name — VARCHAR(50)
- parent_dept_id — VARCHAR(20)
- manager_emp_id — VARCHAR(20)
department2
- dept_id — VARCHAR(20)
- dept_name — VARCHAR(50)
- parent_dept_id — VARCHAR(20)
- manager_emp_id — VARCHAR(20)
employee
- emp_id — VARCHAR(20)
- username — VARCHAR(30) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- dept_id — VARCHAR(20)
- position — VARCHAR(20)
- phone — VARCHAR(20)
- address — VARCHAR(100)
- bank_name — VARCHAR(20)
- bank_account — VARCHAR(50)
- hire_date — DATE
- status — VARCHAR(10)
- created_at — DATE
employee2
- emp_id — VARCHAR(20)
- username — VARCHAR(30) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- dept_id — VARCHAR(20)
- position — VARCHAR(20)
- phone — VARCHAR(20)
- address — VARCHAR(100)
- bank_name — VARCHAR(20)
- bank_account — VARCHAR(50)
- hire_date — DATE
- status — VARCHAR(10)
- created_at — DATE