sample123 - Laravel Schema Designer

Users

id increments
fname string
lname string
password string
email string
email_verify tinyInteger
activation_code string
mobile string
type string
activation_token string
token_type string
api_token longText
expires_at datetime
remember_token string (100)
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

profiles

id increments
user_id ^FK integer
father_name string
national_id string
gender boolean
bank_name string
bank_cart string
bank_number_account string
code_card_number string
sheba string
phone string
post_code string
province integer
city integer
timestamps timestamps

user_addresses

id increments
user_id ^FK integer
name string
receiver_name string
address text
post_code string
lat string
lng string
province integer
city integer
mobile string
phone string
is_active boolean
timestamps timestamps

brands

id increments
name string
fullname string
slug string
description text
content text
year_creator string
agent_count integer
branches integer
power integer
customer_rate integer
delay integer
complain_rank integer
shop_share integer
summary_rank integer
center_rank integer
round_it enum
is_active tinyInteger
position integer
timestamps timestamps

insurances

id increments
name string
slug string
description text
position integer
is_active boolean
timestamps timestamps

third_base

id increments
user_id ^FK integer
car_usage_id integer
name string
count_type string
slug string
base_third_party double
base_driver_accident double
is_active tinyInteger
timestamps timestamps

thirds

id increments
user_id ^FK integer
brand_id ^FK integer
name string
description text
max_discount_percent double
max_years_percent double
max_years_count double
discount_manager_amount double
discount_manager_percent double
installment integer
installment_percent double
short_term integer
shortterm_before double
tax double
round_it boolean
is_active boolean
position integer
timestamps timestamps

third_coefficients

id increments
brand_id ^FK integer
third_base_id ^FK integer
1_2 double
2_5 double
5_5 double
is_active boolean
timestamps timestamps

car_usages

id increments
timestamps timestamps

requirements

id increments
year enum
financial_coverage double
requirement_life double
requirement_driver double
is_active tinyInteger
timestamps timestamps

third_finances

id increments
third_base_id ^FK integer
brand_id ^FK integer
price double
percent double
commitment double
is_active tinyInteger

third_uses

id increments
title string
percent double
is_active tinyInteger

orders

id increments
timestamps timestamps
insurance_id ^FK integer
brand_id ^FK integer

order_handle

id increments
order_id ^FK integer
user_id ^FK integer
client text
note text
processes text
is_active boolean
timestamps timestamps

order_agent

id increments
order_id ^FK integer
user_id ^FK integer
agent_id ^FK integer
note text
status enum
timestamps timestamps

order_Price

id increments
order_id ^FK integer
brand_id ^FK integer
type_insurance string
coefficient text
discount text
price_fell double
price_vat double
final_price double
jarime_sandogh double
timestamps timestamps

order_input

id increments
order_id ^FK integer
input text
timestamps timestamps
insurance_id ^FK integer
brand_id ^FK integer

order_service

id increments
order_id ^FK integer
user_id ^FK integer
send_service string
time_delivery datetime
timestamps timestamps

bodies

id increments
user_id ^FK integer
brand_id ^FK integer
description longText
no_discount double
shortterm string
shortterm_before double
installment string
installment_percent double
round_it boolean
is_danger double
penalti_delay double
penalti_older double
sum_transfer_price double
sum_discount double
position integer
is_active boolean
timestamps timestamps

body_coverages

id increments
body_id ^FK integer
extra double
car_right_type double
steal double
transfer double
break_glass double
price_down double
price double
natural_disaster double
chemical double
transit double
nouse double
timestamps timestamps

body_discounts

id increments
body_id ^FK integer
zero double
cash double
occasion double
CarQuality double
manager double
is_active boolean
is_danger_main double
timestamps timestamps

body_uses

id increments
brand_id ^FK integer
uses_value string
percent double
timestamps timestamps
use_field_id integer

fires

id increments
description text
user_id ^FK integer
brand_id ^FK integer
airplane double
earthquake double
pipe double
tornado double
flood double
steal double
rain double
electricity double
bricks integer
concrete integer
metal integer
fire_rate integer
earthquake_rate integer
discount_manager_percent double
discount_manager_amount double
installments tinyInteger
installment_percent double
short_term integer
shortterm_before double
sum_discount integer
round_it tinyInteger
tax double
position integer
is_active boolean
timestamps timestamps

travel_groups

id increments
title string
flag text
position integer
is_active tinyInteger
timestamps timestamps

travel_plans

id increments
title text
pice_text string
price double
is_active tinyInteger
timestamps timestamps

Travels

id increments
title string
description text
user_id ^FK integer
brand_id ^FK integer
travel_plan_id ^FK integer
travel_group_id ^FK integer
country_id integer
1-7 string
8-15 string
16-23 string
24-31 string
32-45 string
46-62 string
63-92 string
93-180 string
181-365 string
age string
discount_manager_percent double
discount_manager_amount double
installments tinyInteger
installment_percent double
short_term integer
shortterm_before double
round_it tinyInteger
tax double
position string
is_active tinyInteger
timestamps timestamps

healths

id increments
user_id ^FK integer
brand_id ^FK integer
name string
0-15 double
16-50 double
51-60 double
61-70 double
type string
form_complete string
Franchise string
period_other string
period_childbirth string
period_chronic string
cover_hospitalization double
cover_surgery double
cover_sonography double
cover_brain_bar double
cover_laboratory double
cover_ambulance double
cover_childbirth double
cover_visit double
cover_dentistry double
cover_sterile double
cover_eyes double
cover_earphone double
discount_manager_percent double
discount_manager_amount double
short_term integer
shortterm_before double
installment integer
installment_percent double
round_it boolean
tax double
position string
is_active boolean
timestamps timestamps
cover_decrepitude double

responsibles

id increments
user_id ^FK integer
brand_id ^FK integer
level integer
number integer
time integer
price double
discount_manager_percent double
discount_manager_amount double
short_term double
shortterm_before double
installment double
installment_percent double
tax double
round_it boolean
position string
is_active boolean
timestamps timestamps

SmsSend

id increments
mobile string
text string
status enum
timestamps timestamps

user_cars

id increments
user_id ^FK integer
car_usages ^FK integer
car_id ^FK integer
model_id ^FK integer
production_year string
day_duration string
life_loss_count string
financial_loss_count string
person_loss_count string
last_day_duration string
last_unique_code string
last_insurance_no string
last_brand_id ^FK integer
timestamps timestamps

user_credits

id increments
user_id ^FK integer
amount bigIncrements
user_creator ^FK integer
description text
status enum
timestamps timestamps

Lifes

id increments
user_id ^FK integer
insurance_id ^FK integer
years string
type string
payment string
periodic bigInteger
all bigInteger
death bigInteger
s_death bigInteger
s_danger bigInteger
s_maim bigInteger
s_diseases bigInteger
s_cancer bigInteger
s_medical bigInteger
input_type integer
tax double
round_it boolean
position string
is_active boolean
timestamps timestamps