trialxxxx - Laravel Schema Designer

questions

id increments
code char (32)
sharable boolean
label string (255)
valuetype enum
rendertype string
required boolean
definitions json
timestamps timestamps
valuable boolean

answers

id increments
question_id ^FK integer
patient_id ^FK integer
cro_id ^FK integer
site_id ^FK integer
value json
statvalue decimal (16,6)
timestamps timestamps
section_question_id ^FK integer
form_id ^FK integer
event_id ^FK integer

definitions

min integer
max integer
default string
values json

forms

id increments
title string
draft boolean
timestamps timestamps
categories string
type enum

pages

id increments
order smallInteger
form_id ^FK integer
title string
timestamps timestamps

section_questions

id increments
section_id ^FK integer
question_id ^FK integer
order smallInteger
rendertype string
depends_on integer
depends_definition json
timestamps timestamps

configurations

fieldname string
fieldvalue string
fieldtype string
timestamps timestamps

patients

id increments
code string (32)
cro_id ^FK integer
site_id ^FK integer
operator_id ^FK integer
timestamps timestamps
status string
started_at timestamp

operators

id increments
cro_id ^FK integer
site_id ^FK integer
role char (2)
description string
timestamps timestamps

cros

id increments
code string
description string
timestamps timestamps

sites

id increments
cro_id ^FK integer
code string
description string
timestamps timestamps
patient_target integer

sections

id increments
timestamps timestamps
title string
page_id ^FK integer
order smallInteger
repeatable boolean
depends_on integer
depends_definition json

invites

operator_id ^FK integer
invite_code string
email string
timestamps timestamps

schedules

id increments
timestamps timestamps
title string
offset integer
scope text
repeat_for integer
target_id integer
enable_form_ids string
target_type string

events

id increments
timestamps timestamps
schedule_id ^FK integer
patient_id ^FK integer
completed_at timestamp
status string
completed_pages string
questionnaire_id ^FK integer
diary_id ^FK integer
parent_id ^FK integer

checks_plan

id increments
timestamps timestamps
title string
categories string
meta json
strategies json

query

id increments
timestamps timestamps
section_question_id ^FK integer
answer_id ^FK integer
operator_id ^FK integer
status string
event_id ^FK integer

query_comments

id increments
timestamps timestamps
operator_id ^FK integer
query_id ^FK integer
message string

diaries

id increments
timestamps timestamps
title string
offset integer
repeat_for integer
form_id ^FK integer

checks_plan_events

id increments
timestamps timestamps
event_id ^FK integer
check_plan_id ^FK integer

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