api_insurance - Laravel Schema Designer

users

id increments
username string (70)
password string (70)
agent json
email string (100)
phone string (12)
percent_profit tinyInteger
timestamps timestamps
softDeletes softDeletes

credits

id increments
user_id ^FK integer
remaining_money bigInteger
date_create date
date_last_charge date
bank_information json
timestamps timestamps
softDeletes softDeletes

passengers

id increments
first_name_fa string (60)
last_name_fa string (60)
first_name_en string (60)
last_name_en string (60)
national_code string (12)
birth_date date
email string (100)
phone string (12)
gender enum
birth_place string (100)
passport_number string (100)
post_code string (20)
timestamps timestamps
softDeletes softDeletes

operation_records

id increments
user_id ^FK integer
actionable_type string (150)
actionable_id integer
response json
webservice_id integer
uuid string (70)
timestamps timestamps
softDeletes softDeletes

orders

id increments
user_id ^FK integer
passenger_id ^FK integer
plan_id integer
base_price string
discount_price string
total_price string
percent_profit tinyInteger
amount_profit string
timestamps timestamps
softDeletes softDeletes

user_order_profits

id increments
order_id ^FK integer
profit_amount string
softDeletes softDeletes
timestamps timestamps

countries

id increments
name json
domain_prefixes json
alpha_two_code string (2)
timestamps timestamps
softDeletes softDeletes

linkable_countries

id increments
country_id ^FK integer
saman_code smallInteger
pasargad_code smallInteger
timestamps timestamps
softDeletes softDeletes

insurance_plans

id increments
country_id ^FK integer
min_age smallInteger
max_age smallInteger
min_duration smallInteger
max_duration smallInteger
plan_id integer
price integer
timestamps timestamps
softDeletes softDeletes

webservices

id increments
title json
description string (300)
logo string (150)
is_active boolean
timestamps timestamps
softDeletes softDeletes

plans

id increments
code smallInteger
title json
tyoe string (50)
limit json
webservice_id ^FK integer
timestamps timestamps
softDeletes softDeletes

covers

id increments
plan_id ^FK integer
cover json
timestamps timestamps
softDeletes softDeletes

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