Home
stem20
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
events
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
address
string
attendances
id
bigIncrements
student_id
FK
bigInteger
event_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_credits
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
integer
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_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
verified
boolean
attendance_keyword
keyword_id
FK
bigInteger
student_id
FK
bigInteger
attendance_id
FK
bigInteger
credits
integer
timestamps
timestamps
softDeletes
softDeletes
event_keyword
event_id
FK
bigInteger
keyword_id
FK
bigInteger
credits
integer
institutions
id
bigIncrements
institution_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
ico
string
(8)
active
boolean
phone_country
string
(2)
email
string
institution_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
email_verified_at
timestamp
phone_country
string
(2)
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_involvement
event_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_levels
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
decision_approved
boolean
rating_scope
integer
stem_hours
integer
s1
integer
s2
integer
s3
integer
evaluator_id
FK
bigInteger
s4
integer
s5
integer
s6
integer
status
enum
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
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
×
Comments for stem20
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01