Home
chaim-medical
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
email
string
(50)
first_name
string
(50)
last_name
string
(50)
role
enum
language
enum
coutry_id
integer
state_id
integer
timestamps
timestamps
doctors
id
increments
first_name
string
(50)
last_name
string
(50)
sunday_availability
enum
priority_followup
enum
met
enum
consult_rate
integer
surgery_rate
integer
home_number
string
(25)
cell_number
string
(25)
additional_number
string
(25)
mail
string
(50)
assistent_id
integer
zip_code
string
(50)
timestamps
timestamps
updated_user_id
integer
patients
id
increments
first_name
string
(50)
last_name
string
(50)
email
string
(50)
cell_phone
string
(50)
home_phone
string
(25)
dob
date
gender
enum
street
string
(255)
mrn_code
string
(50)
timestamps
timestamps
cases
id
increments
status
enum
doctor_id
integer
patient_id
integer
timestamps
timestamps
tags
name
string
(255)
commentable_id
integer
commentable_type
string
timestamps
timestamps
id
increments
chats
id
increments
timestamps
timestamps
chat_messages
id
increments
text
text
user_id
integer
chat_id
integer
timestamps
timestamps
user_chats
id
increments
timestamps
timestamps
doctor_locations
id
increments
timestamps
timestamps
email
string
(50)
phone
string
(50)
card_name
string
(50)
min_rate
integer
max_rate
integer
type
enum
doctor_id
integer
country_id
integer
city_id
integer
state_id
integer
street
string
(255)
insurances
id
increments
company_name
string
(255)
type
enum
service_phone
string
(25)
claim_phone
string
(25)
provide_link
string
(255)
status
enum
timestamps
timestamps
doctor_assistents
id
increments
timestamps
timestamps
name
string
(50)
email
string
(50)
phone
string
(25)
doctror_id
integer
doctror_feedbaks
id
increments
doctor_id
integer
user_id
integer
text
text
timestamps
timestamps
tasks
id
increments
name
string
(255)
related
string
(255)
type
enum
priority
enum
status
enum
timestamps
timestamps
task_users
id
increments
task_id
integer
user_id
integer
timestamps
timestamps
specialities
id
increments
timestamps
timestamps
name
string
(50)
doctor_specialities
id
increments
speciality_id
integer
doctor_id
integer
timestamps
timestamps
disorders
id
increments
name
string
(50)
timestamps
timestamps
diagnosis
id
increments
name
string
(50)
timestamps
timestamps
symptoms
id
increments
timestamps
timestamps
name
string
(50)
case_disorder
id
increments
disorder_id
integer
case_id
integer
timestamps
timestamps
case_diagnoses
id
increments
case_id
integer
diagnosis_id
integer
timestamps
timestamps
case_symptoms
id
increments
case_id
integer
symptom_id
integer
timestamps
timestamps
case_doctors
id
increments
timestamps
timestamps
case_id
integer
doctor_id
integer
task_reminders
id
increments
date
date
task_id
integer
timestamps
timestamps
notes
id
increments
text
text
type
enum
user_type
enum
user_id
enum
date
date
commentable_id
integer
commentable_type
string
timestamps
timestamps
flags
id
increments
name
string
(25)
case_id
integer
timestamps
timestamps
doctor_insurances
id
increments
doctor_id
integer
insurance_id
integer
status
enum
updated_user_id
string
link
string
note
string
(500)
timestamps
timestamps
documents
id
increments
user_id
integer
type
enum
source
string
(255)
file_id
integer
commentable_id
integer
commentable_type
string
(50)
timestamps
timestamps
insurance_notes
id
increments
insurance_id
integer
text
text
timestamps
timestamps
hospital_admissions
id
increments
name
string
(255)
case_id
integer
patient_id
integer
status
enum
admition_date
date
discharge_date
date
timestamps
timestamps
case_hospital_admissions
id
increments
hospital_admission_id
integer
case_id
integer
timestamps
timestamps
patient_insurances
id
increments
patient_id
integer
insurance_id
integer
effective_day
date
policy_holder
string
(50)
group_id
integer
member_id
integer
card_id
integer
status
enum
timestamps
timestamps
case_tasks
id
increments
case_id
integer
task_id
integer
timestamps
timestamps
permissions
id
increments
name
string
(25)
timestamps
timestamps
user_permissions
id
increments
user_id
integer
permission_id
integer
timestamps
timestamps
permission_influences
id
increments
timestamps
timestamps
permission_id
integer
permission_influence_id
integer
task_doctors
id
increments
doctor_id
integer
task_id
integer
timestamps
timestamps
user_logs
id
increments
user_id
integer
action
string
(500)
patient_id
integer
timestamps
timestamps
sub_specialities
id
increments
name
string
(50)
speciality_id
integer
timestamps
timestamps
patient_contacts
id
increments
name
string
(50)
phone
string
(25)
email
string
(50)
text
string
(2000)
patient_id
integer
timestamps
timestamps
insurance_contacts
id
increments
name
string
(255)
phone
string
(25)
note
string
(500)
timestamps
timestamps
insurances_contacts
id
increments
timestamps
timestamps
insurance_id
integer
contact_id
integer
links
id
increments
disorder_id
integer
user_id
integer
name
string
(50)
path
string
(255)
timestamps
timestamps
document_files
id
increments
name
string
(50)
timestamps
timestamps
expansion
string
(25)
disorder_symptoms
id
increments
disorder_id
integer
symptom_id
integer
timestamps
timestamps
doctor_insurance_logs
id
increments
user_id
integer
action
string
(2000)
doctor_insurance
integer
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01