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

    • 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: Creating New Event / Participants Tab

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

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