airline

Tables (10)

department

  • department_id — INT
  • department_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee

  • employee_id — INT
  • department_id — INT — NOT NULL
  • job_position_id — INT — NOT NULL
  • employee_status_code — VARCHAR(10) — NOT NULL
  • country_code — CHAR(2) — NOT NULL
  • city_code — CHAR(3) — NOT NULL
  • base_airport_id — INT — NOT NULL
  • office_id — INT — NOT NULL
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • hire_date — DATE — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee_attendance

  • attendance_id — INT
  • employee_id — INT — NOT NULL
  • attendance_date — DATE — NOT NULL
  • check_in_at — DATETIME — NOT NULL
  • check_out_at — DATETIME — NOT NULL
  • work_minutes — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee_certificate

  • certificate_id — INT
  • employee_id — INT — NOT NULL
  • certificate_type — VARCHAR(50) — NOT NULL
  • issued_at — DATE — NOT NULL
  • expires_at — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee_contact

  • employee_contact_id — INT
  • employee_id — INT — NOT NULL
  • contact_type — VARCHAR(50) — NOT NULL
  • contact_value — VARCHAR(100) — NOT NULL
  • is_primary — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee_salary

  • employee_salary_id — INT
  • employee_id — INT — NOT NULL
  • base_salary — INT — NOT NULL
  • allowance — INT — NOT NULL
  • currency_code — CHAR(3) — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee_shift

  • employee_shift_id — INT
  • employee_id — INT — NOT NULL
  • office_id — INT — NOT NULL
  • airport_id — INT — NOT NULL
  • shift_date — DATE — NOT NULL
  • shift_start_at — DATETIME — NOT NULL
  • shift_end_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee_status_code

  • employee_status_code — VARCHAR(10)
  • description — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

job_position

  • job_position_id — INT
  • job_name — VARCHAR(100) — NOT NULL
  • job_category — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

office

  • office_id — INT
  • airport_id — INT — NOT NULL
  • office_name — VARCHAR(100) — NOT NULL
  • office_type — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL