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