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
Referenced through training_class_id
v_training_class_training_objective: One-to-Many (1:N)
One class can have many objectives
Referenced through training_class_id
v_personnel: Many-to-One (N:1)
Many classes created by one personnel
Referenced through created_by
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
place_name | varchar(255) | Location name |
name | varchar(255) | Class name |
internal_course_xref_id | varchar(255) | Internal reference |
duration_hours | numeric(8,2) | Duration |
start_date | date | Start date |
end_date | date | End date |
start_time | time | Start time |
end_time | time | End time |
training_category_id | integer | Category reference |
description | text | Class description |
class_status_code | varchar(16) | Status code |
completed_at | timestamp | Completion time |
water_usage | numeric(9,1) | Water used |
category_name | varchar(100) | Category name |
topic_names | text | Topics covered |
created_at | timestamp | Creation time |
created_by | integer | Creator reference |
training_type_ids | integer[] | Type references |