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_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 ...

    • Activities: Creating New Event / Event Tab

      Purpose To explain the Event tab when creating a new event. Related Articles Methods to Create New Event within Activities Activities: Creating a New Event / Attendee Tab Activities: Payroll Summary Tab Activities: Setting a Recurring Event Video ...

    • Activities: Setting a Recurring Event

      Purpose To explain how to set a Recurring Event within the Activities module from the Event List. Related Articles Methods of Create New Event within Activities Activities: Creating New Event / Event Tab Activities: Creating New Event / Attendee Tab ...