erx - Laravel Schema Designer

users

id increments
role_id ^FK integer
email string
password string
timestamps timestamps

contact_methods

id increments
type string
timestamps timestamps

user_profile

id increments
user_id ^FK integer
name string
profile_image string
dob date
phone string
address_line_1 string
address_line_2 string
city string
province_id ^FK integer
contact_method ^FK integer
allergies text
insurance_front string
insurance_back string
idp_front string
idp_back string
alberta_health_care_card_front string
alberta_health_care_card_back string
timestamps timestamps

orders

id increments
user_id ^FK integer
order_status ^FK integer
prescription_img string
comment_id ^FK integer
allergies string
delivery_type tinyInteger
counseling_id ^FK integer
technician_media string
parent_order_id integer
timestamps timestamps

order_status

id increments
status string
timestamps timestamps

drugs

id increments
order_id ^FK integer
din integer
drug_name string
prescription_id string
dosage string
qty integer
cost float
comment_id ^FK integer
refil_count integer
opted_out integer
timestamps timestamps

refils

id increments
order_id ^FK integer
dins string
drug_name string
refil_image string
timestamps timestamps

counselings

id increments
counseling_time datetime
order_id ^FK integer
timestamps timestamps

personal_consultations

id increments
user_id ^FK integer
comment_id ^FK integer
consultation_time datetime
timestamps timestamps

comments

id increments
comment_text text
comment_voice string
timestamps timestamps

payments

id increments
user_id ^FK integer
order_id ^FK integer
payment_id string
payment_method string
amount integer
payment_date timestamp
timestamps timestamps

provinces

id increments
province string
timestamps timestamps

roles

id increments
role string
timestamps timestamps

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