sirilo - Laravel Schema Designer

users

id increments
first_name string
last_name string
email string
document string
gender char
birthdate date
country_code ^FK integer
department_code ^FK integer
municipality_code ^FK integer
photo boolean
timestamps timestamps

purchases

id increments
user_id ^FK integer
coupon_Id ^FK integer
date datetime
price integer
payment_type string
payment_reference string
payment_status string
payment_response_page string
payment_confirmation_page string
timestamps timestamps

tests

id increments
user_id ^FK integer
purchase_id ^FK integer
start_date datetime
last_access datetime
status json
completed boolean
Holland_R float (5,4)
Holland_I float (5,4)
Holland_A float (5,4)
Holland_S float (5,4)
Holland_E float (5,4)
Holland_C float (5,4)
MBTI_EI float (5,4)
MBTI_SN float (5,4)
MBTI_TF float (5,4)
MBTI_JP float (5,4)
MBTI_R float (5,4)
MBTI_I float (5,4)
MBTI_A float (5,4)
MBTI_S float (5,4)
MBTI_E float (5,4)
MBTI_C float (5,4)
Ability_AR float (5,4)
Ability_CM float (5,4)
Ability_SA float (5,4)
Ability_TP float (5,4)
Ability_VA float (5,4)
Ability_RC float (5,4)
Ability_PR float (5,4)
Ability_SR float (5,4)
Ability_FP float (5,4)
Ability_CP float (5,4)
timestamps timestamps
version string

answers

id increments
test_id ^FK integer
question_code ^FK integer
response char
timestamps timestamps

questions

id increments
block_id tinyInteger
code integer
correct_option string
parameters tinyInteger
timestamps timestamps

careers

id increments
onet_soc_code string
name string
translation string
type string
level tinyInteger
area string
Holland_R float (5,4)
Holland_I float (5,4)
Holland_A float (5,4)
Holland_S float (5,4)
Holland_E float (5,4)
Holland_C float (5,4)
Ability_AR float (5,4)
Ability_CM float (5,4)
Ability_SA float (5,4)
Ability_TP float (5,4)
Ability_VA float (5,4)
Ability_RC float (5,4)
Ability_PR float (5,4)
Ability_SR float (5,4)
Ability_CP float (5,4)
Ability_FP float (5,4)
timestamps timestamps

programs

id increments
career_onet_soc_code string
institution_SNIES_code ^FK integer
name string
municipality_code ^FK integer
resolution_date date
validity tinyInteger
methodology string
duration string
url string
timestamps timestamps

institutions

id increments
SNIES_code integer
name string
type string
sector string
url string
timestamps timestamps

municipalities

id increments
code integer
department_code ^FK integer
name string
latitude float
longitude float
timestamps timestamps

departments

id increments
code integer
country_code ^FK integer
name string
timestamps timestamps

countries

id increments
code integer
name string
timestamps timestamps

ratings

id increments
timestamps timestamps
test_id ^FK integer
value tinyInteger
comment string

coupons

id increments
code string
type string
discount float
start_date date
end_date date
cardinality smallInteger
timestamps timestamps

results

id increments
variable string
label string
description string
timestamps timestamps

tweets

id increments
tweet_id string
tweet_created_at timestamp
timestamps timestamps

news

id increments
text string (255)
url string
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01