v_event_participant

v_event_participant

Purpose

  1. 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 user_id



Table



Column

Type

Description

id

integer

Primary key

user_id

integer

User reference

first_name

varchar(64)

First name

last_name

varchar(64)

Last name

middle_name

varchar(64)

Middle name

name_suffix

varchar(8)

Name suffix

client_code

varchar(28)

Organization ID

email

varchar(255)

Email contact

event_id

integer

Event reference

event_name

varchar(50)

Event name

event_date

date

Event date





    • Related Articles

    • v_event

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

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

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

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

    • Events & Activities: Creating a New Event (Event Tab)

      Purpose Statement The Event tab within the event creation interface provides comprehensive tools for configuring all essential event details including timing, location, personnel assignments, attendee information, and supporting documentation. This ...