Skip to content

Entities

János Fehér edited this page Mar 29, 2019 · 20 revisions

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
Clone this wiki locally