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