Schemas | VelaStack

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
first_name* text
last_name* text
email* email
phone text
date_of_birth date
photo file
emergency_contact text
notes text
user users
created autodate
updated autodate

id* text
name* text
description text
price* number
billing_period* select
class_credits number
active bool
created autodate
updated autodate

id* text
member* members
plan* plans
starts_on* date
ends_on date
status* select
price_paid number
notes text
created autodate
updated autodate

id* text
member* members
membership memberships
checked_in_at* date
method select
created autodate
updated autodate

id* text
name* text
description text
instructor users
capacity* number
duration_minutes number
level select
created autodate
updated autodate

id* text
class* classes
starts_at* date
room text
cancelled bool
created autodate
updated autodate

id* text
session* class_sessions
member* members
status* select
created autodate
updated autodate

View Schema

Gym memberships

Members, plans, memberships with billing periods, check-ins and class bookings.

Bookings 7 collections

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
name* text
description text
max_guests* number
base_rate* number
photos file[]
amenities json
created autodate
updated autodate

id* text
number* text
room_type* room_types
floor number
status* select
notes text
created autodate
updated autodate

id* text
room_type* room_types
name* text
from* date
to* date
nightly* number
min_nights number
created autodate
updated autodate

id* text
first_name* text
last_name* text
email email
phone text
nationality text
document_number text
notes text
user users
created autodate
updated autodate

id* text
reference* text
guest* guests
additional_guests guests[]
room_type* room_types
room rooms
check_in* date
check_out* date
adults* number
children number
nightly_rate* number
total* number
status* select
source select
special_requests text
created autodate
updated autodate

id* text
booking* bookings
amount* number
method* select
paid_at* date
reference text
created autodate
updated autodate

View Schema

Hotel bookings

Rooms by type, seasonal rates, guests, bookings with nightly pricing and payments.

Bookings 6 collections

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
name* text
outdoor bool
sort number
created autodate
updated autodate

id* text
name* text
area* areas
seats* number
active bool
created autodate
updated autodate

id* text
name* text
day* select[]
opens_at* text
closes_at* text
max_covers number
created autodate
updated autodate

id* text
name* text
phone text
email email
allergies text
notes text
visits number
user users
created autodate
updated autodate

id* text
guest* guests
at* date
party_size* number
duration_minutes number
tables tables[]
status* select
source select
occasion text
notes text
created autodate
updated autodate

id* text
name* text
phone text
party_size* number
quoted_minutes number
status* select
reservation reservations
created autodate
updated autodate

View Schema

Restaurant reservations

Tables, service periods, reservations with party size and status, guests and waitlist.

Bookings 6 collections

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
user* users
title text
specialty text
bio text
photo file
accepting_patients bool
created autodate
updated autodate

id* text
name* text
description text
duration_minutes* number
price number
practitioners practitioners[]
created autodate
updated autodate

id* text
practitioner* practitioners
day* select
from* text
to* text
created autodate
updated autodate

id* text
first_name* text
last_name* text
date_of_birth date
email email
phone* text
address text
insurance_number text
allergies text
user users
created autodate
updated autodate

id* text
patient* patients
practitioner* practitioners
service* services
starts_at* date
ends_at* date
status* select
reason text
reminder_sent bool
created autodate
updated autodate

id* text
appointment* appointments
author* users
notes editor
diagnosis text
follow_up text
created autodate
updated autodate

View Schema

Clinic appointments

Patients, practitioners, services, availability, appointments and visit notes.

Bookings 6 collections

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
name* text
parent categories
sort number
created autodate
updated autodate

id* text
name* text
contact_name text
email email
phone text
address text
lead_time_days number
notes text
created autodate
updated autodate

id* text
name* text
description text
category categories
default_supplier suppliers
images file[]
active bool
created autodate
updated autodate

id* text
product* products
sku* text
barcode text
name* text
attributes json
cost number
price* number
reorder_point number
active bool
created autodate
updated autodate

id* text
name* text
address text
kind select
active bool
created autodate
updated autodate

id* text
variant* variants
location* locations
on_hand* number
reserved number
created autodate
updated autodate

id* text
variant* variants
location* locations
quantity* number
kind* select
reference text
reason text
recorded_by users
created autodate
updated autodate

id* text
number* text
supplier* suppliers
location* locations
status* select
expected_on date
notes text
created autodate
updated autodate

id* text
purchase_order* purchase_orders
variant* variants
quantity* number
received number
unit_cost number
created autodate
updated autodate

View Schema

Inventory

Products with variants, suppliers, locations, stock levels and every movement.

Operations 9 collections

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
title* text
slug* text
summary text
description editor
instructor* users
cover file
level select
price number
published bool
created autodate
updated autodate

id* text
course* courses
title* text
sort* number
created autodate
updated autodate

id* text
module* modules
title* text
content editor
video_url url
duration_minutes number
sort* number
free_preview bool
created autodate
updated autodate

id* text
learner* users
course* courses
enrolled_at* date
completed_at date
progress_percent number
created autodate
updated autodate

id* text
enrollment* enrollments
lesson* lessons
completed bool
seconds_watched number
last_viewed_at date
created autodate
updated autodate

id* text
lesson* lessons
title* text
questions* json
pass_percent number
created autodate
updated autodate

id* text
quiz* quizzes
enrollment* enrollments
answers* json
score_percent number
passed bool
created autodate
updated autodate

id* text
enrollment* enrollments
number* text
issued_at* date
pdf file
created autodate
updated autodate

View Schema

Online courses

Courses with modules and lessons, enrollments, lesson progress, quizzes and certificates.

Content 8 collections

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
name* text
address text
city text
location geo
capacity number
created autodate
updated autodate

id* text
title* text
slug* text
description editor
venue* venues
organizer* users
starts_at* date
ends_at date
cover file
status* select
created autodate
updated autodate

id* text
event* events
name* text
description text
price* number
quota* number
sold number
sales_start date
sales_end date
max_per_order number
created autodate
updated autodate

id* text
event* events
code* text
kind* select
value* number
max_uses number
uses number
expires_at date
created autodate
updated autodate

id* text
number* text
event* events
buyer users
email* email
name* text
promo_code promo_codes
subtotal* number
discount number
total* number
status* select
payment_reference text
created autodate
updated autodate

id* text
order* orders
ticket_type* ticket_types
code* text
holder_name text
checked_in_at date
checked_in_by users
status* select
created autodate
updated autodate

View Schema

Event ticketing

Venues, events, ticket types with quotas, orders, tickets with check-in and promo codes.

Commerce 6 collections

id* text
password* password
tokenKey* text
email* email
emailVisibility bool
verified bool
name text
avatar file
created autodate
updated autodate

id* text
name* text
contact_name text
email* email
phone text
billing_address text
tax_id text
currency text
payment_terms_days number
notes text
owner* users
created autodate
updated autodate

id* text
name* text
description text
unit_price* number
tax_rate number
unit text
active bool
owner* users
created autodate
updated autodate

id* text
number* text
client* clients
issued_on* date
due_on* date
status* select
currency* text
subtotal number
tax number
total number
amount_paid number
notes text
pdf file
owner* users
created autodate
updated autodate

id* text
invoice* invoices
item items
description* text
quantity* number
unit_price* number
tax_rate number
total number
sort number
created autodate
updated autodate

id* text
invoice* invoices
amount* number
paid_on* date
method* select
reference text
notes text
created autodate
updated autodate

id* text
client* clients
every* select
next_on* date
last_issued_on date
lines* json
active bool
owner* users
created autodate
updated autodate

View Schema

Invoicing

Clients, items, invoices with lines and tax, payments, recurring schedules.

Finance 6 collections