Lawyer - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
full_name string
email string
user_type_id ^FK bigInteger
birthdate date
gender enum
phone_number string
profile_image string (125)
identity_image string
office_manager_membership_number integer
role string
status enum

offices

id increments
timestamps timestamps
softDeletes softDeletes
office_name string (125)
office_description text
office_email string
office_website string
Longitude decimal
office_opening_date date
office_logo string
office_license string
office_phone_1 string (125)
office_phone_2 string (125)
office_phone_3 string (125)
latitude decimal

case_settings

id increments
timestamps timestamps
softDeletes softDeletes
text string

subjects_items

id increments
timestamps timestamps
softDeletes softDeletes
text text
case_id ^FK bigInteger

court_names

id increments
timestamps timestamps
softDeletes softDeletes
name string

court_types

id increments
timestamps timestamps
softDeletes softDeletes
type string

courts_items

id increments
timestamps timestamps
softDeletes softDeletes
court_type_id ^FK bigInteger
court_name_id ^FK bigInteger
court_number string
case_id ^FK bigInteger

case_files_items

id increments
timestamps timestamps
softDeletes softDeletes
file string
case_id ^FK bigInteger
Judgment ^FK bigInteger

Judgment

id increments
timestamps timestamps
softDeletes softDeletes
case_id ^FK bigInteger
notes text
case_status_id ^FK bigInteger

status

id increments
timestamps timestamps
softDeletes softDeletes
name string

xcases

id increments
timestamps timestamps
softDeletes softDeletes
case_uuid string (250)
client_id ^FK bigInteger
opponent_name string (250)
opponent_description string (250)
client_description text
case_registration string (250)
case_registration_date date
court_degree_id ^FK bigInteger
court_item_id ^FK bigInteger

users_offices

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
office_id ^FK bigInteger

user_type

id increments
timestamps timestamps
softDeletes softDeletes
name string (125)

case_expenses

id increments
timestamps timestamps
softDeletes softDeletes
deposit_by_user_id ^FK bigInteger
deposit_for_user_id ^FK bigInteger
amount_paid float
case_id ^FK bigInteger

user_xcases

id increments
timestamps timestamps
softDeletes softDeletes
xcase_id ^FK bigInteger
user_id ^FK bigInteger
start_case date
end_case date

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