dashboard - Laravel Schema Designer

Camps

id increments
timestamps timestamps
city string
date_from date
date_to string

CampDocuments

id increments
camp_id ^FK integer
timestamps timestamps
document_url string
document_description string

CampDays

id increments
camp_id integer
timestamps timestamps
camp_day_number integer
camp_day_weekday tinyInteger
camp_day_date date
camp_day_start time
camp_day_end time

AttendantType

id increments
timestamps timestamps
description string

Participants

id increments
timestamps timestamps
firstname string
lastname string
street string
zip smallInteger
city string
birthdate date
referral integer
gender integer
diet integer
specialities string
camp_id ^FK integer
legal_guardian_id integer

CampFeedback

id increments
timestamps timestamps
camp_id ^FK integer
attendance_id ^FK integer

Attendances

id increments
timestamps timestamps
participant_id ^FK integer
laptop_rental boolean
fee_waived boolean
camp_day_id ^FK integer
laptop_checkout_number integer
laptop_checkin_number integer
checkin boolean
checkout boolean
excused boolean
type_id integer

Gender

id increments
timestamps timestamps
description string

Diets

id increments
timestamps timestamps

LegalGuardian

id increments
timestamps timestamps
legal_guardian_firstname string
legal_guardian_lastname string
legal_guardian_email string
legal_guardian_phone string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01