Skip to content

Events Schema

Event records with scheduling, location, and ticketing.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
organizer_iduuidNO—
titletextNO—
slugtextNO—
descriptiontextYES—
short_descriptiontextYES—
thumbnail_urltextYES—
locationtextYES—
location_typetextNO'online'
linktextYES—
starts_attimestamptzNO—
ends_attimestamptzNO—
timezonetextNO'UTC'
capacityintegerYES—
statustextNO'draft'
ticket_count_soldintegerNO0
metadatajsonbNO'{}'
published_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Event speaker profiles.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
event_iduuidNO—
profile_iduuidYES—
nametextNO—
titletextYES—
biotextYES—
avatar_urltextYES—
sort_orderintegerNO0
created_attimestamptzNOnow()

Event ticket tiers with pricing and sale windows.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
event_iduuidNO—
nametextNO—
descriptiontextYES—
pricenumericNO0
quantityintegerYES—
sold_countintegerNO0
sales_starttimestamptzYES—
sales_endtimestamptzYES—
sort_orderintegerNO0
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Individual ticket purchases with check-in tracking.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
ticket_type_iduuidNO—
event_iduuidNO—
buyer_iduuidNO—
payment_iduuidYES—
quantityintegerNO1
total_amountnumericNO—
statustextNO'pending'
ticket_codetextNO—
checked_in_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()