avsp - Laravel Schema Designer

userverse

id increments
timestamps timestamps
softDeletes softDeletes

profiles

id increments
timestamps timestamps
softDeletes softDeletes

consultant_profiles

id increments
profile_id ^FK integer
hcp_profile ^FK integer
primary_address_id ^FK integer
number_of_publications smallInteger
timestamps timestamps
softDeletes softDeletes
sees_patients boolean
practice_settings string

hcp_profile

id increments
timestamps timestamps
softDeletes softDeletes

addresses

id increments
timestamps timestamps
softDeletes softDeletes

speaker_profile

id increments
consultant_profile ^FK integer
timestamps timestamps
softDeletes softDeletes

publications

id increments
publication_type_id ^FK integer
profile_experience_id ^FK integer
title string
description string
creator integer
created_at integer
updated_at integer
deleted_at integer

publication_types

id increments
label string
description string
creator integer
created_at integer
updated_at integer
deleted_at integer

profile_experience

id increments
timestamps timestamps
softDeletes softDeletes

profile_to_brand

is_speaker boolean
is_consultant boolean
is_brand_investigator boolean

profile_to_publications

id increments
profile_id ^FK integer
publication_id ^FK integer
weight tinyInteger
creator integer
created_at integer
updated_at integer
deleted_at integer

editorial_boards

id increments
year string (4)
address_id integer
created_at integer
updated_at integer
deleted_at integer

profile_to_editorial_boards

id increments
profile_id integer
editorial_board_id integer
created_at integer
updated_at integer
deleted_at integer

profile_to_professional_groups

id increments
profile_id integer
name string
creator integer
created_at integer
updated_at integer

profile_to_professional_groups_to_leadership_roles

id increments
profile_id integer
profile_to_professional_group_id integer
year string
address_id integer
role string
creator integer
created_at integer
updated_at integer

institutions

id increments
abbr string
name string
full_name string
creator integer
created_at integer
updated_at integer

profile_to_institutions

id increments
profile_id integer
institution_id integer
creator integer
created_at integer
updated_at integer

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