test - Laravel Schema Designer

medicines

id increments
scientificName string (255)
commercialName string (255)
price integer
expiry_date date
company_id ^FK bigInteger
quantity_id ^FK bigInteger
softDeletes softDeletes

quantities

id increments
available integer
sold integer
medicine_id ^FK bigInteger

pharmacists

id increments
username string (255)
name string (255)
email string (255)
phone integer
password string (255)
address_id ^FK bigInteger
settings_id ^FK bigInteger

favorites

id increments
medicine_id ^FK bigInteger
pharmacist_id ^FK bigInteger

addresses

id increments
name string (255)
city string (255)
street string (255)
description text

settings

id increments
theme enum
language enum
timestamps timestamps

categories

id increments
name string (255)

categories_medicines

medicine_id ^FK bigInteger
category_id ^FK bigInteger

companies

id increments
address_id ^FK bigInteger

options

id increments
dose string (255)

medicines_options

medicine_id ^FK bigInteger
option_id ^FK bigInteger

orders

id increments
timestamps timestamps
pharmacist_id ^FK bigInteger
delivered_at date
medicine_order_id ^FK bigInteger

medicines_order

medicine_id ^FK bigInteger
quantity integer

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