tic - Laravel Schema Designer

users

id increments
dni string (255)
first_name string (50)
birth_date date
last_name string (50)
gender tinyInteger
email string (255)
avatar string (15)
password string (60)
facebook_id string (60)
google_id string (60)
confirmed tinyInteger
confirmation_code string (255)
remember_token string (100)
timestamps timestamps

courses

id increments
subject_id ^FK integer
name string (255)
start_date date
end_date string
levels smallInteger
registration_type integer
image string (255)
threshold decimal (8,3)
approval_percentage decimal (8,2)
has_certificate tinyInteger
registration_timing string (10)
supported_by text
paid tinyInteger
cost decimal (8,2)
n_modules integer
n_problems integer
timestamps timestamps
deleted_at timestamp
n_resources integer
pin string (30)
type tinyInteger

problems

id increments
timestamps timestamps
name string (255)
type tinyInteger
problem_type_id ^FK integer
subject_id ^FK integer

resources

id increments
subject_id ^FK integer
name string (255)
description text
duration integer
url string (500)
type string (50)
timestamps timestamps

modules

id increments
course_id ^FK integer
name string (255)
description text
start_date timestamp
end_date timestamp
visible tinyInteger
timestamps timestamps
n_problems integer
n_resources integer

topic_replies

id increments
user_id ^FK integer
resported_user_id ^FK integer
reply text
spam tinyInteger
timestamps timestamps

achievements

id increments
name string (255)
description string (255)
reward integer
timestamps timestamps

groups

id increments
name string (255)
course_id ^FK integer
timestamps timestamps

purchases

id increments
user_id ^FK integer
course_id ^FK integer
reference_code string (255)
status integer
data_response_page text
data_confirmation_page text
timestamps timestamps

levels

id increments
timestamps timestamps
name string (255)
image string (255)
description text

likes

id increments
user_id ^FK integer
wall_message_id ^FK integer
topic_reply_id integer
timestamps timestamps

module_problem_user_attempted

id increments
module_id ^FK integer
user_id ^FK integer
problem_id ^FK integer
grade decimal (8,2)
start_date timestamp
end_date timestamp
feedback string (500)
running_code tinyInteger
timestamps timestamps
feedback_html text
code text
errors text
response text
execution_time decimal (8,2)

problems_code

id increments
problem_id ^FK integer
input text
output text
memory integer
time integer
timestamps timestamps

problems_completion

id increments
problem_id ^FK integer
parameters text
formulation text
responses text
timestamps timestamps

problems_selection

id increments
problem_id ^FK integer
parameters text
formulation text
responses text
timestamps timestamps

survey_answers

id increments
answer text
user_id ^FK bigInteger
survey_question_id ^FK bigInteger
timestamps timestamps

chats

id increments
user_from ^FK integer
user_to ^FK integer
message text
read tinyInteger
timestamps timestamps

connections

id increments
user_id ^FK integer
course_id ^FK integer
timestamps timestamps

duels

id increments
course_id ^FK integer
problem_id ^FK integer
defiant_user_id ^FK integer
opponent_user_id ^FK integer
bet integer
winner_user_id ^FK integer
status tinyInteger
defiant_responded string
opponent_responded tinyInteger
timestamps timestamps

friendships

id increments
user_a_id ^FK integer
user_b_id ^FK integer
confirmed tinyInteger
timestamps timestamps

historical_levels

id increments
course_id ^FK integer
user_id ^FK integer
level_id ^FK integer
timestamps timestamps

pin_schools

id increments
pin string (255)
used tinyInteger
timestamps timestamps

survey_questions

id increments
course_id ^FK integer
question text
type smallInteger
enabled tinyInteger
timestamps timestamps

wall_messages

id increments
course_id ^FK integer
user_id ^FK integer
wall_message_id ^FK integer
reached_achievement_id ^FK integer
reported_user_id ^FK integer
message text
spam boolean
timestamps timestamps

module_problem_user_summary

id increments
module_id ^FK integer
user_id ^FK integer
problem_id ^FK integer
best_score decimal (8,2)
solved boolean
n_problems_attempts integer
skipped boolean
timestamps timestamps

enrollments

id increments
group_id ^FK integer
level_id ^FK integer
user_id ^FK integer
role integer
points integer
previous_individual_position string
previous_group_position string
percentage decimal (8,2)
n_problems_ttempts integer
n_problems_solved integer
comment text
anonymous tinyInteger
rating decimal
rated_at timestamp
streak integer
n_resouces_views integer
n_topic_replies_likes integer
timestamps timestamps
n_twitter_shares integer
n_facebook_shares integer

reached_achievements

id increments
user_id ^FK integer
course_id ^FK integer
achievement_id ^FK integer
shared_ticademia tinyInteger
shared_facebook tinyInteger
shared_twitter string
timestamps timestamps

global_notifications

id increments
course_id ^FK integer
user_id ^FK integer
body text
active integer
timestamps timestamps

module_resource_user_summary

id increments
user_id ^FK integer
module_id ^FK integer
rating decimal (8,2)
comment text
anonymous tinyInteger
rated_at timestamp
resource_id ^FK integer
timestamps timestamps

module_problem

id increments
module_id ^FK integer
problem_id ^FK integer
best_user_id ^FK integer
n_problems_attempts integer
n_problems_solved boolean
best_score decimal (8,2)
timestamps timestamps
visible tinyInteger
order integer

module_resource

id increments
module_id ^FK integer
resource_id ^FK integer
n_rating_avg decimal (8,2)
n_rating_count integer
visible tinyInteger
n_resources_views integer
timestamps timestamps

module_user

id increments
module_id ^FK integer
user_id ^FK integer
n_problems_attempts integer
n_problems_solved integer
timestamps timestamps
n_resources_views integer

module_resource_user_views

id increments
module_id ^FK integer
resource_id ^FK integer
user_id ^FK integer
timestamps timestamps

notifications

id increments
reached_achievement_id ^FK integer
user_id ^FK integer
course_id ^FK integer
url string
image string
title string
body string (512)
viewed tinyInteger
timestamps timestamps

problem_types

id increments
timestamps timestamps
name string
value integer
min_value integer
decrement integer

subjects

id increments
timestamps timestamps
name string (255)

institutions

id increments
timestamps timestamps
name string
url string (255)
logo string

supporters

id increments
timestamps timestamps
institution_id integer
course_id ^FK integer

Likes_

id increments
timestamps timestamps
likeable_type string (100)
likeable_id bigInteger
user_id bigInteger

comments

id increments
timestamps timestamps
commentable_type string
commentable_id string
n_likes string
n_dislikes string
n_comments string
user_id string
body string