Entities

Bands

table name: bands

id	name	url
int	text	text nullable

Dance teachers

table name: dance_teachers

id	name	url
int	text	text nullable

DJs

table name: djs

id	name	url
int	text	text nullable

Dance types

table name: dance_types

id	name	color	image
int	text	text	text

Dances

table name: dances

id	name	content	dance_type_id
int	text	text nullable	integer

Articles

table name: articles

id	title	photo	content	published_at
int	text	text	text nullable	datetime nullable

Workshops

table name: workshops

id	title	photo	start_date	end_date	program	content	dance_id	dance_teacher_id	theme	facebook_event	application_form	party_id
int	text	text	datetime	datetime	text	text	int	int	text	text	text	int

Parties

table name: parties

id	title	photo	start_date	end_date	program	content	facebook_event	application_form	spot	bss	dance_course_id	spot_cover	bss_cover
int	text	text	datetime	datetime	text	text	string	string	string	string	dance_course_id	string	string

DJ party

table name: dj_party

dj_id	party_id
int	int

Band party

table name: band_party

band_id	party_id
int	int

Dance courses

table name: dance_course

id	dance_teacher_id	dance_id	level	length
int	int	int	text	text

Users

table name: users

id	name	email	role	authsch_id	member_id
int	text	text	text	text	int

Members

table name: members

id	name	email	position	description	image
int	text	text	text	text	text