pharmacy_management - Laravel Schema Designer

pharmacies

id increments
name string (1000)
slug string (1000)
address string (1000)
state string (255)
city string (255)
pincode string (255)
country string (255)
code string (1000)
status enum
timestamps timestamps

users

id increments
timestamps timestamps

insurances

id increments
status enum
timestamps timestamps
name string (500)

credentials

id increments
timestamps timestamps
insurance_id ^FK bigInteger
type enum
key string (500)
value string (500)
url string (500)

pharmacy_selected_insurances

id increments
pharmacy_id ^FK bigInteger
insurance_id bigInteger
timestamps timestamps

customers

id increments
first_name string (255)
middle_name string (255)
last_name string (255)
full_name string (255)
dob date
mobile_no string (30)
country_code string (10)
patient_category string (100)
country string (100)
state string (100)
city string (100)
area string (200)
address string (500)
email string (200)
passport_number string (100)
age integer
gender string (100)
registration_date date
insurance_provider string (100)
insurance_number string (255)
timestamps timestamps

master_countries

id increments
name string (255)
contry_code string (20)
timestamps timestamps

master_patient_types

id increments
name string (100)
timestamps timestamps

master_gender

id increments
timestamps timestamps
name string

products

id increments
timestamps timestamps
softDeletes softDeletes
name string (300)
code string (50)
sku_id string (200)
drug_manufacturer string (500)

master_product_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

products_category

id increments
category_id bigInteger
name string (255)
product_id ^FK bigInteger
timestamps timestamps

master_product_subcategory

id increments
timestamps timestamps
softDeletes softDeletes

product_sub_categories

id increments
product_id ^FK bigInteger
sub_category_id bigInteger
timestamps timestamps

master_drug_manufacturer

id increments
timestamps timestamps
softDeletes softDeletes
name string (500)

product_covered_insurances

id increments
timestamps timestamps
softDeletes softDeletes

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