helmy_app - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK integer

dreams

id increments
title json
description json
status enum
user_name string
interpreter_name string
plan_id ^FK integer
country_id ^FK integer
voice_record string
marital_status enum
age integer
gender enum
employed tinyInteger
have_childrens tinyInteger
dream_time string
mental_illness tinyInteger
guidance_prayer tinyInteger
notification tinyInteger
timestamps timestamps
softDeletes softDeletes

plans

id increments
name json
description json
softDeletes softDeletes
timestamps timestamps
price string
currency string

countries

id increments
name json
country_code string
currancy json
timestamps timestamps
softDeletes softDeletes

ratings

id increments
user_id ^FK integer
rating integer
timestamps timestamps
softDeletes softDeletes

favorites

id increments
user_id ^FK integer
dream_id ^FK integer
timestamps timestamps
softDeletes softDeletes

transactions

id increments
user_id ^FK integer
dream_id ^FK integer
plan_price string
softDeletes softDeletes
timestamps timestamps

dream_comments

id increments
content string (500)
dream_id ^FK integer
timestamps timestamps
softDeletes softDeletes

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