stem20 - Laravel Schema Designer

event_facts

id bigIncrements
institution_id ^FK bigInteger
user_id ^FK bigInteger
accreditation_id ^FK bigInteger
scope_rating_id ^FK bigInteger
episode_type_id ^FK bigInteger
quiz_id ^FK bigInteger
quiz_public boolean
name string (256)
description string (2048)
age0 boolean
age1 boolean
age2 boolean
age3 boolean
price string (512)
web string (512)
internal_text string (1024)
attend_hours integer
immediate_attendance boolean
lat double
lng double
capacity integer
accreditation_approved boolean
s1 integer
s2 integer
s3 integer
s4 integer
s5 integer
s6 integer
s7 integer
s8 integer
timestamps timestamps
softDeletes softDeletes
public_registration boolean

attendances

id bigIncrements
student_id ^FK bigInteger
event_facts_id ^FK bigInteger
event_realization_id ^FK bigInteger
challenge_id ^FK bigInteger
quiz_id ^FK bigInteger
activity_id ^FK bigInteger
credits integer
s1 integer
s2 integer
s3 integer
s4 integer
s5 integer
s6 integer
s7 integer
s8 string
timestamps timestamps
softDeletes softDeletes
notified boolean
state enum
max_creadits integer

students

id bigIncrements
name string (128)
surname string (128)
nick string (128)
email string (256)
birthyear integer
s1 integer
s2 integer
s3 integer
s4 integer
s5 integer
s6 integer
s7 integer
s8 integer
s1_period integer
s2_period string
s3_period integer
s4_period integer
s5_period integer
s6_period integer
s7_period integer
s8_period integer
timestamps timestamps
softDeletes softDeletes

event_realizations

id bigIncrements
event_facts_id ^FK bigInteger
date_from datetime
date_to datetime
realization_comment string (2048)
timestamps timestamps
softDeletes softDeletes
public boolean

challenges

id bigIncrements
institution_id ^FK bigInteger
user_id ^FK bigInteger
accreditation_id ^FK bigInteger
episode_type_id ^FK bigInteger
name string (256)
description string (4096)
internal_text string (1024)
credits integer
accreditation_approved boolean
s1 integer
s2 integer
s3 integer
s4 integer
s5 integer
s6 integer
s7 integer
s8 integer
timestamps timestamps
softDeletes softDeletes

quizes

id bigIncrements
institution_id ^FK bigInteger
user_id ^FK bigInteger
accreditation_id ^FK bigInteger
episode_type_id ^FK bigInteger
involvement_id ^FK bigInteger
name string (256)
description string (2048)
internal_text string (1024)
max_credits integer
accreditation_approved boolean
s1 integer
s2 integer
s3 integer
s4 integer
s5 integer
s6 integer
s7 integer
s8 integer
credits integer
preparation_hours integer
timestamps timestamps
softDeletes softDeletes

keywords

id bigIncrements
parent_id ^FK bigInteger
name string (128)
description string (1024)
timestamps timestamps
softDeletes softDeletes

att_keywords

keyword_id ^FK bigInteger
student_id ^FK bigInteger
attendance_id ^FK bigInteger
credits integer
timestamps timestamps
softDeletes softDeletes

event_facts_keyword

event_facts_id ^FK bigInteger
keyword_id ^FK bigInteger
credits integer

institutions

id bigIncrements
inst_category_id ^FK bigInteger
responsible_id ^FK bigInteger
name string (128)
description string (1024)
street string (128)
city string (128)
zip string (8)
phone string (16)
logo string (256)
photo string (256)
web string (128)
timestamps timestamps
softDeletes softDeletes
lat float
lng float

inst_categories

id bigIncrements
name string (128)
timestamps timestamps
softDeletes softDeletes

users

id bigIncrements
institution_id ^FK bigInteger
name string (128)
surname string (128)
prefix string (64)
suffix string (64)
email string (256)
phone string (16)
bonus_volume integer
timestamps timestamps
softDeletes softDeletes
bonus_limit integer

episode_types

id bigIncrements
name string (128)
ratio double
description string (1024)
timestamps timestamps
softDeletes softDeletes

episode_type_involvement

episode_type_id ^FK bigInteger
involvement_id ^FK bigInteger

event_facts_involvement

event_facts_id ^FK bigInteger
involvement_id ^FK bigInteger
credits integer
preparation_hours integer
involvement_qr string (256)
softDeletes softDeletes
timestamps timestamps

challenge_elements

id bigIncrements
challenge_id ^FK bigInteger
event_realization_id ^FK bigInteger
quiz_id ^FK bigInteger
activity_id ^FK bigInteger
level integer
description string (2048)
timestamps timestamps
softDeletes softDeletes

challenge_level

challenge_id ^FK bigInteger
level integer
limit integer
description string (2048)
timestamps timestamps
softDeletes softDeletes

scope_ratings

id bigIncrements
name string (256)
rating integer
timestamps timestamps
softDeletes softDeletes

accreditations

id bigIncrements
timestamps timestamps
softDeletes softDeletes
concept integer
request integer
rating integer
count integer
proposal integer
decision_approved boolean
rating_scope integer
rating_excellence integer
rating_equality integer
rating_stem integer
rating_prestige integer
s1 integer
s2 integer
s3 integer
s4 integer
s5 integer
s6 integer
s7 integer
s8 integer

challenge_keyword

challenge_id ^FK bigInteger
keyword_id ^FK bigInteger
credits integer

quiz_keyword

quiz_id ^FK bigInteger
keyword_id ^FK bigInteger
credits integer

involvements_types

id bigIncrements
name string (128)
description string (1024)
ratio double
timestamps timestamps
softDeletes softDeletes

activities

id bigIncrements
institution_id ^FK bigInteger
user_id ^FK bigInteger
episode_type_id ^FK bigInteger
involvement_id ^FK bigInteger
name string (256)
description string (2048)
internal_text string (1024)
link string (512)
date datetime
accreditation_approved boolean
s1 integer
s2 integer
s3 integer
s4 integer
s5 integer
s6 integer
s7 integer
s8 integer
credits integer
preparation_hours integer
timestamps timestamps
softDeletes softDeletes

activity_keyword

activity_id ^FK bigInteger
keyword_id ^FK bigInteger
credits integer

groups

id bigIncrements
owner_user_id ^FK bigInteger
owner_student_id ^FK bigInteger
name string (128)
description string (1024)
timestamps timestamps
softDeletes softDeletes

student_group

student_id ^FK bigInteger
group_id ^FK bigInteger
access enum
usage enum
timestamps timestamps
softDeletes softDeletes

event_involvement_credits

id increments
timestamps timestamps
softDeletes softDeletes