veels_plus - Laravel Schema Designer

partner_business_users_mapping

id increments
timestamps timestamps
softDeletes softDeletes
partner_business_id ^FK bigInteger
partner_user_id ^FK bigInteger
role string
added_by string
role_updated_on string
role_updated_by string

partner_users

id increments
fullname string (50)
email_id string
phone_number string
password string
added_by string
pan_number string
aadhar_number string
softDeletes softDeletes
timestamps timestamps

partner_businesses

id increments
timestamps timestamps
softDeletes softDeletes
business_name string
address string
city string
district string
state string
country string
pin_code string
geo_lat string
geo_long string
geo_location string
partner_user_id ^FK bigInteger
highway boolean
highway_type string
highway_number string
partner_gst_number string
partner_pan_number string
partner_image_gst string
p_image_oil_co_receipt string
p_image_business_logo string
status boolean
status_updated_by string
status_updated_on timestamp

customer_business

id increments
timestamps timestamps
softDeletes softDeletes
business_name string
address string
city string
district string
state string
country string
pin_code string
geo_lat string
geo_long string
partner_user_id ^FK bigInteger
partner_business_id ^FK bigInteger
customer_gst_number string
cusomer_pan_number string
customer_image_gst string
customer_image_business_logo string
status string
status_updated_by string
status_updated_on string
geo_location string

customer_users

id increments
timestamps timestamps
softDeletes softDeletes
full_name string
email_id string
phone_number string
password string
added_by string
pan_number string
aadhar_number string

customer_business_users_mapping

id increments
timestamps timestamps
softDeletes softDeletes
customer_business_id ^FK bigInteger
customer_user_id ^FK bigInteger
role string
added_by string
role_updated_on timestamp
role_updated_by string

partner_business_customer_business_mapping

id increments
timestamps timestamps
softDeletes softDeletes
partner_business_id ^FK bigInteger
customer_business_id ^FK bigInteger
status string
added_by string
edit_updated_on timestamp
edit_updated_by string
credit_limit_assigned string
credit_limit_addded_edited_on timestamp
credit_limit_assigned_by string
status_updated_on timestamp
status_updated_by timestamp

partner_business_customer_business_credit_transactions

id increments
timestamps timestamps
softDeletes softDeletes
p_c_mapping_id ^FK bigInteger
added_by string
edit_updated_on timestamp
edit_updated_by string
transaction_date timestamp
p_ref_number1 string
c_ref_number2 string
vehicle_number string
product string
product_rsp string
product_quantity string
product_amount string
discount_given boolean
discount_amount float

partner_business_customer_business_payments

id increments
timestamps timestamps
softDeletes softDeletes
p_c_mapping_id ^FK bigInteger
added_by string
edit_updated_on timestamp
edit_updated_by string
payment_date timestamp
payment_mode string
payment_amount float

partner_business_customer_business_discounts

id increments
timestamps timestamps
softDeletes softDeletes
p_c_mapping_id ^FK bigInteger
p_c_transaction_id ^FK bigInteger
added_by string
edit_updated_on timestamp
edit_updated_by string
discount_date timestamp
discount_amount float
discount_rate string

partner_business_customer_business_transactions_payments_discounts

id increments
timestamps timestamps
softDeletes softDeletes
p_c_mapping_id ^FK bigInteger
type string
entry_id bigInteger
entry_date timestamp
edit_updated_on timestamp
edit_updated_by string
entry_amount float
balance_amount float

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