medication_prescription_DB - Laravel Schema Designer

companies

id increments
timestamps timestamps
company_name string (255)

Medications

id increments
timestamps timestamps
medication_name string (255)
medication_cost double (255)
medication_available_date timestamps
medication_withdrawn_date timestamps
name string (255)
category_id ^FK integer
caliber_id ^FK integer
company_id ^FK integer

Prescriptions

id increments
timestamps timestamps
costomer_id integer
doctor_id integer
date_prescription date

categories

id increments
timestamps timestamps
name string (255)
parent_id ^FK integer

Contraindications

id increments
timestamps timestamps
content string (255)
title string (255)
medication_id integer

doses

id increments
timestamps timestamps
content string (255)
title string (255)
shape_id integer

Shapes

id increments
timestamps timestamps
title string (255)
content string (255)

medication_doses

id increments
timestamps timestamps
medication_id ^FK integer
dose_id ^FK integer

how_many_times_days

id increments
timestamps timestamps
PATTERN string

prescription_medication_doses

id increments
timestamps timestamps
prescription_id integer
medication_dose_id integer
instruction_to_customers string
how_many_times_day_id integer

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