v_training_instructor

v_training_instructor

Purpose

  1. Training class instructor records.

Relationships

  • v_training_class: Many-to-One (N:1)

    • Many instructors link to one class

    • Referenced through training_class_id

  • v_personnel: Many-to-One (N:1)

    • Many instruction records link to one personnel

    • Referenced through instructor_id


Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

training_class_id

integer

Class reference

instructor_type_id

integer

Type reference

instructor_id

integer

Instructor reference

instructor_name

varchar(255)

Instructor name

instructor_external_id

integer

External reference

instructor_external_name

varchar(100)

External name

instructor_type

varchar(100)

Instructor type

class_name

varchar(255)

Class name

is_external

boolean

External flag




    • Related Articles

    • v_training_class

      Purpose Training class records. Relationships v_training_class_attendee: One-to-Many (1:N) One class can have many attendees Referenced through training_class_id v_training_class_instructor: One-to-Many (1:N) One class can have many instructors ...

    • Training Setup: Instructor Management

      Purpose Statement The Instructor Management section within the Training Module Setup allows administrators to designate, organize, and manage all instructors who will deliver training within the Fire/EMS department. This comprehensive system handles ...

    • v_training_class_attendee

      Purpose Training class attendance records. Relationships v_training_class: Many-to-One (N:1) Many attendees link to one class Referenced through training_class_id v_personnel: Many-to-One (N:1) Many attendance records link to one personnel Referenced ...

    • v_training_certification_user

      Purpose User training certification records. Relationships v_training_certification: Many-to-One (N:1) Many user certs link to one certification type Referenced through training_certification_id v_personnel: Many-to-One (N:1) Many certifications held ...

    • Training Set-Up: Courses vs Classes

      Understanding Courses vs. Classes in the Training Module Purpose Statement The Training Module distinguishes between "Courses" and "Classes" to streamline training management across your department. Courses serve as reusable templates that establish ...