UNHCR - Laravel Schema Designer

users

id increments
first_name string (299)
last_name string (299)
email string (299)
password string (299)
timestamps timestamps

categories

id increments
language_key string (299)
module string (50)
category_en text
category_ind text
category_malay text
category_thai text
category_urdu text
category_burmese text
category_rohingya text
category_dari text
category_somali text
category_arabic text
status tinyInteger
timestamps timestamps

tips

id increments
title_language_key string (299)
desc_language_key string (299)
order integer
image_id ^FK integer
title_en text
title_ind text
title_malay text
title_thai text
desc_en longText
desc_ind longText
desc_malay longText
desc_thai longText
status tinyInteger
timestamps timestamps

images

id increments
file_path string (299)
timestamps timestamps

questions

id increments
language_key string (299)
category_id ^FK integer
question_type enum
image_id ^FK integer
module enum
parent_question_id ^FK integer
question_en longText
question_ind longText
question_malay longText
question_thai longText
question_urdu longText
question_burmese longText
question_rohingya longText
question_dari longText
question_somali longText
question_arabic longText
status tinyInteger
timestamps timestamps

answers

id increments
language_key string (299)
question_id ^FK integer
show_textbox tinyInteger
textbox_label text
image_id ^FK integer
answer_en text
answer_ind text
answer_malay text
answer_thai text
answer_urdu text
answer_burmese text
answe_rohingya text
answer_dari text
answer_somali text
answer_arabic text
timestamps timestamps

sub_question_logic

id increments
sub_question_id ^FK integer
operator string (20)
timestamps timestamps

answer_logic

id increments
logic_id ^FK integer
answer_id ^FK integer
timestamps timestamps

settings

id increments
current_version bigInteger
delivery_status tinyInteger
file_name string (299)
timestamps timestamps

feedbacks

id increments
timestamps timestamps
email string (299)
feedback text

refferal_pathway

id increments
language_key string (299)
image_id ^FK integer
parent_pathway ^FK integer
name_en text
name_ind text
name_malay text
name_thai text
name_urdu text
name_burmese text
name_rohingya text
name_dari text
name_somali text
name_arabic text
desc_en longText
desc_ind longText
desc_malay longText
desc_thai longText
desc_urdu longText
desc_burmese longText
desc_rohingya longText
desc_dari longText
desc_somali longText
desc_arabic longText
timestamps timestamps

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