qPartnerships_db - Laravel Schema Designer

reject_reasons

id increments
title json
is_active boolean
timestamps timestamps

templates

id increments
title json
is_active boolean
timestamps timestamps

workflow

id increments
title json
user_id ^FK bigInteger
final_action boolean
sort mediumInteger
timestamps timestamps

users

id increments
name string
email string
phone string
password string
type enum
timestamps timestamps

partners

id increments
user_id ^FK bigInteger
address json
job_name json
presenter_id ^FK bigInteger
timestamps timestamps

departments

id increments
title json
parent_id ^FK bigInteger
timestamps timestamps

agreements

id increments
subject json
partner_id ^FK bigInteger
side_type enum
category enum
template_id ^FK bigInteger
type enum
invitation_date date
send_by_email boolean
send_by_letter boolean
received_by enum
terms longText
email string
response enum
reject_reason_id ^FK bigInteger
assign_to ^FK bigInteger
created_by ^FK bigInteger
status enum
duration string
rate string
rate_review longText
rated_by ^FK bigInteger
timestamps timestamps

agreement_files

id increments
file string
type enum
timestamps timestamps
agreement_id ^FK bigInteger

employees

id increments
timestamps timestamps
user_id ^FK bigInteger

agreement_workflows

id increments
agreement_id ^FK bigInteger
user_id ^FK bigInteger
title string
comments longText
status enum
final_action boolean
timestamps timestamps

agreement_plan_terms

id increments
agreement_id ^FK bigInteger
title string
description longText
timestamps timestamps
status enum
is_active boolean
number_of_stakeholders integer
from date
to date
contact_name string
contact_phone string
contact_email string
department_id ^FK bigInteger

challenges

id increments
description longText
parent_id ^FK bigInteger
timestamps timestamps
agreement_plan_term_id ^FK bigInteger
created_by ^FK bigInteger

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