WRN-Meldingen-triage-tabel - Laravel Schema Designer

reports

id increments
datetime timestamps
softDeletes softDeletes
helpdesk_id ^FK integer
user_id integer
referrer_id ^FK integer
referrer_name string (255)
referrer_position string (255)
referrer_tel string (255)
client_id ^FK integer
practitioner_id ^FK integer
reason_report text
urgency_id ^FK integer
deviation_urgency text
history_psychiatric text
history_somatic text
history_psychotropics text
agression_id integer
aggression_desc text
addiction_id integer
addiction_desc text
children_id integer
children_desc text
suicidality_id integer
suicidality_desc text
psychotic_problems_id integer
psychotic_desc text
judicial_past_id integer
judicial_past_desc text
substances_use boolean
substances_id integer
substances_additional string (255)
zm_id integer
zm_desc text
caretaker_id integer
transportation_id integer
policy_triage_id integer
motivation_triage text
status_id ^FK integer
consult_type_id ^FK integer
consult_id integer
employee1 ^FK integer
employee2 ^FK integer
updated_at datetime
created_at datetime
inspect_user_id ^FK integer
group_report_id ^FK bigInteger

status

id increments
timestamps timestamps
softDeletes softDeletes
created_at datetime
updated_at datetime

substance

id increments
timestamps timestamps
softDeletes softDeletes

substance_translations

id increments
timestamps timestamps
substance_id ^FK integer
substance string (255)
locale char (2)

status_translations

id increments
status_id ^FK integer
name string (255)
expired_name string (255)
locale char (2)
timestamps timestamps

report_substance

id increments
timestamps timestamps
softDeletes softDeletes
report_id ^FK integer
substance_id ^FK integer

consult_type

id increments
timestamps timestamps
softDeletes softDeletes

consult_type_translation

id increments
timestamps timestamps
consult_id ^FK integer
consult string (255)
locale char (2)

helpdesk

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

referrer

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

practitioner

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

urgency

id increments
period smallInteger
color string (7)
timestamps timestamps
softDeletes softDeletes

urgency_translations

id increments
timestamps timestamps
urgency_id ^FK integer
urgency string (255)
description string
locale char (2)

transportation

id increments
timestamps timestamps
softDeletes softDeletes

transportation_translation

id increments
timestamps timestamps
locale char (2)
transportation_id ^FK integer
transportation string (255)

caretaker

id increments
timestamps timestamps
softDeletes softDeletes

caretaker_translation

id increments
timestamps timestamps
locale char (2)
caretaker string (255)
caretaker_id ^FK integer

policy_triage

id increments
timestamps timestamps
softDeletes softDeletes

policy_triage_translations

id increments
timestamps timestamps
locale char (2)
policy_triage string (255)
policy_triage_id ^FK integer

clients

id increments

users

id increments

groups

id increments

group_report

id increments
report_id bigInteger
group_id bigInteger

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