hospital - Laravel Schema Designer

pationts

id increments
timestamps timestamps
name string
national_ID string
phone string
gender enum
age integer
marital_status enum
address string
blood_type_id enum

blood_types

id increments
timestamps timestamps
name string

files

id increments
timestamps timestamps
category_id integer
ticket_ID string
status enum
start_examination datetime
end_examination string
pationt_id integer

rogets

id increments
timestamps timestamps
pationt_id integer
file_id integer

writen_rogets

id increments
timestamps timestamps
roget_id integer
name integer

operations

id increments
timestamps timestamps
type string
report longText
date datetime
pationt_id integer
blood_bags_num integer
price decimal
room_id integer

operation_tools

id increments
timestamps timestamps
name string
number integer
operation_id integer

rooms

id increments
timestamps timestamps
name string
floor_number string

categories

id increments
timestamps timestamps
name string
parent_id integer

companies

id increments
timestamps timestamps
name string
phone string
email string

reports

id increments
timestamps timestamps
reportable_type string
reportable_id integer
report longText
status enum
recheck_date datetime

medicines

id increments
timestamps timestamps
name string
price decimal
type enum
company_id integer

medicine_quantities

id increments
timestamps timestamps
before integer
amount integer
after integer
medicine_id integer
quantitieable_type string
quantitieable_id integer

medicine_roget

id increments
timestamps timestamps
medicine_id integer
roget_id integer
quantity integer
is_taken tinyInteger

medicine_asks

id increments
timestamps timestamps
medicine_id integer
quantity integer

settings_categories

id increments
name string
level integer
timestamps timestamps

settings

id increments
settings_category_id integer
key string
value longText
display_name string
data_type enum
level integer
timestamps timestamps

notifications

id increments
title string
body text
notifiable_type string
notifiable_id integer
timestamps timestamps

validations

id increments
setting_id integer
value text
timestamps timestamps

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