fodex - Laravel Schema Designer

users

id increments
timestamps timestamps
name string
phone string
password string
image string
phone_verify boolean
device_id string
device_token string
api_token string
verify_code string
usertype_id ^FK integer
role_id smallInteger
block tinyInteger
block_reason string
avatar string
active tinyInteger
appear tinyInteger
not_appear_reason string
wallet_amount double

addresses

id increments
timestamps timestamps
lat double
lon double
country_id smallInteger
state_id ^FK integer
city_id ^FK integer
district string
street string
building_number string
floor_number integer
employee_id integer
user_id ^FK integer
seller_id ^FK integer
title string

countries

id increments
name string
lat double
lon double
timestamps timestamps

states

id increments
name string
country_id ^FK integer
lat double
lon double
timestamps timestamps

cities

id increments
name string
country_id ^FK integer
state_id ^FK integer
lon string
lat double
timestamps timestamps

majors

id increments
timestamps timestamps
title string
description string
image string

usertypes

id increments
timestamps timestamps
title string

categories

id increments
timestamps timestamps
title string
image string
description string
major_id smallInteger

subcategories

id increments
timestamps timestamps
title string
image string
description string
category_id ^FK integer

items

id increments
timestamps timestamps
title string
description string
price double
discount double
seller_id ^FK integer
availability tinyInteger
not_available_reason string
appear tinyInteger
not_appear_reason string
prepare_time smallInteger
calory smallInteger

images

id increments
timestamps timestamps
image string
item_id ^FK integer

seller_category

id increments
timestamps timestamps
seller_id ^FK integer
category_id ^FK integer

sellers

id increments
timestamps timestamps
name string
phone string
mobile string
prepare_time integer
description string
major_id integer
device_token string
verify_code string
api_token string
password string
wallet_amount string
block tinyInteger
availability tinyInteger
not_available_reason string
block_reason string
close tinyInteger

sellerimages

id increments
timestamps timestamps
image string
seller_id integer

sellermessages

id increments
timestamps timestamps
message string
seller_id integer

extras

id increments
timestamps timestamps
title string
item_id ^FK integer

sizes

id increments
timestamps timestamps
title string
price double
item_id ^FK integer
calory smallInteger

workschedules

id increments
timestamps timestamps
work_from time
work_to time
day_id smallInteger
seller_id ^FK integer

days

id increments
timestamps timestamps
day_name string

socials

timestamps timestamps
id increments
facebook string
instagram string
twiter string
seller_id integer

extradetails

id increments
timestamps timestamps
title string
extra_price double
extra_id ^FK integer

employees

id increments
timestamps timestamps
name string
phone string
mobile string
password string
image string
phone_verify tinyInteger
device_id string
device_token string
api_token string
verify_code string
block tinyInteger
block_reason string
identification_number_image string
display_block_reason string
residence_deed_image string
jobtitle_id ^FK integer
gender_id ^FK integer
qualification string
birthday date
alternative_phone string
armycase_id ^FK integer
expiry_date_postponement date
statussocial_id integer
wallet_amount double

employeescontracts

id increments
timestamps timestamps
from_day date
to_day date
creator_employee_id ^FK integer
employee_id ^FK integer
paper_contract_image string
sallary double
notes string

attendances

id increments
timestamps timestamps
attend_from time
attend_to time
day_id ^FK integer
employee_id ^FK integer
notes string
rest_from time
rest_to time
seconed_day_end time

sellercontracts

id increments
timestamps timestamps
from_day date
to_day date
percantge double
paper_contract_image string
employee_id ^FK integer
seller_id ^FK integer
notes string

jobtitles

id increments
timestamps timestamps
title string
description string
notes string

gender

id increments
timestamps timestamps
title string

armycases

id increments
timestamps timestamps
title string

statussocials

id increments
timestamps timestamps
title string

vehicletypes

id increments
timestamps timestamps
title string

zones

id increments
name string
country_id ^FK integer
state_id ^FK integer
city_id ^FK integer
lat double
long double
timestamps timestamps

drivers

id increments
timestamps timestamps
name string
phone string
mobile string
password string
image string
phone_verify tinyInteger
device_token string
api_token string
verify_code string
block tinyInteger
block_reason string
display_block_reason string
identification_number_image string
residence_deed_image string
gender_id ^FK integer
qualification string
birthday date
alternative_phone string
armycase_id ^FK integer
statussocial_id ^FK integer
expiry_date_postponement date
vehicle_license_image string
vehicle_license_number string
country_id ^FK integer
state_id ^FK integer
city_id ^FK integer
wallet_amount double

userwallets

id increments
timestamps timestamps
amount double
user_id ^FK integer
walletmethod_id ^FK integer
source_seller_id ^FK integer
source_driver_id ^FK integer

walletmethods

id increments
timestamps timestamps
title string