Table: employees
- employee_id
int(11) - first_name varchar(50)
- last_name varchar(50)
- email varchar(50)
- phone_number varchar(15)
- hire_date date
- job_id varchar(10)
- salary decimal(10,2)
- commission_pct decimal(3,2)
- manager_id int(11)
- department_id int(11)
Table: departments
- city varchar(50)
- country_id varchar(5)
- country_Name varchar(100)
- department_id int(11)
- employee_id int(11)
- first_name varchar(50)
- job_id varchar(10)
- job_title varchar(100)
- last_name varchar(50)
- location_id int(11)
- Manager ID: int(11)
- region_name varchar(100)
- state_province varchar(100)
- commission_pct decimal(10,2)
- salary decimal(10,2)
Table: Jobs
- job_id varchar(10)
- job_title varchar(100)
- max_salary int(11)
- min_salary int(11)
Table: orders
- order_id int(11)
- user_id int(11)
- product_id int(11)
- quantity int(11)
Table: products
- product_id int(11)
- product_name varchar(100)
- category varchar(100)
- price decimal(10,2)
Table: users
- id int(11)
- first_name varchar(100)
- last_name varchar(100)
- phone varchar(20)
- email varchar(100)
- password varchar(100)