v_event

v_event

Purpose

  1. Event records and tracking.

Relationships


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

    • One event can have many participants

    • Referenced through event_id

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

    • One event can have many payroll entries

    • Referenced through event_id

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

    • Many events created by one personnel

    • Referenced through created_by



Table



Column

Type

Description

id

integer

Primary key

event_type_id

integer

Type reference

event_name

varchar(50)

Event name

start_date

timestamp

Start time

end_date

timestamp

End time

duration

numeric

Duration

first_name

varchar(64)

Contact first name

last_name

varchar(64)

Contact last name

address

varchar(300)

Event location

client_code

varchar(28)

Organization ID

event_notes

text

Notes

young_children_attendees

integer

Child count

school_children_attendees

integer

Student count

adult_attendees

integer

Adult count

senior_adult_attendees

integer

Senior count

total_attendees

integer

Total attendance

created_at

timestamp

Creation time

created_by

integer

Creator reference





    • Related Articles

    • v_event_participant

      Purpose Event participation tracking records. Relationships v_event: Many-to-One (N:1) Many participants link to one event Referenced through event_id v_personnel: Many-to-One (N:1) Many participants link to one personnel record Referenced through ...

    • v_event_payroll_summary

      Purpose Event-related payroll records. Relationships v_event: Many-to-One (N:1) Many payroll records link to one event Referenced through event_id v_personnel: Many-to-One (N:1) Many payroll records link to one personnel Referenced through user_id ...

    • v_personnel_employment_history

      Purpose Personnel employment history records. Relationships v_personnel: Many-to-One (N:1) Many history records link to one personnel Referenced through user_id v_fire_dept_user: Many-to-One (N:1) Many history records created by one user Referenced ...

    • v_fire_dept_user

      Purpose Fire department user information. Relationships v_personnel: One-to-One (1:1) One user links to one personnel record Referenced through id/user_id f_all_schedule: One-to-Many (1:N) One user can have many schedules Referenced through user_id ...

    • Events & Activities: Where to create an Event

      Purpose Statement This guide provides a comprehensive overview of all available locations for creating events within the Events and Activities module. Understanding the multiple event creation access points enables users to efficiently create events ...