test
Tables (10)
Addresses
- address_id — INT
- employee_id — INT
- address_line1 — VARCHAR(255)
- address_line2 — VARCHAR(255)
- city — VARCHAR(100)
- state — VARCHAR(100)
- postal_code — VARCHAR(20)
- country — VARCHAR(100)
Certifications
- certification_id — INT
- employee_id — INT
- certification_name — VARCHAR(255)
- issued_by — VARCHAR(255)
- issue_date — DATE
- expiry_date — DATE
Companies
- company_id — INT
- company_name — VARCHAR(100) — NOT NULL
- is_head_office — BOOLEAN
Departments
- department_id — INT
- company_id — INT
- department_name — VARCHAR(100) — NOT NULL
Education
- education_id — INT
- employee_id — INT
- school_name — VARCHAR(255)
- degree — VARCHAR(100)
- field_of_study — VARCHAR(100)
- start_date — DATE
- end_date — DATE
EmployeeDetails
- detail_id — INT
- employee_id — INT
- fax — VARCHAR(20)
Employees
- employee_id — INT
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20)
- department_id — INT
LoginHistory
- login_id — INT
- user_id — INT
- login_timestamp — TIMESTAMP
Roles
- role_id — INT
- role_name — VARCHAR(50) — NOT NULL
Users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- role_id — INT
- is_approved — BOOLEAN
- created_at — TIMESTAMP