Events

Field

Type

Description

Joins

id

primary key (int)

id of event

event_id in event_attendees/ event_shifts/ event_documents tables

name

text

name of event

unique to table

campaign_id

foreign key (int)

id of campaign associated with the event

id in campaigns table

organization_id

foreign key (int)

id of organization hosting the event

id in organizations table

start_time

timestamp

date&time event shift starts

unique to table

end_time

timestamp

date&time event shift ends

unique to table

public

text

t/f if the event is a public event

unique to table

location_id

foreign key (int)

id of location of event

id in locations table

extras

jsonb

extra details on the event

unique to table

created_at

timestamp

date&time event was created

unique to table

updated_at

timestamp

date&time event was last updated

unique to table

slug

text

url slug of the event

unique to table

description

text

description of the event

unique to table

created_by_user_id

foreign key (int)

id of user who created the event

id in users table

public_page_header_data

jsonb

data of the header of the public registration page

unique to table

attended_count

integer

count of people marked as attending the event

unique to table

invited_count

integer

count of people on the attendance list regardless of status

unique to table

turf_id

foreign key (int)

id of turf of the event

in in turfs table

notes

text

notes added to the event

unique to table

type

text

type of event

unique to table

public_settings

jsonb

settings of public event registration page

unique to table

url

text

url associated to the event

unique to table

url_label

text

label of the url associated to the event

unique to table